MySQL Forums
Forum List  »  Memory Storage Engine

Re: Use more CPU and Ram
Posted by: Rick James
Date: December 02, 2012 07:46PM

> and 1-2% Ram are used. I am using InnoDb default
Set innodb_buffer_pool_size to about 40% of RAM (since you have a 32-bit compile).

See also
http://mysql.rjweb.org/doc.php/memory

If changing the buffer_pool size does not get the CPU down below 10%, then look for your slowest queries, and let's work on optimizing them.

Options: ReplyQuote


Subject
Views
Written By
Posted
5806
November 28, 2012 05:07PM
Re: Use more CPU and Ram
2352
December 02, 2012 07:46PM


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.