Manual talk:Searchindex table

out of date
Is this page out of date? --Cumeo89 10:20, 17 June 2008 (UTC)
 * Nope. The searchindex table just sucks. :D --brion 18:16, 2 July 2009 (UTC)

Migrating from MyISAM to InnoDB
Hi,

I'm currently migrating a large mediawiki from MyISAM to InnoDB, testing this on a development database. When trying to convert searchindex it fails because FULLTEXT isn't supported by InnoDB.

I may leave this table on MyISAM this time but how would MediaWiki create this table in a InnoDB-only environment? What type of INDEX would be used here?

Currently the table looks like this: mysql> show create table searchindex\G Table: searchindex Create Table: CREATE TABLE `searchindex` ( `si_page` int(8) unsigned NOT NULL DEFAULT '0',  `si_title` varchar(255) NOT NULL DEFAULT '',  `si_text` mediumtext NOT NULL,  UNIQUE KEY `si_page` (`si_page`),  FULLTEXT KEY `si_title` (`si_title`),  FULLTEXT KEY `si_text` (`si_text`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1 1 row in set (0.00 sec)
 * 1. row ***************************

Regards --Rabe 20:21, 4 December 2011 (UTC)


 * The fulltext index type is only available on MyISAM; by default, all MediaWiki tables *except* 'searchindex' are InnoDB, and 'searchindex' as an exception gets MyISAM specifically so it will work.
 * This leaves it as a single point of failure in an InnoDB system, where this table can still get marked crashed and cause annoyance.
 * HOWEVER! If you use a separate search engine instead, you don't actually need the searchindex table's fulltext index. Try setting up Sphinx or Lucene search backends, and you can drop the fulltext indexes. --brion 23:04, 4 December 2011 (UTC)

Doc about indexes seems to be wrong
mysql> show indexes from searchindex; +-++--+--+-+---+-+--++--++-+---+ | Table       | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-++--+--+-+---+-+--++--++-+---+ | searchindex |          0 | si_page  |            1 | si_page     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               | | searchindex |         1 | si_title |            1 | si_title    | NULL      |        NULL |     NULL | NULL   |      | FULLTEXT   |         |               | | searchindex |         1 | si_text  |            1 | si_text     | NULL      |        NULL |     NULL | NULL   |      | FULLTEXT   |         |               | +-++--+--+-+---+-+--++--++-+---+ 3 rows in set (0.02 sec)

whereas this page shows only si_page and si_text. Someone less chicken newbie than me to correct it, after some verification?

Important note: I did not install MediaWiki, but used the mwdumper.jar program to import a dump of Wikipédia. However this should not change the indexes layout. --MathsPoetry (talk) 08:44, 25 February 2013 (UTC)
 * You miss si_title; in the meantime it has been added to the page. --88.130.93.218 19:39, 5 March 2014 (UTC)