买的那个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