MySQL 5.1 リファレンスマニュアル :: B Errors, Error Codes, and Common Problems :: B.1 Problems and Common Errors :: B.1.2 Common Errors When Using MySQL Programs :: B.1.2.7 Out of memory
Section Navigation [Toggle]
- B.1.2 Common Errors When Using MySQL Programs
- B.1.2.1 Access denied
- B.1.2.2 Can't connect to [local] MySQL server
- B.1.2.3 Client does not support authentication protocol
- B.1.2.4 Password Fails When Entered Interactively
- B.1.2.5 Host 'host_name' is blocked
- B.1.2.6 Too many connections
- B.1.2.7 Out of memory
- B.1.2.8 MySQL server has gone away
- B.1.2.9 Packet too large
- B.1.2.10 Communication Errors and Aborted Connections
- B.1.2.11 The table is full
- B.1.2.12 Can't create/write to file
- B.1.2.13 Commands out of sync
- B.1.2.14 Ignoring user
- B.1.2.15 Table 'tbl_name' doesn't exist
- B.1.2.16 Can't initialize character set
- B.1.2.17 'File' Not Found and Similar Errors
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).
