mlxahcf 发表于 2011-12-31 15:20

zabbix如何监控mysql

最近在弄zabbix,想用zabbix监控mysql,在网上找了一些方法,模板也导入了,可是绘制图的什么时候,什么也没出来。
以下为运行php /etc/zabbix/mysql.php daily root ****   的输出:
PHP Notice:Undefined variable: bit64 in /etc/zabbix/mysql.php on line 270
PHP Notice:Undefined variable: table_cache in /etc/zabbix/mysql.php on line 274
PHP Notice:Undefined variable: table_cache in /etc/zabbix/mysql.php on line 275
PHP Notice:Undefined variable: Is_root_remote_login_enabled in /etc/zabbix/mysql.php on line 342
PHP Notice:Undefined variable: Is_root_without_password in /etc/zabbix/mysql.php on line 343
PHP Warning:Division by zero in /etc/zabbix/mysql.php on line 470
PHP Warning:Division by zero in /etc/zabbix/mysql.php on line 471
PHP Warning:Division by zero in /etc/zabbix/mysql.php on line 472


查看zabbix_mysql.log,提示如下:
Sending failed. Use option -vv for more detailed output.
Sending failed. Use option -vv for more detailed output.
Sending failed. Use option -vv for more detailed output.
Sending failed. Use option -vv for more detailed output.


php /etc/zabbix/mysql.php-vv
PHP Notice:Undefined offset: 2 in /etc/zabbix/mysql.php on line 29
PHP Notice:Undefined offset: 3 in /etc/zabbix/mysql.php on line 30
PHP Warning:Division by zero in /etc/zabbix/mysql.php on line 470
PHP Warning:Division by zero in /etc/zabbix/mysql.php on line 471
PHP Warning:Division by zero in /etc/zabbix/mysql.php on line 472


希望有高手能够帮忙

mengchang_cu 发表于 2012-02-29 15:37

我也遇到了同样的问题,解决了告诉我下,学习下

mengchang_cu 发表于 2012-03-01 15:30

换个别的吧操作简单,功能还全
mysql_performance_monitor-0.7.2.tar.gz用这个包做操作简单功能还全,还有相关的文档,交流qq:1091262364

mlxahcf 发表于 2012-03-02 17:09

已经解决了。谢谢大家啊

viato 发表于 2012-03-15 21:24

本帖最后由 viato 于 2012-03-15 21:25 编辑

兄弟是怎么解决的? 介绍一下,不会是PHP降级吧?

appop 发表于 2012-04-08 17:38

回复 4# mlxahcf


    是怎么解决的啊?

mlxahcf 发表于 2012-04-13 09:34

加我QQ;1596586548

mcsafe 发表于 2013-07-24 16:37

楼主真是极品!

zhwhao 发表于 2013-12-19 17:18

是那php文件的问题,在php里面输出下$server 和$host就看到了
页: [1]
查看完整版本: zabbix如何监控mysql