cs cart queries killing my server, processes not dieing

cs cart queries killing my server, processes not dying



I have been having some load issues lately and no have narrowed it down to the fact the cs cart is opening mysql queries but they are remaining open and not diwing therefore taking up all the server resources



SELECT cscart_product_features_values.feature_id, COUNT( DISTINCT cscart_products.product_id ) AS prod



I had like 10 instaces of this and the process had been open for like 40 minutes



What can be done about this?



Thanks



B



veriosn 2.0.11

ID User Host Database Command Time Status SQL query

Kill 757 admin localhost cart Query 19 statistics SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product AS product, products.tracking, produc

Kill 771 admin localhost xxxxx_db Sleep 0 — —

Kill 772 admin localhost xxxxx_db Sleep 0 — —

Kill 773 admin localhost mysql Query 0 — SHOW PROCESSLIST



Then like 20 seconds later, query still open:



ID User Host Database Command Time Status SQL query

Kill 757 admin localhost cart Query 47 statistics SELECT cscart_product_features_values.feature_id, COUNT( DISTINCT cscart_products.product_id ) AS prod

Kill 848 admin localhost mysql Query 0 — SHOW PROCESSLIST



80 seconds later, query still open:



ID User Host Database Command Time Status SQL query

Kill 757 admin localhost cart Query 100 statistics SELECT cscart_product_features_values.feature_id, COUNT( DISTINCT cscart_products.product_id ) AS prod



200 seconds later:



ID User Host Database Command Time Status SQL query

Kill 757 admin localhost cart Query 200 statistics SELECT cscart_product_features_values.feature_id, COUNT( DISTINCT cscart_products.product_id ) AS prod



Process still open and if the same process opens again it also will not sleep so in a few hours time my servers load will be high and very very slow…



Note: This only happens for CS cart process all other process from say Wordpress close instantly, you see them go to sleep



What to do?



Thanks