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?
.
.