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

XF 1.4 Xenforo_search database too big ?

ceptime

Active member
#1
Hello my site database "xenforo_search" table too big 13.8GiB


xf_search Gözat Yapı Search Add Boşalt Remove ~3,562,149 13.8GiB

ERROR LOG
Hata Bilgisi
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : The total number of locks exceeds the lock table size - library/Zend/Db/Statement/Mysqli.php:214
Oluşturan: Bilinmeyen Hesap, 13 dakika önce
Yığın İzleme
#0 /var/www/vhosts/-/httpdocs/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/-/httpdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /var/www/vhosts/-/httpdocs/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
#3 /var/www/vhosts/-/httpdocs/library/XenForo/Model/Search.php(77): Zend_Db_Adapter_Abstract->insert('xf_search', Array)
#4 /var/www/vhosts/c-/httpdocs/library/Tinhte/XenTag/XenForo/Model/Search.php(39): XenForo_Model_Search->insertSearch(Array, 'recent-posts', '', Array, 'date', false, Array, Array, NULL, NULL)
#5 /var/www/vhosts/c-/httpdocs/library/XenForo/ControllerPublic/FindNew.php(206): Tinhte_XenTag_XenForo_Model_Search->insertSearch(Array, 'recent-posts', '', Array, 'date', false)
#6 /var/www/vhosts/-/httpdocs/library/XenForo/ControllerPublic/FindNew.php(35): XenForo_ControllerPublic_FindNew->findNewPosts()
#7 /var/www/vhosts/-/httpdocs/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_FindNew->actionPosts()
#8 /var/www/vhosts/-/httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#9 /var/www/vhosts/-/httpdocs/index.php(13): XenForo_FrontController->run()
#10 {main}
Request State
array(3) {
["url"] => string(42) ""
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
 

Jafo

Active member
#8
Sorry to dig this up, but could you tell me which cron handles this? My table is huge (15GB) and not being cleaned out.