Skip navigation links

MySQL Forums :: MyISAM :: MySQL Server Crashing need Help


Advanced Search

Re: MySQL Server Crashing need Help
Posted by: Rick James ()
Date: May 07, 2011 11:42PM

Let's look at the slow queries in the Slow log now.
Once we have fixed them, then lower this to 2:
Current long_query_time = 10.000000 sec.

Also read this for tuning advice. (Some of what they say as OK, is not.)
http://mysql.rjweb.org/doc.php/memory

query_cache_size = 512M -- TOO BIG; 50M, max.

[OK] InnoDB data size / buffer pool: 35.4M/512.0M
-- Not OK; wasting nearly 500MB. Change to
innodb_buffer_pool_size = 40M

[OK] Key buffer size / total MyISAM indexes: 8.0M/59.4M
-- With 12GB of RAM, you may as well have
key_buffer_size = 70M

table_cache = 4096
-- too big (unless you are running a version that hashes the entries)

Options: ReplyQuote


Subject Views Written By Posted
MySQL Server Crashing need Help 2160 cataplexy cataplexy 04/25/2011 02:54AM
Re: MySQL Server Crashing need Help 832 Rick James 05/07/2011 11:42PM


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.