mysql 启动时怎么会Out of memory 呢？一般是什么地方设得不对？

阿辉

070408 21:27:18  mysqld started
070408 21:27:20  InnoDB: Started; log sequence number 0 3089809617
/usr/libexec/mysqld: Out of memory (Needed 237527040 bytes)
/usr/libexec/mysqld: Out of memory (Needed 178145280 bytes)
070408 21:27:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

mysql 启动时怎么会Out of memory 呢？一般是什么地方设得不对？

llzqq

my.cnf是怎么配置的？

shanya

google 了下。在freeBSD下好像有内存512的限制。LINUX没发现这样的解决办法。呵呵。

lvDbing

Out of memory

If you issue a query using the mysql client program and receive an error like the following one, it means that mysql does not have enough memory to store the entire query result:
mysql: Out of memory at line 42, 'malloc.c'
mysql: needed 8136 byte (8k), memory in use: 12481367 bytes (12189k)
ERROR 2008: MySQL client ran out of memory

To remedy the problem, first check whether your query is correct. Is it reasonable that it should return so many rows? If not, correct the query and try again. Otherwise, you can invoke mysql with the --quick option. This causes it to use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server).