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.
Subject
Views
Written By
Posted
7432
November 28, 2012 05:07PM
Re: Use more CPU and Ram
3217
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.