Guest Posted January 20, 2006 Posted January 20, 2006 just got a message from my host stating this query was causing high load on the server. 192593 | xx_xxxx | localhost | xx_xxxx | Query | 113 | Copying to tmp table | select distinct p.products_image, m.manufacturers_id, p.products_id, pd.products_name, p.products_p | | 192598 | xx_xxxx | localhost | xx_xxxx | Query | 108 | Copying to tmp table | select distinct p.products_image, m.manufacturers_id, p.products_id, pd.products_name, p.products_p | | 192599 | xx_xxxx | localhost | xx_xxxx | Query | 107 | Copying to tmp table | select distinct p.products_image, m.manufacturers_id, p.products_id, pd.products_name, p.products_p | | 192641 | xx_xxxx | localhost | xx_xxxx | Query | 21 | Locked | update products_description set products_viewed = products_viewed+1 where products_id = '797' and la | | 192642 | xx_xxxx the x's are either my cpanel username or database username. what could cause this problem?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.