maria-discuss team mailing list archive

[Arjen Lentz <arjen@xxxxxxxxxxxxx>]

Hi Monty

On 04/08/2010, at 8:39 AM, Michael Widenius wrote:
> <cut>
>
> 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.

Cheers,
Arjen.
--
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