My Host Is Complaining about SQL

[Tsuri Japan]

My host (BLUEHOST.COM) has been really sucking lately. They are shutting my server down because they say my site is too heavy on SQL and is slowing down their server. I have a feeling it could be store that is causing this problem.

 

Does anyone know anyway I can use less sql's queries or is there someone I could hire to stream my site?

 

Nigel

[Jack_mcs]

This thread could help but if your site is too busy due to the number of customers you now have, there probably isn't anything to be done other than moving to a more powerful server or hosting plan.

 

Jack

[cocoonfx]

This thread could help but if your site is too busy due to the number of customers you now have, there probably isn't anything to be done other than moving to a more powerful server or hosting plan.

 

Jack

 

Get a new host!

[Jack_mcs]

A new host may not make a difference. It depends on the cause of the problem and the resource limits of the hosting plans.

 

Jack

[Guest]

Hello,

 

Are you using the so call "unlimited hosting"?

 

If not, they shouldn't shut down your hosting so far the traffic is within the bandwidth limited. Moreover they should advise you to upgrade the hosting plan rather than shut down your hosting.

 

Best regards

[Jack_mcs]

That depends on the host. Most, if not all, of those that offer unlimited disk space and/or bandwidth, will have conditions in their TOS's that allows them to limit those. There will also probably be asection that explains a site will be shut down if it is causing server load problems - that's pretty standard. As you hint at, those "unlimited" offers are a gimick but I've seen many posts here, and on other forums, where people continually fall for them.

 

Jack

[~Kira]

yes but they should easily be able to tell which scripts/pages/queries are causing the stress. they have access to a lot of diagnostic tools that the user doesn't. they should be able to at least help you pinpoint the area(s) that need reworking, unless they just don't care and want to get rid of you, or they don't know what they're doing.

[steve_s]

running this sql on your stores datbase will cut down a lot of the queries being made

ALTER TABLE `products_to_categories` DROP PRIMARY KEY;
ALTER TABLE `products_to_categories` ADD INDEX `idx_p2c_categories_id` ( `categories_id` );
ALTER TABLE `products_to_categories` ADD INDEX `idx_p2c_products_id` ( `products_id` );
ALTER TABLE `categories` ADD INDEX (`sort_order`);
ALTER TABLE `customers` ADD INDEX (`customers_email_address`);
ALTER TABLE `orders` ADD INDEX (`customers_id`);
ALTER TABLE `products` ADD INDEX (`products_model`), ADD INDEX (`products_price`), ADD
INDEX (`products_date_available`), ADD INDEX (`manufacturers_id`);
ALTER TABLE `products_attributes` ADD INDEX (`products_id`), ADD INDEX (`options_id`);
ALTER TABLE `products_options` ADD INDEX (`products_options_name`);
create index IDXSPECIALSPRICE on specials (products_id,status,specials_new_products_price);