帮忙看看我的buyvm怎么了?
11812
- xd040530452010-09-05金牌会员2871
买的那个buyvm的15刀一年的,以前就装了个apach跑静态页面的,内存一直在60-80MB
今天下午闲着没事,打算搞个论坛玩玩,于是尝试着给vps装mysql,可是装Mysql时杯具产生了,
service mysql start总是启动不了,网上查了好久也不知道什么问题,后来看了下日志,应该是INnoDB导致的内存不足什么的吧,
这个是日志文件:- InnoDB: Check if you should increase the swap file or- InnoDB: ulimits of your operating system.
- InnoDB: On FreeBSD check you have compiled the OS with
- InnoDB: a big enough maximum process size.
- InnoDB: Note that in most 32-bit computers the process
- InnoDB: memory space is limited to 2 GB or 4 GB.
- InnoDB: We keep retrying the allocation for 60 seconds...
- 100905 8:14:09 InnoDB: Error: cannot allocate 186368 bytes of
- InnoDB: memory with malloc! Total allocated memory
- InnoDB: by InnoDB 13848800 bytes. Operating system errno: 12
- InnoDB: Check if you should increase the swap file or
- InnoDB: ulimits of your operating system.
- InnoDB: On FreeBSD check you have compiled the OS with
- InnoDB: a big enough maximum process size.
- InnoDB: Note that in most 32-bit computers the process
- InnoDB: memory space is limited to 2 GB or 4 GB.
- InnoDB: We keep retrying the allocation for 60 seconds...
- InnoDB: Error: pthread_create returned 11
- 100905 8:19:20 Plugin 'FEDERATED' is disabled.
- 100905 8:19:20 InnoDB: Error: cannot allocate 440000 bytes of
- InnoDB: memory with malloc! Total allocated memory
- InnoDB: by InnoDB 388 bytes. Operating system errno: 12
- InnoDB: Check if you should increase the swap file or
- InnoDB: ulimits of your operating system.
- InnoDB: On FreeBSD check you have compiled the OS with
- InnoDB: a big enough maximum process size.
- InnoDB: Note that in most 32-bit computers the process
- InnoDB: memory space is limited to 2 GB or 4 GB.
- InnoDB: We keep retrying the allocation for 60 seconds...
- 100905 8:19:21 InnoDB: Error: cannot allocate 1048576 bytes of
- InnoDB: memory with malloc! Total allocated memory
- InnoDB: by InnoDB 441696 bytes. Operating system errno: 12
- InnoDB: Check if you should increase the swap file or
- InnoDB: ulimits of your operating system.
- InnoDB: On FreeBSD check you have compiled the OS with
- InnoDB: a big enough maximum process size.
- InnoDB: Note that in most 32-bit computers the process
- InnoDB: memory space is limited to 2 GB or 4 GB.
- InnoDB: We keep retrying the allocation for 60 seconds...
- 100905 8:19:31 InnoDB: Error: cannot allocate 8404992 bytes of
- InnoDB: memory with malloc! Total allocated memory
- InnoDB: by InnoDB 5443792 bytes. Operating system errno: 12
- InnoDB: Check if you should increase the swap file or
- InnoDB: ulimits of your operating system.
- InnoDB: On FreeBSD check you have compiled the OS with
- InnoDB: a big enough maximum process size.
- InnoDB: Note that in most 32-bit computers the process
- InnoDB: memory space is limited to 2 GB or 4 GB.
- InnoDB: We keep retrying the allocation for 60 seconds...
- InnoDB: Error: pthread_create returned 11
- 100905 8:38:20 Plugin 'FEDERATED' is disabled.
- 100905 8:38:20 Plugin 'InnoDB' is disabled.
- 100905 8:38:20 Event Scheduler: Loaded 0 events
- 100905 8:38:20 /usr/sbin/mysqld: ready for connections.
- Version: '5.1.41-3ubuntu12' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
- 100905 8:50:34 Plugin 'FEDERATED' is disabled.
- 100905 8:50:34 Plugin 'InnoDB' is disabled.
- 100905 8:50:34 /usr/sbin/mysqld: Out of memory (Needed 16384 bytes)
- 100905 8:50:34 /usr/sbin/mysqld: Out of memory (Needed 3704 bytes)
- 100905 8:50:34 Can't open the mysql.func table. Please run mysql_upgrade to create it.
- terminate called after throwing an instance of 'std::bad_alloc'
- what(): std::bad_alloc
- 100905 8:50:34 - mysqld got signal 6 ;
- This could be because you hit a bug. It is also possible that this binary
- or one of the libraries it was linked against is corrupt, improperly built,
- or misconfigured. This error can also be caused by malfunctioning hardware.
- We will try our best to scrape up some info that will hopefully help diagnose
- the problem, but since we have already crashed, something is definitely wrong
- and this may fail.
- - key_buffer_size=16777216
- read_buffer_size=131072
- max_used_connections=0
- max_threads=151
- threads_connected=0
- It is possible that mysqld could use up to
- key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 345919 K
- bytes of memory
- Hope that's ok; if not, decrease some variables in the equation.
- - thd: 0x0
- Attempting backtrace. You can use the following information to find out
- where mysqld died. If you see no messages after this, something went
- terribly wrong...
- stack_bottom = (nil) thread_stack 0x30000
- /usr/sbin/mysqld(my_print_stacktrace+0x2d) [0xb7de830d]
- /usr/sbin/mysqld(handle_segfault+0x494) [0xb7ab43d4]
- /lib/libpthread.so.0(+0xdff8) [0xb781fff8]
- /lib/libc.so.6(abort+0x182) [0xb754eab2]
- /usr/lib/libstdc++.so.6(__gnu_cxx::__verbose_terminate_handler()+0x14f) [0xb776f52f]
- /usr/lib/libstdc++.so.6(+0xbd465) [0xb776d465]
- /usr/lib/libstdc++.so.6(+0xbd4a2) [0xb776d4a2]
- /usr/lib/libstdc++.so.6(+0xbd5e1) [0xb776d5e1]
- /usr/lib/libstdc++.so.6(operator new(unsigned int)+0x7f) [0xb776dc5f]
- /usr/sbin/mysqld(init_slave()+0x2e) [0xb7c1317e]
- /usr/sbin/mysqld(main+0x8bf) [0xb7aba1df]
- /lib/libc.so.6(__libc_start_main+0xe6) [0xb7537bc6]
- /usr/sbin/mysqld(+0x182cc1) [0xb79cfcc1]
- The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
- information that should help you find out what is causing the crash.复制代码搞了好几个小时没搞定,打算把mysql卸载了,不装论坛玩了,玩不来啊
可是我卸载后我的内存会占用增多了很多。尝试重启了好几次都不行,而且在控制面板中经常重启都无法重启
这个是截图:
各位给看看我要怎么降低内存使用啊,要不经常连静态页面都刷不出来啊。3650
3651
3652