[SR T A RICH]

our website database has been temporarily blocked as the database is consuming excessive server resources

here is hostgator response to situation:
If using a CMS, like WordPress or Joomla, ensure that you have a caching plugin enabled
– Reduce the size of your databases by removing old content, clearing out post revisions and spam comments, or simply archiving old table data
– Perform a repair and optimization of your databases via phpMyAdmin or command line
– Remove any database-based logging when other options are available
– Reduce the item count in pagination. Instead of 50 items per page, try 20 or 30
– Identify slow running processes and queries for further optimization
– Add database indexes on frequently used tables and queries
– Include return limits on your queries, select * from posts limit 10
– User counter caches to replace select count(*) statements
– Limit the number of temporary tables created on large joins
– Be cautious when sorting large table returns
– Perform extensive maintenance operations off peak-hours
– Mysql connections should be closed as soon as the query results are returned

any suggestions how to proceed?

[Theme Horse Support Team]

Hi Tarich,

Sorry! This is not a theme related issue and seems that you have a large data in your site.
Which needs to fix by yourself OR you can hire a developer for to fix all above mentioned points also it seems that you have to upgrade your hosting service as well to fix all above points.

Thank you!

[Author]

Posts