PDA

View Full Version : My website's server is pressing...


CiyaEzIM
22 Apr 2008, 22:14
| 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

ssslippy
24 Apr 2008, 22:06
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.