Skip navigation links

MySQL Forums :: Full-Text Search :: FULLTEXT Search performance


Advanced Search

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)

Options: ReplyQuote


Subject Views Written By Posted
FULLTEXT Search performance 9821 Serge 12/18/2004 08:18AM
Re: FULLTEXT Search performance 5244 James Day 12/18/2004 11:18AM
Re: FULLTEXT Search performance 3961 Serge 12/21/2004 08:40AM
Re: FULLTEXT Search performance 3968 James Day 12/21/2004 11:27AM
Re: FULLTEXT Search performance 3607 Serge 12/22/2004 02:02AM
Re: FULLTEXT Search performance 5156 James Day 12/22/2004 07:54AM
Re: FULLTEXT Search performance 3460 Peter Zaitsev 12/31/2004 08:09PM
Re: FULLTEXT Search performance 3390 Milen Milkovski 04/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.