this is hostgator message..

[16melih]

Code Select Expand

Hello,

It appears the account was suspended because of MySQL resource abuse:

2012/03/12 12:50:15 INFO - Freezing (xxdb) => CPU_TIME:80 table_rows_read:247612 SELECTS:3042 ROWS_UPDATED:2806 ROWS_FETCHED:0 BUSY_TIME:6994 ONNECTED_TIME:7324 BYTES_SENT:1680073 BYTES_RECEIVED:2894400 WAIT_TIME:6914
2012/03/12 12:50:15 INFO - Freeze time xxdb -- 15 mins
2012/03/12 12:50:15 INFO - -------- xxdb - 1 -----
2012/03/12 12:50:15 INFO - UPDATE mysql.user SET max_questions='1', max_updates='1', max_connections='1', max_user_connections='1' where user LIKE ' xxdb\_%'
2012/03/12 12:50:15 INFO - xxdb => 1331575515 --
2012/03/12 12:51:15 INFO - xxdb => 1331575515 --
2012/03/12 12:52:15 INFO - xxdb => 1331575515 --
2012/03/12 12:53:15 INFO - xxdb => 1331575515 --
2012/03/12 12:54:15 INFO - xxdb => 1331575515 --
2012/03/12 12:55:16 INFO - xxdb => 1331575515 --
2012/03/12 12:56:16 INFO - xxdb => 1331575515 --
2012/03/12 12:57:16 INFO - xxdb => 1331575515 --
2012/03/12 12:58:16 INFO - xxdb => 1331575515 --
2012/03/12 12:59:16 INFO - xxdb => 1331575515 --
2012/03/12 13:00:16 INFO - xxdb => 1331575515 --
2012/03/12 13:01:16 INFO - xxdb => 1331575515 --
2012/03/12 13:02:16 INFO - xxdb => 1331575515 --
2012/03/12 13:03:16 INFO - xxdb => 1331575515 --
2012/03/12 13:04:16 INFO - xxdb => 1331575515 --
2012/03/12 13:05:16 INFO - xxdb => 1331575515 --
2012/03/12 13:05:16 INFO - -------- xxdb - 0 -----
2012/03/12 13:05:16 INFO - UPDATE mysql.user SET max_questions='0', max_updates='0', max_connections='0', max_user_connections='0' where user LIKE ' xxdb\_%'
2012/03/12 13:05:16 INFO - -- Unfreezing - xxdb

The account should be unsuspended at this time as it happens automatically. You may want to review your scripts, enable any caching options they offer and optimize your SQL queries and scripts to prevent this from happening. When a query runs for too long it's killed which can cause these table crashes. You'll want to review any queries that utilize the messages table and make any necessary adjustments to prevent them from running for such long times. Below are some of the queries being killed, this should help you in pin-pointing which ones to look at:

[ 1331585281 ] [ xxdb_fal ] [ 157057 ] [ 169 ] [ xxdb_smf ] [ Query ] [ KILLED ] [ 'gator1351.hostgator.com' ] [ SELECT t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll, t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts, t.id_last_msg + 1 AS new_from FROM smf_topics AS t INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg) WHERE t.id_topic = 16153 LIMIT 1 ]
[ 1331585281 ] [ xxdb_fal ] [ 157056 ] [ 169 ] [ xxdb_smf ] [ Query ] [ KILLED ] [ 'gator1351.hostgator.com' ] [ SELECT t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll, t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts, t.id_last_msg + 1 AS new_from FROM smf_topics AS t INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg) WHERE t.id_topic = 57063 LIMIT 1 ]
[ 1331585281 ] [ xxdb_fal ] [ 157044 ] [ 171 ] [ xxdb_smf ] [ Query ] [ KILLED ] [ 'gator1351.hostgator.com' ] [ SELECT t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll, t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts, t.id_last_msg + 1 AS new_from FROM smf_topics AS t INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg) WHERE t.id_topic = 187080 LIMIT 1 ]
[ 1331585281 ] [ xxdb_fal ] [ 157033 ] [ 173 ] [ xxdb_smf ] [ Query ] [ KILLED ] [ 'gator1351.hostgator.com' ] [ SELECT t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll, t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts, t.id_last_msg + 1 AS new_from FROM smf_topics AS t INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg) WHERE t.id_topic = 65287 LIMIT 1 ]
[ 1331585281 ] [ xxdb_fal ] [ 157029 ] [ 174 ] [ xxdb_smf ] [ Query ] [ KILLED ] [ 'gator1351.hostgator.com' ] [ SELECT t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll, t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts, t.id_last_msg + 1 AS new_from FROM smf_topics AS t INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg) WHERE t.id_topic = 57063 LIMIT 1 ]
[ 1331585281 ] [ xxdb_fal ] [ 157022 ] [ 173 ] [ xxdb_smf ] [ Query ] [ KILLED ] [ 'gator1351.hostgator.com' ] [ SELECT b.id_board, b.name AS board_name, b.description, CASE WHEN b.redirect != '' THEN 1 ELSE 0 END AS is_redirect, b.num_posts, b.num_topics, b.unapproved_posts, b.unapproved_topics, b.id_parent, IFNULL(m.poster_time, 0) AS poster_time, IFNULL(mem.member_name, m.poster_name) AS poster_name, m.subject, m.id_topic, IFNULL(mem.real_name, m.poster_name) AS real_name, 1 AS is_read, 0 AS new_from, IFNULL(mem.id_member, 0) AS id_member, m.id_msg, IFNULL(mods_mem.id_member, 0) AS id_moderator, mods_mem.real_name AS mod_real_name FROM smf_boards AS b LEFT JOIN smf_messages AS m ON (m.id_msg = b.id_last_msg) LEFT JOIN smf_members AS mem ON (mem.id_member = m.id_member) LEFT JOIN smf_moderators AS mods ON (mods.id_board = b.id_board) LEFT JOIN smf_members AS mods_mem ON (mods_mem.id_member = mods.id_member) WHERE (FIND_IN_SET(-1, b.member_groups) != 0) AND b.child_level BETWEEN 1 AND 2 ]
[ 1331585281 ] [ xxdb_fal ] [ 157017 ] [ 175 ] [ xxdb_smf ] [ Query ] [ KILLED ] [ 'gator1351.hostgator.com' ] [ SELECT t.num_replies, t.num_views, t.locked, ms.subject, t.is_sticky, t.id_poll, t.id_member_started, t.id_first_msg, t.id_last_msg, t.approved, t.unapproved_posts, t.id_last_msg + 1 AS new_from FROM smf_topics AS t INNER JOIN smf_messages AS ms ON (ms.id_msg = t.id_first_msg) WHERE t.id_topic = 70027 LIMIT 1 ]


If there's anything else I can help you with please let me know.

help me my friends. Often smf_message crashed  and cpu...

[Illori]

you have an oversold host, find a non-oversold host and all your problems will go away.