[arch-general] Mariadb eats system ressources

[Maykel Franco]

El 09/10/2014 18:24, "Stefan Tatschner" <rumpelsepp at sevenbyte.org> escribió:
>
> On 2014-10-09 17:48, Leonidas Spyropoulos wrote:
> > Can you share your my.cnf and a few information on your databases you
> > host on the mariadb server?
>
> The my.cnf is just the default one from the repo, I have enabled
> "skip-network". My setup is not that big. I host 5 wordpress sites and
> one piwik instance on it. There are daily about 50 visitors maximum.
> Apache is most of the time in idle state and -- as I mentioned before --
> even disabling apache does not fix the cpu usage of mariadb.
>
> Stefan

Hi, when MySQL is high, go to into cmd line MySQL command and exec: show
peocesslist;

What's result?

You use raíd por single disk?? The state disk health is ok?