MySQL Forums
Forum List  »  General

Re: Anybody met this errors :Out of memory (Needed 16777224 bytes) ?
Posted by: Rick James
Date: March 15, 2009 12:17PM

In my experience, that message means that the Operating System has a limit on how much address space it will give one process. On 32-bit FreeBSD, it defaulted to 512MB. When we had a 2GB machine dedicated to MySQL, the solution was to change the OS limit, not to shrink the settings in MySQL. I recommend trying that first.

In any case, you should not let MySQL swap; performance will suffer badly.

The primary tunables are
key_buffer_size - set to 20% of _available_ RAM if using MyISAM heavily, else 20M.
innodb_buffer_pool_size - 70% of _available_ RAM if using InnoDB heavily, else 0.
Then make sure you are not swapping.

64-bit machines running 64-bit MySQL probably have no limit that anyone will hit (in this decade).

Options: ReplyQuote


Subject
Written By
Posted
Re: Anybody met this errors :Out of memory (Needed 16777224 bytes) ?
March 15, 2009 12:17PM


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.