My site is WP 3.6.1 , plugins & ClassiPress theme are latest.
Hostgator don't allow my site connect with database.
This is message that hostgator sent to me: "The database was found to be consuming an inordinate amount of processor time, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Requests to this database may become degraded by limiting the maximum number of queries or connections for a limited amount of time, or if there are sustained issues, ultimately we may be forced to block access to this database until the issue has been resolved.
Resolving this situation may be as simple as adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.
If you believe you have a solution to this overuse, we are happy to discuss the situation with you and possibly reinstate the database on the server. Otherwise, we will be happy to assist you with the upgrade process if a dedicated server is the most appropriate solution. Thank you, and we look forward to hearing from you shortly.
Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (b) a query that is not optimized ][example: select all from ... and involving a large or complex query], (c) huge table copies/maintenance during peak hours. "
The error_log file increase to 100MB within 10 days
I also tried to migrate my site to VPS with 4 cores & 4GB RAM dedicated, but mysql load very high and slow down all node.
My site's database is about 1GB , about 1000visitors / day .
Please help me how to fix the problem.
This is 1 record of error_log file:
[16-Sep-2013 06:11:29] Database of WordPress error User 'webraova_wpusr' has exceeded the 'max_questions' resource (current value: 1) with query SELECT SQL_CALC_FOUND_ROWS dl_posts.ID FROM dl_posts INNER JOIN dl_postmeta ON (dl_posts.ID = dl_postmeta.post_id) WHERE 1=1 AND dl_posts.post_type = 'page' AND (dl_posts.post_status = 'publish' OR dl_posts.post_status = 'tr_pending' OR dl_posts.post_status = 'tr_failed' OR dl_posts.post_status = 'tr_completed' OR dl_posts.post_status = 'tr_activated') AND ( (dl_postmeta.meta_key = '_wp_page_template' AND CAST(dl_postmeta.meta_value AS CHAR) = 'tpl-registration.php') ) GROUP BY dl_posts.ID ORDER BY dl_posts.post_date DESC LIMIT 0, 1 require by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/classipress/wrapper.php'), get_header, locate_template, load_template, require_once('/themes/classipress/header.php'), cp_login_head, appthemes_get_registration_url, APP_Registration::get_id, APP_View_Page::_get_id, WP_Query->__construct, WP_Query->query, WP_Query->get_posts