Re: Out of memory: Kill process 3046 (mysqld)
Posted by:
Rick James
Date: April 21, 2014 10:10AM
Linux?
Is the "oom killer" running?
What is the OS value of "swappiness"? (Hint: Don't set it to 0)
> open_files_limit=65535
> innodb_open_files=65535
> table_open_cache=32768
Drop these to 5000 each
> table_definition_cache=65535
Drop to 500.
> thread_cache_size=128
Drop to 10.
> thread_stack=1M
Go back to the default. (probably never need more than 262144.)
> read_buffer_size=1M
> join_buffer_size=1M
> read_rnd_buffer_size=1M
Go back to defaults. Some of these actually hurt when going too large.
What else was running? Your settings, though high, do not look like they should have led to the need for swapping (hence oom).
Subject
Written By
Posted
Re: Out of memory: Kill process 3046 (mysqld)
April 21, 2014 10:10AM
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.