MySQL Forums
Forum List  »  Newbie

Re: Query performance
Posted by: Rick James
Date: November 22, 2014 11:11AM

> innodb_buffer_pool_size = 6000M
> 4G ram

Very, very, VERY BAD!

You have asked to use more than 10GB (buffer_pool + key_buffer + query_cache + etc) of RAM on a 4GB system. It won't fit, and must "swap". Swapping is terrible for MySQL (MyISAM or InnoDB).

For the 4GB machine:
key_buffer_size = 200M
innodb_buffer_pool_size = 1000M
query_cache_size = 25M

For the 8GB machine, double those numbers.

> The server version is 5.5.40-36.1 Percona Server (GPL). This matter?

Thanks for the info, but for your particular situation, all versions of MySQL treat RAM and caching similarly.

Options: ReplyQuote


Subject
Written By
Posted
November 21, 2014 09:45AM
November 21, 2014 12:56PM
November 21, 2014 02:15PM
November 22, 2014 09:00AM
Re: Query performance
November 22, 2014 11:11AM


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.