Help to improve performance !

Hi all,

I have a large data, about 20 million record. This is my table:

CREATE TABLE books (
record_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
isbn VARCHAR(20) NULL,
book_name VARCHAR(255) NULL,
author VARCHAR(100) NULL,
publisher VARCHAR(100) NULL,
publish_date DATE NULL,
PRIMARY KEY(record_id),
UNIQUE INDEX isbn(isbn),
FULLTEXT INDEX book_name(book_name),
FULLTEXT INDEX author(author),
FULLTEXT INDEX publisher(publisher )
) ENGINE=MyISAM DEFAULT CHARSET=latin1

When I run query :
“select count(*) from books where match(book_name) against (’+cooking guide’ in boolean mode)”, it takes about 30 seconds to finish.

Any ideas to improve performance ?

Below is my MySQL configuration:

key_buffer_size=50M
read_buffer_size=1M
read_rnd_buffer_size=2M
sort_buffer_size=256K

Trong