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