account suspended due to 90% CPU consumption

  • Hello everybody..
    My account has been suspended by my hosting provider for the following reasons…Can anyone tell me what is causing this server overload?I am not a programmer and would appreciate someone tell me where the fault lies…

    This is the message i received..

    As per our terms and conditions all the shared hosting accounts are allowed to utilize the maximum of 20% CPU load and that too shouldn’t continue for more than 90 seconds continuously, so you are advised to be in touch with your programmer to investigate about this issue and ask them to optimize your website and if this issue continues then we will suspend this account permanently and this domain is not allowed to host it on our shared servers.

    Here with i have pasted the sample My SQL queries that are running for every seconds as follows,

    mysql> show processlist;
    +——–+——————+———–+—————-+———+—
    | Id | User | Host | db | Command | Time | State | Info |
    +——–+——————+———–+—————-+———+—
    | 362704 | leechprotect | localhost | leechprotect | Sleep | 796 | | NULL |
    | 364632 | root | localhost | NULL | Query | 0 | NULL | show processlist |
    | 364676 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 0 | | NULL |
    | 364678 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 0 | | NULL |
    | 364684 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 0 | | NULL |
    | 364685 | viewfree | localhost | viewfree_ads | Query | 0 | Sending data | SELECT COUNT(*) AS records_foundFROM (posts) WHERE category = ‘services’AND title REGEXP |
    | 364686 | viewfree | localhost | viewfree_ads | Query | 0 | Sending data | SELECT COUNT(*) AS records_foundFROM (posts) WHERE category = ‘miscellaneous ‘AND state = ‘ |
    +——–+——————+———–+—————-+———+—
    7 rows in set (0.00 sec)

    mysql> show processlist;
    +——–+——————+———–+—————-+———+—
    | Id | User | Host | db | Command | Time | State | Info |
    +——–+——————+———–+—————-+———+—
    | 362704 | leechprotect | localhost | leechprotect | Sleep | 797 | | NULL |
    | 364632 | root | localhost | NULL | Query | 0 | NULL | show processlist |
    | 364676 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 0 | | NULL |
    | 364678 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 0 | | NULL |
    | 364684 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 0 | | NULL |
    | 364689 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 1 | | NULL |
    +——–+——————+———–+—————-+———+—
    6 rows in set (0.00 sec)

    mysql> show processlist;
    +——–+———————-+———–+—————-+———
    | Id | User | Host | db | Command | Time | State | Info |
    +——–+———————-+———–+—————-+———
    | 362704 | leechprotect | localhost | leechprotect | Sleep | 798 | | NULL |
    | 364632 | root | localhost | NULL | Query | 0 | NULL | show processlist |
    | 364684 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 0 | | NULL |
    | 364689 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 0 | | NULL |
    | 364700 | unauthenticated user | localhost | NULL | Connect | NULL | Reading from net | NULL |
    +——–+———————-+———–+—————-+———
    5 rows in set (0.01 sec)

    mysql> show processlist;
    +——–+——————+———–+—————-+———+—
    | Id | User | Host | db | Command | Time | State | Info |
    +——–+——————+———–+—————-+———+—
    | 362704 | leechprotect | localhost | leechprotect | Sleep | 801 | | NULL |
    | 364632 | root | localhost | NULL | Query | 0 | NULL | show processlist |
    | 364706 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 0 | | NULL |
    | 364708 | hindusta_mayur72 | localhost | hindusta_wp686 | Sleep | 1 | | NULL |
    +——–+——————+———–+—————-+———+—
    4 rows in set (0.00 sec)

    Please reply me back if you need any additional help regarding this.

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hve you scanned your site at Sucuri?

    Have you tried:

    – deactivating all plugins to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s).

    – switching to the default theme to rule out any theme-specific problems.

    – resetting the plugins folder by FTP or PhpMyAdmin. Sometimes, an apparently inactive plugin can still cause problems.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘account suspended due to 90% CPU consumption’ is closed to new replies.