Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Help to improve performance !

huytrongpham83huytrongpham83 EntrantCurrent User Role Beginner
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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.