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

XF 1.1 MYSQLI Conversion issues..

Discussion in 'Troubleshooting and Problems' started by Stan, Jan 1, 2014.

  1. Stan

    Stan Active Member

    I just converted over to MySQLI and now can not post on the site. Any help would be greatly appreciated.

    I am getting:

    Mysqli prepare error: DELAYED option not supported for table 'xf_search_index'
    Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    Zend_Db_Adapter_Abstract->query() in XenForo/Search/SourceHandler/MySqlFt.php at line 110
    XenForo_Search_SourceHandler_MySqlFt->_pushToIndex() in XenForo/Search/SourceHandler/MySqlFt.php at line 82
    XenForo_Search_SourceHandler_MySqlFt->insertIntoIndex() in XenForo/Search/Indexer.php at line 44
    XenForo_Search_Indexer->insertIntoIndex() in XenForo/Search/DataHandler/Post.php at line 61
    XenForo_Search_DataHandler_Post->_insertIntoIndex() in XenForo/Search/DataHandler/Abstract.php at line 227
    XenForo_Search_DataHandler_Abstract->insertIntoIndex() in XenForo/DataWriter/DiscussionMessage.php at line 688
    XenForo_DataWriter_DiscussionMessage->_insertOrUpdateSearchIndex() in XenForo/DataWriter/DiscussionMessage.php at line 667
    XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 523
    XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1385
    XenForo_DataWriter->save() in XenForo/DataWriter/Discussion.php at line 415
    XenForo_DataWriter_Discussion->_saveFirstMessageDw() in XenForo/DataWriter/Discussion.php at line 363
    XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1385
    XenForo_DataWriter->save() in XenForo/ControllerPublic/Forum.php at line 490
    XenForo_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 313
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
    XenForo_FrontController->run() in /home/humpervi/public_html/index.php at line 13
     
  2. MattW

    MattW Well-Known Member

    What version of MySQL are you running? Also, what is the storage engine for the xf_search_index table? MyISAM or InnoDB?
     
  3. digitalpoint

    digitalpoint Well-Known Member

    If you go to your performance options (Admin -> Options -> Performance), disable the "Enable Delayed Insert SQL Queries" option.

    Not all MySQL servers/storage engines support it. All my tables are ndbcluster (instead of InnoDB) and it doesn't support delayed either.
     
  4. RoldanLT

    RoldanLT Well-Known Member

    Why did you choose ndbcluster DP?
     
  5. digitalpoint

    digitalpoint Well-Known Member

    Because we use MySQL Cluster
     
  6. digitalpoint

    digitalpoint Well-Known Member

    I think I misread the question...

    I use ndbcluster because it's fault tolerant (any db server can fail or be taken down completely for things like hardware upgrades and it doesn't affect site).

    It scales linearly (my setup can handle around 15,000,000 SQL SELECTs per second *while* doing around 5,000,000 INSERT/UPDATE/DELETEs per second).

    It also does a lot of nice things natively as a bonus (hot/non-blocking backups), you can upgrade MySQL even across major versions without a millisecond of downtime.

    This is a pretty good overview:

     
    RoldanLT likes this.
  7. digitalpoint

    digitalpoint Well-Known Member

    Sexy... :) In the middle of upgrading the cluster to mysql-5.6.15 ndb-7.3.4, and users don't even know. :)

    Code:
    ndb_mgm> show
    Cluster Configuration
    ---------------------
    [ndbd(NDB)]    8 node(s)
    id=11    @192.168.10.20  (mysql-5.6.15 ndb-7.3.4, Nodegroup: 0)
    id=12    @192.168.10.21  (mysql-5.6.15 ndb-7.3.4, Nodegroup: 1)
    id=13    @192.168.10.22  (mysql-5.6.15 ndb-7.3.4, Nodegroup: 2)
    id=14    @192.168.10.23  (mysql-5.6.15 ndb-7.3.4, starting, Nodegroup: 0)
    id=15    @192.168.10.24  (mysql-5.6.14 ndb-7.3.3, Nodegroup: 0, *)
    id=16    @192.168.10.25  (mysql-5.6.14 ndb-7.3.3, Nodegroup: 1)
    id=17    @192.168.10.26  (mysql-5.6.14 ndb-7.3.3, Nodegroup: 2)
    id=18    @192.168.10.27  (mysql-5.6.14 ndb-7.3.3, Nodegroup: 3)
    
    [ndb_mgmd(MGM)]    2 node(s)
    id=1    @192.168.10.20  (mysql-5.6.15 ndb-7.3.4)
    id=2    @192.168.10.21  (mysql-5.6.15 ndb-7.3.4)
    
    [mysqld(API)]    33 node(s)
    id=21    @192.168.10.20  (mysql-5.6.15 ndb-7.3.4)
    id=22    @192.168.10.21  (mysql-5.6.15 ndb-7.3.4)
     
    RoldanLT likes this.

Share This Page