RE: What is relay-bin log?
On Mon, 2002-10-21 at 14:25, Michael Widenius wrote: Which log files is it that you want to delete ? (Please give an example for this) If you have a problem that old relay logs are not deleted, try to upgrade to MySQL 4.0.4 ; We recently fixed a bug in this code. This is still happening with 4.0.5a (Std, with InnoDB). # grep relay /service/svc-mysql/run --relay-log=/mysql/logs/relay \ --relay-log-info-file=/mysql/logs/relay.info \ --relay_log_space_limit=500M \ # ls -al (...) -rw-rw1 mysqlmysql541557913 Dec 16 17:04 relay.001 (...) # mysqladmin processlist (...) | 2 | system user | none | | Connect | 539| Waiting for relay log space to free | (...) # mysqladmin shutdown nothing happens # svc -t /service/svc-mysql nothing still # svc -k /service/svc-mysql ; rm relay.* this works ... # mysql --version mysql Ver 12.16 Distrib 4.0.5a-beta, for pc-linux (i686) # /usr/local/libexec/mysqld --version /usr/local/libexec/mysqld Ver 4.0.5a-beta for pc-linux on i686 -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - 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: What is relay-bin log?
On Mon, 2002-12-16 at 16:20, Nicolas MONNET (Tech) wrote: (...) Nevermind. This was due to an error in the replication; but nonetheless, it is impossible to shutdown mysqld cleanly if it's waiting for relay logs to be freed. -- Nicolas MONNET (Tech) [EMAIL PROTECTED] Carpe Diem - 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: What is relay-bin log?
You said that old relay logs are automatically deleted. But on what condition? log file size? time? or anything else? I'd asked about when the relay logs are deleted but got no answers, so I'm asking again. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Michael Widenius [mailto:monty;mysql.com] Sent: Monday, October 21, 2002 9:25 PM To: Á¤ Çϳç Cc: 'Victoria Reznichenko'; [EMAIL PROTECTED] Subject: RE: What is relay-bin log? Hi! Chung == Chung Ha-nyung [EMAIL PROTECTED] writes: Chung It is seems that RESET SLAVE query sholud not be done while Chung replication is working. Slave forget its replication position and cannot Chung continue replication since it tries to do the queries already executed. Chung Do I need to do SLAVE STOP before RESET SLAVE? Or any Chung other means to delete replication logs during replication? Which log files is it that you want to delete ? (Please give an example for this) If you have a problem that old relay logs are not deleted, try to upgrade to MySQL 4.0.4 ; We recently fixed a bug in this code. If you want to delete all old binary log files, then the command is RESET MASTER. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: What is relay-bin log?
Hi! Chung == Chung Ha-nyung [EMAIL PROTECTED] writes: Chung It is seems that RESET SLAVE query sholud not be done while Chung replication is working. Slave forget its replication position and cannot Chung continue replication since it tries to do the queries already executed. Chung Do I need to do SLAVE STOP before RESET SLAVE? Or any Chung other means to delete replication logs during replication? Which log files is it that you want to delete ? (Please give an example for this) If you have a problem that old relay logs are not deleted, try to upgrade to MySQL 4.0.4 ; We recently fixed a bug in this code. If you want to delete all old binary log files, then the command is RESET MASTER. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: What is relay-bin log?
Hi! Chung == Chung Ha-nyung [EMAIL PROTECTED] writes: Chung If all works correctly, can I delete replication logs by RESET SLAVE Chung safely? Chung I'd like to configure two servers with two-master scheme, each is the Chung master of Chung another. relay logs should automaticly be deleted and you should never have to do RESET SLAVE to delete them. RESET SLAVE should only be used when you want the slave to not be a part of the replication anymore. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: What is relay-bin log?
It is seems that RESET SLAVE query sholud not be done while replication is working. Slave forget its replication position and cannot continue replication since it tries to do the queries already executed. Do I need to do SLAVE STOP before RESET SLAVE? Or any other means to delete replication logs during replication? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Chung Ha-nyung [mailto:alita;neowiz.com] Sent: Monday, October 21, 2002 2:22 PM To: 'Victoria Reznichenko'; [EMAIL PROTECTED] Subject: RE: What is relay-bin log? If all works correctly, can I delete replication logs by RESET SLAVE safely? I'd like to configure two servers with two-master scheme, each is the master of another. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Friday, October 18, 2002 8:01 PM To: [EMAIL PROTECTED] Subject: re: What is relay-bin log? Chung, Thursday, October 17, 2002, 9:48:15 AM, you wrote: CHn At the slave server of replication there are log files like CHn environment hostname-relay-bin.xxx. Yes, these logs are used for replication: http://www.mysql.com/doc/en/Replication_SQL.html CHn For what these logs and how can I know which one I can delete safely? RESET SLAVE; -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 - 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: What is relay-bin log?
Well... Then when is the time for replication logs to be deleted? Can I change the conditions for it? I'm not able to find out related section in the official manual. No mention about auto deletion, either. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Michael Widenius [mailto:monty;mysql.com] Sent: Monday, October 21, 2002 9:22 PM To: Á¤ Çϳç Cc: 'Victoria Reznichenko'; [EMAIL PROTECTED] Subject: RE: What is relay-bin log? Hi! Chung == Chung Ha-nyung [EMAIL PROTECTED] writes: Chung If all works correctly, can I delete replication logs by RESET SLAVE Chung safely? Chung I'd like to configure two servers with two-master scheme, each is the Chung master of Chung another. relay logs should automaticly be deleted and you should never have to do RESET SLAVE to delete them. RESET SLAVE should only be used when you want the slave to not be a part of the replication anymore. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: What is relay-bin log?
If all works correctly, can I delete replication logs by RESET SLAVE safely? I'd like to configure two servers with two-master scheme, each is the master of another. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Friday, October 18, 2002 8:01 PM To: [EMAIL PROTECTED] Subject: re: What is relay-bin log? Chung, Thursday, October 17, 2002, 9:48:15 AM, you wrote: CHn At the slave server of replication there are log files like CHn environment hostname-relay-bin.xxx. Yes, these logs are used for replication: http://www.mysql.com/doc/en/Replication_SQL.html CHn For what these logs and how can I know which one I can delete safely? RESET SLAVE; -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 - 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: What is relay-bin log?
Chung, Thursday, October 17, 2002, 9:48:15 AM, you wrote: CHn At the slave server of replication there are log files like CHn environment hostname-relay-bin.xxx. Yes, these logs are used for replication: http://www.mysql.com/doc/en/Replication_SQL.html CHn For what these logs and how can I know which one I can delete safely? RESET SLAVE; -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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