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

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 3079 cataplexy cataplexy 04/25/2011 02:54AM
Re: MySQL Server Crashing need Help 1285 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.