2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
→Maintenance: Added Remove Old Binary Logs
m (→Export / Backup: Added export as CSV) |
m (→Maintenance: Added Remove Old Binary Logs) |
||
| Line 310: | Line 310: | ||
<source lang="mysql"> | <source lang="mysql"> | ||
OPTIMIZE TABLE SystemEvents; | OPTIMIZE TABLE SystemEvents; | ||
</source> | |||
=== Remove Old Binary Logs === | |||
Make sure that any Slave's are up to date before deleting old binary logs | |||
<source lang="mysql"> | |||
SHOW MASTER STATUS\g # Get current logfile name | |||
PURGE MASTER LOGS TO 'mysql-bin.012344'; # Removes all logs up to the one specified | |||
</source> | </source> | ||