Currently Browsing: zabbix

History Tables – Housekeeper

First, I recommend to you read about the differences between the history and trends table. Each item on Zabbix can have your own housekeeper value. But this feature turns housekeeping process a performance killer, because delete_history() function executes a DELETE per item every turn. If you have 100k items, 100k DELETE queries will be executed. This can be a big problem using InnoDB engine on MySQL, because DELETE is extremelly slow on large tables and deleted rows doesn’t release space on disk. My proposed and tested solution is disable housekeeping and partitioning some tables. To know...
read more

Zabbix Git Repository

I usually explore the source code of Zabbix to understand some resources, then I’d like to do it using a browser, without need to download the tar.gz file, uncompress, use a tool like grep to find any content and finally open it with a editor like vim. Moreover, in recent years Git gained much popularity among coders against the SVN (Subversion). Gathered these needs, I created a read-only Git repository with a GitWeb interface: http://git.zabbixzone.com It is automatically updated every 4 hours from the official Zabbix SVN (svn://svn.zabbix.com) and is only recommended for research...
read more

New Colors on Frontend

I’ve to deal all day with many Zabbix environments and all are blue color, so there is not difficult to make a mistake. Only changing 3 files inside images directory, I created new six colors: cyan, golden, green, grey, red and violet. Installation Instructions (only for Zabbix 1.8.x) Download zabbix1.8-colors.zip (all colors included) and extract on your computer Upload the 3 image files from your favorite color to FTP on directory /images/gradients/ Reload the Page. Some browsers can need to force the refresh (CTRL+F5 or...
read more

Queue Explained

Queue’s page is one of essential indicators to measure the performance of Server/Proxy on collect data. But the numbers can be a little hard to understand. Let’s try make it easy: Imagine that the last check from an item occurred at 11:05:00. It’s configured to check each 3 minutes (180 seconds delay), then the next check should be made ​​at 11:08:00. Something happened (like Zabbix Proxy was down)  and this item was not checked at 11:08:00. If the clock is now 11:09:10, this item is delayed 70 seconds, then it would appear in the column “1 minute”. According to the...
read more

History and Trends

These two terms can cause some confusion, but their understanding is crucial for small and medium environments. History All collected data, doesn’t matter what type, will be stored on history tables. Trends Trends basically are the collected data (only numeric) consolidated by hour. Zabbix Server hourly takes all values from history tables and calculates minimum, average and maximum for one hour period. Note: string items, like character, log and text, doesn’t have trends Housekeeper Both data still remains on database until Housekeeper from Zabbix Server deletes it based on Keep history...
read more

Easy Update on Custom Scripts

Every time that you need to add or change an UserParameter on zabbix_agentd.conf you need to restart the agent. It’s easy if you have less than 10 servers, but could be a trouble if you have more than 30 servers. Automation Tools like CFEngine and Puppet do this work well done, but unfortunately they aren’t used in many companies. But it’s possible using a Dynamic UserParameter: 1) add two lines on zabbix_agentd.conf and restart the agent: UserParameter=custom.getvalue[*],/etc/zabbix/zabbix_agentd/custom_getvalue $1 $2 $3 $4...
read more

Making your Frontend Faster

A simple way to make your Zabbix Frontend faster is install a PHP cache on WebServer, and to do it I recommend eAccelerator: eAccelerator is a free open-source PHP accelerator & optimizer. It increases the performance of PHP scripts by caching them in their compiled state, so that the overhead of compiling is almost completely eliminated. It also optimizes scripts to speed up their execution. eAccelerator typically reduces server load and increases the speed of your PHP code by 1-10 times. For complete documentation and information, please visit http://eaccelerator.net/ Installation...
read more

Next Entries »