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