Hello !
Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
Ok now
-----Original Message-----
From: Darvin Denmian [mailto:darvin.denmian@gmail.com]
Sent: Wednesday 09 June 2010 19:00
To: mysql@lists.mysql.com
Subject: FLUSH LOCAL LOGS
Hello !
Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=azzopardi@eib.org
------------------------------------------------------------ --------
Les informations contenues dans ce message et/ou ses annexes sont
reservees a l'attention et a l'utilisation de leur destinataire et peuvent etre
confidentielles. Si vous n'etes pas destinataire de ce message, vous etes
informes que vous l'avez recu par erreur et que toute utilisation en est
interdite. Dans ce cas, vous etes pries de le detruire et d'en informer la
Banque Europeenne d'Investissement.
The information in this message and/or attachments is intended solely for
the attention and use of the named addressee and may be confidential. If
you are not the intended recipient, you are hereby notified that you have
received this transmittal in error and that any use of it is prohibited. In
such a case please delete this message and kindly notify the European
Investment Bank accordingly.
------------------------------------------------------------ --------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
On Jun 9, 2010, at 11:59 AM, Darvin Denmian wrote:
> Hello !
>=20
> Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
Yes. http://dev.mysql.com/doc/refman/5.1/en/flush.html says:
"
By default, FLUSH statements are written to the binary log so that they =
will be replicated to replication slaves. Logging can be suppressed with =
the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL.
Note
FLUSH LOGS, FLUSH MASTER, FLUSH SLAVE, and FLUSH TABLES WITH READ LOCK =
are not written to the binary log in any case because they would cause =
problems if replicated to a slave.
"
--=20
Paul DuBois
Oracle Corporation / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
Thanks Paul
you opened my eyes !!!
On Wed, Jun 9, 2010 at 2:27 PM, Paul DuBois
>
> On Jun 9, 2010, at 11:59 AM, Darvin Denmian wrote:
>
>> Hello !
>>
>> Is there some diference between : FLUSH LOCAL LOGS and FLUSH LOGS ?
>
>
> Yes. http://dev.mysql.com/doc/refman/5.1/en/flush.html says:
>
> "
> By default, FLUSH statements are written to the binary log so that they will be replicated to replication slaves. Logging can be suppressed with the optional NO_WRITE_TO_BINLOG keyword or its alias LOCAL.
>
> Note
> FLUSH LOGS, FLUSH MASTER, FLUSH SLAVE, and FLUSH TABLES WITH READ LOCK are not written to the binary log in any case because they would cause problems if replicated to a slave.
> "
>
> --
> Paul DuBois
> Oracle Corporation / MySQL Documentation Team
> Madison, Wisconsin, USA
> www.mysql.com
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org