MySQL - logging all orders
Since I managed to fix it I dohledovací Zabbix system, I got to the question of how to get it just the data and draw maps. In my case it is a company that has over 300 branches and each the same infrastructure (approx. 10 dohledovaných items) always by the same name and IP conventions. Because I need the script that creates a map for each subsidiary, need to find out what Zabbix writes to the database when you add each item / map.
I chose this option:
- Stop Zabbix
- turn on full logging MySQL
- insert the item and maps
- analyze SQL queries
- to create a PHP script that populates the database according to my values
- run Zabbix and surveillance: D
First Stop Zabbix
/etc/init.d/zabbix-server stop Second turn on full logging MySQL
just vyeditovat / etc / mysql / my.cnf and set the following lines
.. general_log_file = /var/log/mysql/mysql.log general_log = 1 .. Third insert the item and maps
Zabbix web interface to add items
4th 5th 6th in the following chapters: D
