Mysqld High CPU

[datalabsys]

Hi, im running Proxmox4 in a 128GB RAM machine with 8 core cpu

4 VMs in there and there is a mysqld service runnung at 135% the CPU, why is this happening and how do i troubleshoot it?


thank in advance guys!

 

[udo]

Hi,
if the VM has more than one core: the mysql-process simply use more than one core.
It's very usefull to use smp with db-server.

If a kvm-process use more than 100% on a 1-core-process I guess it happens due the virtio-driver.

Udo