XF 1.1 MYSQLI Conversion issues..

[Stan]

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

 

[MattW]

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

 

[digitalpoint]

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.

 

[rdn]

Why did you choose ndbcluster DP?

 

[digitalpoint]

Because we use MySQL Cluster

 

[digitalpoint]

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:

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

 

[digitalpoint]

you can upgrade MySQL even across major versions without a millisecond of downtime.

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

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)