GNU Info

(mysql.info)Fulltext Features to Appear in MySQL 4.0

---

Next: Fulltext TODO Prev: Fulltext Fine-tuning Up: Fulltext Search

---

Enter node , (file) or (file)node

New Features of Full-text Search to Appear in MySQL 4.0
-------------------------------------------------------

This section includes a list of the fulltext features that are already
implemented in the 4.0 tree. It explains *More functions for full-text
search* entry of *Note TODO MySQL 4.0::.

   * `REPAIR TABLE' with `FULLTEXT' indexes, `ALTER TABLE' with
     `FULLTEXT' indexes, and `OPTIMIZE TABLE' with `FULLTEXT' indexes
     are now up to 100 times faster.

   * `MATCH ... AGAINST' is going to supports the following *boolean
     operators*:

        * `+'word means the that word *must* be present in every row
          returned.

        * `-'word means the that word *must not* be present in every
          row returned.

        * `<' and `>' can be used to decrease and increase word weight
          in the query.

        * `~' can be used to assign a *negative* weight to a noise word.

        * `*' is a truncation operator.

     Boolean search utilizes a more simplistic way of calculating the
     relevance, that does not have a 50% threshold.

   * Searches are now up to 2 times faster due to optimized search
     algorithm.

   * Utility program `ft_dump' added for low-level `FULLTEXT' index
     operations (querying/dumping/statistics).