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/25/05, Richard Dale <[EMAIL PROTECTED]> wrote: > > 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 if there are queries going on. > > It's like the unix "top" command. > http://jeremy.zawodny.com/mysql/mytop/ > > Also try: > SHOW PROCESSLIST; > > If you use InnoDB: > show innodb status; > > Best regards, > Richard Dale. > Norgate Investor Services > - Premium quality Stock, Futures and Foreign Exchange Data for > markets in Australia, Asia, Canada, Europe, UK & USA - > www.premiumdata.net > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
