Kyle Hayes writes:
>
> I did not see subselects in this list. Will MySQL support subselects in 4.x?
>
> What exactly does the "LOAD TABLE FROM MASTER" 'automagically' comment mean?
> Does that command sync the slave with the master at that point? If I have
> three tables, A, B, and C, and I want to load them at runtime from the master
> and start replication do I have to lock them before doing "LOAD TABLE FROM
> MASTER"?
>
> We are searching for a solution to enable us to load a large amount of data
> without stopping the master for more than a couple of seconds. So far, we
> have been able to write our own complex code to do this, but it is far from
> the level of automation that we want.
>
> Could someone from the MySQL team please give us some details on subselects
> and the new load table functionality?
Hi,
Subselects are scheduled for version 4.1.
I don't know about the LOAD TABLE question, please direct this question
to Sasha Pachev ([EMAIL PROTECTED]).
Matt
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor
/_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota USA
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php