Site overloading 25% of server database use
Hi, My hosting company (hostgator) had suspended access to my database recently due to requests which used 25% or more from the shared server database. I had actually deactivated and deleted unwanted plugins and even two used plugins thinking that this must be from a plugin. I installed
Wp-super-cache and set it up successfull with a guide from hostgator support. However I am getting the same error still every 2 days or so. So hopefully someone from AppThemes can help me out. I am using Classipress Theme for my site. Below is the report. I have just blanked the domain to make sure it doesnt link. Any assistant is highly appreciated because there surely is something wrong which is causing this and I need to know what it is and how to fix it.
CPU_TIME:215 table_rows_read:368159099 SELECTS:16794 ROWS_UPDATED:1182 ROWS_FETCHED:5506787 BUSY_TIME:256 ONNECTED_TIME:772 BYTES_SENT:154757924 BYTES_RECEIVED:5521236 WAIT_TIME:41
Top table row reads: DB_USER: maidenv_place1 -- TOTAL_CONNECTIONS: 137 -- CONNECTED_TIME: 749 -- CPU_TIME: 214 -- TABLE_ROW_READS: 364546832 -- SELECT_COMMANDS: 16396 -- UPDATE_COMMANDS: -- BUSY_TIME: 255 -- BYTES_SENT: 154156028 -- BYTES_RECEIVED: 5454864 -- WAIT_TIME (IO): 41
DB_USER: maidenv_buysomet -- TOTAL_CONNECTIONS: 3 -- CONNECTED_TIME: 18 -- CPU_TIME: 1 -- TABLE_ROW_READS: 2527542 -- SELECT_COMMANDS: 120 -- UPDATE_COMMANDS: -- BUSY_TIME: 1 -- BYTES_SENT: 454440 -- BYTES_RECEIVED: 23448 -- WAIT_TIME (IO): 0
DB_USER: maidenv_place3 -- TOTAL_CONNECTIONS: 2 -- CONNECTED_TIME: 5 -- CPU_TIME: 0 -- TABLE_ROW_READS: 1186979 -- SELECT_COMMANDS: 299 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 409600 -- BYTES_RECEIVED: 49047 -- WAIT_TIME (IO): 0
Top WAIT (IO) TIME:
DB_USER: maidenv_place1 -- TOTAL_CONNECTIONS: 137 -- CONNECTED_TIME: 749 -- CPU_TIME: 214 -- TABLE_ROW_READS: 364546832 -- SELECT_COMMANDS: 16396 -- UPDATE_COMMANDS: -- BUSY_TIME: 255 -- BYTES_SENT: 154156028 -- BYTES_RECEIVED: 5454864 -- WAIT_TIME (IO): 41
DB_USER: maidenv_place3 -- TOTAL_CONNECTIONS: 2 -- CONNECTED_TIME: 5 -- CPU_TIME: 0 -- TABLE_ROW_READS: 1186979 -- SELECT_COMMANDS: 299 -- UPDATE_COMMANDS: -- BUSY_TIME: 0 -- BYTES_SENT: 409600 -- BYTES_RECEIVED: 49047 -- WAIT_TIME (IO): 0
DB_USER: maidenv_buysomet -- TOTAL_CONNECTIONS: 3 -- CONNECTED_TIME: 18 -- CPU_TIME: 1 -- TABLE_ROW_READS: 2527542 -- SELECT_COMMANDS: 120 -- UPDATE_COMMANDS: -- BUSY_TIME: 1 -- BYTES_SENT: 454440 -- BYTES_RECEIVED: 23448 -- WAIT_TIME (IO): 0
maidenv 9965 0.0 0.0 17980 1532 ? SN 19:09 0:00 imap [md@domain****.net 49.181.173.128]
maidenv 20685 3.8 0.1 349804 51320 ? RN 19:34 0:00 /usr/bin/php
/home3/maidenv/public_html/ domain****/
wp-cron.php maidenv 21019 0.0 0.0 17980 1528 ? SN 19:22 0:00 imap [md@domain**** 49.181.173.128]
maidenv 21832 53.5 0.2 384416 84664 ? SN 19:34 0:01 /usr/bin/php
/home3/maidenv/public_html/domain****/malaysia/index.php maidenv 21870 50.0 0.2 383384 83508 ? RN 19:34 0:01 /usr/bin/php
/home3/maidenv/public_html/domain****/malaysia/index.php maidenv 21912 72.0 0.1 361536 62580 ? SN 19:34 0:00 /usr/bin/php
/home3/maidenv/public_html/domain****/malaysia/index.php Mon Oct 21 19:34:44 CDT 2013 Running Processes: maidenv 9965 0.0 0.0 17980 1532 ? SN 19:09 0:00 imap [md@domain**** 49.181.173.128] maidenv 20685 3.8 0.1 349804 51320 ? SN 19:34 0:00 /usr/bin/php
/home3/maidenv/public_html/domain****/
wp-cron.php maidenv 21019 0.0 0.0 17980 1528 ? SN 19:22 0:00 imap [md@domain**** 49.181.173.128] maidenv 21832 53.5 0.2 384416 84664 ? SN 19:34 0:01 /usr/bin/php /home3/maidenv/public_html/domain****/malaysia/index.php
maidenv 21870 54.5 0.2 384408 84604 ? SN 19:34 0:01 /usr/bin/php
/home3/maidenv/public_html/domain****/malaysia/index.php maidenv 21912 73.0 0.1 361988 62844 ? RN 19:34 0:00 /usr/bin/php
/home3/maidenv/public_html/domain****/malaysia/index.php
Running Queries:
*************************** 1. row *************************** USER: maidenv_place1 DB: maidenv_place1 STATE: Sending data TIME: 0 COMMAND: Query INFO: SELECT object_id, term_taxonomy_id FROM me_term_relationships INNER JOIN me_posts ON object_id = ID WHERE term_taxonomy_id IN (13,3699,664,16,20,15,17,23,18,14,24,457,19,22,467 ,465,466,458,459,460,461,338,21,456,455,462,463,46 4) AND post_type IN ('ad_listing') AND post_status = 'publish'
*************************** 2. row ***************************
USER: maidenv_place1 DB: maidenv_place1 STATE: TIME: 0 COMMAND: Sleep
INFO: NULL
*************************** 3. row ***************************
USER: maidenv_place1 DB: maidenv_place1 STATE: Sending data TIME: 0 COMMAND: Query INFO: SELECT SQL_CALC_FOUND_ROWS me_posts.ID FROM me_posts INNER JOIN me_cp_ad_pop_total ON (me_posts.ID = me_cp_ad_pop_total.postnum) WHERE 1=1 AND me_posts.post_type = 'ad_listing' AND (me_posts.post_status = 'publish') AND me_cp_ad_pop_total.postcount > 0 ORDER BY me_cp_ad_pop_total.postcount DESC LIMIT 0, 10
*************************** 4. row ***************************
USER: maidenv_buysomet DB: maidenv_buysomet STATE: TIME: 0 COMMAND: Sleep INFO: NULL
Open connections Current Site Requests:
178.154.204.251 domain**** /malaysia/ad-tag/perak/
178.154.204.251 domain**** /malaysia/ad-tag/perak/
192.254.230.87 buysomething.domain**** /
wp-cron.php?doing_wp_cron=1382402068.7760500907897949 2187
192.254.230.87 buysomething.domain**** /
wp-cron.php?doing_wp_cron=1382402068.7760500907897949 2187
208.184.81.30 domain**** /malaysia/ads/condo-gembira-green-lane-3/
208.184.81.30 domain**** /malaysia/ads/condo-gembira-green-lane-3/
208.184.81.30 domain**** /robots.txt 208.184.81.30 domain**** /robots.txt
66.249.74.145 domain**** /malaysia/
wp-content/uploads/2013/07/607618-75x75.jpg
66.249.74.145 domain**** /malaysia/
wp-content/uploads/2013/07/607618-75x75.jpg
98.137.207.40 domain**** /malaysia/ads/casabella-kota-damansara-10/
98.137.207.40 domain**** /malaysia/ads/casabella-kota-damansara-10/