I'm having major problems with a very busy database. Everytime the Not_flushed_key_blocks gets to be more than 0 then all my queries to the main table gets Locked for like 200 seconds. It Not_flushed_key_blocks is 0 it only takes like 2 seconds to return.

Any one come accross similar problems?

Scott