Helpful Information
 
 
Category: Forum and Server Management
My website's server is pressing...

| 970 | xxxxxxx | localhost | xxxxxxx_xxxxxxx | Query | 8 | Sending data | SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
IF(displaygroupid=0, user.usergr |
| 973 | xxxxxxx | localhost | xxxxxxx_xxxxxxx | Query | 5 | Locked | UPDATE user
SET
lastvisit = lastactivity,
lastactivity = 1208775420
WHERE |
| 979 | admin | localhost | NULL | Query | 0 | NULL | show processlist |
| 983 | xxxxxxx | localhost | xxxxxxx_xxxxxxx | Sleep | 6 | | NULL |
| 986 | xxxxxxx | localhost | xxxxxxx_xxxxxxx | Query | 5 | Locked | SELECT userid, username FROM user
WHERE userid != 0
AND
(
username = 'fuzinnes'
OR
|
| 987 | xxxxxxx | localhost | xxxxxxx_xxxxxxx | Query | 5 | Locked | select s.*, u.username, u.usergroupid from shout s
left join user u on (u.userid = s.s_by)
ord |
| 989 | xxxxxxx | localhost | xxxxxxx | Query | 0 | Sorting result | SELECT post.postid, post.visible, post.userid
FROM post AS post

WHERE post.threadid = 4667 |
| 994 | xxxxxxx | localhost | xxxxxxx_xxxxxxx | Query | 3 | Locked | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 996 | xxxxxxx | localhost | xxxxxxx_xxxxxxx | Query | 2 | Locked | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 999 | xxxxxxx | localhost | xxxxxxx_xxxxxxx | Query | 1 | Locked | SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF |
| 1002 | xxxxxxx | localhost | xxxxxxx_xxxxxxx | Query | 0 | Locked | select s.*, u.username, u.usergroupid from shout s
left join user u on (u.userid = s.s_by)
ord |
--------------------------------------------------------------------------------------------------------------------


I get some errors as you can see above.
Is there anyone who knows about this error or anyone who can give me some solutions. The Cpu value shows 10 and sometimes even 300. However it does not do this everytime. It does it one or two time in 24 hours.

additions: Vbseo, Vbshout,Vbshotbox,nCode Image Resizer,Cyb - Forumhome Sub-Forums Manager,Cyb - Advanced Forum Statistics

You should post for a server optimization at vb.com.

Also if u are running inferno shout you should update to the latest revision it has a dramatic way to reduce server load.

Also optimize your vbseo. Their forums has some good tips on how to do so. Also move your rewrite rules into your config files if you can.










privacy (GDPR)