zabbix table -- History and Trends
来源:互联网 发布:日语考试 知乎 编辑:程序博客网 时间:2024/06/06 00:45
These two terms can cause some confusion, but their understanding is crucial for small and medium environments.
History
All collected data, doesn’t matter what type, will be stored on history tables.
Trends
Trends basically are the collected data (only numeric) consolidated by hour. Zabbix Server hourly takes all values from history tables and calculates minimum, average and maximum for one hour period.
Note: string items, like character, log and text, doesn’t have trends
Housekeeper
Both data still remains on database until Housekeeper from Zabbix Server deletes it based on Keep historyand Keep trends configurations:
So if you have an item with 60 seconds Update interval and 7 days for Keep history it will generates (60*24*7) 10080 rows per-item on history table.
For trend table, with 730 days configuration, it will generates (730*24*7) 17520 rows per-item.
Database tables for history/trends and theirs item type:
- history – numeric (float)
- history_uint – numeric (unsigned integers)
- history_str – character (up to 255 bytes)
- history_log – log
- history_text – text
- trends – numeric (float)
- trends_uint – numeric (unsigned integers)
If you have a large environment, I recommend you to disable housekeeping, the explanation in this post.
Recommendations
- Consider not more than 7 days for history (3 days for medium environments)
- Avoid intervals less than 60 seconds
- Keep your eyes on disksize from history/trend tables
- zabbix table -- History and Trends
- Zabbix --- History 和 Trends
- Browser and its Emerging Trends
- Handbook of Database Security: Applications and Trends
- Machine learning: Trends,perspectives, and prospects读书笔记
- <<Machine learning: Trends, perspectives, and prospects>> 总结
- Find table of Invoice History
- html5 and history.js
- history and traditions
- Semantic Web Technologies : Trends and Research in Ontology-based Systems
- Current research issues and trends in non-English Web searching
- 15 hot programming trends -- and 15 going cold
- 15 hot programming trends -- and 15 going cold: infoword.com
- Active noise cancellation: Trends, concepts, and technical challenges
- SharePoint’s Popularity Trends & Popularity and Search Reports
- 【pySpark教程】Big Data, Hardware trends, and Spark(二)
- zabbix数据库items根据vlaue_type选择性存放history相关表
- Windows Products and Technologies History
- OC class self
- webStorm8使
- Secedit:命令行下操作组策略找工具
- 启用一个新的线程
- 码路指南:为何你成不了编程高手?
- zabbix table -- History and Trends
- java多线程-并发容器ConcurrentHashMap
- C macros __LINE__, __FILE__ and __func__
- opencv243学习之一 安装配置OpenCV2.4.3(VS2010+64位系统+Win7)
- GTK进阶学习:定时器
- 译文 日经春秋 20150127
- struts2开发环境搭建
- Hibernate 映射关系注解 属性详解
- 李嘉诚无锡演讲:骂到你成功