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

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 5645 PF SQL 11/28/2012 05:07PM
Re: Use more CPU and Ram 2310 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.