MySQL Forums
Forum List  »  Full-Text Search

Re: Mysql Fulltext and Slow First Query
Posted by: Rick James
Date: December 04, 2008 09:07PM

What are your cache settings (esp, key_buffer)?

SQL_CALC_FOUND_ROWS means it has to discover all the results. This may not be as bad as fetching all the results, if it can do the count in an index.

Query cache = 300MB -- possibly too big. The QC is useful only when
1. you present it with exactly the same query, and
2. no updates/inserts/etc have changed the table(s).

"First" -- meaning after restarting the server? That would be slow because of nothing being in cache. If by First you mean that you are presenting exactly the same query, well that's the QC's job, and it will be blazingly fast.

Options: ReplyQuote

Written By
November 07, 2008 11:17AM
Re: Mysql Fulltext and Slow First Query
December 04, 2008 09:07PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.