Re: ERROR 5 (HY000): Out of memory
Posted by:
Rick James
Date: August 07, 2011 03:56PM
How much RAM do you have?
32-bit or 64-bit OS?
32-bit or 64-bit MySQL?
What OS are you on?
The OS limits the amount of RAM allocated to each process -- what is that value?
These may be too large; cut them in half:
max_connections = 256
table_cache = 2048
Since your tables are InnoDB, change key_buffer_size from 256M to only 30M.
For more discussion of memory allocation, see
http://mysql.rjweb.org/doc.php/memory
Subject
Written By
Posted
Re: ERROR 5 (HY000): Out of memory
August 07, 2011 03:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.