How To Use Tritonn

Overview

Tritonn is a patched version of MySQL that supports better fulltext search function with Senna.

Why Tritonn?

MySQL version after 3.23.23 supports FULLTEXT index. With it, MySQL can execute the full-text search for the field of VARCHAR and TEXT type. But, MySQL's fulltext search implementation has the following problems:

• Insufficient Japanese/Chinese/Korean support
• Slow phrase search
• Slow update

With Tritonn, you get M17N fulltext search function, faster phrase search, and faster update WITHOUT modifying your application.

Install

You can find RPM files for Mandriva 2008.0 at the following URI.

http://www.nexedi.org/static/experimental/mandrivalinux/

Setup

Add followings to mysqld section of /etc/my.cnf

# Use utf8 as the default character set.
default-character-set=utf8

# Ignore client information and use the default server character set.
skip-character-set-client-handshake

Drop and recreate table for ERP5, and invoke ERP5Site_reindexAll.

That's all.