Re: MySQL 4.1 replication relay log control
Victoria Reznichenko wrote: relay-log-purge is available from 4.1.1. Do you use 4.1.1 or 4.1.0? Is it in the manual because relay-log-purge is available in 4.0.x? AFAICT, 4.1.1 isn't available for download from the mysql.com site. 4.1.0-alpha is. How would one obtain 4.1.1? Would this work to manage the relay log size: 1. restart the slave server to make it start a new realy log 2. monitor the slave server status until we see that its on the new relay log 3. at that point stop the slave server again 4. delete the extra logs and edit the relay log index by hand. 5. start the slave server. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1 replication relay log control
At 13:26 -0500 10/11/03, Christopher L. Everett wrote: Victoria Reznichenko wrote: relay-log-purge is available from 4.1.1. Do you use 4.1.1 or 4.1.0? Is it in the manual because relay-log-purge is available in 4.0.x? Sorry, what? AFAICT, 4.1.1 isn't available for download from the mysql.com site. 4.1.0-alpha is. How would one obtain 4.1.1? It's available from the BitKeeper repository: http://www.mysql.com/doc/en/Installing_source_tree.html Would this work to manage the relay log size: 1. restart the slave server to make it start a new realy log 2. monitor the slave server status until we see that its on the new relay log 3. at that point stop the slave server again 4. delete the extra logs and edit the relay log index by hand. 5. start the slave server. You don't need to stop and restart the server to make it start a new relay log. Just issue a FLUSH LOGS statement... -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1 replication relay log control
Christopher L. Everett [EMAIL PROTECTED] wrote: The online manual at http://www.mysql.com/doc/en/Replication_Options.html says that these two variables: max-relay-log-size=# relay-log-purge=0|1 exist to control the size of the relay log. But when I try to start my slave server with: set-variable = max-relay-log-size=192MB set-variable = relay-log-purge=1 in my.cnf it won't start. Am I using them right? relay-log-purge is available from 4.1.1. Do you use 4.1.1 or 4.1.0? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1 replication relay log control
The online manual at http://www.mysql.com/doc/en/Replication_Options.html says that these two variables: max-relay-log-size=# relay-log-purge=0|1 exist to control the size of the relay log. But when I try to start my slave server with: set-variable = max-relay-log-size=192MB set-variable = relay-log-purge=1 in my.cnf it won't start. Am I using them right? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]