# Help to improve performance !

**URL:** <https://forums.percona.com/t/help-to-improve-performance/469>\
**Category:** Other MySQL® Questions\
**Created:** [September 27, 2007, 10:49pm UTC](https://forums.percona.com/t/help-to-improve-performance/469 "2007-09-27T22:49:11Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![huytrongpham83](https://avatars.discourse-cdn.com/v4/letter/h/a8b319/32.png) [@huytrongpham83](https://forums.percona.com/u/huytrongpham83)\
**Post date:** [September 27, 2007, 10:49pm UTC](https://forums.percona.com/t/help-to-improve-performance/469/1 "2007-09-27T22:49:11Z")

</div>

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