MySQL Forums
Forum List  »  Performance

Re: Poor performance of MySQL 5.5
Posted by: Rick James
Date: May 24, 2011 08:14AM

query_cache_size, key_buffer_size

query_cache_size=350M --> 50M -- Do not set higher than 50M; it is inefficient at high values.
table_cache=1520 --> 500
key_buffer_size=548M --> 40M -- Used only for MyISAM, but you are using only InnoDB.
innodb_flush_log_at_trx_commit=1 -- This is safer, but hits the disk on every COMMIT. I assume you have autocommit=1, so that means it hits the disk on every write query.
innodb_buffer_pool_size = 10G -- Good. (But overkill if you have only 500M of data)
long_query_time = 5 --> 1 -- then (after some time) check the slowlog for what queries are slowest.

SHOW VARIABLES LIKE 'innodb%';
SHOW GLOBAL STATUS LIKE 'Innodb%';
SHOW GLOBAL STATUS LIKE 'Uptime';

More discussion of these topics:
http://mysql.rjweb.org/doc.php/memory

Options: ReplyQuote


Subject
Views
Written By
Posted
15128
May 23, 2011 04:43AM
Re: Poor performance of MySQL 5.5
4863
May 24, 2011 08:14AM
4907
May 25, 2011 10:40AM
3142
May 31, 2011 09:03AM
3689
June 03, 2011 09:33AM
2299
June 03, 2011 07:13PM


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.