Re: Mysqld chewing up cpu in the background.

2005-07-27 Thread mos
At 09:16 AM 7/27/2005, you wrote: Thanks for the suggestion. That did help me find out. It wasn't idle. The problem is that its taking 10 seconds to insert a single record, composed mainly of one longtext field. The index is killing me. Does anyone know of how FT indexing can be changed to do i

Re: Mysqld chewing up cpu in the background.

2005-07-27 Thread Dan Baughman
Thanks for the suggestion. That did help me find out. It wasn't idle. The problem is that its taking 10 seconds to insert a single record, composed mainly of one longtext field. The index is killing me. Does anyone know of how FT indexing can be changed to do inserts quicker or something? On 7/

RE: Mysqld chewing up cpu in the background.

2005-07-25 Thread Richard Dale
> I am fairly sure that there aren't any queries being run, but while in > the background, my mysqld process chews up exactly 50% of my cpu. It > runs queries nicely and has excellent response times for most any > query I throw at it, but its causing issues for other apps. Try using mytop to see i

Mysqld chewing up cpu in the background.

2005-07-25 Thread Dan Baughman
Hello All, I am fairly sure that there aren't any queries being run, but while in the background, my mysqld process chews up exactly 50% of my cpu. It runs queries nicely and has excellent response times for most any query I throw at it, but its causing issues for other apps. What can I do to fin