RESET MASTER
/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.