Post by Vindojeens » Wed May 30, 2018 11:49 pm

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:

Image

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

Newbie

Posts

Joined
Sun Nov 20, 2016 12:49 am

Post by thekrotek » Thu May 31, 2018 7:02 am

This is the part when you contact your hosting provider.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member
Online

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by Vindojeens » Fri Jun 01, 2018 12:43 am

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.

Newbie

Posts

Joined
Sun Nov 20, 2016 12:49 am
Who is online

Users browsing this forum: No registered users and 38 guests