CivilWarTalk
Active member
My site is experiencing a new problem recently. Users are complaining that actions such as posting and liking posts are "slow", and I've experienced the problem too. Sometimes the slowness leads to double posts, although I've never had this issue happen to me, I've deleted a bunch of them. Browsing is still fast and server loads are low (0.5 most of the time), so I'm not sure what the issue is.
I thought there was a problem with XenMedio, I uninstalled the mod and was getting errors from that (Mysqli prepare error: Table 'cwt1861_xenForo.EWRmedio_keywords' doesn't exist and such), I reinstalled the mod, but left it disabled. It might be my problem, or maybe not, I'm not sure...
This is the error I occasionally see in the Server logs:
I'm wondering if I should do a repair or optimize tables in phpmyadmin?
I thought there was a problem with XenMedio, I uninstalled the mod and was getting errors from that (Mysqli prepare error: Table 'cwt1861_xenForo.EWRmedio_keywords' doesn't exist and such), I reinstalled the mod, but left it disabled. It might be my problem, or maybe not, I'm not sure...
This is the error I occasionally see in the Server logs:
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/XXXX/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/XXXX/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/XXXX/public_html/library/XenForo/DataWriter/DiscussionMessage.php(828): Zend_Db_Adapter_Abstract->query('?????UPDATE xf_...', 2666)
#3 /home/XXXX/public_html/library/XenForo/DataWriter/DiscussionMessage/Post.php(133): XenForo_DataWriter_DiscussionMessage->_updateUserMessageCount(false)
#4 /home/XXXX/public_html/library/XenForo/DataWriter/DiscussionMessage.php(504): XenForo_DataWriter_DiscussionMessage_Post->_updateUserMessageCount()
#5 /home/XXXX/public_html/library/XenForo/DataWriter.php(1385): XenForo_DataWriter_DiscussionMessage->_postSave()
#6 /home/XXXX/public_html/library/XenForo/ControllerPublic/Thread.php(505): XenForo_DataWriter->save()
#7 /home/XXXX/public_html/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_Thread->actionAddReply()
#8 /home/XXXX/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /home/XXXX/public_html/index.php(13): XenForo_FrontController->run()
#10 {main}
array(3) {
["url"] => string(84) "http://civilwartalk.com/threads/civil-war-movies-which-are-the-worst.71315/add-reply"
["_GET"] => array(0) {
}
["_POST"] => array(8) {
["message_html"] => string(199) "<p>[quote="ole, post: 437833, member: 186"]You mean missed noticing that Stuart looked like he was still chewing on a muskrat?[/quote]</p>
<p> </p>
<p>Actually, it looks like two muskrats.</p>"
["_xfRelativeResolver"] => string(81) "http://civilwartalk.com/threads/civil-war-movies-which-are-the-worst.71315/page-3"
["attachment_hash"] => string(32) "304d17d9e7f37dc339acb1884121e9ab"
["last_date"] => string(10) "1333745735"
["_xfToken"] => string(56) "2666,1333746184,9551af705b4f5e41eaa2f51e056bc11535c7b426"
["_xfRequestUri"] => string(58) "/threads/civil-war-movies-which-are-the-worst.71315/page-3"
["_xfNoRedirect"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
I'm wondering if I should do a repair or optimize tables in phpmyadmin?