Copyright (C) 2000-2012 |
GNU Info (mysql.info)Out of memory`Out of memory' Error --------------------- If you issue a query and get something like the following error: 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 note that the error refers to the MySQL client `mysql'. The reason for this error is simply that the client does not have enough memory to store the whole result. To remedy the problem, first check that your query is correct. Is it reasonable that it should return so many rows? If so, you can use `mysql --quick', which uses `mysql_use_result()' to retrieve the result set. This places less of a load on the client (but more on the server). automatically generated by info2www version 1.2.2.9 |