1、创建zabbix用户
# groupadd zabbix# useradd -g zabbix zabbix# usermod -s /sbin/nologin zabbix
2、在mysql中给zabbix授权，或者任意一个有查询权限的用户都行，这里用zabbix
mysql> grant all on zabbix.* to zabbix@'%' identified by '123456'; Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)退出
3、编译zabbix agent端
# tar zxvf zabbix-2.2.3.tar.gz# ./configure --enable-agent # make install注：未指定--prefix= 则默认目录在/usr/local/etc/下
4、修改agend端配置文件
# vim /usr/local/etc/zabbix_agentd.confLogFile=/var/log/zabbix_agentd.logServer=192.168.0.232ServerActive=192.168.0.232Hostname=Zabbix server注： LogFile agend日志文件位置 Server zabbix服务端地址 ServerActive zabbix服务端地址 Hostname zabbix服务器主机名由于修改了日志文件位置，手动创建文件，并赋予其权限# touch /var/log/zabbix_agentd.log# chmod 777 /var/log/zabbix_agentd.log
5、
# vim /etc/serviceszabbix_agent 10050/tcpzabbix_agent 10050/udp
6、复制启动脚本
# cp misc/init.d/tru64/zabbix_agentd /etc/init.d/zabbix_agentd# chmod +x /etc/init.d/zabbix_agentd确保以下几项的路径为zabbix_agentd的正确路径DAEMON=/usr/local/sbin/zabbix_agentd
7、启动agentd端
# /etc/init.d/zabbix_agentd start[root@node3 zabbix-2.2.3]# netstat -tunlp | grep 10050tcp 0 0 0.0.0.0:10050 0.0.0.0:* LISTEN 18705/zabbix_agentd
至此agentd端已经编译好了，并启动成功
8、配置监控mysql相关属性
# vim /usr/local/etc/zabbix_agentd.conf添加如下段UserParameter=mysql.Ping,mysqladmin -uzabbix -h192.168.0.233 -p123456 ping|grep alive|wc -lUserParameter=mysql.Threads,mysqladmin -uzabbix -h192.168.0.233 -p123456 status|cut -f3 -d":"|cut -f1 -d"Q"UserParameter=mysql.Questions,mysqladmin -uzabbix -h192.168.0.233 -p123456 status|cut -f4 -d":"|cut -f1 -d"S"UserParameter=mysql.Slowqueries,mysqladmin -uzabbix -h192.168.0.233 -h192.168.0.233 -p123456 status|cut -f5 -d":"|cut -f1 -d"O"UserParameter=mysql.Qps,mysqladmin -uzabbix -h192.168.0.233 -p123456 status|cut -f9 -d":"UserParameter=mysql.Slave_IO_State,if [ "$(mysql -uzabbix -h192.168.0.233 -p123456 -e "show slave status\G"| grep Slave_IO_Running|awk '{print $2}')" == "Yes" ];then echo 1; else echo 0;fiUserParameter=mysql.Slave_SQL_State,if [ "$(mysql -uzabbix -h192.168.0.233 -p123456 -e "show slave status\G"| grep Slave_SQL_Running|awk '{print $2}')" == "Yes" ];then echo 1; else echo 0;fiUserParameter=mysql.Key_buffer_size,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'key_buffer_size';"| grep -v Value |awk '{print $2/1024^2}'UserParameter=mysql.Key_reads,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'key_reads';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Key_read_requests,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'key_read_requests';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Key_cache_miss_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'key_reads';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'key_read_requests';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",$1/$2*100)}'UserParameter=mysql.Key_blocks_used,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'key_blocks_used';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Key_blocks_unused,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'key_blocks_unused';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Key_blocks_used_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'key_blocks_used';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'key_blocks_unused';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",$1/($1+$2)*100)}'UserParameter=mysql.Innodb_buffer_pool_size,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'innodb_buffer_pool_size';"| grep -v Value |awk '{print $2/1024^2}'UserParameter=mysql.Innodb_log_file_size,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'innodb_log_file_size';"| grep -v Value |awk '{print $2/1024^2}'UserParameter=mysql.Innodb_log_buffer_size,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'innodb_log_buffer_size';"| grep -v Value |awk '{print $2/1024^2}'UserParameter=mysql.Table_open_cache,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'table_open_cache';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Open_tables,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'open_tables';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Opened_tables,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'opened_tables';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Open_tables_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'open_tables';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'opened_tables';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",$1/($1+$2)*100)}'UserParameter=mysql.Table_open_cache_used_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'open_tables';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'table_open_cache';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",$1/($1+$2)*100)}'UserParameter=mysql.Thread_cache_size,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'thread_cache_size';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Threads_cached,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Threads_cached';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Threads_connected,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Threads_connected';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Threads_created,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Threads_created';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Threads_running,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Threads_running';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Qcache_free_blocks,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_free_blocks';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Qcache_free_memory,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_free_memory';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Qcache_hits,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_hits';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Qcache_inserts,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_inserts';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Qcache_lowmem_prunes,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_lowmem_prunes';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Qcache_not_cached,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_not_cached';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Qcache_queries_in_cache,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_queries_in_cache';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Qcache_total_blocks,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_total_blocks';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Qcache_fragment_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_free_blocks';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_total_blocks';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",$1/$2*100)}'UserParameter=mysql.Qcache_used_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'query_cache_size';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_free_memory';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",($1-$2)/$1*100)}'UserParameter=mysql.Qcache_hits_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_hits';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Qcache_inserts';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",($1-$2)/$1*100)}'UserParameter=mysql.Query_cache_limit,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'query_cache_limit';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Query_cache_min_res_unit,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'query_cache_min_res_unit';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Query_cache_size,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'query_cache_size';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Sort_merge_passes,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Sort_merge_passes';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Sort_range,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Sort_range';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Sort_rows,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Sort_rows';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Sort_scan,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Sort_scan';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Handler_read_first,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Handler_read_first';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Handler_read_key,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Handler_read_key';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Handler_read_next,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Handler_read_next';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Handler_read_prev,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Handler_read_prev';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Handler_read_rnd,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Handler_read_rnd';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Handler_read_rnd_next,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Handler_read_rnd_next';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Com_select,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'com_select';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Com_insert,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'com_insert';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Com_insert_select,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'com_insert_select';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Com_update,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'com_update';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Com_replace,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'com_replace';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Com_replace_select,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'com_replace_select';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Table_scan_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Handler_read_rnd_next';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'com_select';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",$1/$2*100)}'UserParameter=mysql.Open_files,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'open_files';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Open_files_limit,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'open_files_limit';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Open_files_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'open_files';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'open_files_limit';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",$1/$2*100)}'UserParameter=mysql.Created_tmp_disk_tables,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'created_tmp_disk_tables';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Created_tmp_tables,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'created_tmp_tables';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Created_tmp_disk_tables_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'created_tmp_disk_tables';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'created_tmp_tables';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",$1/$2*100)}'UserParameter=mysql.Max_connections,mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'max_connections';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Max_used_connections,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Max_used_connections';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Max_connections_used_rate,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Max_used_connections';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show variables like 'max_connections';"| grep -v Value |awk '{print $2}')| awk '{printf("%1.4f\n",$1/$2*100)}'UserParameter=mysql.Table_locks_immediate,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Table_locks_immediate';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Table_locks_waited,mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'table_locks_waited';"| grep -v Value |awk '{print $2}'UserParameter=mysql.Engine_select,echo $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'Table_locks_immediate';"| grep -v Value |awk '{print $2}') $(mysql -uzabbix -h192.168.0.233 -p123456 -e "show status like 'table_locks_waited';"| grep -v Value |awk '{print $2}')| awk '{printf("%5.4f\n",$1/$2)}' 重启agentd端
# /etc/init.d/zabbix_agentd restart
ok 到这里，服务器上相关的配置工作，已经完成了，下边去zabbix的web页面上，添加监控项
9、
(1)添加主机
组态-->主机-->创建主机
(2)、添加模板
重启agentd端，即可
过一会可以看出，漂亮的图片以及产生了