Skip navigation links

MySQL Forums :: Memory Storage Engine :: Use more CPU and Ram


Advanced Search

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
Use more CPU and Ram 1608 PF SQL 11/28/2012 05:07PM
Re: Use more CPU and Ram 1219 Rick James 12/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.