Re: indexer -Cw takes too much time

2002-06-14 Thread Alexander Barkov
Kreso wrote: On Wed, Jun 12, 2002 at 08:28:27PM +0500, Alexander Barkov wrote: What does mysqladmin processlist display? Are there any active queries being executed by mnogosearch? Well, I switched the query logging on. In the query log file I can see: $ ./indexer -Cw -t ECA $ tail

Re: indexer -Cw takes too much time

2002-06-14 Thread Kreso
On Fri, Jun 14, 2002 at 03:13:04PM +0500, Alexander Barkov wrote: Kreso wrote: On Wed, Jun 12, 2002 at 08:28:27PM +0500, Alexander Barkov wrote: What does mysqladmin processlist display? Are there any active queries being executed by mnogosearch? Well, I switched the query

Re: indexer -Cw takes too much time

2002-06-14 Thread Alexander Barkov
Kreso wrote: Well, as far as ndictxx tables are concerned, I would not like to propose any ad hoc solutions which you have probably tested already. In any case, I would try to avoid any solution with mysql which leads to SELECT looping, even at the price of search speed. Would it be

Re: indexer -Cw takes too much time

2002-06-13 Thread Kreso
On Wed, Jun 12, 2002 at 08:28:27PM +0500, Alexander Barkov wrote: What does mysqladmin processlist display? Are there any active queries being executed by mnogosearch? Well, I switched the query logging on. In the query log file I can see: $ ./indexer -Cw -t ECA $ tail -f

Re: indexer -Cw takes too much time

2002-06-12 Thread Alexander Barkov
What does mysqladmin processlist display? Are there any active queries being executed by mnogosearch? Kreso wrote: RedHat 7.2, 2x1Ghz, 512MB, hardware RAID dedicated search maschine, no other tasks running. MySQL 3.23.49, default configuration. Maybe some mysql tuning would help.

Re: indexer -Cw takes too much time

2002-06-11 Thread Aleksey Trubin
Kreso wrote: Hallo, I have a problem with indexer -Cw -t xxx. It takes too much time. With a database 1.5 million entries it works longer than 2 hours already. mysqld doesn't take much CPU. Any ideas? mnogosearch v3.1.19 is in the question. I have created an index on tags before. thanks,