Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 07 Jan 2011, 17:44
James T Brock James T Brock is offline
 
Join Date: Sep 2004
MySQL over-loading, what could be causing this?

On my forum every couple of hours MySQL over-loads on my server and the load goes through the roof. My forum has a couple million posts and several thousand visitors a day.

Here is an example of the queries (hundreds of these per second)...

Query SELECT * FROM session WHERE sessionhash = 'dfd9268b20ae92b017c267ba18970a4b' AND lastactivity > 129440744
Query SELECT * FROM session WHERE sessionhash = 'bd05b6ddfc180f2012a7c741e0122488' AND lastactivity > 129440744
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, session.inforu
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query UPDATE session SET lastactivity = 1294421744, location = '/forums/showthread.php?t=220501&page=2', in
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query SELECT COUNT(userID) AS c FROM session WHERE lastactivity > 1294421812 AND location LIKE '%gameroom%'
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, session.inforu
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query UPDATE session SET lastactivity = 1294421802, location = '/forums/showthread.php?t=277163&page=3', in
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query SELECT COUNT(userID) AS c FROM session WHERE lastactivity > 1294421812 AND location LIKE '%gameroom%'
Query SELECT post.*, IF(post.visible = 2, 1, 0) AS isdeleted, editlog.userid AS edit_userid, editlog.dateline A
Query SELECT user.username, (user.options & 512) AS invisible, user.usergroupid, session.userid, session.inforu
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query SELECT * FROM session WHERE sessionhash = 'daddef1968276899ff4486a1c0b45fcf' AND lastactivity > 129440744
Query SELECT * FROM session WHERE sessionhash = '3599a066f604de7e17648eb96f68b3ba' AND lastactivity > 129440744
Query SELECT COUNT(userID) AS c FROM session WHERE lastactivity > 1294421812 AND location LIKE '%gameroom%'
Query UPDATE session SET lastactivity = 1294421729, location = '/forums/showthread.php?t=887806', inforum = 53,
Query UPDATE user SET lastactivity = 1294421729 WHERE userid = 9665
Query UPDATE user SET lastactivity = 1294421734 WHERE userid = 301320
Query UPDATE user SET lastactivity = 1294421734 WHERE userid = 301320
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
Query INSERT INTO post (showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parenti
Query INSERT IGNORE INTO session (sessionhash, userid, host, idhash, lastactivity, location, styleid, languagei
That's just a snapshot of what was just there. There are other queries as well that start showing up. Anyone familiar with vBulletin programming that has an idea of what could be happening when those queries are run? What exactly is happening when you see "user SET lastactivity" or "INSERT IGNORE INTO" Is that just a bunch of hits at one time, a DOS attack?

Last edited by James T Brock; 07 Jan 2011 at 21:27.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 03:57.

Layout Options | Width: Wide Color: