mysql memory used_大家来看下这个mysql的错误是怎么回事

你的位置:

问答吧

-> MySQL

-> 问题详情

大家来看下这个mysql的错误是怎么回事

本来好好的,我重启了下MYSQL服务,结果,刚重启时好好的,可是过了一会,MYSQL就报错,错误如下:

080815 17:38:16 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed 1677456 bytes)

080815 17:38:21 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed 1480320 bytes)

080815 17:38:23 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed 1677712 bytes)

080815 17:38:28 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed 1353000 bytes)

080815 17:38:32 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed 8192 bytes)

080815 17:38:32 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed 8164 bytes)

080815 17:38:32 [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space

080815 17:38:32 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed 8164 bytes)

080815 17:38:32 [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space

080815 17:38:32 - mysqld got signal 11;

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=536870912

read_buffer_size=4190208

max_used_connections=9

max_connections=2000

threads_connected=9

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 123056 K

bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

我用top看下进程时,发现MYSQL进程的size一启动就有450M以上,没过几分种就涨到500M以上了,这是怎么回事呀,是不是我的配置文件有问题,还是怎么回事,

我的内存是4G的,应该够用了呀,操作系统是freeBSD的

希望有高手指点一二.

附件: 您所在的用户组无法下载或查看附件

作者: sdomain

发布时间: 2008-08-18

超出存储器，超出存储，应该是指内存？？

作者: 恋上恋鱼s

发布时间: 2008-08-18

是呀,就是内存溢出,该怎么办呀,有什么好的解决办法或,

作者: sdomain

发布时间: 2008-08-18

你的Key_buffer_size, reade_buffer_size, max_connection都设置的也太大了，不知道你想干嘛，这样的设置大约要用8.6G内存，所以，Out of memery就很正常了。

作者: leric

发布时间: 2008-08-18

那我想请问下楼上的,

Key_buffer_size, reade_buffer_size, max_connection

这三个值应该设成多大的最合适,谢谢

作者: sdomain

发布时间: 2008-08-20