1. 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 ?

Discussion in 'XenForo Questions and Support' started by ceptime, Jun 24, 2015.

  1. ceptime

    ceptime Active Member

    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) {
    }
    }
     
  2. Mike

    Mike XenForo Developer Staff Member

  3. ceptime

    ceptime Active Member

  4. ceptime

    ceptime Active Member

  5. Mike

    Mike XenForo Developer Staff Member

    There's nothing for you to do. It will get cleaned up automatically.
     
  6. ceptime

    ceptime Active Member

    3.8GB data not cleaned. Problem solution
    Daily clean Cron run 500 internal server error
     
  7. Mike

    Mike XenForo Developer Staff Member

    You can try emptying the table in phpMyAdmin if you must then.
     
  8. Jafo

    Jafo Active Member

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

    Mike XenForo Developer Staff Member

    Daily clean up.
     
    Jafo likes this.

Share This Page