Help me for "CPU Quota/Suspension Error"

[tiengnhat]

Hello all.

I have any question and i want you help me to fix it.

My host have an error below: "

CPU Quota/Suspension Error

http://www.etrainingteam.com/fastdomain/fdcpuexceeded.JPG

And I joint to "cpu_exceeded_logs" and open log:

--------------------------------------------------------------------------------

CPU Exceeded Log For Fri Aug 29 03:32:21 2008

Fri Aug 29 03:32:21 2008: used 799.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:32:21 2008: used 0.07 seconds of cpu time for /ramdisk/bin/php5 /home.../public_html/4rum/register.php

Fri Aug 29 03:32:21 2008: used 0.06 seconds of cpu time for /ramdisk/bin/php5 /home.../public_html/4rum/showthread.php

Fri Aug 29 03:32:21 2008: used 0.06 seconds of cpu time for /ramdisk/bin/php5 /home.../public_html/4rum/misc.php

Fri Aug 29 03:32:21 2008: used 0.05 seconds of cpu time for /ramdisk/bin/php5 /home.../public_html/4rum/showthread.php

Fri Aug 29 03:32:21 2008: used 1.23 seconds of cpu time for PROCESS : /ramdisk/bin/php5 /home.../public_html/4rum/register.php

Fri Aug 29 03:32:15 2008: used 0.14 seconds of cpu time for /ramdisk/bin/php5 /home.../public_html/4rum/register.php

Fri Aug 29 03:31:50 2008: used 0.14 seconds of cpu time for /ramdisk/bin/php5 /home.../public_html/4rum/showthread.php

Fri Aug 29 03:31:35 2008: used 3.86 seconds of cpu time for HTTP Request: www.yoursite.com : GET /favicon.ico HTTP/1.1



--------------------------------------------------------------------------------

CPU Exceeded Log For Fri Aug 29 03:58:25 2008

Fri Aug 29 03:58:25 2008: used 268.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:24 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:24 2008: used 0.01 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:24 2008: used 0.03 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:23 2008: used 2.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:23 2008: used 0.08 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:23 2008: used 0.14 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:22 2008: used 0.08 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:22 2008: used 0.18 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:21 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:21 2008: used 0.02 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:21 2008: used 0.04 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:20 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:20 2008: used 0.13 seconds of cpu time for /ramdisk/bin/php5 /home.../public_html/4rum/login.php

Fri Aug 29 03:58:20 2008: used 0.01 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:20 2008: used 0.01 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:19 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:19 2008: used 0.04 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:19 2008: used 0.11 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:18 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:18 2008: used 0.07 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:18 2008: used 0.18 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:17 2008: used 3.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:17 2008: used 0.02 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:17 2008: used 0.15 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:16 2008: used 0.03 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:16 2008: used 0.17 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:15 2008: used 0.03 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:15 2008: used 0.14 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:14 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:14 2008: used 0.02 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:14 2008: used 0.16 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:13 2008: used 3.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:13 2008: used 0.02 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:13 2008: used 0.03 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:12 2008: used 0.02 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:12 2008: used 0.04 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:11 2008: used 0.01 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:11 2008: used 0.03 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:10 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:10 2008: used 0.02 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:10 2008: used 0.04 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:09 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:09 2008: used 0.08 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:09 2008: used 0.18 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:08 2008: used 0.03 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:08 2008: used 0.17 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:07 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:07 2008: used 0.01 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:07 2008: used 0.02 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:06 2008: used 1.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:06 2008: used 0.03 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:06 2008: used 0.05 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:05 2008: used 50.00 seconds of cpu time for [[mysql query]]

Fri Aug 29 03:58:05 2008: used 0.01 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:04 2008: used 0.01 seconds of cpu time for mysqldump -c -q --add-drop-table -h localhost -u data -px xxxxxxxxxxxxx data_4rum

Fri Aug 29 03:58:04 2008: used 0.01 seconds of cpu time for gzip -f -

Fri Aug 29 03:58:03 2008: used 0.02 seconds of cpu time for gzip -f -

Fri Aug 29 03:57:30 2008: used 0.13 seconds of cpu time for /ramdisk/bin/php5 /home.../public_html/4rum/musicajax.php







And open log in "mysql_slow_queries" :

# Fri Aug 29 00:21:22 2008

# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 725

use data_4rum;

SELECT user.userid, user.username, COUNT(post.postid) AS replycount

FROM post AS post

LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)

LEFT JOIN user AS user ON (post.userid = user.userid)

WHERE thread.forumid=112 AND thread.firstpostid != post.postid

GROUP BY post.userid

ORDER BY replycount DESC

LIMIT 1



And

# Fri Aug 29 03:32:20 2008

# Query_time: 161 Lock_time: 0 Rows_sent: 57 Rows_examined: 57

use data_4rum;

SELECT /*!40001 SQL_NO_CACHE */ * FROM `attachment`







I contact to my sever`support but they can help me for it.They said below:

How can I prevent more CPU Quota/Suspension Errors? If you receive several CPU Quota/Suspension Errors a day or notice this to be a repetitive issue, we encourage you to consult your personal designer, programmer or webmaster. As these issues are the account holders responsibility to resolve, HostMonster Technical Support is not authorized to trouble shoot your scripting or database programming issues on your behalf. Please have your designer, programmer or webmaster review your detailed log files by doing the following:

[rapidphim]

are you hosting with Hostmonster? I am getting the same problem.

[Marco van Herwaarden]

Try disabling your modifications.

[tiengnhat]

are you hosting with Hostmonster? I am getting the same problem.

Yes,my hot is Hostmonster.Can you help me fix this error?

--------------- Added 1220114832 at 1220114832 ---------------

Try disabling your modifications.

I dont know what you writed.Can you help me for fix this error?

[Dismounted]

I don't see how much simpler Marco could have said it. Disable any modifications you are running on your board.

[rapidphim]

Tiengnhat, I still have problem with Hostmonster. I am looking for new host.

Macro was saying that you need to disable your modifications (cậu nên bỏ bới những Mod mà cậu đã hack vào)

[TheInsaneManiac]

You need to disable your plugins if you have any. If you do not it's time you upgrade to a VPS, because your website is using to many resources.