High MySQL load

Hello!

I have a problem with high server response times (TTFB). I suspect it is because of high MySQL cpu load but I am not sure. Can someone help me analyze this SSH htop situtation:



Basically we have a mysql connection for 275 hours that is not closing and creating up to 485% cpu load.
It has also about 20 child connections that are up for like 2 hours.

Can this be normal?

I'm not a pro at that, any input would be helpful.

Thanks

This is the part when you contact your hosting provider.

thekrotek wrote: ↑

Thu May 31, 2018 7:02 am

This is the part when you contact your hosting provider.

Actually it wasn't even their fault. I changed the table structure to innodb and added indexes for some reason the load decreased dramatically.