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