Knowledgebase

 

If you issue a query and get something like the following error:

mysql: Out of memory at line 42, 'test.c'
mysql: needed 8136 byte (8k), memory in use: 12481367 bytes (12189k)
ERROR 2008: MySQL client ran out of memory

Solution:

>>The reason for this error is simply that the client does not have enough memory to store the whole result. To reslove this problem, first check whether your query is correct that it sould not return so many rows in the result.