Announcement

Collapse
No announcement yet.

My SQL Issues!!!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • feldon23
    replied
    Why would you be "blocked" by a dedicated host. That makes no sense.

    I just looked, BlueHost does not offer dedicated hosting.

    Leave a comment:


  • lazyllama
    replied
    That log looks like the slow query log from MySQL, but the queries are all from May, so nothing useful to indicate what may be going on with your board at the moment.

    Is there a .err log file in the same directory as that log?

    Leave a comment:


  • SPS12
    replied
    No Help?!?!?!

    Leave a comment:


  • SPS12
    replied
    No
    I am Using Dedicated Host!!
    it's From BlueHost

    Leave a comment:


  • punchbowl
    replied
    Are you on shared hosting? You are using too much resources. Forums are mysql heavy.

    Leave a comment:


  • SPS12
    started a topic My SQL Issues!!!

    My SQL Issues!!!

    Hi
    my Site Gone Down Because Of MySQL Issuse
    their MySQL Version Was 5.0 And I Dont Check And Update Vbulletin to 3.8
    Now They Blocekd My Site And Say Chek SQL Log
    Sql Log is :
    Code:
    # Fri May  9 05:01:04 2008
    # Query_time: 3  Lock_time: 0  Rows_sent: 3  Rows_examined: 13
    use bazinama_message;
    SELECT pm.*, pmtext.*
      , icon.title AS icontitle, icon.iconpath
      FROM pm AS pm
      LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
      LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
      WHERE pm.userid=304 AND pm.folderid=0
      ORDER BY pmtext.dateline DESC
      LIMIT 0, 50
    
    # Fri May  9 05:08:05 2008
    # Query_time: 2  Lock_time: 0  Rows_sent: 10  Rows_examined: 78
    use bazinama_message;
    SELECT
      post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
      user.*, userfield.*, usertextfield.*,
      icon.title as icontitle, icon.iconpath,
      avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
      editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
      editlog.reason AS edit_reason, editlog.hashistory,
      postparsed.pagetext_html, postparsed.hasimages,
      sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
      sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
      IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
            FROM post AS post
            LEFT JOIN user AS user ON(user.userid = post.userid)
            LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
            LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
            LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
            LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
            LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
            LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 8 AND postparsed.languageid = 3)
            LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 8 AND sigparsed.languageid = 3)
            LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
            WHERE post.postid IN (0,82684,82747,82750,82758,82769,82771,82803,82824,82834,82838)
            ORDER BY post.dateline
    
    # Fri May  9 05:40:38 2008
    # Query_time: 2  Lock_time: 0  Rows_sent: 19  Rows_examined: 86
    use bazinama_message;
    SELECT pm.*, pmtext.*
      , icon.title AS icontitle, icon.iconpath
      FROM pm AS pm
      LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
      LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
      WHERE pm.userid=407 AND pm.folderid=0
      ORDER BY pmtext.dateline DESC
      LIMIT 0, 50
    
    # Fri May  9 05:40:42 2008
    # Query_time: 2  Lock_time: 0  Rows_sent: 2  Rows_examined: 4
    SELECT album.*,
      picture.pictureid, picture.extension, picture.idhash, album.moderation,
      picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height
      FROM album AS album
      LEFT JOIN picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
      WHERE album.userid = 1450
      AND album.state IN ('public')
      AND album.visible > 0
      ORDER BY album.lastpicturedate DESC
      LIMIT 2
    
    # Fri May  9 05:51:04 2008
    # Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
    use bazinama_message;
    SELECT picture.pictureid, picture.userid, picture.extension, picture.idhash, picture.state,
      albumpicture.dateline, album.state AS albumstate,
      picture.thumbnail AS filedata, picture.thumbnail_filesize AS filesize
            FROM albumpicture AS albumpicture
            INNER JOIN picture AS picture ON (albumpicture.pictureid = picture.pictureid)
            INNER JOIN album AS album ON (albumpicture.albumid = album.albumid)
            WHERE albumpicture.albumid = 162 AND albumpicture.pictureid = 851
    
    # Fri May  9 05:56:22 2008
    # Query_time: 3  Lock_time: 0  Rows_sent: 3  Rows_examined: 6
    use bazinama_message;
    SELECT *
      FROM mailqueue
      ORDER BY mailqueueid
      LIMIT 10
    What I Do Now?!?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X