On Wed, May 02, 2007 at 09:11:12PM +0200, Antti Akonniemi wrote: > 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?
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 [EMAIL PROTECTED] | www.webit.de Amtsgericht Dresden | HRB 15422 GF Sven Haubold, Hagen Malessa _______________________________________________ Ferret-talk mailing list [email protected] http://rubyforge.org/mailman/listinfo/ferret-talk
