Guest Posted May 22, 2009 Share Posted May 22, 2009 My oscommerce sites have started crashing mysql because of 100s of locked querys. I have two oscommerce sites on a dedicated server with 1 gb ram. My hosting company is trying to help but keep recommending 2gb memory, which I dont really want to do as there hasnt been any up in traffic. I dont know what to do, help? Heres an example of the proccess list pd.products_name, pd.products_description, pd.products_head_ti | | 158 | caios | localhost | shacktoo_shcktoo83 | Query | 107 | Locked | select pd.language_id, p.products_id, pd.products_name, pd.products_description, pd.products_head_ti | | 160 | caios | localhost | shacktoo_shcktoo83 | Query | 119 | Locked | select pd.language_id, p.products_id, pd.products_name, pd.products_description, pd.products_head_ti | | 161 | caios | localhost | shacktoo_shcktoo83 | Query | 26 | Locked | select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from review | | 165 | caios | localhost | shacktoo_shcktoo83 | Query | 28 | Locked | select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from review | | 166 | caios | localhost | shacktoo_shcktoo83 | Query | 28 | Locked | select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from review | | 168 | root | localhost | shacktoo_shcktoo83 | Query | 500 | Waiting to get writelock | REPAIR TABLE `address_book`, `address_format`, `affiliate_affiliate`, `affiliate_banners`, `affiliat | | 172 | caios | localhost | shacktoo_shcktoo83 | Query | 24 | Locked | select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from review | | 173 | caios | localhost | shacktoo_shcktoo83 | Query | 25 | Locked | select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from review | | 174 | caios | localhost | shacktoo_shcktoo83 | Query | 26 | Locked | select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from review | Link to comment Share on other sites More sharing options...
Guest Posted May 22, 2009 Share Posted May 22, 2009 anything to do with advanced search seams to take ages as well Link to comment Share on other sites More sharing options...
Guest Posted May 22, 2009 Share Posted May 22, 2009 HELP, have watched the process list and as soon as "DELETE FROM cache WHERE cache_expires" comes up the server grinds to a hault. Its from chemos code the above. I dont see why the cache would delete it self after the servers only beeen running an hour. I cant find a setting for this in configure. Any ideas, please? Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.