Go Back   vb.org Archive > Community Discussions > Forum and Server Management
Reload this Page VPS Suspended for overloading root node
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 08-25-2008, 09:27 PM
pimpfelix pimpfelix is offline
 
Join Date: Apr 2005
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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 | | |
Reply With Quote
  #2  
Old 08-25-2008, 09:28 PM
pimpfelix pimpfelix is offline
 
Join Date: Apr 2005
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
| 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 | | |
Reply With Quote
  #3  
Old 08-26-2008, 12:04 AM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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
Reply With Quote
  #4  
Old 08-26-2008, 01:11 AM
pimpfelix pimpfelix is offline
 
Join Date: Apr 2005
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by FRDS View Post
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?
Reply With Quote
  #5  
Old 08-26-2008, 01:13 AM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Who is your host, and disable the arcade for now and tell your "VPS" provider that you've disabled the modification causing the problem
Reply With Quote
  #6  
Old 08-26-2008, 02:31 AM
pimpfelix pimpfelix is offline
 
Join Date: Apr 2005
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
i've disabled the arcade and its hostforweb.com
Reply With Quote
  #7  
Old 08-26-2008, 02:46 AM
Eikinskjaldi's Avatar
Eikinskjaldi Eikinskjaldi is offline
 
Join Date: Feb 2006
Location: Hell, never looked better
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
  #8  
Old 08-26-2008, 10:32 PM
pimpfelix pimpfelix is offline
 
Join Date: Apr 2005
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Eikinskjaldi View Post
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?
Reply With Quote
  #9  
Old 08-26-2008, 11:45 PM
Eikinskjaldi's Avatar
Eikinskjaldi Eikinskjaldi is offline
 
Join Date: Feb 2006
Location: Hell, never looked better
Posts: 572
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by pimpfelix View Post
Disabling text search? so people cant search the site?
Correct.
Reply With Quote
  #10  
Old 08-27-2008, 12:47 AM
DieselMinded's Avatar
DieselMinded DieselMinded is offline
 
Join Date: Mar 2007
Posts: 1,655
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
How many users do you have online on avg ?
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 02:53 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.12717 seconds
  • Memory Usage 2,310KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete