Results 1 to 4 of 4

Thread: Site overloading 25% of server database use

  1. #1
    Thread Starter
    Senior Member muadmz's Avatar
    Join Date
    Jun 2011
    Location
    Malaysia
    Posts
    154
    Thanks
    5
    Thanked 6 Times in 5 Posts

    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/

  2. #2
    Thread Starter
    Senior Member muadmz's Avatar
    Join Date
    Jun 2011
    Location
    Malaysia
    Posts
    154
    Thanks
    5
    Thanked 6 Times in 5 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  3. #3
    Thread Starter
    Senior Member muadmz's Avatar
    Join Date
    Jun 2011
    Location
    Malaysia
    Posts
    154
    Thanks
    5
    Thanked 6 Times in 5 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!

  4. #4
    seoagent's Avatar
    Join Date
    Jul 2012
    Location
    Edmonton, AB, Canada
    Posts
    660
    Thanks
    136
    Thanked 86 Times in 74 Posts
    You must be an AppThemes customer and logged in to view this response. Join today!
    When in doubt: Read, Ask, Do. G+

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Best way to backup site/database??
    By erj80 in forum ClassiPress General Discussion
    Replies: 1
    Last Post: February 18th, 2013, 02:53 AM
  2. Using database for multilanguage site
    By orangemedia in forum ClassiPress General Discussion
    Replies: 5
    Last Post: December 11th, 2012, 01:20 PM
  3. Dimitris Using database for multilanguage site
    By orangemedia in forum Report ClassiPress Bugs
    Replies: 5
    Last Post: December 11th, 2012, 01:20 PM
  4. Using wamp server to build site
    By mazza in forum ClassiPress General Discussion
    Replies: 8
    Last Post: September 25th, 2012, 12:54 PM
  5. Database error?? In server error_log
    By gordon in forum Report ClassiPress Bugs
    Replies: 11
    Last Post: February 8th, 2012, 10:00 AM