Re: Percona 5.5 semisynchronous replication.

2013-01-08 Thread Johan De Meersman
- Original Message - > From: "Rafał Radecki" > > Seconds_Behind_Master: 364 > > So if I have rpl_semi_sync_master_timeout=5000 (5s) and semisync > > why is it possible on the slave to fall behind the master? Semi-sync only guarantees that the slave has *received* the statement in it's

Re: Relay log Question

2013-01-08 Thread Akshay Suryavanshi
Also, you may want to see, if at all new file is really getting every hour exactly, if any cron'd script runs, which executes "flush logs" on the slave server. That will also rotate relay log. Cheers On Wed, Jan 9, 2013 at 1:35 AM, Akshay Suryavanshi < akshay.suryavansh...@gmail.com> wrote: > Hi

Re: Relay log Question

2013-01-08 Thread Akshay Suryavanshi
Hi, Please re-phrase your question. The relay logs are created as and when required by the Slave_SQL thread. Once all the events in the relay logs are executed the relay log would be purged by the Slave_SQL thread. By setting relay_log_purge=0 you are disabling this automatic purge option. So the

mysql-5.1.67-osx10.6-x86_64.dmg

2013-01-08 Thread Elim Qiu
I downloaded mysql-5.1.67-osx10.6-x86_64.dmg, installed it to my snow leopard book. it works but from the preference pane I see MySQL(32-bit) What I should believe, how do I make sure it's 64bit? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

Percona 5.5 semisynchronous replication.

2013-01-08 Thread Rafał Radecki
Hi all. I have installed a setup in which I use semisync replication. On master I have: mysql> show status like '%rpl%'; ++-+ | Variable_name | Value | ++-