Mysql Started Eating Up Cpu

Our CSCart V3 site has been working fine but on Friday we started getting errors, usually it is issue with cscart_product_options table which once repaired everything is fine but not this time. htop is showing that CPU usage is very high all attributed to mysql. We don't seem to be experiencing high traffic, disk space is no where near full, memory usage is low but i am unable to do anything product update related without getting either internal server error or error_occurred. So far the front end seems ok.

Scratching my head, any suggestions would be appreciated


Could you describe the environment you are using a bit more. PHP Version, Operating System, Webserver, etc.

Also, check the MySQL error log.

Kind regards,

In addition to what poppedweb said, you might also try restarting mysqld.