Re: how to avoid lock table, wait online

[Ingo Strüwing]

I belive that I cannot give useful advice. Please consider to ask in the "Performance" forum again. Just some thoughts:

With MyISAM there is little help against table locks. You could however try to insert and delete a single row at a time only. This will reduce the overall troughput, because of the additional overhead, but you will have thousands of very short locks instead of a single long lock. That way inserts and deletes can run alternately and thus seemingly at the same time.

If your main goal is to avoid that the insert process is blocked, you could try to use INSERT DELAYED.

You could also try to use InnoDB instead of MyISAM. It is able to do row-level locking. With a low isolation level, you might perhaps get around your problem.