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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to