Forum: Ferret Index update - problems

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
39f714d21ec9593a754084ca8bc8c834?d=identicon&s=25 Antti Akonniemi (Guest)
on 2007-05-02 21:11
Hi,

Rails 1.2.2
Ruby 1.8.5
Ferret 0.11.4

I have pretty big forum that has 2 columns that are indexed, in addition
to this couple more tables with far less data are indexed.

It seems that first index update works. Mysqld process takes the idle
CPU time, but behaves nicely.. until at some point it takes 99% and
doesn't let other processes use it :) I'm forced to restart mysqld. Then
again it works for a while, but then after some new rows problems begin.

I'm using :remote => true for my models

I started my ferret server with this command:
FERRET_USE_LOCAL_INDEX=1 RAILS_ENV=production ruby script/runner 'load
"script/ferret_start"'

Has anyone else bumped into this kind of behaviour? Any ideas what might
be causing it?

Regards,

Antti
C9dd93aa135988cabf9183d3210665ca?d=identicon&s=25 Jens Kraemer (Guest)
on 2007-05-03 10:01
(Received via mailing list)
On Wed, May 02, 2007 at 09:11:12PM +0200, Antti Akonniemi wrote:
> CPU time, but behaves nicely.. until at some point it takes 99% and
> be causing it?
maybe there's some mysql limit (number of connections, threads, mem
usage) that gets reached? You could monitor the mysql server variables
(show status) to find out.

Jens

--
Jens Krämer
webit! Gesellschaft für neue Medien mbH
Schnorrstraße 76 | 01069 Dresden
Telefon +49 351 46766-0 | Telefax +49 351 46766-66
kraemer@webit.de | www.webit.de

Amtsgericht Dresden | HRB 15422
GF Sven Haubold, Hagen Malessa
39f714d21ec9593a754084ca8bc8c834?d=identicon&s=25 Antti Akonniemi (Guest)
on 2007-05-04 07:23
Found the problem! Wasn't actually Rails related. Mysql udpdate had
messed something and was causing a ton of troubles. What a relief! :)
AAF is now working like a charm! Thanks for your time!

-antti
This topic is locked and can not be replied to.