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
kraemer at webit.de | www.webit.de
Amtsgericht Dresden | HRB 15422
GF Sven Haubold, Hagen Malessa