msgbartop
A chronological documentation test project, nothing serious, really!
msgbarbottom

01 Feb 2007 RESET MASTER

Posted by

/var/lib/mysql har blitt over 1,5GB stor så jeg Googlet litt for å finne ut hva som kunne gjøre dette og det viser seg at mysql logger all aktivitet. RESET MASTER sletter logger osv og etter å ha kjørt kommandoen så var /var/lib/mysql bare 222MB.

You can delete all binary log files with the RESET MASTER statement, or a subset of them with PURGE MASTER LOGS.

RESET reset_option [, reset_option] ...

The RESET statement is used to clear the state of various server operations. You must have the RELOAD privilege to execute RESET.

RESET acts as a stronger version of the FLUSH statement.

reset_option can be any of the following:

MASTER
Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file. (Known as FLUSH MASTER in versions of MySQL before 3.23.26.

Source: http://dev.mysql.com/doc/refman/5.0/en/reset.html

Tags: , ,

Comments are closed.