![xshell 配色 xshell 配色](https://www.itbkz.com/wp-content/uploads/2019/10/552d0ac44e19bafe074970362a0c4b15.png)
Then, it is suggested to compress the dump file. As Zabbix history tables usually have lots of records in them, this is a suggested flag for Zabbix database backups. Mysqldump retrieve one row at a time, instead of buffering all of them, thus it speeds up backups of large tables.
![xshell 配色 xshell 配色](https://i1.kknews.cc/SIG=21l2l1b/ctp-vzntr/1534756159548p1q7n4n114.jpg)
The dropdown can't even show them all simultaneously - we can choose from nearly anything you could imagine while working with Zabbix frontend, starting with hosts and items, and ending with value maps and scripts.Įxercise: Find out at what time you added the Restart Apache action. We can see that the action list has actions both for logging in and out, as well as all possible element actions like adding or updating. How fine-grained are those action and resource filters? Expand each and examine the contents. While we can see all actions in a consecutive fashion, we can also filter for a specific user, action, or resource. In the output table we can see ourselves logging in and out, and adding and removing elements, and more.īut pay close attention to the filter. We are presented with a list of things we did. Navigate to Administration | Audit, set the filter field Actions since to be about week ago, and click Filter. During our configuration quest we have made quite a lot of changes - let's see what footprints we left. Just like most functionality, it is conveniently accessible from the web frontend. For Zabbix configuration changes, an internal audit log is available. Accountability and trace of actions help a lot to determine that the questioner was the one who made the change and then forgot about it. Weird configuration changes, unsolicited reboots. «Now who did that?» - a question occasionally heard in many places, IT workplaces included. This approach also works around MySQL internals and simply pushes temporary tables into RAM. In all cases, setting the temporary directory to a In the case of local storage, a faster disk like a flash-based one would be a better location. In the case of NFS storage, local disks would be a better location.
![xshell 配色 xshell 配色](https://exp-picture.cdn.bcebos.com/0cdb2f0e1799e92a8436f4f3e1fec314f0c5a021.jpg)
etc/my.cnf allows you to place temporary on-disk tables in arbitrary locations. In addition to MySQL parameters that allow tuning sizes when temporary tables are kept in memory or pushed to disk, there's also one more global parameter. For example, attempting to keep the database files on an NFS volume will pretty much kill the database. Slow temporary tables will slow down the whole database considerably, so this can be crucial configuration. These can be created in memory or on disk, and there are multiple configuration parameters depending on your MySQL version to control temporary table behavior, so consult the MySQL documentation for your version. A typical Zabbix database will require constant use of temporary tables, which are created and removed on the fly. With this item set up, let's switch those two hosts back on - go to Configuration | Hosts, mark checkboxes next to IPMI Host, and Another host, then choose Activate selected in the action dropdown and click Go. Trigger名称中可以使用宏:>10Īs it could also indicate valid large proper configuration additions, you probably don't want to set severity of such trigger very high. MariaDB > show tables //定义好items后,可以在mysql中查看表history MariaDB > select key_,type from items where key_ like 'system.cpu%' //可以获取关于cpu的item名称 tls-connect psk -tls-psk-identity "PSK ID Zabbix agentd" \ tls-key-file /home/zabbix/zabbix_get.key tls-cert-file /home/zabbix/zabbix_get.crt \ "CN=server1,OU=IT operations,O=Example Corp,DC=example,DC=com" \ "CN=Signing CA,OU=IT operations,O=Example Corp,DC=example,DC=com" \ tls-connect cert -tls-ca-file /home/zabbix/zabbix_ca_file \ tls-connect psk -tls-psk-identity PSK-identity tls-cert-file cert-file -tls-key-file key-file -k item-key Zabbix_get -s host-name-or-IP -k item-key