mszpatusko / zabbix Goto Github PK
View Code? Open in Web Editor NEWThis project forked from k0k/zabbix
Useful files and scripts used with Zabbix monitoring system
This project forked from k0k/zabbix
Useful files and scripts used with Zabbix monitoring system
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.