willsion / appaloosa-zabbix-templates Goto Github PK

Im running Ubuntu 12.04 and BIND9 (9.8.1.dfsg.P1-4ubuntu0.7)

Im getting this error, when running bind9_stats.pl, using any arguments

Argument "Incoming" isn't numeric in int at /etc/zabbix/plugins/bind9_stats.pl 
line 80.


My stat fil is looking like this:

+++ Statistics Dump +++ (1389351020)
++ Incoming Requests ++
              221190 QUERY
++ Incoming Queries ++
               82258 A
               17422 PTR
                  34 MX
              121476 AAAA
++ Outgoing Queries ++
[View: default]
                 605 A
                  15 NS
                 136 PTR
                   5 MX
                 885 AAAA
                 118 DS
                  14 DNSKEY
[View: _bind]
++ Name Server Statistics ++
              221189 IPv4 requests received
                   1 IPv6 requests received
                   1 requests with EDNS(0) received
              220889 responses sent
                   1 responses with EDNS(0) sent
               89687 queries resulted in successful answer
                 257 queries resulted in authoritative answer
              220632 queries resulted in non authoritative answer
               58965 queries resulted in nxrrset
               72237 queries resulted in NXDOMAIN
                1398 queries caused recursion
                 301 duplicate queries received
++ Zone Maintenance Statistics ++
                   1 IPv4 notifies sent
++ Resolver Statistics ++
[Common]
[View: default]
                1442 IPv4 queries sent
                 336 IPv6 queries sent
                1433 IPv4 responses received
                 335 IPv6 responses received
                 263 NXDOMAIN received
                  20 other errors received
                  56 query retries
                  11 query timeouts
                  85 IPv4 NS address fetches
                  86 IPv6 NS address fetches
                  49 IPv6 NS address fetch failed
                1277 DNSSEC validation attempted
                 653 DNSSEC validation succeeded
                 624 DNSSEC NX validation succeeded
                1095 queries with RTT < 10ms
                 564 queries with RTT 10-100ms
                 106 queries with RTT 100-500ms
                   1 queries with RTT 500-800ms
[View: _bind]
++ Cache DB RRsets ++
[View: default]
                 420 A
                 158 NS
                  56 CNAME
                  24 PTR
                 145 AAAA
                  29 DS
                 105 RRSIG
                  10 NSEC
                  14 DNSKEY
                   2 !A
                   1 !MX
                 119 !AAAA
                  80 !DS
                  98 NXDOMAIN
[View: _bind (Cache: _bind)]
++ Socket I/O Statistics ++
                1445 UDP/IPv4 sockets opened
                 337 UDP/IPv6 sockets opened
                   3 TCP/IPv4 sockets opened
                   1 TCP/IPv6 sockets opened
                1443 UDP/IPv4 sockets closed
                 336 UDP/IPv6 sockets closed
                  70 TCP/IPv4 sockets closed
                1442 UDP/IPv4 connections established
                 336 UDP/IPv6 connections established
                  71 TCP/IPv4 connections accepted
                   2 UDP/IPv4 recv errors
++ Per Zone Query Statistics ++
--- Statistics Dump --- (1389351020)

The keys a0..fm do not work anymore. The old version of the "better cacti 
templates" 
(http://mysql-cacti-templates.googlecode.com/files/better-cacti-templates-1.1.8.
tar.gz) still contains the keys, which are also assumed by the Zabbix 
UserParameters.

The version of the templates offered at Percona 
(http://www.percona.com/software/percona-monitoring-plugins/) has keys g0..lm

At least for me it wasn't clear that I must use the version from the 
mysql-cacti-templates page (http://code.google.com/p/mysql-cacti-templates/) 
instead of follow the link to the new project home.

After looking through the code a bit, I think it might make sense to port and 
maintain a fork of the Cacti PHP script.  This way things won't break when that 
changes, and also we can remove the name:value syntax and just make it print 
out the value, so there is no need for the awk command.

Alternatively, we can add a command-line option to the script in the Cacti 
project, and this project can call the script with that option so it only 
prints the value instead of name:value.

What steps will reproduce the problem?
1. I run this line
hg clone https://appaloosa-zabbix-templates.googlecode.com/hg/ 
appaloosa-zabbix-templates
2. Generate the MySQL template
3. Import the template on Zabbix Server 1.8.2

What is the expected output? What do you see instead?
It should import the template without problems. But zabbix report an error 
importing/parsing.
This problem is because there are missing () at this line on mysql.pl

Wrong line:
expression  => 
'{Template_MySQL:mysql.slave_running.last(0)}=-1|{Template_MySQL:mysql.slave_sto
pped.last(0)}=-1',

Correct line:
expression  => 
'{Template_MySQL:mysql.slave_running.last(0)}=(-1)|{Template_MySQL:mysql.slave_s
topped.last(0)}=(-1)',     

   >> It's problem only happen using mercurial

What version of the product are you using? On what operating system?
I'm using mercurial to clone your project and ubuntu 9.04.

Please provide any additional information below.
You should change this line in your project.

What steps will reproduce the problem?
1. Generate the mysql.xml with the appaloosa plugin : perl 
tools/gen_template.pl defs/mysql.pl mysql.xml
2. Import the mysql.xml into the new Zabbix 2

What is the expected output? What do you see instead?

Many errors occurs :

Created: Application "MySQL" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf cell count" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Unflushed log" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State end" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Threads connected" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com update multi" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read next" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache queries in cache" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Spin waits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Relay log space" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB locked tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read first" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Innodb row lock time" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Lock system memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pool size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Page hash memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Open files limit" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf merges" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State sending data" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending log flushes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Opened tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache not cached" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Total mem alloc" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State locked" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key read requests" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Open tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Sort range" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler delete" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Threads created" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Rows read" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Read views" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read key" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Sort rows" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Bytes sent" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending buf pool flushes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB lock wait secs" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave lag" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State init" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Log bytes written" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Questions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler rollback" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State updating" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Thread hash memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com replace select" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave retried transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache total blocks" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Created tmp files" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read rnd" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key reads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com replace" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache free blocks" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select range check" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slow launch threads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key buf bytes unflushed" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select full range join" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Current transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Active transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending AIO sync ios" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Threads cached" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read rnd next" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB lock structs" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State reading from net" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State freeing items" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Binlog cache size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select range" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State sorting result" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Hash index cells used" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State none" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Open files" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pages read" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Log bytes flushed" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com insert" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com delete" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending normal AIO writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Free pages" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Additional pool alloc" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Created tmp disk tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave running" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State statistics" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Database pages" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Uncheckpointed bytes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select full join" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending chkp writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Rows updated" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Max connections" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Aborted clients" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Sort scan" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key write requests" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Rows inserted" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Connections" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State preparing" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com select" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "OS waits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Recovery system memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Table cache" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Binlog cache use" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB sem wait time ms" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com update" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache free memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Spin rounds" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler savepoint" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com delete multi" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pages created" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache lowmem prunes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Bytes received" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler read prev" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Hash index cells total" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache inserts" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com load" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State login" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "History list" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MySQL Processes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Qcache hits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Binlog cache disk use" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler commit" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State other" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave open temp tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending ibuf AIO reads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Adaptive hash memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler prepare" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf inserts" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Rows deleted" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Table locks immediate" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Modified pages" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Table locks waited" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB tables in use" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB sem waits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Created tmp tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Aborted connects" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "File fsyncs" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM key buffer size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Query cache size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Innodb row lock waits" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "File system memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Binary log space" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slave stopped" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler discover" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending normal AIO reads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State copying to tmp table" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf merged" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Slow queries" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State closing tables" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Thread cache size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pages written" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "File reads" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf used cells" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Com insert select" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Locked transactions" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending AIO log ios" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Pending log writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB log buffer size" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Ibuf free cells" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "File writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Max used connections" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler write" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler savepoint rollback" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Threads running" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "MyISAM Key buf bytes used" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Dictionary cache memory" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Handler update" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "InnoDB open files" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Log writes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Sort merge passes" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "Select scan" on "Template_MySQL".
Undefined index: delay_flex [api/classes/CItemGeneral.php:275]
Created: Item "State writing to net" on "Template_MySQL".
Created: Trigger "Process mysqld not running on {HOSTNAME}" on "Template_MySQL".
Created: Trigger "Slave lag more than 10m over 10m on {HOSTNAME}" on 
"Template_MySQL".
Created: Trigger "Slave lag more than 5m over 10m on {HOSTNAME}" on 
"Template_MySQL".
Created: Trigger "Slave is stopped on {HOSTNAME}" on "Template_MySQL".
Created: Trigger "More than 500 threads on {HOSTNAME}" on "Template_MySQL".
Created: Trigger "Server {HOSTNAME} is waiting on table locks" on 
"Template_MySQL".
Created: Trigger "InnoDB lock structures more than 30 in 5m on {HOSTNAME}" on 
"Template_MySQL".
Created: Trigger "InnoDB uncheckpointed bytes in the last 10m > 25MB on 
{HOSTNAME}" on "Template_MySQL".
Created: Trigger "Thread in state Copying_to_tmp_table for more than 6min on 
{HOSTNAME}" on "Template_MySQL".
Updated: Trigger "Slave lag more than 10m over 10m on {HOSTNAME}" on 
"Template_MySQL".
Error in query [INSERT INTO trigger_depends 
(triggerid_down,triggerid_up,triggerdepid) VALUES ('13536','1',40)] [Cannot add 
or update a child row: a foreign key constraint fails 
(`zabbix`.`trigger_depends`, CONSTRAINT `c_trigger_depends_2` FOREIGN KEY 
(`triggerid_up`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE)]
SQL statement execution has failed "INSERT INTO trigger_depends 
(triggerid_down,triggerid_up,triggerdepid) VALUES ('13536','1',40)".

What version of the product are you using? On what operating system?

Zabbix 2.0.0
appaloosa-zabbix-templates 0.0.1
better-cacti-templates 1.1.8
MySQL 5.5.24
PHP 5.3.3-7+squeeze9
Debian squeeze

I've written a simple shell script and Perl wrapper for Cacti's PHP script, 
because IMHO Zabbix trapper is better solution here. I need to run the PHP 
script only once instead of 165 times like for Zabbix agent.

Please note that I run my script via Cron 2 times in 1 minute (hint: `sleep 
30`). For debugging/verbose mode you can set DEBUG=1. I also renamed Cacti's 
ss_get_mysql_stats.php file to mysql-stats.php.

I like your Zabbix template and I'm happy with it, so I would like to share my 
files with another users. I hope they will be useful.

What steps will reproduce the problem?

1. Try to connect to a non-existent host using the zbx_memcached.pl script.  
This does have a timeout at what looks to be 75 seconds.

1. Alternatively, connect to a real host that has an artificially slow response 
time to the "stats" command so that perl is waiting for the read() rather than 
connect().  This appears to not have a timeout at all.

What is the expected output? What do you see instead?

  I would expect both versions of the tests above to timeout in no more than a couple of seconds by default.

What version of the product are you using?

  The zbx_memcached.pl script doesn't seem to have a version number within it.  It came with version 0.0.1 of the templates.

More info:

  IO::Socket::INET accepts a timeout parameter but it seems to only honour it on connects and not on reads.  There are some solutions to timeouts below.

  http://www.perlmonks.org/?node_id=732970
  http://www.webmasterworld.com/forum13/3140.htm

Normally you would expect memcached to handle all of these functions in 
milliseconds but I have been seeing an error where occasionally memcached 
wouldn't ever respond to a request and the zbx_memcached.pl script would sit 
there forever waiting for the read().
I don't know the cause of or the solution to the underlying memcached problem 
yet but the stacking up of the zbx_memcached.pl script ended up bringing the 
load average of the box up enough to affect the site.

The scale says "X MB" when it should say something like "X MB/s"

I can tell that the value isn't in seconds on my installation because I'm 
seeing 90MB in the Memcached Network Traffic graph and 750KBps in the Network 
Utilization graph on the same host.  This ratio seems to be about the same as 
the 120 second polling time so the value of the scale is probably "X MB per 2 
minutes".

Changing this to "X MB/s" would probably be the most useful change.