Documentation
Table of Contents
5 §¯§Ñ§Ý§Ñ§ê§ä§å§Ó§Ñ§ß§ß§ñ TimescaleDB
§°§Ô§Ý§ñ§Õ
Áú»¢¶Ä²© §á?§Õ§ä§â§Ú§Þ§å? TimescaleDB, §Ò§Ñ§Ù§å §Õ§Ñ§ß§Ú§ç §ß§Ñ §Ò§Ñ§Ù? PostgreSQL, §ñ§Ü§Ñ §Ñ§Ó§ä§à§Þ§Ñ§ä§Ú§é§ß§à §â§à§Ù§Ò§Ú§Ó§Ñ? §Õ§Ñ§ß? §ß§Ñ §æ§â§Ñ§Ô§Þ§Ö§ß§ä§Ú, §ë§à §Ò§Ñ§Ù§å§ð§ä§î§ã§ñ §ß§Ñ §é§Ñ§ã§à§Ó§à§Þ§å §Õ?§Ñ§á§Ñ§Ù§à§ß?, §Õ§Ý§ñ §á?§Õ§ä§â§Ú§Þ§Ü§Ú §Ò?§Ý§î§ê§à? §á§â§à§Õ§å§Ü§ä§Ú§Ó§ß§à§ã§ä? §Ó §Þ§Ñ§ã§ê§ä§Ñ§Ò?.
§¯§Ñ§â§Ñ§Ù? TimescaleDB §ß§Ö §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ §á§â§à§Ü§ã? Áú»¢¶Ä²©.
?§ß§ã§ä§â§å§Ü§è?? §ß§Ñ §è?§Û §ã§ä§à§â?§ß§è? §Þ§à§Ø§ß§Ñ §Ó§Ú§Ü§à§â§Ú§ã§ä§à§Ó§å§Ó§Ñ§ä§Ú §Õ§Ý§ñ §ã§ä§Ó§à§â§Ö§ß§ß§ñ §Ò§Ñ§Ù§Ú §Õ§Ñ§ß§Ú§ç TimescaleDB §Ñ§Ò§à §Þ?§Ô§â§Ñ§è?? §Ù ?§ã§ß§å§ð§é§Ú§ç §ä§Ñ§Ò§Ý§Ú§è§î PostgreSQL §Õ§à TimescaleDB.
Configuration
We assume that TimescaleDB extension has been already installed on the database server (see ).
TimescaleDB extension must also be enabled for the specific DB by executing:
Running this command requires database administrator privileges.
If you use a database schema other than 'public' you need to add a SCHEMA clause to the command above. E.g.:
echo "CREATE EXTENSION IF NOT EXISTS timescaledb SCHEMA yourschema CASCADE;" | sudo -u postgres psql zabbix
Then run the timescaledb.sql script located in database/postgresql. For new installations the script must be run after the regular PostgreSQL database has been created with initial schema/data (see database creation):
The migration of existing history and trend data may take a lot of time. Áú»¢¶Ä²© server and frontend must be down for the period of migration.
The timescaledb.sql script sets the following housekeeping parameters:
- Override item history period
- Override item trend period
In order to use partitioned housekeeping for history and trends, both these options must be on. It's possible to use TimescaleDB partitioning only for trends (by setting Override item trend period) or only for history (Override item history period).
For PostgreSQL version 10.2 or higher and TimescaleDB version 1.5 or higher, the timescaledb.sql script sets two additional parameters:
- Enable compression
- Compress records older than 7 days
All of these parameters can be changed in Administration ¡ú General ¡ú Housekeeping after the installation.
You may want to run the timescaledb-tune tool provided by TimescaleDB to optimize PostgreSQL configuration parameters in your postgresql.conf.
§³§ä§Ú§ã§ß§Ö§ß§ß§ñ §Þ§à§Ø§ß§Ñ §Ó§Ú§Ü§à§â§Ú§ã§ä§à§Ó§å§Ó§Ñ§ä§Ú, §Ý§Ú§ê§Ö §ñ§Ü§ë§à §Ó§Ó?§Þ§Ü§ß§Ö§ß§à §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ú §±§Ö§â§Ö§Ó§Ú§Ù§ß§Ñ§é§Ú§ä§Ú §á§Ö§â?§à§Õ ?§ã§ä§à§â?? §Ö§Ý§Ö§Þ§Ö§ß§ä?§Ó ? §±§Ö§â§Ö§Ó§Ú§Ù§ß§Ñ§é§Ú§ä§Ú §á§Ö§â?§à§Õ §ä§â§Ö§ß§Õ?§Ó §Ö§Ý§Ö§Þ§Ö§ß§ä?§Ó. §Á§Ü§ë§à §á§Ö§â§Ö§Ó§Ú§Ù§ß§Ñ§é§Ö§ß§ß§ñ §Ó§Ú§Þ§Ü§ß§Ö§ß§à, §Ñ §ä§Ñ§Ò§Ý§Ú§è? §Þ§Ñ§ð§ä§î §ã§ä§Ú§ã§Ý? §æ§â§Ñ§Ô§Þ§Ö§ß§ä§Ú, §Ö§Ü§à§ß§à§Þ §ß§Ö §Ó§Ú§Õ§Ñ§Ý§ñ§ä§Ú§Þ§Ö §Õ§Ñ§ß? §Ù §è§Ú§ç §ä§Ñ§Ò§Ý§Ú§è§î, §Ñ §ß§Ñ §Ö§Ü§â§Ñ§ß? §Ñ§Õ§Þ?§ß?§ã§ä§â§å§Ó§Ñ§ß§ß§ñ §Ó?§Õ§à§Ò§â§Ñ§Ø§Ñ§ä§Ú§Þ§å§ä§î§ã§ñ §á§à§á§Ö§â§Ö§Õ§Ø§Ö§ß§ß§ñ §á§â§à §ß§Ö§á§â§Ñ§Ó§Ú§Ý§î§ß§å §Ü§à§ß§æ?§Ô§å§â§Ñ§è?§ð §Õ§Ý§ñ [Housekeeping] /manual/web_interface/frontend_sections/administration/general#housekeeper) ? §â§à§Ù§Õ?§Ý System information.
§µ§ã? §è? §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ú §Þ§à§Ø§ß§Ñ §Ù§Þ?§ß§Ú§ä§Ú §Ó §¡§Õ§Þ?§ß?§ã§ä§â§å§Ó§Ñ§ß§ß§ñ ¡ú §©§Ñ§Ô§Ñ§Ý§î§ß? ¡ú §¥§à§Þ§Ñ§ê§ß? §à§Ò§ã§Ý§å§Ô§à§Ó§å§Ó§Ñ§ß§ß§ñ §á?§ã§Ý§ñ §Ó§ã§ä§Ñ§ß§à§Ó§Ý§Ö§ß§ß§ñ.
§£§Ú §Þ§à§Ø§Ö§ä§Ö §Ù§Ñ§á§å§ã§ä§Ú§ä§Ú ?§ß§ã§ä§â§å§Þ§Ö§ß§ä timescaledb-tune, §ß§Ñ§Õ§Ñ§ß§Ú§Û TimescaleDB, §ë§à§Ò §à§á§ä§Ú§Þ?§Ù§å§Ó§Ñ§ä§Ú §á§Ñ§â§Ñ§Þ§Ö§ä§â§Ú §Ü§à§ß§æ?§Ô§å§â§Ñ§è?? PostgreSQL §å §Ó§Ñ§ê§à§Þ§å postgresql.conf.
§³§ä§Ú§ã§ß§Ö§ß§ß§ñ TimescaleDB
§£§Ý§Ñ§ã§ß§Ö §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ TimescaleDB §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ, §á§à§é§Ú§ß§Ñ§ð§é§Ú §Ù Áú»¢¶Ä²© 5.0 §Õ§Ý§ñ PostgreSQL §Ó§Ö§â§ã?? 10.2 §Ñ§Ò§à §ß§à§Ó?§ê§à? §ä§Ñ TimescaleDB §Ó§Ö§â§ã?? 1.5 §Ñ§Ò§à §ß§à§Ó?§ê§à? §Õ§Ý§ñ §Ó§ã?§ç §ä§Ñ§Ò§Ý§Ú§è§î Áú»¢¶Ä²©, §ñ§Ü§Ú§Þ§Ú §Ü§Ö§â§å? TimescaleDB. §±?§Õ §é§Ñ§ã §à§ß§à§Ó§Ý§Ö§ß§ß§ñ §Ñ§Ò§à §Þ?§Ô§â§Ñ§è?? §Õ§à TimescaleDB §á§à§é§Ñ§ä§Ü§à§Ó§Ö §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ §Ó§Ö§Ý§Ú§Ü§Ú§ç §ä§Ñ§Ò§Ý§Ú§è§î §Þ§à§Ø§Ö §Ù§Ñ§Û§ß§ñ§ä§Ú §Ò§Ñ§Ô§Ñ§ä§à §é§Ñ§ã§å.
§©§Ñ§å§Ó§Ñ§Ø§ä§Ö, §ë§à §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ §Ù§Ô?§Õ§ß§à §Ù §Ý?§è§Ö§ß§Ù??§ð Timescale Community "timescale" ? §ß§Ö §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ §Ý?§è§Ö§ß§Ù??§ð "apache" Apache 2.0. §±§à§é§Ú§ß§Ñ§ð§é§Ú §Ù Áú»¢¶Ä²© 6.0.7, Áú»¢¶Ä²© §Ó§Ú§Ù§ß§Ñ§é§Ñ?, §é§Ú §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ. §Á§Ü§ë§à §Ó?§ß §ß§Ö §á?§Õ§ä§â§Ú§Þ§å?§ä§î§ã§ñ, §å §Ø§å§â§ß§Ñ§Ý? §ã§Ö§â§Ó§Ö§â§Ñ Áú»¢¶Ä²© §Ù§Ñ§á§Ú§ã§å?§ä§î§ã§ñ §á§à§á§Ö§â§Ö§Õ§Ø§å§Ó§Ñ§Ý§î§ß§Ö §á§à§Ó?§Õ§à§Þ§Ý§Ö§ß§ß§ñ, ? §Ü§à§â§Ú§ã§ä§å§Ó§Ñ§é? §ß§Ö §Þ§à§Ø§å§ä§î §å§Ó?§Þ§Ü§ß§å§ä§Ú §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ §å ?§ß§ä§Ö§â§æ§Ö§Û§ã?.
§±§Ö§â§Ö§Õ §Ó§Ú§Ü§à§â§Ú§ã§ä§Ñ§ß§ß§ñ§Þ §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ §Ü§à§â§Ú§ã§ä§å§Ó§Ñ§é§Ñ§Þ §â§Ö§Ü§à§Þ§Ö§ß§Õ§å?§ä§î§ã§ñ §à§Ù§ß§Ñ§Û§à§Þ§Ú§ä§Ú§ã§ñ §Ù §Õ§à§Ü§å§Þ§Ö§ß§ä§Ñ§è??§ð §ë§à§Õ§à §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ .
§©§Ñ§å§Ó§Ñ§Ø§ä§Ö, §ë§à §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ §ß§Ñ§Ü§Ý§Ñ§Õ§Ñ? §á§Ö§Ó§ß? §à§Ò§Þ§Ö§Ø§Ö§ß§ß§ñ, §Ñ §ã§Ñ§Þ§Ö:
- §®§à§Õ§Ú§æ?§Ü§Ñ§è?? §ã§ä§Ú§ã§ß§Ö§ß§à§Ô§à §Ò§Ý§à§Ü§å (§Ó§ã§ä§Ñ§Ó§Ü§Ú, §Ó§Ú§Õ§Ñ§Ý§Ö§ß§ß§ñ, §à§ß§à§Ó§Ý§Ö§ß§ß§ñ) §Ù§Ñ§Ò§à§â§à§ß§Ö§ß?
- §©§Þ?§ß§Ú §ã§ç§Ö§Þ§Ú §Õ§Ý§ñ §ã§ä§Ú§ã§ß§å§ä§Ú§ç §ä§Ñ§Ò§Ý§Ú§è§î §ß§Ö §Õ§à§á§å§ã§Ü§Ñ§ð§ä§î§ã§ñ.
§±§Ñ§â§Ñ§Þ§Ö§ä§â§Ú §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ §Þ§à§Ø§ß§Ñ §Ù§Þ?§ß§Ú§ä§Ú §Ó §Ò§Ý§à§è? §³§ä§Ú§ã§ß§Ö§ß§ß§ñ ?§ã§ä§à§â?? §ä§Ñ §ä§Ö§ß§Õ§Ö§ß§è?§Û §å §â§à§Ù§Õ?§Ý? §¡§Õ§Þ?§ß?§ã§ä§â§å§Ó§Ñ§ß§ß§ñ ¡ú §©§Ñ§Ô§Ñ§Ý§î§ß? ¡ú §¬§à§Þ§Þ§Ö§â§ä§Ú§é§ß?§ã§ä§î ?§ß§ä§Ö§â§æ§Ö§Û§ã§å Áú»¢¶Ä²©.
| §±§Ñ§â§Ñ§Þ§Ö§ä§â | §©§Ñ §å§Þ§à§Ó§é§Ñ§ß§ß§ñ§Þ | §¬§à§Þ§Ö§ß§ä§Ñ§â? |
|---|---|---|
| §µ§Ó?§Þ§Ü§ß§å§ä§Ú §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ | §µ§Ó?§Þ§Ü§ß§Ö§ß§à | §µ§ã§ä§Ñ§ß§à§Ó§Ü§Ñ §Ñ§Ò§à §Ù§ß§ñ§ä§ä§ñ §á§â§Ñ§á§à§â§è§ñ §ß§Ö §Ñ§Ü§ä§Ú§Ó§å?/§Õ§Ö§Ù§Ñ§Ü§ä§Ú§Ó§å? §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ §ß§Ö§Ô§Ñ§Û§ß§à. §°§ã§Ü?§Ý§î§Ü§Ú §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ §à§Ò§â§à§Ò§Ý§ñ?§ä§î§ã§ñ Housekeeper, §Ù§Þ?§ß§Ú §ß§Ñ§Ò§å§Õ§å§ä§î §é§Ú§ß§ß§à§ã§ä? §é§Ö§â§Ö§Ù 2 §Ô§à§Õ§Ú§ß§Ú HousekeepingFrequency (§Ó§ã§ä§Ñ§ß§à§Ó§Ý§Ö§ß§à §Ó zabbix_server.conf)§±?§ã§Ý§ñ §Ó§Ú§Þ§Ü§ß§å§Ó§ê§Ú §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ, §ß§à§Ó? §ê§Þ§Ñ§ä§Ü§Ú, §ñ§Ü? §á§à§ä§â§Ñ§á§Ý§ñ§ð§ä§î §å §á§Ö§â?§à§Õ §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ, §ß§Ö §Ò§å§Õ§å§ä§î §ã§ä§Ú§ã§ß§å§ä?. §°§Õ§ß§Ñ§Ü §å§ã? §á§à§á§Ö§â§Ö§Õ§ß§î§à §ã§ä§Ú§ã§ß§å§ä? §Õ§Ñ§ß? §Ù§Ñ§Ý§Ú§ê§Ñ§ä§î§ã§ñ §ã§ä§Ú§ã§ß§å§ä§Ú§Þ§Ú. §»§à§Ò §â§à§Ù§á§Ñ§Ü§å§Ó§Ñ§ä§Ú §á§à§á§Ö§â§Ö§Õ§ß§î§à §ã§ä§Ú§ã§ß§å§ä? §æ§â§Ñ§Ô§Þ§Ö§ß§ä§Ú, §Õ§à§ä§â§Ú§Þ§å§Û§ä§Ö§ã§î ?§ß§ã§ä§â§å§Ü§è?§Û §å §Õ§à§Ü§å§Þ§Ö§ß§ä§Ñ§è?? . §±?§Õ §é§Ñ§ã §à§ß§à§Ó§Ý§Ö§ß§ß§ñ §ã§ä§Ñ§â?§ê§Ú§ç §Ó§Ö§â§ã?§Û Áú»¢¶Ä²© ?§Ù §á?§Õ§ä§â§Ú§Þ§Ü§à§ð TimescaleDB, §ã§ä§Ú§ã§ß§Ö§ß§ß§ñ §ß§Ö §Ò§å§Õ§Ö §Ó§Ó?§Þ§Ü§ß§Ö§ß§à §Ù§Ñ §Ù§Ñ§Þ§à§Ó§é§å§Ó§Ñ§ß§ß§ñ§Þ. |
| §³§ä§Ú§ã§Ü§Ñ§ä§Ú §Ù§Ñ§á§Ú§ã§Ú, §ã§ä§Ñ§â§ê? §Ù§Ñ | 7d | §¸§Ö§Û §á§Ñ§â§Ñ§Þ§Ö§ä§â §ß§Ö §Þ§à§Ø§Ö §Ò§å§ä§Ú §Þ§Ö§ß§ê§Ú§Þ §Ù§Ñ 7 §Õ§ß?§Ó. §¹§Ö§â§Ö§Ù §ß§Ö§Ù§Þ?§ß§ß?§ã§ä§î §ã§ä§Ú§ã§ß§Ö§ß§Ú§ç §æ§â§Ñ§Ô§Þ§Ö§ß§ä?§Ó §å§ã? §Ù§Ñ§á?§Ù§ß?§Ý? §Õ§Ñ§ß? (§ß§Ñ§á§â§Ú§Ü§Ý§Ñ§Õ, §Õ§Ñ§ß?, §Ù§Ñ§ä§â§Ú§Þ§Ñ§ß? §á§â§à§Ü§ã?-§ã§Ö§â§Ó§Ö§â§à§Þ), §ã§ä§Ñ§â§ê? §Ù§Ñ §è§Ö §Ù§ß§Ñ§é§Ö§ß§ß§ñ, §Ò§å§Õ§å§ä§î §Ó§Ú§Ü§Ú§ß§å§ä§Ú§Û. |