Recently I had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with queries in Locked status.My first thought was that the customer had deleted from the table, which leaves "holes" in the middle [...]