VPS Suspended for overloading root node

[pimpfelix]

Hey guys.. My VPS was suspended for overloading the CPU.... Here is what they emailed me... They wont turn it back on until I figure out what is causing it.. can someone help?

Overloading with MySQL:

-bash-3.00# mysqladmin processlist;
------ ---------------------- ----------- ----------------- --------- ------ ------------------ ------------------------------------------------------------------------------------------------------
| Id | User | Host | db | Command | Time | State | Info |
------ ---------------------- ----------- ----------------- --------- ------ ------------------ ------------------------------------------------------------------------------------------------------
| 3 | eximstats | localhost | eximstats | Sleep | 1601 | | |
| 3687 | leechprotect | localhost | leechprotect | Sleep | 563 | | |
| 5562 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5563 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5579 | remix_remix | localhost | remix_vbulletin | Query | 27 | closing tables | ( select u.userid, u.username
from user u
where u.userid in (1) ) |
| 5588 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5592 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5600 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5598 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5597 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5605 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5610 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5612 | remix_remix | localhost | remix_vbulletin | Sleep | 108 | | |
| 5618 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5624 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5625 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5627 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5631 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5639 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5641 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5643 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT COUNT(*) AS count
FROM user
WHERE referrerid = 418
AND usergroupid NOT IN (3,4) |
| 5651 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5652 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5653 | remix_remix | localhost | remix_vbulletin | Sleep | 96 | | |
| 5655 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5656 | remix_remix | localhost | remix_vbulletin | Sleep | 96 | | |
| 5645 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5658 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5667 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5669 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5672 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5674 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT COUNT(*) AS count
FROM user
WHERE referrerid = 542
AND usergroupid NOT IN (3,4) |
| 5677 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5678 | remix_remix | localhost | remix_vbulletin | Query | 27 | closing tables | SELECT COUNT(*) AS count
FROM user
WHERE referrerid = 850
AND usergroupid NOT IN (3,4) |
| 5686 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5683 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5696 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5701 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5712 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5745 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5754 | remix_remix | localhost | remix_vbulletin | Query | 27 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5755 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 5757 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | ( select u.userid, u.username
from user u
where u.userid in (266) ) |
| 5758 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5774 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5778 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5786 | remix_remix | localhost | remix_vbulletin | Sleep | 71 | | |
| 5792 | remix_remix | localhost | remix_vbulletin | Query | 24 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5796 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | SELECT user.userid, user.username, user.usergroupid, user.displaygroupid, profilevisitor.visible
|
| 5797 | remix_remix | localhost | remix_vbulletin | Sleep | 69 | | |
| 5794 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | ( select u.userid, u.username
from user u
where u.userid in (64) ) |
| 5801 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5800 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5808 | remix_remix | localhost | remix_vbulletin | Query | 28 | closing tables | SELECT user.userid, user.username, user.usergroupid, user.displaygroupid, profilevisitor.visible
|
| 5816 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5817 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.usernam |
| 5819 | remix_remix | localhost | remix_vbulletin | Query | 22 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5835 | remix_remix | localhost | remix_vbulletin | Query | 23 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5833 | remix_remix | localhost | remix_vbulletin | Query | 23 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5831 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 5827 | remix_remix | localhost | remix_vbulletin | Query | 22 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5824 | remix_remix | localhost | remix_vbulletin | Sleep | 51 | | |
| 5853 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 5854 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |