On Aug 18, Michael Widenius wrote:
> Sergei> Also, INSERT_METHOD should also go to MRG file, for isam layer to know
> It's should be enough for MySQL to know about this.
It CAN be done that way - that is to pass INSERT_METHOD as an argument
But to be consistent it should be stored on isam layer - it's isam information,
and MySQL shouldn't ever worry about it.
> Sergei> Also in ROUND_ROBIN it has somehow to preserve the last-target-table
> Sergei> on shutdown. This will change MRG files from simple ``ls *.MYI >
> Sergei> to something more complex. In ROUND_ROBIN they also won't be read-only.
> Sorry, but I didn't get that.
Well, suppose you have three tables in MERGE, and INSERT_METHOD=ROUND_ROBIN
First insert goes to the first table, the second one - to the second.
Now one does ``mysql.server stop; mysql.server start'' - or simply mysqld
dies and safe_mysqld restarts it. I would prefer the first insert after restart
to go to the third table.
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany