MySQL Forums :: Memory Storage Engine :: Use more CPU and Ram
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.
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.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Use more CPU and Ram | 724 | PF SQL | 11/28/2012 05:07PM |
| Re: Use more CPU and Ram | 426 | 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.
© 2013, Oracle Corporation and/or its affiliates