MySQL database cleanup MyISAMInnodb table

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 Innodb tables (MySQL 5.1.6 or later versions are supported) a large number of MyISAM log tables in the data center need to be cleaned regularly, which is set to every weekend, about 10 Gb, 5

MySQL database cleanup MyISAM Innodb table

[Date: 2012-02-25] Source: Linux community Author: ylqmf [Font:]

MySQL database cleanup MyISAM Innodb table (MySQL versions earlier than MySQL 5.1.6 are supported)

There are a large number of MyISAM log tables in the data center that need to be cleaned regularly. This is set to be done every weekend, about 10 Gb, 5-10 minutes.

The event will not be written here, And the stored procedure will be directly stored ....

0

Insert data cyclically in MySQL stored procedures

MySQL master-slave replication. When only one database is copied, the write operations performed on other databases cannot be copied.

,