Skip navigation links
/ / Up / Table of Contents

User Comments

Posted by Daevid Vincent on December 23 2009 8:48pm[Delete] [Edit]

Just a word of caution, if you're using replication, then DO NOT use the "RESET MASTER" to consolidate your mysql-bin.00000X files.

This page fails to be explicit about mentioning what this page does, nor is there even a link to this critical information:
http://dev.mysql.com/doc/refman/5.0/en/reset-master.html

The correct command is "PURGE BINARY LOGS"
http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html

Posted by Derek Downey on September 4 2011 3:07am[Delete] [Edit]

It may be obvious, but RESET commands are not written to the Binary Log.

This is particularly pertinent to RESET QUERY CACHE command.

Top / / / Up / Table of Contents