Zabbix

mysql -u root -p

mysql> CREATE DATABASE zabbixdb character set utf8 collate utf8_bin;
mysql> CREATE USER 'zabbix'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON zabbix.* TO 'zabbix'@'localhost' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

cd /usr/share/doc/zabbix-server-mysql
zcat create.sql.gz | mysql -u zabbix -p zabbixdb
cd /var/lib/mysql
ls
rm -r *
mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
systemctl start mysqld
systemctl start mysql.service
systemctl start mariadb
mysql
timestamp:::   using configuration file: /etc/zabbix/zabbix_server.conf
timestamp:::   current database version (mandatory/optional): 03050162/03050162
timestamp:::   required mandatory version: 03050162
timestamp:::   __mem_malloc: skipped 1 asked 512 skip_min 400 skip_max 400
timestamp:::   [file:dbconfig.c,line:94] zbx_mem_realloc(): out of memory (requested 512 bytes)
timestamp:::   [file:dbconfig.c,line:94] zbx_mem_realloc(): please increase CacheSize configuration parameter

CacheSize — Size of configuration cache, in bytes. Shared memory size for storing host, item and trigger data.

HistoryCacheSize — Size of history cache, in bytes. Shared memory size for storing history data.

HistoryIndexCacheSize — Size of history index cache, in bytes. Shared memory size for indexing history data stored in history cache. The index cache size needs roughly 100 bytes to cache one item.

TrendCacheSize — Size of trend cache, in bytes. Shared memory size for storing trends data.

ValueCacheSize — Size of history value cache, in bytes. Shared memory size for caching item history data requests. Setting to 0 disables value cache (not recommended). When value cache runs out of the shared memory a warning message is written to the server log every 5 minutes.

CacheSize=2048M
HistoryCacheSize=1024M
TrendCacheSize=256M
HistoryIndexCacheSize=1024M
ValueCacheSize=512M

StartPollers=80;
StartPollersUnreachable=40
pinggger = 600

Napsat komentář

Vaše emailová adresa nebude zveřejněna. Vyžadované informace jsou označeny *