Announcement

Announcement Module
Collapse
No announcement yet.

Help to improve performance !

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
Working...
X