First time ever but my site was suspended. I'll post the email below. I was told if it happens again, I'm outta there and I've been in business for 7 years with this company.I don't know what happened. If someone can help me out here, I'd so appreciate it!
I do know the MSN Bot visited at 12:15 right before all these queries, do you think it's possible the bot did this? If so, how can if be corrected so it doesn't happen again. If it happens again, they will shut me down!
Thanks in advance!
~Marie
------------------------------------
Below is the email and partial queries/problem: (shortened due to length of email)
Dear Customer,
One of your domains, XXXXX.com, has been suspended for excessive system resource usage due to single MySQL connections executing over 320 MySQL queries. Two examples of this occurring are attached. This sort of activity cannot be tolerated in a shared hosting environment.
Regards,
XXX
060718 12:23:43 1 Connect zen@localhost on
1 Init DB zen
1 Query select configuration_key as cfgkey, configuration_value as cfgvalue
1 Query select configuration_key as cfgkey, configuration_value as cfgvalue
060718 12:23:44 1 Query select value
1 Query select code, title, symbol_left, symbol_right, decimal_point,
1 Query select template_dir
1 Query select template_dir
1 Query select p.products_id
1 Query delete from whos_online
1 Query select count(*) as count
1 Query update whos_online
1 Query select banners_id, date_scheduled
1 Query select b.banners_id, b.expires_date, b.expires_impressions,
1 Query select categories_name
1 Query select categories_name
1 Query select products_name
1 Query select products_type from products where products_id = '151'
1 Query select type_handler from product_types where type_id = '1'
1 Query select specials_new_products_price from specials where products_id = '151' and status='1'
1 Query select master_categories_id from products where products_id = '151'
10 Query select sale_specials_condition, sale_deduction_value, sale_deduction_type from salemaker_sales where sale_categories_all like '%,20,%' and sale_status = '1' and (sale_date_start <= now() or sale_date_start = '0001-01-01') and (sale_date_end >= now() or sale_date_end = '0001-01-01') and (sale_pricerange_from <= '26.0000' or sale_pricerange_from = '0') and (sale_pricerange_to >= '26.0000' or sale_pricerange_to = '0')
10 Query select sum(tax_rate) as tax_rate
10 Query select products_name
10 Query select products_type from products where products_id = '253'
10 Query select type_handler from product_types where type_id = '1'
10 Query select products_type from products where products_id = '253'
10 Query select type_handler from product_types where type_id = '1'
10 Query select categories_name from categories_description where categories_id= '2' and language_id= '1'
10 Query select distinct p.products_id, p.products_image, pd.products_name
10 Query select p.products_id, pd.products_name, products_date_available as date_expected
10 Query select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows
10 Query select startdate, counter from counter
10 Query update counter set counter = '300293'
10 Query select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows
10 Query select banners_id, banners_title, banners_image, banners_html_text, banners_open_new_windows
060718 12:23:58 10 Query select count(*) as total
10 Query update sessions
Bookmarks