High CPU usage with 0 traffic.

[woocommerce_dev]

Hi,

I am hosting a e commerce website with Digital Ocean via OLS image. I see my website has high CPU usage with 0 or no traffic as I am still completing developments.
I am trying to understand why MySQL keeps going down again and again. Also how can I debug and find the root cause for this poor performance? My CPU are running at 60% and lsphp / redis are top results in top command.

Thanks.

 

[exe.cash]

InnoDB engine causes that if your system has low memory and shared cpu. I converted my tables to MyISAM.

InnoDB was good almost over 600k products. However requires much more system resources than MyISAM. Totally sucked my monthly budget way over. You can think about to work with a database optimizer. Also do not use database caching feature to avoid slowing it down.