Re: Slow Fulltext Search on Large Table

Hi! On Feb 18, Peter Bryant wrote: My problem is that my fulltext searches run quite slowly. I have a 2300MB table with 4.3M rows and an index (primarily a fulltext index) of 1300M. My hardware is a dual Athlon MP1500+ with 2GB of memory. I am running MySQL 4.0.10. My my.cnf

Re: Slow Fulltext Search on Large Table

Peter, Here are my suggestions based on past and current experience. 1) set-variable = sort_bufffer=8M Since you have a lot of records there you will no doubt be doing quite a lot of sorting. Increase the sort_buffer. This would also speed up new index creation. 2) set-variable=

Re: Slow Fulltext Search on Large Table

Hi! On Feb 18, xing wrote: Peter, Here are my suggestions based on past and current experience. Unfortunately, they are mostly wrong :( 1) set-variable = sort_bufffer=8M Since you have a lot of records there you will no doubt be doing quite a lot of sorting. Increase the

Slow Fulltext Search on Large Table

My problem is that my fulltext searches run quite slowly. I have a 2300MB table with 4.3M rows and an index (primarily a fulltext index) of 1300M. My hardware is a dual Athlon MP1500+ with 2GB of memory. I am running MySQL 4.0.10. My my.cnf includes: set-variable = key_buffer=16M