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).

Options: ReplyQuote


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.