On Wed, 27 Aug 2003 at 13:22:46 +0400, yayaivan wrote: > >> 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. > > When database was near 500.000 documents, index -D works ~2 hours. And then smth > happened... To increase speed of index -S I had been added KEY to the table > "urlword" on field status, but I think it can only slow insert/delete queries, and > index -D I think only make selects....
You need to be careful of adding new indexes. I have seen cases where the MySQL query optimizer has made a very poor choice of index resulting in significant decrease in performance. Try enabling log-slow-queries in your my.cnf and check the log during/after an index run. Matt. > > > 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. > > Thank you, I'll try.
pgp00000.pgp
Description: PGP signature
