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

XF 1.4 Speed Questions

Discussion in 'XenForo Questions and Support' started by Alexander Firth, Mar 26, 2015.

  1. Alexander Firth

    Alexander Firth Active Member

    Hey, I'm having a few issues with speed and occasional lag on one of my sites. All sites are on the same high-end VPS, and it's only the larger site that's struggling. This is intermittent, but when it does happen it almost locks up for maybe 40 seconds. In this time, the admin CP functions absolutely fine with no lag at all, it's just the front end that really struggles. You can't load the index, new threads or post replies.

    I do have occasional server errors, but they do not coincide with the timing of this lag. The server errors are:

    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
    
    #0 /home/youthdebates/public_html/forums/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/youthdebates/public_html/forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/youthdebates/public_html/forums/library/XenForo/Model/Poll.php(322): Zend_Db_Adapter_Abstract->query('SELECT poll_id ...', 1245)
    #3 /home/youthdebates/public_html/forums/library/XenForo/ControllerPublic/Thread.php(1585): XenForo_Model_Poll->voteOnPoll(1245, 4185)
    #4 /home/youthdebates/public_html/forums/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_Thread->actionPollVote()
    #5 /home/youthdebates/public_html/forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #6 /home/youthdebates/public_html/forums/index.php(13): XenForo_FrontController->run()
    #7 {main}
    
    array(3) {
      ["url"] => string(93) "http://youthdebates.org/forums/threads/very-long-term-goal-with-no-guarantees.11174/poll/vote"
      ["_GET"] => array(0) {
      }
      ["_POST"] => array(5) {
        ["response"] => string(4) "4185"
        ["_xfToken"] => string(8) "********"
        ["_xfRequestUri"] => string(61) "/forums/threads/very-long-term-goal-with-no-guarantees.11174/"
        ["_xfNoRedirect"] => string(1) "1"
        ["_xfResponseType"] => string(4) "json"
      }
    }
    But as I said, these don't match the timing of the lag.

    We have a few add-ons installed that I worry may not be helping. Our board is a decent size, with anywhere between 20 and 55 registered members online at any time, along with a couple of dozen guests. Is it fair to say most add-ons have a negative speed impact? A few I'm worrying about are Taigachat Pro, Tapatalk and Tab Alerts. I can test removing these, but it'll take hours and hours for me to tell if anything worked, so I figured I'd just ask for a bit of advice here as well.

    We also have [bd] Cache and Defer JS installed, does anyone have anything negative to say about those? The performance increase when we're not lagging seems like it could be too good to be true?

    Any advice welcome, thanks :)
     
  2. Solidus

    Solidus Well-Known Member

    Increase the value of innodb_lock_wait_timeout and innodb_buffer_pool_size in my.cnf, then restart MySQL.
     
    Coop1979 likes this.
  3. Alexander Firth

    Alexander Firth Active Member

    Already did this, what values would you recommend?
     
  4. Solidus

    Solidus Well-Known Member

    How much RAM is on your server? You could run mysqltuner as well. Post results here.
     
  5. Solidus

    Solidus Well-Known Member

    You can put Taigachat in speed mode too.
     
  6. Alexander Firth

    Alexander Firth Active Member

    12GB RAM. Will look into mysqltuner, not heard of that.
     
  7. Solidus

    Solidus Well-Known Member

    It will give you suggestions for my.cnf, I wouldn't follow them all but some are useful.
     
  8. Solidus

    Solidus Well-Known Member

    Oh, and innodb buffer pool can be 10G if you wanted. Larger = good
     
    Alexander Firth likes this.

Share This Page