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