We have a wordpress website, but it appears the woocommerce plugin (or possible plugin conflict) is causing processes to get stuck, which eventually crashes the site.
it appears there are a large number of processes are stuck, specifically database queries locking the table:
========
ALTER TABLE wp8e_wc_category_lookup CHANGE COLUMN `category_tree_id` category_tree_id BIGINT UNSIGNED NOT NULL
INSERT IGNORE INTO wp8e_wc_category_lookup (category_tree_id,category_id) VALUES (729,729),(730,730),(729,730),(741,741),(729,741),(746,746),(729,746),(731,731),(729,731),(742,742),(729,742),(732,732),(729,732),(743,743),(729,743),(733,733),(729,733),(734,734),(729,734),(735,735),(729,735),(736,736),(729,736),(737,737),(729,737),(738,738),(729,738),(739,739),(729,739),(744,744),(729,744),(825,825),(729,825),(745,745),(729,745),(740,740),(729,740),(252,252),(119,119),(310,310),(558,558),(179,179),(180,180),(179,180),(182,182),(179,182),(181,181),(179,181),(630,630),(190,190),(273,273),(190,273),(184,184),(190,184),(120,120),(190,120),(157,157),(120,157),(190,157),(158,158),(120,158),(190,158),(97,97),(129,129),(175,175),(129,175),(288,288),(129,288),(114,114),(129,114),(160,160),(114,160),(129,160),(159,159),(114,159),(129,159),(297,297),(129,297),(303,303),(129,303),(98,98),(202,202),(98,202),(171,171),(98,171),(250,250),(98,250),(170,170),(98,170),(172,172),(98,172),(99,99),(136,136),[...]
========
I suspect there may be an issue with the plugin running the queries, resulting in an infinite loop, which in turns locks the table preventing further queries.
Further googling indicates that this might be a woocommerce issue: [login to view URL]