# Index update - problems

**URL:** <https://www.ruby-forum.com/t/index-update-problems/103196>\
**Category:** Ferret\
**Created:** [May 2, 2007, 9:11pm UTC](https://www.ruby-forum.com/t/index-update-problems/103196 "2007-05-02T21:11:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Antti\_Akonniemi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f4b2a3/32.png) [@Antti\_Akonniemi](https://www.ruby-forum.com/u/Antti_Akonniemi)\
**Post date:** [May 2, 2007, 9:11pm UTC](https://www.ruby-forum.com/t/index-update-problems/103196/1 "2007-05-02T21:11:12Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Antti\_Akonniemi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f4b2a3/32.png) [@Antti\_Akonniemi](https://www.ruby-forum.com/u/Antti_Akonniemi)\
**Post date:** [May 3, 2007, 10:01am UTC](https://www.ruby-forum.com/t/index-update-problems/103196/2 "2007-05-03T10:01:17Z")

</div>

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  
removed\_email\_address@domain.invalid | [www.webit.de](http://www.webit.de)

Amtsgericht Dresden | HRB 15422  
GF Sven Haubold, Hagen Malessa

---

<div class="post-metadata">

**Author:** ![Antti\_Akonniemi](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f4b2a3/32.png) [@Antti\_Akonniemi](https://www.ruby-forum.com/u/Antti_Akonniemi)\
**Post date:** [May 4, 2007, 7:23am UTC](https://www.ruby-forum.com/t/index-update-problems/103196/3 "2007-05-04T07:23:58Z")

</div>

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