← Back to team overview

maria-discuss team mailing list archive

Re: Full text search in MariaDB


Hi Monty

On 04/08/2010, at 8:39 AM, Michael Widenius wrote:

Arjen> Real world feedback: almost all clients we have that use FULLTEXT need
Arjen> to not use it, because
Arjen> - they need the tables to be InnoDB for transactional/ consistency
Arjen> reasons; since Aria is not transactional it's not an option.

Aria is crash safe and consistent, which should make it an option for
a lot of users;  Arjen, how often do you need to do rollback on a
fulltext index ?

Such a table is not "purely" an index, it just happens to have columns that need such indexing. Data in multiple tables belongs together, and is inserted/updated at the same time. Rollback is relevant/important.

Please don't recycle the ancient argument that you don't need transactions, it's not a winner.

Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Exceptional Services for MySQL at a fixed budget.

Follow our blog at http://openquery.com/blog/
OurDelta: packages for MySQL and MariaDB @ http://ourdelta.org