Zabbix on Social Media

I always dreamed of seeing the Zabbix spreading in all social networks, because it’s fundamental for an Open Source project. Is very difficult bring some serious TI guys to this social world, but this tools can be very powerful when wisely used. Finally Zabbix annunciated in February’s Newsletter the Zabbix page on Facebook: https://www.facebook.com/zabbix Over 1100 people follow the Zabbix on Twitter: https://twitter.com/zabbix Linkedin also has an expressive Zabbix Group with 643 members:...
read more

MySQL performance tips for Zabbix

Most of these tips is useful for many application, but I’ll keep focus on Zabbix. Use a Dedicated Server Database is the main bottleneck from Zabbix. Try to use a Dedicated Server for MySQL and make sure that server has great resources (CPU, memory and fast disks). This is the specs for an environment with 3000 values per second: Dell PowerEdge R610 CPU: Intel Xeon L5520 2.27GHz (16 cores) Memory: 24GB RAM Disks: 6x SAS 10k with RAID10 by hardware Create one file per...
read more

Backuping only the Zabbix Configuration

This script is a simple way to backup all configuration tables (eg. templates, hostgroups, hosts, triggers…) without the history data. If you need do a full backup (history included) I recommend you this post: http://zabbixzone.com/zabbix/backuping-full-database/ As the result is very small (around 30 MB), is possible run this backup many times per day. https://github.com/xsbr/zabbixzone/blob/master/zabbix-mysql-backupconf.sh #!/bin/bash # # zabbix-mysql-backupconf.sh # v0.2 - 20111105 # # Configuration Backup for Zabbix 1.8 w/MySQL # # Author: Ricardo Santos...
read more

Partitioning Tables on Zabbix 1.8

Many performance problems on Zabbix are related to the database and it became visible only when we have thousands of items. On another side, we have to handle enormous tables and it makes impossible operational routines like housekeeping and backup. Use all information and scripts at your own risk. Make backups! My suggestion is disable housekeeping and to partition some tables based on clock, an unix timestamp field. If you wanna know more about partitioning access the MySQL Reference Manual – Partitioning Overview.   The Concept An easy way to handle partitioning is splitting the tables...
read more

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 more...
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

« Previous Entries Next Entries »