Re: CONCURRENT_INSERT?

[Michael Widenius]

>>>>> "Tim" == Tim Bunce <Tim.Bunce@stripped> writes:

Tim> On Wed, Jan 05, 2000 at 01:35:19AM +0200, Michael Widenius wrote:
>> 
>> It works instead as follows (this is done in an atomic context without
>> giving any other threads any possibility to interfere)
>> 
>> - Get a write-insert-lock
>> - Check if the table has any deleted blocks;  If this is true,
>> upgrade the lock to a write_lock and continue without concurrent inserts.

Tim> What's the fastest/cheapest way to remove deleted blocks? "Optimize"?

isamchk -r -O sort_buffer=128M */*.MYI  is faster (if you have > 128M memory),
but optimize is the fastest way from withing MySQL.

Regards,
Monty