VPS Suspended for overloading root node
 

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 | | |

| 5860 | remix_remix | localhost | remix_vbulletin | Query | 21 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5868 | 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 |
| 5866 | 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 |
| 5864 | remix_remix | localhost | remix_vbulletin | Query | 20 | Opening tables | SELECT user.userid, user.username, user.usergroupid, user.displaygroupid, profilevisitor.visible
|
| 5872 | 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 |
| 5873 | 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 |
| 5874 | 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 |
| 5887 | 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 |
| 5886 | 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 |
| 5889 | 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 |
| 5883 | 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 |
| 5882 | 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 |
| 5897 | remix_remix | localhost | remix_vbulletin | Sleep | 8 | | |
| 5901 | 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 |
| 5904 | 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 |
| 5910 | remix_remix | localhost | remix_vbulletin | Query | 21 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5908 | 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 |
| 5913 | remix_remix | localhost | remix_vbulletin | Query | 21 | closing tables | SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS |
| 5915 | 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 |
| 5916 | 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 |
| 5921 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 5925 | remix_remix | localhost | remix_vbulletin | Sleep | 29 | | |
| 5928 | 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 |
| 5926 | 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 |
| 5934 | 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 |
| 5932 | 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 |
| 5936 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 5938 | 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 |
| 5941 | 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 |
| 5943 | 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 |
| 5944 | remix_remix | localhost | remix_vbulletin | Sleep | 22 | | |
| 5945 | remix_remix | localhost | remix_vbulletin | Sleep | 4 | | |
| 5947 | 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 |
| 5948 | 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 |
| 5959 | 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 |
| 5963 | 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 |
| 5964 | remix_remix | localhost | remix_vbulletin | Query | 26 | closing tables | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 5967 | remix_remix | localhost | remix_vbulletin | Query | 25 | closing tables | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 5968 | remix_remix | localhost | remix_vbulletin | Query | 20 | Opening tables | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 5971 | remix_remix | localhost | remix_vbulletin | Query | 1 | Writing to net | SELECT *
FROM datastore
WHERE title IN (,options,bitfields,attachmentcache,forumcache |
| 5972 | remix_remix | localhost | remix_vbulletin | Query | 22 | closing tables | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 5977 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 5978 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 5980 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 5983 | remix_remix | localhost | remix_vbulletin | Query | 20 | Opening tables | SELECT *
FROM datastore
WHERE title IN (credits_central,credits_forum_overrides,credits_i |
| 5986 | remix_remix | localhost | remix_vbulletin | Sleep | 3 | | |
| 5987 | remix_remix | localhost | remix_vbulletin | Query | 20 | Opening tables | SELECT *
FROM datastore
WHERE title IN (,options,bitfields,attachmentcache,forumcache |
| 5984 | remix_remix | localhost | remix_vbulletin | Query | 20 | Opening tables | SELECT *
FROM datastore
WHERE title IN (credits_central,credits_forum_overrides,credits_i |
| 5988 | remix_remix | localhost | remix_vbulletin | Query | 20 | Opening tables | SELECT *
FROM datastore
WHERE title IN (credits_central,credits_forum_overrides,credits_i |
| 5989 | remix_remix | localhost | remix_vbulletin | Query | 20 | Opening tables | SELECT *
FROM datastore
WHERE title IN (,options,bitfields,attachmentcache,forumcache |
| 5991 | remix_remix | localhost | remix_vbulletin | Query | 20 | Opening tables | SELECT *
FROM datastore
WHERE title IN (,options,bitfields,attachmentcache,forumcache |
| 5997 | remix_remix | localhost | remix_vbulletin | Sleep | 2 | | |
| 6013 | remix_remix | localhost | remix_vbulletin | Sleep | 2 | | |
| 6023 | remix_remix | localhost | remix_vbulletin | Query | 11 | Writing to net | SELECT t.forumid, t.threadid, t.title, t.replycount, t.lastposter, t.lastpost
FROM thread AS t
LEFT |
| 6025 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6024 | remix_remix | localhost | remix_vbulletin | Sleep | 6 | | |
| 6034 | remix_remix | localhost | remix_vbulletin | Sleep | 2 | | |
| 6037 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6036 | remix_remix | localhost | remix_vbulletin | Sleep | 2 | | |
| 6044 | remix_remix | localhost | remix_vbulletin | Sleep | 3 | | |
| 6045 | remix_remix | localhost | remix_vbulletin | Sleep | 2 | | |
| 6049 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6048 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6053 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6055 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6054 | remix_remix | localhost | remix_vbulletin | Sleep | 2 | | |
| 6052 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 6051 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 6050 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6056 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6057 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6060 | remix_remix | localhost | remix_vbulletin | Sleep | 2 | | |
| 6062 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6061 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 6059 | remix_remix | localhost | remix_vbulletin | Sleep | 2 | | |
| 6058 | root | localhost | | Query | 0 | | show processlist |
| 6063 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |
| 6064 | remix_remix | localhost | remix_vbulletin | Sleep | 1 | | |
| 6066 | unauthenticated user | localhost | | Connect | | Reading from net | |
| 6068 | unauthenticated user | localhost | | Connect | | Reading from net | |
| 6067 | unauthenticated user | localhost | | Connect | | Reading from net | |
| 6065 | unauthenticated user | localhost | | Connect | | Reading from net | |
| 6069 | unauthenticated user | localhost | | Connect | | Reading from net | |
| 6070 | remix_remix | localhost | remix_vbulletin | Sleep | 0 | | |

Did you tell them the whole purpose of a VPS is so only your VPS goes down?

Are you sure you're on a true VPS provider? And they all seem to be MySQL releated

how do i find out if im on a true vps?

Who is your host, and disable the arcade for now and tell your "VPS" provider that you've disabled the modification causing the problem

i've disabled the arcade and its hostforweb.com

What you are seeing is the aftermath of a mysql crisis, not the crisis itself. The opening/closing tables problem rears its ugly head when mysql has been overloaded by something else, Assuming all your modifications have optimized queries the likely cause is a the creation of a large tmp table on disk.

I'd recommend as a first step disabling text searching.

Disabling text search? so people cant search the site?

Correct.

How many users do you have online on avg ?