MySQL Forums
Forum List  »  MyISAM

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
Re: MySQL Server Crashing need Help
1305
May 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.