| Posted by Ibrahim6oct, 12-07-2008, 04:15 PM | | High Load caused by vbulletin database
Hi,
Don't know if it is some kind of attack or this is normal
but the Server load goes reaching 20 in most of the times and may be greater!
this is the mysql_process list
jarabhar_JUHyyuh is opening alot of connections in the same time
and this is not the normal behavior
Code:
58322 jarabhar_JUHyyuh localhost jarabhar_vb Query 17 Sending data select userid from user where username regexp "^(|[^a-z\\\\d])*l(|[^a-z\\\\d
58317 jarabhar_JUHyyuh localhost jarabhar_vb Sleep 19 NULL
58325 jarabhar_JUHyyuh localhost jarabhar_vb Sleep 11 NULL
58349 jarabhar_JUHyyuh localhost jarabhar_vb Query 16 Sending data select userid from user where username regexp "^(|[^a-z\\\\d])*mr(|[^a-z\\\\
58363 jarabhar_JUHyyuh localhost jarabhar_vb Query 10 Sending data select userid from user where username regexp "^(|[^a-z\\\\d])*[e????????][n??]g(|[^a-z\\\\d])*l(|[^a-z\\\\d
58389 jarabhar_JUHyyuh localhost jarabhar_vb Query 8 Sending data select userid from user where username regexp "^(|[^a-z\\\\d])*l(|[^a-z\\\\d
58394 jarabhar_JUHyyuh localhost jarabhar_vb Query 5 Locked SELECT\n\t\t\tpost.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS
58399 jarabhar_JUHyyuh localhost jarabhar_vb Query 3 Locked SELECT\n\t\t\tuser.username, (user.options
|
| Posted by Ibrahim6oct, 12-07-2008, 04:34 PM | | now the load is 25 and the proccess list :
Code:
67714 jarabhar_JUHyyuh localhost jarabhar_vb Sleep 6 NULL
67723 jarabhar_JUHyyuh localhost jarabhar_vb Sleep 1 NULL
67761 jarabhar_JUHyyuh localhost jarabhar_vb Query 6 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('136866') )
67765 jarabhar_JUHyyuh localhost jarabhar_vb Sleep 7 NULL
67770 jarabhar_JUHyyuh localhost jarabhar_vb Sleep 1 NULL
67771 jarabhar_JUHyyuh localhost jarabhar_vb Query 1 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678363, location = '/forum/forumdisplay.php?f=40', inthre
67772 jarabhar_JUHyyuh localhost jarabhar_vb Query 1 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678362, location = '/forum/showthread.php?t=102903', inth
67783 jarabhar_JUHyyuh localhost jarabhar_vb Query 14 Sending data select userid from user where username regexp "^(|[^a-z\\\\d])*[a????????????]hm[e????
67781 jarabhar_JUHyyuh localhost jarabhar_vb Sleep 14 NULL
67784 jarabhar_JUHyyuh localhost jarabhar_vb Query 4 Locked SELECT\n\t\t\tannouncement.announcementid, startdate, title, announcement.views,\n\t\t\tuser.username, user.
67776 jarabhar_JUHyyuh localhost jarabhar_vb Query 4 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('11122970','11122895') )
67785 jarabhar_JUHyyuh localhost jarabhar_vb Sleep 8 NULL
67775 jarabhar_JUHyyuh localhost jarabhar_vb Query 4 Locked SELECT\n\t\t\tuser.username, (user.options |[^a-z\\\\d])*m[o????????????](
|
| Posted by Ibrahim6oct, 12-07-2008, 04:44 PM | | reached 90!!!!!!!!
Code:
70446 jarabhar_JUHyyuh localhost jarabhar_vb Query 43 Locked ( select u.userid, u.username\nfrom user u\nwhere u.userid in ('1268') )
70523 jarabhar_JUHyyuh localhost jarabhar_vb Query 159 Copying to tmp table SELECT COUNT(post.dateline) AS postcount, post.userid, user.username \n\t\t\tFROM post AS post \n\t\t\tLEFT
70517 jarabhar_JUHyyuh localhost jarabhar_vb Query 104 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678800, location = '/forum/showthread.php?t=88758', inthr
70516 jarabhar_JUHyyuh localhost jarabhar_vb Query 90 Locked UPDATE session\n\t\t\t\t\tSET lastactivity = 1228678800, location = '/forum/showthread.php?t=57861
|
|
 Add to Favourites
 Print this Article
|
