MySQL/MariaDB monitor using Zabbix

3,040 total views, 6 views today

3,040 total views, 6 views today If you are using Zabbix centralized monitoring server and want to monitor your all host MySQL then you should follow below steps. This is really an easy job. First of all, go to your Zabbix configuration folder, that is /etc/zabbix. create a file in this directory named “.my.cnf” (without the colon)…

Delete OLD data from Zabbix database

7,613 total views, 9 views today

7,613 total views, 9 views today If you are using Zabbix for a long time, then you might notice that the database size of Zabbix is increasing every day. Then you should delete the old data from the database. login to the MySQL. Select your database (Which is used for zabbix) Run below commands (Please change the interval day…

Adding new Linux host in zabbix server

1,149 total views, 2 views today

1,149 total views, 2 views today Assume that you have 2 Linux servers, one is having zabbix-server (192.168.0.1) and another is having zabbix-agent (192.168.0.2). In agent server Zabbix Agent is required to install on all remote systems needs to monitor through Zabbix server. The Zabbix Agent collects resource utilization and applications data on the client system and…

Notice “A non well formed numeric value encountered” in Zabbix dashboard with PHP 7.1

899 total views, no views today

899 total views, no views today If you installed Zabbix server with PHP 7.0 or upper version, then you will face this issue after login to the Zabbix dashboard. For this issue, just open include/func.inc.php with your preferred editor and change some entry. After change it will look like below. function str2mem($val) { $val = trim($val);…

Zabbix installation on Ubuntu 16.04 LTS

476 total views, no views today

476 total views, no views today Here is the complete guide of how to install Zabbix centralized monitoring Server in Ubuntu 16.04. I will install this with MySQL 5.7 and PHP 7.1. I Hope you would like this. Run the following commands for update all the repository and upgrade the installed package: Repository update: # apt…