Methods for processing Zabbix history database two------------using Zabbix table partitioning

http://john88wang.blog.51cto.com/2165294/1770582

In the previous procedure, you can process historical data by creating a new table and then importing data from one months to a new table, and finally deleting the old table.

However, this is a very time-consuming approach, at least for a few hours, and you do not have to stop Zabbix server to prevent new data writes. This approach is undesirable for applications that need to be constantly monitored throughout the day.

This article is from the Linux SA John blog, so be sure to keep this source http://john88wang.blog.51cto.com/2165294/1771557

Methods for processing Zabbix history database two------------using Zabbix table partitioning