![]() ![]() MySQL: Created tmp tables on memory per second Number of internal on-disk temporary tables created by the server while executing statements. MySQL: Created tmp tables on disk per second How many temporary files mysqld has created. MySQL: Created tmp files on disk per second Ratio of used to total pages in the buffer pool. The item shows how effectively the buffer pool is serving reads. Number of threads which are not sleeping. The cache miss rate can be calculated as Threads_created/Connections. If Threads_created is big, you may want to increase the thread_cache_size value. ![]() Number of threads created to handle connections. The maximum number of connections that have been in use simultaneously since the server start. Number of connection attempts (successful or not) to the MySQL server. Number of connections the libwrap library has refused. MySQL: Connection errors tcpwrap per second The client would not necessarily have been rejected in these cases. Number of errors during calls to select() or poll() on the listening port. MySQL: Connection errors select per second Number of errors while searching for the connecting client IP address. MySQL: Connection errors peer address per second Number of refused connections due to the max_connections limit being reached. MySQL: Connection errors max connections per second Number of refused connections due to internal server errors, for example, out of memory errors, or failed thread starts. MySQL: Connection errors internal per second Number of errors that occurred during calls to accept() on the listening port. MySQL: Connection errors accept per second Number of failed attempts to connect to the MySQL server. Number of connections that were aborted because the client died without closing the connection properly. The amount of seconds that the server has been up. Regular expression: (Server version)\s+(.+) \2 The maximum number of created tmp tables in memory per second for trigger expressions. The minimum buffer pool utilization in percentage for trigger expression. The number of slow queries for trigger expression. The lag of slave from master for trigger expression. Hostname or IP of MySQL host or container. The number of failed attempts to connect to the MySQL server for trigger expression. # semodule_package -o zabbix_home.pp -m zabbix_home.mod # checkmodule -M -m -o zabbix_home.mod zabbix_home.te #= zabbix_agent_t =Īllow zabbix_agent_t zabbix_var_lib_t:file read Īllow zabbix_agent_t zabbix_var_lib_t:file open Īllow zabbix_agent_t mysqld_etc_t:file read Īllow zabbix_agent_t mysqld_port_t:tcp_socket name_connect Īllow zabbix_agent_t mysqld_var_run_t:sock_file write NOTE: Use systemd to start Zabbix agent on Linux OS.įor example, in Centos use "systemctl edit rvice" to set the required user to start the Zabbix agent.Īdd the rule to the SELinux policy (example for Centos): # cat zabbix_home.te my.cnf in the home directory of Zabbix agent for Linux ( /var/lib/zabbix by default ) or my.cnf in c:\ for Windows. GRANT REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON *.* TO more information, please see MySQL documentation Create a MySQL user for monitoring ( at your discretion):.Copy template_db_nf into the folder with Zabbix agent configuration ( /etc/zabbix/zabbix_agentd.d/ by default).If necessary, add the path to the mysql and mysqladmin utilities to the global environment variable PATH. Install Zabbix agent and MySQL client.Zabbix should be configured according to the instructions in the Templates out of the box section. This template is designed for the effortless deployment of MySQL monitoring by Zabbix via Zabbix agent and doesn't require any external scripts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |