aseek-users  

Re: [aseek-users] index -D

Kir Kolyshkin
Sun, 17 Aug 2003 08:56:10 -0700

yayaivan wrote:
Hi all,

Index -D is working 7-8 hours:( Is it normal???

It may or may not be normal, depending on other factors, such as RAM size, disks speed, CPU number and speed etc.


> In database there are 700.000 documents. How can I increase speed?

Increase MySQL's key_buffer_size to 1/4 of available RAM. Add more RAM.
Run OPTIMIZE TABLE on all MySQL's tables in aspseek's database.