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
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= ft_min
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 in
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
set-variable
