Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

SQL Overload
 
orthodoxkohen
Jr. Member
 
Total Posts:  9
Joined:  2008-07-25
 

Database overload due to queries being executed. My hosting provider has said the following

We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server’s load to increase degrading the performance for all other customers on this server.

->Query summary
Time
96% (8290 secAmount96% (970 queriesRows Examined/Sent737 87 AvgQuery Exec/Lock Time0 sec.
Used databases[kencost_msn]
Query example
: use kencost_msnINSERT INTO `catalogindex_aggregation` (`store_id`, `created_at`, `key`, `data`) VALUES ('1''2009-09-08 07:58:40''Q_38_STORE_1_CAT_3_CUSTGROUP_0_enable_googlecheckout_1_computer_manufacturers_75_manufacturer_119_SUBCATEGORIES''a:0:{}');

Any help with this would be helpful.

 
Magento Community Magento Community
Magento Community
Magento Community
 
orthodoxkohen
Jr. Member
 
Total Posts:  9
Joined:  2008-07-25
 

taps fingers on keyboard…

 
Magento Community Magento Community
Magento Community
Magento Community
 
demonkoryu
Guru
 
Avatar
Total Posts:  328
Joined:  2008-11-26
Dortmund, Germany
 

Magento is performance hungry. It is not advised to run Magento on a shared host.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top