PDA

View Full Version : VPS Suspended for overloading root node


pimpfelix
25 Aug 2008, 22:27
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 | | |

pimpfelix
25 Aug 2008, 22:28
| 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 | | |

SEOvB
26 Aug 2008, 01:04
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

pimpfelix
26 Aug 2008, 02:11
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?

SEOvB
26 Aug 2008, 02:13
Who is your host, and disable the arcade for now and tell your "VPS" provider that you've disabled the modification causing the problem

pimpfelix
26 Aug 2008, 03:31
i've disabled the arcade and its hostforweb.com

Eikinskjaldi
26 Aug 2008, 03:46
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.

pimpfelix
26 Aug 2008, 23:32
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?

Eikinskjaldi
27 Aug 2008, 00:45
Disabling text search? so people cant search the site?

Correct.

DieselMinded
27 Aug 2008, 01:47
How many users do you have online on avg ?

Eikinskjaldi
27 Aug 2008, 05:31
How many users do you have online on avg ?

It's not likely to be relevant. A better question, assuming searching is the issue, is how big is your post table. In the past I have had my system freeze with 20 people online because one of them was looking for the word "door".

rapidphim
30 Aug 2008, 04:53
How are you going to optimize your Search engine so that it won't cause the overload?