Thanks Paul

you opened my eyes !!!

On Wed, Jun 9, 2010 at 2:27 PM, Paul DuBois <paul.dub...@oracle.com> wrote:
>
> 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=arch...@jab.org

Reply via email to