PDA

View Full Version : sql queries overloading my hosts, what to do?



Anonymous
08-03-2004, 01:51 PM
According to my host, queries are causing overloading of the servers.

Host says:

The problem is, whenever someone visits the site, a bunch of mysql processes such as this occurs:

| 3166 | nationa_jacob | localhost | nationa_oscmax | Query | 95 | Copying to tmp table on disk | select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_product |

| 3172 | nationa_jacob | localhost | nationa_oscmax | Query | 34 | Copying to tmp table on disk | select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_product |

I'm not really sure what to do here.
Our account may be suspended unless we figure this out.

Any help is appreciated.
Jacob

red_fraggle
08-03-2004, 11:10 PM
these are normal queries performed by OSC to display products for your customers.

Maybe you need a host specializing in OSC hosting like AABOX or US, See our signature line :)