Re: Features in 4.0
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? Best, Kyle On Tuesday 25 September 2001 14:29, Fournier Jocelyn [Presence-PC] wrote: Take a look at this :) http://www.mysql.com/doc/N/e/News-4.0.0.html I'm currently using MySQL 4.0 on two servers, and it works great :) Union seems also to work really fine now although it remains some features to be added before beeing perfect. Jocelyn Fournier Presence-PC -- Quicknet has just released the following new products: Internet SwitchBoard v5.5 and MicroTelco Gateway 2.0. We have also added a new low cost carrier, Blue Star Telecom to our award winning MicroTelco services. For more information visit: www.quicknet.net or www.microtelco.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
Re: Features in 4.0
Subselects are not yet supported in the 4.0 release. - Original Message - From: Kyle Hayes [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, September 26, 2001 4:40 PM Subject: Re: Features in 4.0 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? Best, Kyle On Tuesday 25 September 2001 14:29, Fournier Jocelyn [Presence-PC] wrote: Take a look at this :) http://www.mysql.com/doc/N/e/News-4.0.0.html I'm currently using MySQL 4.0 on two servers, and it works great :) Union seems also to work really fine now although it remains some features to be added before beeing perfect. Jocelyn Fournier Presence-PC -- Quicknet has just released the following new products: Internet SwitchBoard v5.5 and MicroTelco Gateway 2.0. We have also added a new low cost carrier, Blue Star Telecom to our award winning MicroTelco services. For more information visit: www.quicknet.net or www.microtelco.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 - 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
Re: Features in 4.0
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
Re: Features in 4.0
On Wed, Sep 26, 2001 at 07:40:45AM -0700, Kyle Hayes wrote: I did not see subselects in this list. Will MySQL support subselects in 4.x? The last plan for sub-selects I heard was in 4.1.x. What exactly does the LOAD TABLE FROM MASTER 'automagically' comment mean? Does that command sync the slave with the master at that point? Yes. 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? I'm not sure yet. But I think that the goal is to avoid the need to do that. 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. Complex? Have you seen mysqlsnapshot? http://jeremy.zawodny.com/mysql/mysqlsnapshot/ It's what I've used to setup replication? Could someone from the MySQL team please give us some details on subselects and the new load table functionality? What I'm relaying is information I've heard from MySQL team members. But I'm sure someone will speak up if I get any of it wrong. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 20 days, processed 394,225,723 queries (217/sec. avg) - 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
Features in 4.0
What will this thing have? i know Union tables will be present :) . What else? I'm very anctious to get my hands on it. thanx ^_^ ** - Deryck Henson - http://www.comp-u-exchange.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
Re: Features in 4.0
Take a look at this :) http://www.mysql.com/doc/N/e/News-4.0.0.html I'm currently using MySQL 4.0 on two servers, and it works great :) Union seems also to work really fine now although it remains some features to be added before beeing perfect. Jocelyn Fournier Presence-PC - Original Message - From: Deryck Henson [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 11:15 PM Subject: Features in 4.0 What will this thing have? i know Union tables will be present :) . What else? I'm very anctious to get my hands on it. thanx ^_^ ** - Deryck Henson - http://www.comp-u-exchange.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 - 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
