Clean / remove ipb_core_search_index ?

[Duken]

Dear,

I found this in my database. Im running 4.3.4
A tabel ipb_core_search_index with a size of 309 MiB. Is this still in use for 4.3.4? Can i change it to InnoDB? Or can it be cleaned?

Thank you guys :)

 

[Yamamura]

12 hours ago, Duken said:

Is this still in use for 4.3.4?

This is used for searching.

12 hours ago, Duken said:

Can i change it to InnoDB?

Yes. By default, all tables are of type InnoDB.

12 hours ago, Duken said:

Or can it be cleaned?

Click on the "Rebuild Search Index" button in the "ACP → Search" if you have any problems with the search index.

If you want to reduce the size of the table, specify the number of days to store the search index:

[bfarber]

You can use InnoDB if you are using a version of MySQL that supports FULLTEXT indices with InnoDB (which is 5.6+ I believe, and basically all versions of Percona/MariaDB.