1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 Site being hammered by queries.

Discussion in 'Troubleshooting and Problems' started by ineedhelp, Oct 7, 2013.

  1. ineedhelp

    ineedhelp Well-Known Member

    My site has been running slow for somedays and my host has said the queries below is causing the slowness. Can someone tell me how to fix this asap and what could be causing it.

    Thanks.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Disable all add-ons and test again.
     
    ineedhelp and Adam Howard like this.
  3. Mike

    Mike XenForo Developer Staff Member

    Unfortunately they didn't run the "full" processlist so I can't confirm, but those queries don't look like standard ones.
     
  4. ineedhelp

    ineedhelp Well-Known Member

    The host has now sent me this.... What do you make of it?

     
  5. Mike

    Mike XenForo Developer Staff Member

    That's still not the full process list ( SHOW FULL PROCESSLIST; ).

    Regardless, I'm 99.9% sure this is add-on related, so @Brogan's recommendation is correct.
     
    ineedhelp and Adam Howard like this.
  6. Adam Howard

    Adam Howard Well-Known Member

    @ineedhelp Should you find which add-on that is causing this, please do share. Thanks
     
    JVCode and ineedhelp like this.
  7. Daniel Hood

    Daniel Hood Well-Known Member

    The start of the query looks a lot like my hashtags add on. It shouldn't be running that excessively as it only queries once and it's on a cron job. Unless someone made an add on with a similar query.

    It doesn't make much sense though as numerous people run that add on with large databases.

    Just to be clear I'm only referring to the select query in that list:

    Code:
    SELECT n.*, t.*, p.* FROM xf_post p LEFT JOIN xf_thread t ON t.thread_id = p.thread_id LEFT JOIN xf_
     
    Last edited: Oct 7, 2013
    ineedhelp likes this.
  8. ineedhelp

    ineedhelp Well-Known Member

    Adam Howard likes this.
  9. Chris D

    Chris D XenForo Developer Staff Member

    Well that's good news...

    But to be clear: that add-on doesn't seem to be performing any of those queries you posted from your log.

    I can understand why that add-on is causing issues, though. It's really not very well optimised at all and it uses no caching so it effectively just runs several queries like this on every page load that has a sidebar:

    PHP:
                    SELECT COUNT( * ) AS postsFROM_UNIXTIMEpost_date,  '%Y-%m-%d' ) AS DATE
                    FROM xf_post
                    WHERE FROM_UNIXTIME
    post_date,  '%Y-%m-%d' ) = CURDATE()
     
    Adam Howard and CyclingTribe like this.
  10. DRE

    DRE Well-Known Member

    I'm wondering if this addon had something to do with it: http://xenforo.com/community/resources/default-avatars.1395/

    The Default Avatars addon seemed to be working fine until I accidentally deleted my Minify folder. I re-uploaded it but I noticed that the php file size of some files within Minify is still different than the ones I upload from the upgrade folder of Xenforo 1.2.2. Currently unable to login to my server for some reason to directly upload them. I have disabled and uninstalled Default Avatars until I can fix my Minify folder. After I disabled and uninstalled it, the queries stopped. I'm hoping this will be fixed after I re-upload my Minify folder properly.
     

Share This Page