zabbix_zabbix监控mysql_zabbix二次开发(2)

PARTITION p201107 VALUES LESS THAN (UNIX_TIMESTAMP('2011-08-0100:00:00')),

PARTITION p201108 VALUES LESS THAN (UNIX_TIMESTAMP('2011-09-0100:00:00')),

PARTITION p201109 VALUES LESS THAN (UNIX_TIMESTAMP('2011-10-0100:00:00')),

PARTITION p201110 VALUES LESS THAN (UNIX_TIMESTAMP('2011-11-0100:00:00')),

PARTITION p201111 VALUES LESS THAN (UNIX_TIMESTAMP('2011-12-0100:00:00')),

PARTITION p201112 VALUES LESS THAN (UNIX_TIMESTAMP('2012-01-0100:00:00'))

);

step3.设置每日的分区

以下步骤请在第一步的所有表中重复，下例是为history_uint表创建5.15到5.22之间的每日分区。zabbix

ALTER TABLE `history_uint` PARTITION BY RANGE( clock ) (

PARTITION p20110515 VALUES LESS THAN (UNIX_TIMESTAMP('2011-05-1600:00:00')),

PARTITION p20110516 VALUES LESS THAN (UNIX_TIMESTAMP('2011-05-1700:00:00')),

PARTITION p20110517 VALUES LESS THAN (UNIX_TIMESTAMP('2011-05-1800:00:00')),

PARTITION p20110518 VALUES LESS THAN (UNIX_TIMESTAMP('2011-05-1900:00:00')),

PARTITION p20110519 VALUES LESS THAN (UNIX_TIMESTAMP('2011-05-2000:00:00')),

PARTITION p20110520 VALUES LESS THAN (UNIX_TIMESTAMP('2011-05-2100:00:00')),

PARTITION p20110521 VALUES LESS THAN (UNIX_TIMESTAMP('2011-05-2200:00:00')),

PARTITION p20110522 VALUES LESS THAN (UNIX_TIMESTAMP('2011-05-2300:00:00'))

);

手动维护分区：

增加新分区

ALTER TABLE `history_uint` ADD PARTITION (

PARTITION p20110523 VALUES LESS THAN (UNIX_TIMESTAMP('2011-05-2400:00:00'))

);

删除分区(使用Housekeepeing)

ALTER TABLE `history_uint` DROP PARTITION p20110515;

step4.自动每日分区

确认已经在step3的时候为history表正确创建了分区。

以下脚本自动drop和创建每日分区,默认只保留最近3天,如果你需要更多天的，请修改

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/ruanjian/article-37966-2.html