ohmer1 / zabbix Goto Github PK

FILES:
======

1.- zabbix18-json-register-host.pl: Simple perl script to access the JSON API Zabbix
1.8.x releases, it use the methods of access and register, designed to deploy via
puppet and register each server without monkey assistence ;D, the requirements are
perl-JSON-XS on Fedora/RHEL5+ or install via CPAN: cpan JSON::XS.

2.- zabbix20-json-register-host.pl: Simple perl script to access the JSON API Zabbix
2.0 releases, please check k0k#1 for more information.

3.- db-mysqlstat.pl - (Alpha): Simple perl script designed to work with Zabbix
to keep monitored MySQL databases some features monitored are: connection pool,
threads, locks, and other powerfull status information. This script must be 
used with zbx_Template_App_MySQL.xml file and was tested with RHEL6 + MySQL
Enterprise Edition.

4.- db-pgstat.pl - Simple perl script designed to work with Zabbix to keep monitored 
PostgreSQL databases some features monitored are: connection pool, buffers, locks,
checkpoints, must be used with zbx_Template_App_PostgreSQL.xml file and was tested
with RHEL4 + PostgreSQL EnterpriseDB.

5.- zbx_Template_App_PostgreSQL.xml: XML template to keep monitored PostgreSQL
Enterprise Databases, must be used with db-pgstat.pl perl script. 

6.- zbx_Template_App_MySQL.xml - (Alpha): XML template to keep monitored MySQL
Enterprise Databases, must be used with db-mysqlstat.pl perl script, created
by SmartMarmot Tech. for mysqlbix and adapted for db-mysqlstat.pl script.

INSTRUCTIONS PostgreSQL:
========================

You just need to put the script: 'db-pgstat.pl' on the databases servers in a executable
search path and add user paramenters in zabbix_agentd.conf:

UserParameter=postgres.size,db-pgstat.pl --user postgres --database DATABASE --size
UserParameter=postgres.threads,db-pgstat.pl --user postgres --database DATABASE --threads
UserParameter=postgres.activeconn,db-pgstat.pl --user postgres --database DATABASE --activeconn 
UserParameter=postgres.tupreturned,db-pgstat.pl --user postgres --database DATABASE --tupreturned
UserParameter=postgres.tupfetched,db-pgstat.pl --user postgres --database DATABASE --tupfetched
UserParameter=postgres.tupinserted,db-pgstat.pl --user postgres --database DATABASE --tupinserted
UserParameter=postgres.tupupdated,db-pgstat.pl --user postgres --database DATABASE --tupupdated
UserParameter=postgres.tupdeleted,db-pgstat.pl --user postgres --database DATABASE --tupdeleted
UserParameter=postgres.xactcommit,db-pgstat.pl --user postgres --database DATABASE --xactcommit
UserParameter=postgres.xactrollback,db-pgstat.pl --user postgres --database DATABASE --xactrollback
UserParameter=postgres.exclusivelock,db-pgstat.pl --user postgres --database DATABASE --exclusivelock
UserParameter=postgres.accessexclusivelock,db-pgstat.pl --user postgres --database DATABASE --accessexclusivelock
UserParameter=postgres.accesssharelockery,db-pgstat.pl --user postgres --database DATABASE --accesssharelockery
UserParameter=postgres.rowsharelock,db-pgstat.pl --user postgres --database DATABASE --rowsharelock
UserParameter=postgres.rowexclusivelock,db-pgstat.pl --user postgres --database DATABASE --rowexclusivelock
UserParameter=postgres.shareupdateexclusivelock,db-pgstat.pl --user postgres --database DATABASE --shareupdateexclusivelock
UserParameter=postgres.sharerowexclusivelock,db-pgstat.pl --user postgres --database DATABASE --sharerowexclusivelock
UserParameter=postgres.checkpoints_timed,db-pgstat.pl --user postgres --database DATABASE --checkpoints_timed
UserParameter=postgres.checkpoints_req,db-pgstat.pl --user postgres --database DATABASE --checkpoints_req
UserParameter=postgres.buffers_checkpoint,db-pgstat.pl --user postgres --database DATABASE --buffers_checkpoint
UserParameter=postgres.buffers_clean,db-pgstat.pl --user postgres --database DATABASE --buffers_clean
UserParameter=postgres.maxwritten_clean,db-pgstat.pl --user postgres --database DATABASE --maxwritten_clean
UserParameter=postgres.buffers_backend,db-pgstat.pl --user postgres --database DATABASE --buffers_backend
UserParameter=postgres.buffers_alloc,db-pgstat.pl --user postgres --database DATABASE  --buffers_alloc

You can use --pass option for password database support (not recommend).
Zabbix discussions: http://www.zabbix.com/forum/showthread.php?p=99640#post99640

Template and perl file was tested for Zabbix 1.8.10, postgreSQL 8.4+ and RHEL 5.5


INSTRUCTIONS MySQL:
========================
You just need to put the script: 'db-mysqlstat.pl' on the databases servers in a executable
search path, create a database user with low privileges and add a total of 226 user 
paramenters in zabbix_agentd.conf:

UserParameter=Aborted_clients,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Aborted_clients
UserParameter=Aborted_connects,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Aborted_connects
UserParameter=Binlog_cache_disk_use,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Binlog_cache_disk_use
UserParameter=Binlog_cache_use,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Binlog_cache_use
UserParameter=Bytes_received,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Bytes_received
UserParameter=Bytes_sent,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Bytes_sent
UserParameter=Com_admin_commands,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_admin_commands
UserParameter=Com_alter_db,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_alter_db
UserParameter=Com_alter_table,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_alter_table
UserParameter=Com_analyze,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_analyze
UserParameter=Com_backup_table,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_backup_table
UserParameter=Com_begin,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_begin
UserParameter=Com_change_db,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_change_db
UserParameter=Com_change_master,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_change_master
UserParameter=Com_check,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_check
UserParameter=Com_checksum,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_checksum
UserParameter=Com_commit,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_commit
UserParameter=Com_create_db,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_create_db
UserParameter=Com_create_function,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_create_function
UserParameter=Com_create_index,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_create_index
UserParameter=Com_create_table,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_create_table
UserParameter=Com_create_user,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_create_user
UserParameter=Com_dealloc_sql,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_dealloc_sql
UserParameter=Com_delete,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_delete
UserParameter=Com_delete_multi,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_delete_multi
UserParameter=Com_do,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_do
UserParameter=Com_drop_db,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_drop_db
UserParameter=Com_drop_function,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_drop_function
UserParameter=Com_drop_index,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_drop_index
UserParameter=Com_drop_table,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_drop_table
UserParameter=Com_drop_user,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_drop_user
UserParameter=Com_execute_sql,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_execute_sql
UserParameter=Com_flush,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_flush
UserParameter=Com_grant,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_grant
UserParameter=Com_ha_close,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_ha_close
UserParameter=Com_ha_open,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_ha_open
UserParameter=Com_help,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_help
UserParameter=Com_insert,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_insert
UserParameter=Com_insert_select,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_insert_select
UserParameter=Com_kill,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_kill
UserParameter=Com_load,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_load
UserParameter=Com_load_master_data,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_load_master_data
UserParameter=Com_load_master_table,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_load_master_table
UserParameter=Com_lock_tables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_lock_tables
UserParameter=Com_optimize,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_optimize
UserParameter=Com_preload_keys,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_preload_keys
UserParameter=Com_prepare_sql,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_prepare_sql
UserParameter=Com_purge,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_purge
UserParameter=Com_purge_before_date,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_purge_before_date
UserParameter=Com_rename_table,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_rename_table
UserParameter=Com_repair,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_repair
UserParameter=Com_replace,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_replace
UserParameter=Com_replace_select,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_replace_select
UserParameter=Com_reset,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_reset
UserParameter=Com_restore_table,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_restore_table
UserParameter=Com_revoke,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_revoke
UserParameter=Com_revoke_all,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_revoke_all
UserParameter=Com_rollback,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_rollback
UserParameter=Com_savepoint,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_savepoint
UserParameter=Com_select,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_select
UserParameter=Com_set_option,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_set_option
UserParameter=Com_show_binlog_events,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_binlog_events
UserParameter=Com_show_binlogs,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_binlogs
UserParameter=Com_show_charsets,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_charsets
UserParameter=Com_show_collations,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_collations
UserParameter=Com_show_column_types,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_column_types
UserParameter=Com_show_create_db,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_create_db
UserParameter=Com_show_create_table,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_create_table
UserParameter=Com_show_databases,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_databases
UserParameter=Com_show_errors,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_errors
UserParameter=Com_show_fields,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_fields
UserParameter=Com_show_grants,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_grants
UserParameter=Com_show_innodb_status,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_innodb_status
UserParameter=Com_show_keys,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_keys
UserParameter=Com_show_logs,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_logs
UserParameter=Com_show_master_status,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_master_status
UserParameter=Com_show_ndb_status,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_ndb_status
UserParameter=Com_show_new_master,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_new_master
UserParameter=Com_show_open_tables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_open_tables
UserParameter=Com_show_privileges,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_privileges
UserParameter=Com_show_processlist,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_processlist
UserParameter=Com_show_slave_hosts,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_slave_hosts
UserParameter=Com_show_slave_status,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_slave_status
UserParameter=Com_show_status,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_status
UserParameter=Com_show_storage_engines,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_storage_engines
UserParameter=Com_show_tables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_tables
UserParameter=Com_show_triggers,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_triggers
UserParameter=Com_show_variables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_variables
UserParameter=Com_show_warnings,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_show_warnings
UserParameter=Com_slave_start,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_slave_start
UserParameter=Com_slave_stop,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_slave_stop
UserParameter=Com_stmt_close,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_stmt_close
UserParameter=Com_stmt_execute,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_stmt_execute
UserParameter=Com_stmt_fetch,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_stmt_fetch
UserParameter=Com_stmt_prepare,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_stmt_prepare
UserParameter=Com_stmt_reset,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_stmt_reset
UserParameter=Com_stmt_send_long_data,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_stmt_send_long_data
UserParameter=Com_truncate,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_truncate
UserParameter=Com_unlock_tables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_unlock_tables
UserParameter=Com_update,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_update
UserParameter=Com_update_multi,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_update_multi
UserParameter=Com_xa_commit,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_xa_commit
UserParameter=Com_xa_end,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_xa_end
UserParameter=Com_xa_prepare,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_xa_prepare
UserParameter=Com_xa_recover,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_xa_recover
UserParameter=Com_xa_rollback,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_xa_rollback
UserParameter=Com_xa_start,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Com_xa_start
UserParameter=Compression,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Compression
UserParameter=Connections,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Connections
UserParameter=Created_tmp_disk_tables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Created_tmp_disk_tables
UserParameter=Created_tmp_files,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Created_tmp_files
UserParameter=Created_tmp_tables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Created_tmp_tables
UserParameter=Delayed_errors,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Delayed_errors
UserParameter=Delayed_insert_threads,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Delayed_insert_threads
UserParameter=Delayed_writes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Delayed_writes
UserParameter=Flush_commands,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Flush_commands
UserParameter=Handler_commit,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_commit
UserParameter=Handler_delete,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_delete
UserParameter=Handler_discover,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_discover
UserParameter=Handler_prepare,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_prepare
UserParameter=Handler_read_first,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_read_first
UserParameter=Handler_read_key,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_read_key
UserParameter=Handler_read_next,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_read_next
UserParameter=Handler_read_prev,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_read_prev
UserParameter=Handler_read_rnd,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_read_rnd
UserParameter=Handler_read_rnd_next,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_read_rnd_next
UserParameter=Handler_rollback,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_rollback
UserParameter=Handler_savepoint,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_savepoint
UserParameter=Handler_savepoint_rollback,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_savepoint_rollback
UserParameter=Handler_update,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_update
UserParameter=Handler_write,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Handler_write
UserParameter=Innodb_buffer_pool_pages_data,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_pages_data
UserParameter=Innodb_buffer_pool_pages_dirty,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_pages_dirty
UserParameter=Innodb_buffer_pool_pages_flushed,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_pages_flushed
UserParameter=Innodb_buffer_pool_pages_free,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_pages_free
UserParameter=Innodb_buffer_pool_pages_misc,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_pages_misc
UserParameter=Innodb_buffer_pool_pages_total,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_pages_total
UserParameter=Innodb_buffer_pool_read_ahead_rnd,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_read_ahead_rnd
UserParameter=Innodb_buffer_pool_read_ahead_seq,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_read_ahead_seq
UserParameter=Innodb_buffer_pool_read_requests,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_read_requests
UserParameter=Innodb_buffer_pool_reads,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_reads
UserParameter=Innodb_buffer_pool_wait_free,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_wait_free
UserParameter=Innodb_buffer_pool_write_requests,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_buffer_pool_write_requests
UserParameter=Innodb_data_fsyncs,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_data_fsyncs
UserParameter=Innodb_data_pending_fsyncs,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_data_pending_fsyncs
UserParameter=Innodb_data_pending_reads,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_data_pending_reads
UserParameter=Innodb_data_pending_writes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_data_pending_writes
UserParameter=Innodb_data_read,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_data_read
UserParameter=Innodb_data_reads,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_data_reads
UserParameter=Innodb_data_writes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_data_writes
UserParameter=Innodb_data_written,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_data_written
UserParameter=Innodb_dblwr_pages_written,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_dblwr_pages_written
UserParameter=Innodb_dblwr_writes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_dblwr_writes
UserParameter=Innodb_log_waits,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_log_waits
UserParameter=Innodb_log_write_requests,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_log_write_requests
UserParameter=Innodb_log_writes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_log_writes
UserParameter=Innodb_os_log_fsyncs,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_os_log_fsyncs
UserParameter=Innodb_os_log_pending_fsyncs,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_os_log_pending_fsyncs
UserParameter=Innodb_os_log_pending_writes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_os_log_pending_writes
UserParameter=Innodb_os_log_written,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_os_log_written
UserParameter=Innodb_page_size,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_page_size
UserParameter=Innodb_pages_created,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_pages_created
UserParameter=Innodb_pages_read,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_pages_read
UserParameter=Innodb_pages_written,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_pages_written
UserParameter=Innodb_row_lock_current_waits,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_row_lock_current_waits
UserParameter=Innodb_row_lock_time,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_row_lock_time
UserParameter=Innodb_row_lock_time_avg,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_row_lock_time_avg
UserParameter=Innodb_row_lock_time_max,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_row_lock_time_max
UserParameter=Innodb_row_lock_waits,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_row_lock_waits
UserParameter=Innodb_rows_deleted,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_rows_deleted
UserParameter=Innodb_rows_inserted,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_rows_inserted
UserParameter=Innodb_rows_read,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_rows_read
UserParameter=Innodb_rows_updated,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Innodb_rows_updated
UserParameter=Key_blocks_not_flushed,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Key_blocks_not_flushed
UserParameter=Key_blocks_unused,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Key_blocks_unused
UserParameter=Key_blocks_used,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Key_blocks_used
UserParameter=Key_read_requests,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Key_read_requests
UserParameter=Key_reads,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Key_reads
UserParameter=Key_write_requests,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Key_write_requests
UserParameter=Key_writes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Key_writes
UserParameter=Last_query_cost,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Last_query_cost
UserParameter=Max_used_connections,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Max_used_connections
UserParameter=Ndb_cluster_node_id,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Ndb_cluster_node_id
UserParameter=Ndb_config_from_host,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Ndb_config_from_host
UserParameter=Ndb_config_from_port,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Ndb_config_from_port
UserParameter=Ndb_number_of_data_nodes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Ndb_number_of_data_nodes
UserParameter=Not_flushed_delayed_rows,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Not_flushed_delayed_rows
UserParameter=Open_files,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Open_files
UserParameter=Open_streams,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Open_streams
UserParameter=Open_tables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Open_tables
UserParameter=Opened_tables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Opened_tables
UserParameter=Prepared_stmt_count,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Prepared_stmt_count
UserParameter=Qcache_free_blocks,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Qcache_free_blocks
UserParameter=Qcache_free_memory,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Qcache_free_memory
UserParameter=Qcache_hits,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Qcache_hits
UserParameter=Qcache_inserts,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Qcache_inserts
UserParameter=Qcache_lowmem_prunes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Qcache_lowmem_prunes
UserParameter=Qcache_not_cached,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Qcache_not_cached
UserParameter=Qcache_queries_in_cache,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Qcache_queries_in_cache
UserParameter=Qcache_total_blocks,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Qcache_total_blocks
UserParameter=Questions,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Questions
UserParameter=Rpl_status,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Rpl_status
UserParameter=Select_full_join,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Select_full_join
UserParameter=Select_full_range_join,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Select_full_range_join
UserParameter=Select_range,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Select_range
UserParameter=Select_range_check,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Select_range_check
UserParameter=Select_scan,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Select_scan
UserParameter=Slave_open_temp_tables,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Slave_open_temp_tables
UserParameter=Slave_retried_transactions,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Slave_retried_transactions
UserParameter=Slave_running,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Slave_running
UserParameter=Slow_launch_threads,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Slow_launch_threads
UserParameter=Slow_queries,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Slow_queries
UserParameter=Sort_merge_passes,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Sort_merge_passes
UserParameter=Sort_range,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Sort_range
UserParameter=Sort_rows,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Sort_rows
UserParameter=Sort_scan,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Sort_scan
UserParameter=Table_locks_immediate,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Table_locks_immediate
UserParameter=Table_locks_waited,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Table_locks_waited
UserParameter=Tc_log_max_pages_used,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Tc_log_max_pages_used
UserParameter=Tc_log_page_size,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Tc_log_page_size
UserParameter=Tc_log_page_waits,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Tc_log_page_waits
UserParameter=Threads_cached,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Threads_cached
UserParameter=Threads_connected,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Threads_connected
UserParameter=Threads_created,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Threads_created
UserParameter=Threads_running,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Threads_running
UserParameter=Uptime,db-mysqlstat.pl --user USERNAME --pass PASSWORD --Uptime

Template and perl file was tested for Zabbix 1.8.15, MySQL Enterprise Edition 5.5.27 and RHEL6.3