Tuning FULLTEXT performance (was Re: Memory upgrade and swap partition size)

Thomas Charron twaffle at gmail.com
Wed Sep 27 09:01:00 EDT 2006


On 9/26/06, Fred <puissante at lrc.puissante.com> wrote:
>
> Anyway, I am having a dilly of a time tuning the FULLTEXT performance with
> MySQL, because I have many FULLTEXT inserts going on at the same time with
> FULLTEXT searches, and every INSERT locks the entire table, causing
> everything else to wait -- and exhaust swap space and crash the server!



  What type of database?  InnoDB, or MyISAM?

  Thomas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.gnhlug.org/mailman/private/gnhlug-discuss/attachments/20060927/367a9e84/attachment.html


More information about the gnhlug-discuss mailing list