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