Problem with MySQL Cluster performance

  Hello,

  Just had performance incident with the Cluster. I was notified that queries take too long to execute. And looking into "mysqladmin proc" I noticed that many threads are in "Locked" state. That's not normal.   Since I changed very many rows today (added ~250k rows to already ~250k rows table and also deleted ~120k rows) I guessed that maybe index got bloated and droped and recreated the index. (DROP INDEX, CREATE UNIQUE INDEX). And things went back to normal.

  How could I check that index is really in bad shape? And maybe I could somehow fix that bloat without droping and recreating? Since that took ~20min to perform.

  MySQL 5.0.41-community-log (installed from RPMs).

  Thanks,

  Mindaugas

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com