Re: my system usage hits 100% at every 6 hours.

[mrugesh shah]

Rick James Wrote:
-------------------------------------------------------
> Well, nothing you said points at MySQL as being
> the CPU hog. Turn on the slowlog, and see if
> anything shows up. Set long_query_time=2 (to
> catch any slow critters taking > 2 sec).
>
> Does VPS or Wordpress use Java under the hood?
> Java used to have spikes when it does garbage
> collection.
>
> Do not "kill" mysqld, stop it gracefully. Killing
> it can lead to corruption, especially of MyISAM
> tables.
>
> 11 qps -- yawn. Unless they are big queries,
> MySQL is not doing much.

hello,

Now I have set long_query_time=2 in my.conf let us see what happens now after 4 hours.

"Turn on the slowlog" - how I can do that ? Any command for that ?

I donot know my VPS or wordpress installation uses Java or not. Mine is VZ power panel with 384MB ram and 786 brustable. It is nothing specific. just standard installation. No complicated site. Just one blog with text data only.

You are right, I will not kill any process. I am just restating mysql services from VPS power panel.

Your last sentence : " 11 qps -- yawn. Unless they are big queries,
> MySQL is not doing much." I did not get this properly. WIll you please explain me ?

one thing i deeply observed that due to mysql.sock process, my system usage gets starts increasing only after two hours (after restarting mysql). It takes total 4.5 hours to reach at maximum 100%. Do not know why this is happing, but it is due to mysql process only.


Please guide.