Re: Concurrent Inserts with merged table

[mos]

At 08:54 PM 3/5/2009, Baron Schwartz wrote:
> > Is there a way I can restore the concurrent select feature to a working
> > state without having to shut down the server and rebuild the entire data
> > base?
>
>Usually when concurrent insert is not permitted, it's because there
>are holes in the table that cause inserts to go somewhere other than
>at the end of the table.

So if Baron is right. then just run "optimize table1, table2,...tablen" to 
get rid of the holes.

See http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html


Mike