I wish to set
always on a MyISAM log table, so that inserts wouldn't have to wait for selects to perform when there are some holes in the table.
We're talking about 10-20 inserts per second and quite rare but yet some selects on the log that could take around 10s. I don't want my 100-200 inserts wait for these selects.
My question is quite simple actually. Taken aside the hole not-always-being-filled concern, when and how would it do any harm ?
Nota Bene: I wouldn't use
DELAYED INSERT as they are of the
INSERT ... ON DUPLICATE KEY UPDATE form.