asapcustoms Posted October 11, 2007 Share Posted October 11, 2007 We have been told by our host to shut our OS system down after over 2 years and 7500 hours of work due to server load over 80%. Does anyone know why the following errors happen, this is what the host keeps sending but not sure where to start to fix it? Any help would be great for this stressed team over here. with mysql high load mysql and whole system: root@server [/]# uptime 17:45:59 up 22 min, 0 users, load average: 11.57, 9.09, 5.50 root@server [/]# mysqladmin processlist +-----+---------------+-----------+---------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+---------------+-----------+---------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 60 | asapcust_asap | localhost | asapcust_cart | Query | 445 | Copying to tmp table | select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_ne | | 69 | asapcust_asap | localhost | asapcust_cart | Query | 407 | Copying to tmp table | select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_ne | | 72 | asapcust_asap | localhost | asapcust_cart | Query | 399 | Copying to tmp table | select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_ne | | 77 | asapcust_asap | localhost | asapcust_cart | Query | 262 | Copying to tmp table | select distinct p.products_image, p.products_model, m.manufacturers_name, m.manufacturers_id, p.pro | | 79 | asapcust_asap | localhost | asapcust_cart | Query | 261 | Copying to tmp table | select distinct p.products_image, p.products_model, m.manufacturers_name, m.manufacturers_id, p.pro | | 80 | asapcust_asap | localhost | asapcust_cart | Query | 241 | Copying to tmp table | select p.products_image, p.products_model, m.manufacturers_name, pd.products_name, p.products_id, p | | 82 | asapcust_asap | localhost | asapcust_cart | Query | 343 | Copying to tmp table | select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_ne | | 83 | asapcust_asap | localhost | asapcust_cart | Query | 255 | Copying to tmp table | select p.products_image, p.products_model, m.manufacturers_name, pd.products_name, p.products_id, p | | 84 | asapcust_asap | localhost | asapcust_cart | Query | 340 | Copying to tmp table | select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_ne | | 86 | asapcust_asap | localhost | asapcust_cart | Query | 294 | Sending data | select count(p.products_id) as total from products p, products_description pd, manufacturers m left | | 91 | asapcust_asap | localhost | asapcust_cart | Query | 12 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 93 | asapcust_asap | localhost | asapcust_cart | Query | 11 | Locked | select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quanti | | 94 | asapcust_asap | localhost | asapcust_cart | Query | 10 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 99 | asapcust_asap | localhost | asapcust_cart | Query | 9 | Locked | select count(p.products_id) as total from products_description pd, products p left join manufacture | | 102 | asapcust_asap | localhost | asapcust_cart | Query | 10 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 106 | asapcust_asap | localhost | asapcust_cart | Query | 10 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 108 | asapcust_asap | localhost | asapcust_cart | Sleep | 8 | | | | 123 | asapcust_asap | localhost | asapcust_cart | Query | 9 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 126 | asapcust_asap | localhost | asapcust_cart | Query | 11 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 127 | asapcust_asap | localhost | asapcust_cart | Query | 12 | Locked | update products_description set products_viewed = products_viewed+1 where products_id = '7449' and l | | 129 | asapcust_asap | localhost | asapcust_cart | Query | 10 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 130 | asapcust_asap | localhost | asapcust_cart | Query | 45 | Copying to tmp table | select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_ne | | 131 | asapcust_asap | localhost | asapcust_cart | Query | 11 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 132 | asapcust_asap | localhost | asapcust_cart | Query | 11 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 133 | asapcust_asap | localhost | asapcust_cart | Query | 41 | Copying to tmp table | select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_ne | | 136 | asapcust_asap | localhost | asapcust_cart | Query | 11 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 137 | asapcust_asap | localhost | asapcust_cart | Query | 8 | Locked | select count(p.products_id) as total from products_description pd, products p left join manufacture | | 138 | asapcust_asap | localhost | asapcust_cart | Query | 10 | Locked | select count(p.products_id) as total from products_description pd, products p left join manufacture | | 140 | asapcust_asap | localhost | asapcust_cart | Query | 10 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 141 | asapcust_asap | localhost | asapcust_cart | Query | 10 | Locked | select p.products_id, pd.products_name, pd.products_description, pd.products_spec, pd.products_musth | | 143 | asapcust_asap | localhost | asapcust_cart | Query | 9 | Copying to tmp table | select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_ne | | 144 | root | localhost | | Query | 0 | | show processlist | +-----+---------------+-----------+---------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ root@server [/]# ------------------- Thank you for any info you may provide. Link to comment Share on other sites More sharing options...
asapcustoms Posted October 11, 2007 Author Share Posted October 11, 2007 Still no takers? I thought this is where all the pros read? Does anyone have any tips on the following problem above? Link to comment Share on other sites More sharing options...
♥toyicebear Posted October 11, 2007 Share Posted October 11, 2007 osCommerce query optimization Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here] Link to comment Share on other sites More sharing options...
asapcustoms Posted October 11, 2007 Author Share Posted October 11, 2007 Nick Thank you so much for pointing me in the right area. We will spend the next few days putting the changes in. You Rock!! :thumbsup: Link to comment Share on other sites More sharing options...
asapcustoms Posted October 11, 2007 Author Share Posted October 11, 2007 Do you happen to know what the Copying to tmp table part means? Is this the tmp folder in oscommerce on the server or a DB? Thanks again Link to comment Share on other sites More sharing options...
allcam Posted October 21, 2009 Share Posted October 21, 2009 Hi Asapcustoms, Can you kindly advise what was the solution to the "Copying to tmp table" problem? We have experienced the same issue, we have even upgrade to a 4-core CPU 4GB RAM linux server, but the problem still exist. 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.