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
Has anyone else bumped into this kind of behaviour? Any ideas what might
be causing it?