FULLTEXT Search performance
Posted by:
Serge
Date: December 18, 2004 08:18AM
I have a large table with fulltext index (~180000 records, ~530Mb data, ~700Mb index).
All fulltext search queries execute too slow. How can I speed up theese queries?
mysql> select count(*) from papers where match(title,keywords) against("test");
+----------+
| count(*) |
+----------+
| 12474 |
+----------+
1 row in set (58.95 sec)
mysql> show columns from papers;
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | | PRI | NULL | auto_increment |
| title | varchar(255) | | MUL | | |
| keywords | text | | | | |
+----------+------------------+------+-----+---------+----------------+
3 rows in set (0.01 sec)
mysql> show index from papers;
+--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| papers | 0 | PRIMARY | 1 | id | A | 178406 | NULL | NULL | | BTREE | |
| papers | 1 | search | 1 | title | A | NULL | NULL | NULL | | FULLTEXT | |
| papers | 1 | search | 2 | keywords | A | NULL | 1 | NULL | | FULLTEXT | |
+--------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
3 rows in set (0.00 sec)
Subject
Views
Written By
Posted
FULLTEXT Search performance
11741
December 18, 2004 08:18AM
6327
December 18, 2004 11:18AM
4678
December 21, 2004 08:40AM
4714
December 21, 2004 11:27AM
4446
December 22, 2004 02:02AM
6154
December 22, 2004 07:54AM
4191
December 31, 2004 08:09PM
4084
April 15, 2005 08:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.