mysql cleanup

One, MySQL full-scale backup and incremental backup1, the full amount of backup command: /application/mysql/bin/mysqldump-uroot-p123456--lock-all-tables-a-b-f--master-data=2--single-transaction-- Events|gzip

1. What are the MySQL log files on the master server?View by command:Show binary logs;650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/85/45/wKioL1ee4Bqi9Zz0AAAwuxXkZk0315.png-wh_500x0-wm_3 -wmp_4-s_6781112.png "title=" 1.png "alt="

1: Binary logThe binary log records all DDL(data definition Language) statements and DML(Data Manipulation language) statements, but does not record statements that include data queries. Statements are saved as "events," which describe the process

background cleanup work : Dirty page Brush disc, Undo Recycle 1.Page Cleaner thread: Refresh Dirty page 2,purge thread: Empty the Undo page, clean the "deleted" page First, Innodb_page_cleanersPage cleaner The number of threads that the

MySQL database cleanup MyISAMInnodb tables (MySQL 5.1.6 or later versions are supported) a large number of MyISAMlog tables in the data center need to be cleaned regularly, which is set to every weekend, about 10 Gb, 5 MySQL database cleanup MyISAM

DescriptionWhen you turn on MySQL database master and slave, there will be a lot of files such as mysql-bin.00000* log, which will consume your hard disk space.mysql-bin.000001mysql-bin.000002mysql-bin.000003mysql-bin.000004mysql-bin.000005...There

Description:when you turn on MySQL database master and slave, there will be a lot of files such as mysql-bin.00000* log, which will consume your hard disk space. mysql-bin.000001mysql-bin.000002mysql-bin.000003mysql-bin.000004mysql-bin.000005...

MySQL Bin-log effect 1. Data recovery: If your database is out of order and you have a previous backup, you can look at the log file to find out which command caused your database to go wrong and try to recover the loss. 2. Synchronize data between

DescriptionWhen you turn on MySQL database master and slave, there will be a lot of files such as mysql-bin.00000* log, which will consume your hard disk space.mysql-bin.000001mysql-bin.000002mysql-bin.000003mysql-bin.000004mysql-bin.000005...There

(1) Setting the Relay Log Purge method (on each slave node): mysql-e ' Set global relay_log_purge=0 'Attention:MHA in the process of switching, from the library during the recovery process depends on the relay log information, so here to relay log