J’ai trouv\u00e9 sur le net un template avec des scripts pour le monitoring de mysql dans Zabbix.<\/p>\n
Voici donc traduction de l’article. Vous trouverez les scripts en bas de page.<\/p>\n
Sur le serveur, importez le fichier mysql.xml dans les templates.<\/p>\n
Sur le client, assurez-vous que php5 est install\u00e9 et que le plugin php-mysql \u00e9galement, ainsi que php-cli.<\/p>\n
Je consid\u00e8re que l’agent a \u00e9t\u00e9 compil\u00e9 depuis les sources et que le fichier de configuration est dans \/usr\/local\/etc comme c’est le cas chez moi.<\/p>\n
Cr\u00e9ez un r\u00e9pertoire \/usr\/local\/share\/zabbix\/plugins<\/p>\n
Copiez dedans le fichier ss_get_mysql_stats.php<\/p>\n
Copiez le fichier zabbixmysql.conf dans \/usr\/local\/etc\/<\/p>\n
Editez le fichier \/usr\/local\/etc\/zabbis_agentd.conf, et ajoutez y<\/p>\n
Include=\/usr\/local\/etc\/zabbixmysql.conf<\/pre>\nConnectez-vous \u00e0 mysql. Cr\u00e9ez un utilisateur de base de donn\u00e9e (par exemple zabbix) et accordez-lui les droits comme indiqu\u00e9:<\/p>\n
\"GRANT PROCESS ON *.* TO 'zabbix'@'localhost' identified BY 'some_password';<\/pre>\nEditez le \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php et modifier les param\u00e8tres d’authenfication dans la base de donn\u00e9es:<\/p>\n
$mysql_user = 'zabbix';\r\n$mysql_pass = 'some_password';<\/pre>\nRed\u00e9marrez l’agent.<\/p>\n
Pour testez, vous pouvez ex\u00e9cuter par exemple une commande comme:<\/p>\n
Sur le client:<\/p>\n
zabbix_agentd -t mysql.Sort_scan<\/pre>\nSur le serveur:<\/p>\n
zabbix_get -s agentip -k mysql.Sort_scan<\/pre>\nFichiers:<\/p>\n
# Copyright 2010 (c) Brian Smith <brian@palominodb.com> and PalominoDB.\r\n# Feedback and improvements are welcome.\r\n#\r\n# THIS PROGRAM IS PROVIDED \"AS IS\" AND WITHOUT ANY EXPRESS OR IMPLIED\r\n# WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF\r\n# MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.\r\n#\r\n# This program is free software; you can redistribute it and\/or modify it under\r\n# the terms of the GNU General Public License as published by the Free Software\r\n# Foundation, version 2.\r\n#\r\n# You should have received a copy of the GNU General Public License along with\r\n# this program; if not, write to the Free Software Foundation, Inc., 59 Temple\r\n# Place, Suite 330, Boston, MA 02111-1307 USA.\r\nUserParameter=mysql.Key_read_requests,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g0 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Key_reads,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g1 | awk -F: '{ prin\tt $2 }'\r\nUserParameter=mysql.Key_write_requests,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g2 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Key_writes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g3 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.history_list,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g4 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.innodb_transactions,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g5 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.read_views,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g6 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.current_transactions,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g7 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.locked_transactions,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g8 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.active_transactions,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items g9 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.setting.pool_size,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ga | awk -F: '{ print $2 }'\r\nUserParameter=mysql.free_pages,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gb | awk -F: '{ print $2 }'\r\nUserParameter=mysql.database_pages,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gc | awk -F: '{ print $2 }'\r\nUserParameter=mysql.modified_pages,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gd | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pages_read,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ge | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pages_created,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gf | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pages_written,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gg | awk -F: '{ print $2 }'\r\nUserParameter=mysql.file_fsyncs,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gh | awk -F: '{ print $2 }'\r\nUserParameter=mysql.file_reads,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gi | awk -F: '{ print $2 }'\r\nUserParameter=mysql.file_writes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gj | awk -F: '{ print $2 }'\r\nUserParameter=mysql.log_writes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gk | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pending_aio_log_ios,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gl | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pending_aio_sync_ios,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gm | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pending_buf_pool_flushes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gn | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pending_chkp_writes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items go | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pending_ibuf_aio_reads,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gp | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pending_log_flushes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gq | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pending_log_writes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gr | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pending_normal_aio_reads,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gs | awk -F: '{ print $2 }'\r\nUserParameter=mysql.pending_normal_aio_writes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gt | awk -F: '{ print $2 }'\r\nUserParameter=mysql.ibuf_inserts,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gu | awk -F: '{ print $2 }'\r\nUserParameter=mysql.ibuf_merged,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gv | awk -F: '{ print $2 }'\r\nUserParameter=mysql.ibuf_merges,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gw | awk -F: '{ print $2 }'\r\nUserParameter=mysql.spin_waits,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gx | awk -F: '{ print $2 }'\r\nUserParameter=mysql.spin_rounds,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gy | awk -F: '{ print $2 }'\r\nUserParameter=mysql.os_waits,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items gz | awk -F: '{ print $2 }'\r\nUserParameter=mysql.rows_inserted,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h0 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.rows_updated,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h1 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.rows_deleted,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h2 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.rows_read,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h3 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Table_locks_waited,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h4 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Table_locks_immediate,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h5 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Slow_queries,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h6 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Open_files,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h7 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Open_tables,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h8 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Opened_tables,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items h9 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.innodb_open_files,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ha | awk -F: '{ print $2 }'\r\nUserParameter=mysql.setting.open_files_limit,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hb | awk -F: '{ print $2 }'\r\nUserParameter=mysql.setting.table_cache,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hc | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Aborted_clients,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hd | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Aborted_connects,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items he | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Max_used_connections,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hf | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Slow_launch_threads,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hg | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Threads_cached,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hh | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Threads_connected,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hi | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Threads_created,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hj | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Threads_running,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hk | awk -F: '{ print $2 }'\r\nUserParameter=mysql.setting.max_connections,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hl | awk -F: '{ print $2 }'\r\nUserParameter=mysql.setting.thread_cache_size,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hm | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Connections,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hn | awk -F: '{ print $2 }'\r\nUserParameter=mysql.slave_running,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ho | awk -F: '{ print $2 }'\r\nUserParameter=mysql.slave_stopped,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hp | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Slave_retried_transactions,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hq | awk -F: '{ print $2 }'\r\nUserParameter=mysql.slave_lag,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hr | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Slave_open_temp_tables,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hs | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Qcache_free_blocks,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ht | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Qcache_free_memory,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hu | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Qcache_hits,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hv | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Qcache_inserts,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hw | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Qcache_lowmem_prunes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hx | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Qcache_not_cached,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hy | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Qcache_queries_in_cache,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items hz | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Qcache_total_blocks,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i0 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.setting.query_cache_size,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i1 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Questions,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i2 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_update,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i3 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_insert,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i4 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_select,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i5 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_delete,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i6 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_replace,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i7 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_load,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i8 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_update_multi,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items i9 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_insert_select,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ia | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_delete_multi,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ib | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Com_replace_select,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ic | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Select_full_join,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items id | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Select_full_range_join,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ie | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Select_range,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items if | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Select_range_check,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ig | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Select_scan,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ih | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Sort_merge_passes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ii | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Sort_range,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ij | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Sort_rows,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ik | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Sort_scan,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items il | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Created_tmp_tables,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items im | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Created_tmp_disk_tables,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items in | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Created_tmp_files,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items io | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Bytes_sent,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ip | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Bytes_received,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items iq | awk -F: '{ print $2 }'\r\nUserParameter=mysql.innodb_log_buffer_size,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ir | awk -F: '{ print $2 }'\r\nUserParameter=mysql.unflushed_log,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items is | awk -F: '{ print $2 }'\r\nUserParameter=mysql.log_bytes_flushed,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items it | awk -F: '{ print $2 }'\r\nUserParameter=mysql.log_bytes_written,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items iu | awk -F: '{ print $2 }'\r\nUserParameter=mysql.relay_log_space,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items iv | awk -F: '{ print $2 }'\r\nUserParameter=mysql.setting.binlog_cache_size,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items iw | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Binlog_cache_disk_use,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ix | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Binlog_cache_use,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items iy | awk -F: '{ print $2 }'\r\nUserParameter=mysql.binary_log_space,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items iz | awk -F: '{ print $2 }'\r\nUserParameter=mysql.innodb_locked_tables,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j0 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.innodb_lock_structs,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j1 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_closing_tables,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j2 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_copying_to_tmp_table,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j3 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_end,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j4 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_freeing_items,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j5 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_init,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j6 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_locked,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j7 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_login,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j8 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_preparing,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items j9 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_reading_from_net,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ja | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_sending_data,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jb | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_sorting_result,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jc | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_statistics,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jd | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_updating,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items je | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_writing_to_net,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jf | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_none,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jg | awk -F: '{ print $2 }'\r\nUserParameter=mysql.State_other,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jh | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_commit,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ji | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_delete,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jj | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_discover,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jk | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_prepare,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jl | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_read_first,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jm | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_read_key,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jn | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_read_next,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jo | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_read_prev,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jp | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_read_rnd,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jq | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_read_rnd_next,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jr | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_rollback,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items js | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_savepoint,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jt | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_savepoint_rollback,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ju | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_update,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jv | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Handler_write,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jw | awk -F: '{ print $2 }'\r\nUserParameter=mysql.innodb_tables_in_use,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jx | awk -F: '{ print $2 }'\r\nUserParameter=mysql.innodb_lock_wait_secs,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jy | awk -F: '{ print $2 }'\r\nUserParameter=mysql.hash_index_cells_total,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items jz | awk -F: '{ print $2 }'\r\nUserParameter=mysql.hash_index_cells_used,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k0 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.total_mem_alloc,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k1 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.additional_pool_alloc,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k2 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.uncheckpointed_bytes,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k3 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.ibuf_used_cells,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k4 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.ibuf_free_cells,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k5 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.ibuf_cell_count,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k6 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.adaptive_hash_memory,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k7 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.page_hash_memory,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k8 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.dictionary_cache_memory,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items k9 | awk -F: '{ print $2 }'\r\nUserParameter=mysql.file_system_memory,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ka | awk -F: '{ print $2 }'\r\nUserParameter=mysql.lock_system_memory,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items kb | awk -F: '{ print $2 }'\r\nUserParameter=mysql.recovery_system_memory,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items kc | awk -F: '{ print $2 }'\r\nUserParameter=mysql.thread_hash_memory,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items kd | awk -F: '{ print $2 }'\r\nUserParameter=mysql.innodb_sem_waits,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ke | awk -F: '{ print $2 }'\r\nUserParameter=mysql.innodb_sem_wait_time_ms,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items kf | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Key_buf_bytes_unflushed,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items kg | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Key_buf_bytes_used,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items kh | awk -F: '{ print $2 }'\r\nUserParameter=mysql.setting.key_buffer_size,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items ki | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Innodb_row_lock_time,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items kj | awk -F: '{ print $2 }'\r\nUserParameter=mysql.Innodb_row_lock_waits,\/usr\/bin\/php \/usr\/local\/share\/zabbix\/plugins\/ss_get_mysql_stats.php --host localhost --items kk | awk -F: '{ print $2 }'<\/pre>\n<?php # ============================================================================ # This program is part of Percona Monitoring Plugins # License: GPL License (see COPYING) # Copyright 2008-2012 Baron Schwartz, 2012 Percona Inc. # Authors: # Baron Schwartz # ============================================================================ # ============================================================================ # To make this code testable, we need to prevent code from running when it is # included from the test script. The test script and this file have different # filenames, so we can compare them. In some cases $_SERVER['SCRIPT_FILENAME'] # seems not to be defined, so we skip the check -- this check should certainly # pass in the test environment. # ============================================================================ if ( !array_key_exists('SCRIPT_FILENAME', $_SERVER) || basename(__FILE__) == basename($_SERVER['SCRIPT_FILENAME']) ) { # ============================================================================ # CONFIGURATION # ============================================================================ # Define MySQL connection constants in config.php. Arguments explicitly passed # in from Cacti will override these. However, if you leave them blank in Cacti # and set them here, you can make life easier. Instead of defining parameters # here, you can define them in another file named the same as this file, with a # .cnf extension. # ============================================================================ $mysql_user = 'mysqluser'; $mysql_pass = 'mysqlpass'; $mysql_port = 3306; $mysql_ssl = FALSE; # Whether to use SSL to connect to MySQL. $heartbeat = ''; # db.tbl if you use pt-heartbeat from Percona Toolkit. $cache_dir = '\/tmp'; # If set, this uses caching to avoid multiple calls. $poll_time = 300; # Adjust to match your polling interval. $timezone = null; # If not set, uses the system default. Example: \"UTC\" $chk_options = array ( 'innodb' => true, # Do you want to check InnoDB statistics?\r\n 'master' => true, # Do you want to check binary logging?\r\n 'slave' => true, # Do you want to check slave status?\r\n 'procs' => true, # Do you want to check SHOW PROCESSLIST?\r\n 'get_qrt' => true, # Get query response times from Percona Server?\r\n);\r\n\r\n$use_ss = FALSE; # Whether to use the script server or not\r\n$debug = FALSE; # Define whether you want debugging behavior.\r\n$debug_log = '\/tmp\/alpha'; # If $debug_log is a filename, it'll be used.\r\n\r\n# ============================================================================\r\n# You should not need to change anything below this line.\r\n# ============================================================================\r\n$version = '1.0.0';\r\n\r\n# ============================================================================\r\n# Include settings from an external config file (issue 39).\r\n# ============================================================================\r\nif ( file_exists(__FILE__ . '.cnf' ) ) {\r\n debug(\"Found configuration file \" . __FILE__ . \".cnf\");\r\n require(__FILE__ . '.cnf');\r\n}\r\n\r\n# Make this a happy little script even when there are errors.\r\n$no_http_headers = true;\r\nini_set('implicit_flush', false); # No output, ever.\r\nif ( $debug ) {\r\n ini_set('display_errors', true);\r\n ini_set('display_startup_errors', true);\r\n ini_set('error_reporting', 2147483647);\r\n}\r\nelse {\r\n ini_set('error_reporting', E_ERROR);\r\n}\r\nob_start(); # Catch all output such as notices of undefined array indexes.\r\nfunction error_handler($errno, $errstr, $errfile, $errline) {\r\n print(\"$errstr at $errfile line $errline\\n\");\r\n debug(\"$errstr at $errfile line $errline\");\r\n}\r\n# ============================================================================\r\n# Set up the stuff we need to be called by the script server.\r\n# ============================================================================\r\nif ( $use_ss ) {\r\n if ( file_exists( dirname(__FILE__) . \"\/..\/include\/global.php\") ) {\r\n # See issue 5 for the reasoning behind this.\r\n debug(\"including \" . dirname(__FILE__) . \"\/..\/include\/global.php\");\r\n include_once(dirname(__FILE__) . \"\/..\/include\/global.php\");\r\n }\r\n elseif ( file_exists( dirname(__FILE__) . \"\/..\/include\/config.php\" ) ) {\r\n # Some Cacti installations don't have global.php.\r\n debug(\"including \" . dirname(__FILE__) . \"\/..\/include\/config.php\");\r\n include_once(dirname(__FILE__) . \"\/..\/include\/config.php\");\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Set the default timezone either to the configured, system timezone, or the\r\n# default set above in the script.\r\n# ============================================================================\r\nif ( function_exists(\"date_default_timezone_set\")\r\n && function_exists(\"date_default_timezone_get\") ) {\r\n $tz = ($timezone ? $timezone : @date_default_timezone_get());\r\n if ( $tz ) {\r\n @date_default_timezone_set($tz);\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Make sure we can also be called as a script.\r\n# ============================================================================\r\nif (!isset($called_by_script_server)) {\r\n debug($_SERVER[\"argv\"]);\r\n array_shift($_SERVER[\"argv\"]); # Strip off this script's filename\r\n $options = parse_cmdline($_SERVER[\"argv\"]);\r\n validate_options($options);\r\n $result = ss_get_mysql_stats($options);\r\n debug($result);\r\n if ( !$debug ) {\r\n # Throw away the buffer, which ought to contain only errors.\r\n ob_end_clean();\r\n }\r\n else {\r\n ob_end_flush(); # In debugging mode, print out the errors.\r\n }\r\n\r\n # Split the result up and extract only the desired parts of it.\r\n $wanted = explode(',', $options['items']);\r\n $output = array();\r\n foreach ( explode(' ', $result) as $item ) {\r\n if ( in_array(substr($item, 0, 2), $wanted) ) {\r\n $output[] = $item;\r\n }\r\n }\r\n debug(array(\"Final result\", $output));\r\n print(implode(' ', $output));\r\n}\r\n\r\n# ============================================================================\r\n# End \"if file was not included\" section.\r\n# ============================================================================\r\n}\r\n\r\n# ============================================================================\r\n# Work around the lack of array_change_key_case in older PHP.\r\n# ============================================================================\r\nif ( !function_exists('array_change_key_case') ) {\r\n function array_change_key_case($arr) {\r\n $res = array();\r\n foreach ( $arr as $key => $val ) {\r\n $res[strtolower($key)] = $val;\r\n }\r\n return $res;\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Validate that the command-line options are here and correct\r\n# ============================================================================\r\nfunction validate_options($options) {\r\n debug($options);\r\n $opts = array('host', 'items', 'user', 'pass', 'heartbeat', 'nocache', 'port');\r\n # Required command-line options\r\n foreach ( array('host', 'items') as $option ) {\r\n if ( !isset($options[$option]) || !$options[$option] ) {\r\n usage(\"Required option --$option is missing\");\r\n }\r\n }\r\n foreach ( $options as $key => $val ) {\r\n if ( !in_array($key, $opts) ) {\r\n usage(\"Unknown option --$key\");\r\n }\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Print out a brief usage summary\r\n# ============================================================================\r\nfunction usage($message) {\r\n global $mysql_user, $mysql_pass, $mysql_port, $heartbeat;\r\n\r\n $usage = << --items <item,...> [OPTION]\r\n\r\n --host Hostname to connect to; use host:port syntax to specify a port\r\n Use :\/path\/to\/socket if you want to connect via a UNIX socket\r\n --items Comma-separated list of the items whose data you want\r\n --user MySQL username; defaults to $mysql_user if not given\r\n --pass MySQL password; defaults to $mysql_pass if not given\r\n --heartbeat MySQL heartbeat table; defaults to '$heartbeat' (see pt-heartbeat)\r\n --nocache Do not cache results in a file\r\n --port MySQL port; defaults to $mysql_port if not given\r\n --mysql_ssl Add the MYSQL_CLIENT_SSL flag to mysql_connect() call\r\n\r\nEOF;\r\n die($usage);\r\n}\r\n\r\n# ============================================================================\r\n# Parse command-line arguments, in the format --arg value --arg value, and\r\n# return them as an array ( arg => value )\r\n# ============================================================================\r\nfunction parse_cmdline( $args ) {\r\n $result = array();\r\n $cur_arg = '';\r\n foreach ($args as $val) {\r\n if ( strpos($val, '--') === 0 ) {\r\n if ( strpos($val, '--no') === 0 ) {\r\n # It's an option without an argument, but it's a --nosomething so\r\n # it's OK.\r\n $result[substr($val, 2)] = 1;\r\n $cur_arg = '';\r\n }\r\n elseif ( $cur_arg ) { # Maybe the last --arg was an option with no arg\r\n if ( $cur_arg == '--user' || $cur_arg == '--pass' || $cur_arg == '--port' ) {\r\n # Special case because Cacti will pass these without an arg\r\n $cur_arg = '';\r\n }\r\n else {\r\n die(\"No arg: $cur_arg\\n\");\r\n }\r\n }\r\n else {\r\n $cur_arg = $val;\r\n }\r\n }\r\n else {\r\n $result[substr($cur_arg, 2)] = $val;\r\n $cur_arg = '';\r\n }\r\n }\r\n if ( $cur_arg && ($cur_arg != '--user' && $cur_arg != '--pass' && $cur_arg != '--port') ) {\r\n die(\"No arg: $cur_arg\\n\");\r\n }\r\n debug($result);\r\n return $result;\r\n}\r\n\r\n# ============================================================================\r\n# This is the main function. Some parameters are filled in from defaults at the\r\n# top of this file.\r\n# ============================================================================\r\nfunction ss_get_mysql_stats( $options ) {\r\n # Process connection options and connect to MySQL.\r\n global $debug, $mysql_user, $mysql_pass, $heartbeat, $cache_dir, $poll_time,\r\n $chk_options, $mysql_port, $mysql_ssl;\r\n\r\n # Connect to MySQL.\r\n $user = isset($options['user']) ? $options['user'] : $mysql_user;\r\n $pass = isset($options['pass']) ? $options['pass'] : $mysql_pass;\r\n $port = isset($options['port']) ? $options['port'] : $mysql_port;\r\n $heartbeat = isset($options['heartbeat']) ? $options['heartbeat'] : $heartbeat;\r\n # If there is a port, or if it's a non-standard port, we add \":$port\" to the\r\n # hostname.\r\n $host_str = $options['host']\r\n . (isset($options['port']) || $port != 3306 ? \":$port\" : '');\r\n debug(array('connecting to', $host_str, $user, $pass));\r\n if ( !extension_loaded('mysql') ) {\r\n debug(\"The MySQL extension is not loaded\");\r\n die(\"The MySQL extension is not loaded\");\r\n }\r\n if ( $mysql_ssl || (isset($options['mysql_ssl']) && $options['mysql_ssl']) ) {\r\n $conn = mysql_connect($host_str, $user, $pass, true, MYSQL_CLIENT_SSL);\r\n }\r\n else {\r\n $conn = mysql_connect($host_str, $user, $pass);\r\n }\r\n if ( !$conn ) {\r\n debug(\"MySQL connection failed: \" . mysql_error());\r\n die(\"MySQL: \" . mysql_error());\r\n }\r\n\r\n $sanitized_host\r\n = str_replace(array(\":\", \"\/\"), array(\"\", \"_\"), $options['host']);\r\n $cache_file = \"$cache_dir\/$sanitized_host-mysql_cacti_stats.txt\"\r\n . (isset($options['port']) || $port != 3306 ? \":$port\" : '');\r\n debug(\"Cache file is $cache_file\");\r\n\r\n # First, check the cache.\r\n $fp = null;\r\n if ( !isset($options['nocache']) ) {\r\n if ( $fp = fopen($cache_file, 'a+') ) {\r\n $locked = flock($fp, 1); # LOCK_SH\r\n if ( $locked ) {\r\n if ( filesize($cache_file) > 0\r\n && filectime($cache_file) + ($poll_time\/2) > time()\r\n && ($arr = file($cache_file))\r\n ) {# The cache file is good to use.\r\n debug(\"Using the cache file\");\r\n fclose($fp);\r\n return $arr[0];\r\n }\r\n else {\r\n debug(\"The cache file seems too small or stale\");\r\n # Escalate the lock to exclusive, so we can write to it.\r\n if ( flock($fp, 2) ) { # LOCK_EX\r\n # We might have blocked while waiting for that LOCK_EX, and\r\n # another process ran and updated it. Let's see if we can just\r\n # return the data now:\r\n if ( filesize($cache_file) > 0\r\n && filectime($cache_file) + ($poll_time\/2) > time()\r\n && ($arr = file($cache_file))\r\n ) {# The cache file is good to use.\r\n debug(\"Using the cache file\");\r\n fclose($fp);\r\n return $arr[0];\r\n }\r\n ftruncate($fp, 0); # Now it's ready for writing later.\r\n }\r\n }\r\n }\r\n else {\r\n debug(\"Couldn't lock the cache file, ignoring it.\");\r\n $fp = null;\r\n }\r\n }\r\n }\r\n else {\r\n $fp = null;\r\n debug(\"Couldn't open the cache file\");\r\n }\r\n\r\n # Set up variables.\r\n $status = array( # Holds the result of SHOW STATUS, SHOW INNODB STATUS, etc\r\n # Define some indexes so they don't cause errors with += operations.\r\n 'relay_log_space' => null,\r\n 'binary_log_space' => null,\r\n 'current_transactions' => 0,\r\n 'locked_transactions' => 0,\r\n 'active_transactions' => 0,\r\n 'innodb_locked_tables' => 0,\r\n 'innodb_tables_in_use' => 0,\r\n 'innodb_lock_structs' => 0,\r\n 'innodb_lock_wait_secs' => 0,\r\n 'innodb_sem_waits' => 0,\r\n 'innodb_sem_wait_time_ms' => 0,\r\n # Values for the 'state' column from SHOW PROCESSLIST (converted to\r\n # lowercase, with spaces replaced by underscores)\r\n 'State_closing_tables' => null,\r\n 'State_copying_to_tmp_table' => null,\r\n 'State_end' => null,\r\n 'State_freeing_items' => null,\r\n 'State_init' => null,\r\n 'State_locked' => null,\r\n 'State_login' => null,\r\n 'State_preparing' => null,\r\n 'State_reading_from_net' => null,\r\n 'State_sending_data' => null,\r\n 'State_sorting_result' => null,\r\n 'State_statistics' => null,\r\n 'State_updating' => null,\r\n 'State_writing_to_net' => null,\r\n 'State_none' => null,\r\n 'State_other' => null, # Everything not listed above\r\n );\r\n\r\n # Get SHOW STATUS and convert the name-value array into a simple\r\n # associative array.\r\n $result = run_query(\"SHOW \/*!50002 GLOBAL *\/ STATUS\", $conn);\r\n foreach ( $result as $row ) {\r\n $status[$row[0]] = $row[1];\r\n }\r\n\r\n # Get SHOW VARIABLES and do the same thing, adding it to the $status array.\r\n $result = run_query(\"SHOW VARIABLES\", $conn);\r\n foreach ( $result as $row ) {\r\n $status[$row[0]] = $row[1];\r\n }\r\n\r\n # Get SHOW SLAVE STATUS, and add it to the $status array.\r\n if ( $chk_options['slave'] ) {\r\n $result = run_query(\"SHOW SLAVE STATUS\", $conn);\r\n $slave_status_rows_gotten = 0;\r\n foreach ( $result as $row ) {\r\n $slave_status_rows_gotten++;\r\n # Must lowercase keys because different MySQL versions have different\r\n # lettercase.\r\n $row = array_change_key_case($row, CASE_LOWER);\r\n $status['relay_log_space'] = $row['relay_log_space'];\r\n $status['slave_lag'] = $row['seconds_behind_master'];\r\n\r\n # Check replication heartbeat, if present.\r\n if ( $heartbeat ) {\r\n $result2 = run_query(\r\n \"SELECT MAX(GREATEST(0, UNIX_TIMESTAMP() - UNIX_TIMESTAMP(ts) - 1))\"\r\n . \" AS delay FROM $heartbeat\", $conn);\r\n $slave_delay_rows_gotten = 0;\r\n foreach ( $result2 as $row2 ) {\r\n $slave_delay_rows_gotten++;\r\n if ( $row2 && is_array($row2)\r\n && array_key_exists('delay', $row2) )\r\n {\r\n $status['slave_lag'] = $row2['delay'];\r\n }\r\n else {\r\n debug(\"Couldn't get slave lag from $heartbeat\");\r\n }\r\n }\r\n if ( $slave_delay_rows_gotten == 0 ) {\r\n debug(\"Got nothing from heartbeat query\");\r\n }\r\n }\r\n\r\n # Scale slave_running and slave_stopped relative to the slave lag.\r\n $status['slave_running'] = ($row['slave_sql_running'] == 'Yes')\r\n ? $status['slave_lag'] : 0;\r\n $status['slave_stopped'] = ($row['slave_sql_running'] == 'Yes')\r\n ? 0 : $status['slave_lag'];\r\n }\r\n if ( $slave_status_rows_gotten == 0 ) {\r\n debug(\"Got nothing from SHOW SLAVE STATUS\");\r\n }\r\n }\r\n\r\n # Get SHOW MASTER STATUS, and add it to the $status array.\r\n if ( $chk_options['master']\r\n && array_key_exists('log_bin', $status)\r\n && $status['log_bin'] == 'ON'\r\n ) { # See issue #8\r\n $binlogs = array(0);\r\n $result = run_query(\"SHOW MASTER LOGS\", $conn);\r\n foreach ( $result as $row ) {\r\n $row = array_change_key_case($row, CASE_LOWER);\r\n # Older versions of MySQL may not have the File_size column in the\r\n # results of the command. Zero-size files indicate the user is\r\n # deleting binlogs manually from disk (bad user! bad!).\r\n if ( array_key_exists('file_size', $row) && $row['file_size'] > 0 ) {\r\n $binlogs[] = $row['file_size'];\r\n }\r\n }\r\n if (count($binlogs)) {\r\n $status['binary_log_space'] = to_int(array_sum($binlogs));\r\n }\r\n }\r\n\r\n # Get SHOW PROCESSLIST and aggregate it by state, then add it to the array\r\n # too.\r\n if ( $chk_options['procs'] ) {\r\n $result = run_query('SHOW PROCESSLIST', $conn);\r\n foreach ( $result as $row ) {\r\n $state = $row['State'];\r\n if ( is_null($state) ) {\r\n $state = 'NULL';\r\n }\r\n if ( $state == '' ) {\r\n $state = 'none';\r\n }\r\n # MySQL 5.5 replaces the 'Locked' state with a variety of \"Waiting for\r\n # X lock\" types of statuses. Wrap these all back into \"Locked\" because\r\n # we don't really care about the type of locking it is.\r\n $state = preg_replace('\/^(Table lock|Waiting for .*lock)$\/', 'Locked', $state);\r\n $state = str_replace(' ', '_', strtolower($state));\r\n if ( array_key_exists(\"State_$state\", $status) ) {\r\n increment($status, \"State_$state\", 1);\r\n }\r\n else {\r\n increment($status, \"State_other\", 1);\r\n }\r\n }\r\n }\r\n\r\n # Get SHOW INNODB STATUS and extract the desired metrics from it, then add\r\n # those to the array too.\r\n if ( $chk_options['innodb']\r\n && array_key_exists('have_innodb', $status)\r\n && $status['have_innodb'] == 'YES'\r\n ) {\r\n $result = run_query(\"SHOW \/*!50000 ENGINE*\/ INNODB STATUS\", $conn);\r\n $istatus_text = $result[0]['Status'];\r\n $istatus_vals = get_innodb_array($istatus_text);\r\n\r\n # Get response time histogram from Percona Server if enabled.\r\n if ( $chk_options['get_qrt']\r\n && isset($status['have_response_time_distribution']) \r\n && ($status['have_response_time_distribution'] == 'YES'))\r\n {\r\n debug('Getting query time histogram');\r\n $i = 0;\r\n $result = run_query(\r\n \"SELECT `count`, total * 1000000 AS total \"\r\n . \"FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME \"\r\n . \"WHERE `time` <> 'TOO LONG'\",\r\n $conn);\r\n foreach ( $result as $row ) {\r\n if ( $i > 13 ) {\r\n # It's possible that the number of rows returned isn't 14.\r\n # Don't add extra status counters.\r\n break;\r\n }\r\n $count_key = sprintf(\"Query_time_count_%02d\", $i);\r\n $total_key = sprintf(\"Query_time_total_%02d\", $i);\r\n $status[$count_key] = $row['count'];\r\n $status[$total_key] = $row['total'];\r\n $i++;\r\n }\r\n # It's also possible that the number of rows returned is too few.\r\n # Don't leave any status counters unassigned; it will break graphs.\r\n while ( $i <= 13 ) { $count_key = sprintf(\"Query_time_count_%02d\", $i); $total_key = sprintf(\"Query_time_total_%02d\", $i); $status[$count_key] = 0; $status[$total_key] = 0; $i++; } } else { debug('Not getting time histogram because it is not enabled'); } # Override values from InnoDB parsing with values from SHOW STATUS, # because InnoDB status might not have everything and the SHOW STATUS is # to be preferred where possible. $overrides = array( 'Innodb_buffer_pool_pages_data' => 'database_pages',\r\n 'Innodb_buffer_pool_pages_dirty' => 'modified_pages',\r\n 'Innodb_buffer_pool_pages_free' => 'free_pages',\r\n 'Innodb_buffer_pool_pages_total' => 'pool_size',\r\n 'Innodb_data_fsyncs' => 'file_fsyncs',\r\n 'Innodb_data_pending_reads' => 'pending_normal_aio_reads',\r\n 'Innodb_data_pending_writes' => 'pending_normal_aio_writes',\r\n 'Innodb_os_log_pending_fsyncs' => 'pending_log_flushes',\r\n 'Innodb_pages_created' => 'pages_created',\r\n 'Innodb_pages_read' => 'pages_read',\r\n 'Innodb_pages_written' => 'pages_written',\r\n 'Innodb_rows_deleted' => 'rows_deleted',\r\n 'Innodb_rows_inserted' => 'rows_inserted',\r\n 'Innodb_rows_read' => 'rows_read',\r\n 'Innodb_rows_updated' => 'rows_updated',\r\n );\r\n\r\n # If the SHOW STATUS value exists, override...\r\n foreach ( $overrides as $key => $val ) {\r\n if ( array_key_exists($key, $status) ) {\r\n debug(\"Override $key\");\r\n $istatus_vals[$val] = $status[$key];\r\n }\r\n }\r\n\r\n # Now copy the values into $status.\r\n foreach ( $istatus_vals as $key => $val ) {\r\n $status[$key] = $istatus_vals[$key];\r\n }\r\n }\r\n\r\n # Make table_open_cache backwards-compatible (issue 63).\r\n if ( array_key_exists('table_open_cache', $status) ) {\r\n $status['table_cache'] = $status['table_open_cache'];\r\n }\r\n\r\n # Compute how much of the key buffer is used and unflushed (issue 127).\r\n $status['Key_buf_bytes_used']\r\n = big_sub($status['key_buffer_size'],\r\n big_multiply($status['Key_blocks_unused'],\r\n $status['key_cache_block_size']));\r\n $status['Key_buf_bytes_unflushed']\r\n = big_multiply($status['Key_blocks_not_flushed'],\r\n $status['key_cache_block_size']);\r\n\r\n if ( array_key_exists('unflushed_log', $status)\r\n && $status['unflushed_log']\r\n ) {\r\n # TODO: I'm not sure what the deal is here; need to debug this. But the\r\n # unflushed log bytes spikes a lot sometimes and it's impossible for it to\r\n # be more than the log buffer.\r\n debug(\"Unflushed log: $status[unflushed_log]\");\r\n $status['unflushed_log']\r\n = max($status['unflushed_log'], $status['innodb_log_buffer_size']);\r\n }\r\n\r\n # Define the variables to output. I use shortened variable names so maybe\r\n # it'll all fit in 1024 bytes for Cactid and Spine's benefit. Strings must\r\n # have some non-hex characters (non a-f0-9) to avoid a Cacti bug. This list\r\n # must come right after the word MAGIC_VARS_DEFINITIONS. The Perl script\r\n # parses it and uses it as a Perl variable.\r\n $keys = array(\r\n 'Key_read_requests' => 'g0',\r\n 'Key_reads' => 'g1',\r\n 'Key_write_requests' => 'g2',\r\n 'Key_writes' => 'g3',\r\n 'history_list' => 'g4',\r\n 'innodb_transactions' => 'g5',\r\n 'read_views' => 'g6',\r\n 'current_transactions' => 'g7',\r\n 'locked_transactions' => 'g8',\r\n 'active_transactions' => 'g9',\r\n 'pool_size' => 'ga',\r\n 'free_pages' => 'gb',\r\n 'database_pages' => 'gc',\r\n 'modified_pages' => 'gd',\r\n 'pages_read' => 'ge',\r\n 'pages_created' => 'gf',\r\n 'pages_written' => 'gg',\r\n 'file_fsyncs' => 'gh',\r\n 'file_reads' => 'gi',\r\n 'file_writes' => 'gj',\r\n 'log_writes' => 'gk',\r\n 'pending_aio_log_ios' => 'gl',\r\n 'pending_aio_sync_ios' => 'gm',\r\n 'pending_buf_pool_flushes' => 'gn',\r\n 'pending_chkp_writes' => 'go',\r\n 'pending_ibuf_aio_reads' => 'gp',\r\n 'pending_log_flushes' => 'gq',\r\n 'pending_log_writes' => 'gr',\r\n 'pending_normal_aio_reads' => 'gs',\r\n 'pending_normal_aio_writes' => 'gt',\r\n 'ibuf_inserts' => 'gu',\r\n 'ibuf_merged' => 'gv',\r\n 'ibuf_merges' => 'gw',\r\n 'spin_waits' => 'gx',\r\n 'spin_rounds' => 'gy',\r\n 'os_waits' => 'gz',\r\n 'rows_inserted' => 'h0',\r\n 'rows_updated' => 'h1',\r\n 'rows_deleted' => 'h2',\r\n 'rows_read' => 'h3',\r\n 'Table_locks_waited' => 'h4',\r\n 'Table_locks_immediate' => 'h5',\r\n 'Slow_queries' => 'h6',\r\n 'Open_files' => 'h7',\r\n 'Open_tables' => 'h8',\r\n 'Opened_tables' => 'h9',\r\n 'innodb_open_files' => 'ha',\r\n 'open_files_limit' => 'hb',\r\n 'table_cache' => 'hc',\r\n 'Aborted_clients' => 'hd',\r\n 'Aborted_connects' => 'he',\r\n 'Max_used_connections' => 'hf',\r\n 'Slow_launch_threads' => 'hg',\r\n 'Threads_cached' => 'hh',\r\n 'Threads_connected' => 'hi',\r\n 'Threads_created' => 'hj',\r\n 'Threads_running' => 'hk',\r\n 'max_connections' => 'hl',\r\n 'thread_cache_size' => 'hm',\r\n 'Connections' => 'hn',\r\n 'slave_running' => 'ho',\r\n 'slave_stopped' => 'hp',\r\n 'Slave_retried_transactions' => 'hq',\r\n 'slave_lag' => 'hr',\r\n 'Slave_open_temp_tables' => 'hs',\r\n 'Qcache_free_blocks' => 'ht',\r\n 'Qcache_free_memory' => 'hu',\r\n 'Qcache_hits' => 'hv',\r\n 'Qcache_inserts' => 'hw',\r\n 'Qcache_lowmem_prunes' => 'hx',\r\n 'Qcache_not_cached' => 'hy',\r\n 'Qcache_queries_in_cache' => 'hz',\r\n 'Qcache_total_blocks' => 'i0',\r\n 'query_cache_size' => 'i1',\r\n 'Questions' => 'i2',\r\n 'Com_update' => 'i3',\r\n 'Com_insert' => 'i4',\r\n 'Com_select' => 'i5',\r\n 'Com_delete' => 'i6',\r\n 'Com_replace' => 'i7',\r\n 'Com_load' => 'i8',\r\n 'Com_update_multi' => 'i9',\r\n 'Com_insert_select' => 'ia',\r\n 'Com_delete_multi' => 'ib',\r\n 'Com_replace_select' => 'ic',\r\n 'Select_full_join' => 'id',\r\n 'Select_full_range_join' => 'ie',\r\n 'Select_range' => 'if',\r\n 'Select_range_check' => 'ig',\r\n 'Select_scan' => 'ih',\r\n 'Sort_merge_passes' => 'ii',\r\n 'Sort_range' => 'ij',\r\n 'Sort_rows' => 'ik',\r\n 'Sort_scan' => 'il',\r\n 'Created_tmp_tables' => 'im',\r\n 'Created_tmp_disk_tables' => 'in',\r\n 'Created_tmp_files' => 'io',\r\n 'Bytes_sent' => 'ip',\r\n 'Bytes_received' => 'iq',\r\n 'innodb_log_buffer_size' => 'ir',\r\n 'unflushed_log' => 'is',\r\n 'log_bytes_flushed' => 'it',\r\n 'log_bytes_written' => 'iu',\r\n 'relay_log_space' => 'iv',\r\n 'binlog_cache_size' => 'iw',\r\n 'Binlog_cache_disk_use' => 'ix',\r\n 'Binlog_cache_use' => 'iy',\r\n 'binary_log_space' => 'iz',\r\n 'innodb_locked_tables' => 'j0',\r\n 'innodb_lock_structs' => 'j1',\r\n 'State_closing_tables' => 'j2',\r\n 'State_copying_to_tmp_table' => 'j3',\r\n 'State_end' => 'j4',\r\n 'State_freeing_items' => 'j5',\r\n 'State_init' => 'j6',\r\n 'State_locked' => 'j7',\r\n 'State_login' => 'j8',\r\n 'State_preparing' => 'j9',\r\n 'State_reading_from_net' => 'ja',\r\n 'State_sending_data' => 'jb',\r\n 'State_sorting_result' => 'jc',\r\n 'State_statistics' => 'jd',\r\n 'State_updating' => 'je',\r\n 'State_writing_to_net' => 'jf',\r\n 'State_none' => 'jg',\r\n 'State_other' => 'jh',\r\n 'Handler_commit' => 'ji',\r\n 'Handler_delete' => 'jj',\r\n 'Handler_discover' => 'jk',\r\n 'Handler_prepare' => 'jl',\r\n 'Handler_read_first' => 'jm',\r\n 'Handler_read_key' => 'jn',\r\n 'Handler_read_next' => 'jo',\r\n 'Handler_read_prev' => 'jp',\r\n 'Handler_read_rnd' => 'jq',\r\n 'Handler_read_rnd_next' => 'jr',\r\n 'Handler_rollback' => 'js',\r\n 'Handler_savepoint' => 'jt',\r\n 'Handler_savepoint_rollback' => 'ju',\r\n 'Handler_update' => 'jv',\r\n 'Handler_write' => 'jw',\r\n 'innodb_tables_in_use' => 'jx',\r\n 'innodb_lock_wait_secs' => 'jy',\r\n 'hash_index_cells_total' => 'jz',\r\n 'hash_index_cells_used' => 'k0',\r\n 'total_mem_alloc' => 'k1',\r\n 'additional_pool_alloc' => 'k2',\r\n 'uncheckpointed_bytes' => 'k3',\r\n 'ibuf_used_cells' => 'k4',\r\n 'ibuf_free_cells' => 'k5',\r\n 'ibuf_cell_count' => 'k6',\r\n 'adaptive_hash_memory' => 'k7',\r\n 'page_hash_memory' => 'k8',\r\n 'dictionary_cache_memory' => 'k9',\r\n 'file_system_memory' => 'ka',\r\n 'lock_system_memory' => 'kb',\r\n 'recovery_system_memory' => 'kc',\r\n 'thread_hash_memory' => 'kd',\r\n 'innodb_sem_waits' => 'ke',\r\n 'innodb_sem_wait_time_ms' => 'kf',\r\n 'Key_buf_bytes_unflushed' => 'kg',\r\n 'Key_buf_bytes_used' => 'kh',\r\n 'key_buffer_size' => 'ki',\r\n 'Innodb_row_lock_time' => 'kj',\r\n 'Innodb_row_lock_waits' => 'kk',\r\n 'Query_time_count_00' => 'kl',\r\n 'Query_time_count_01' => 'km',\r\n 'Query_time_count_02' => 'kn',\r\n 'Query_time_count_03' => 'ko',\r\n 'Query_time_count_04' => 'kp',\r\n 'Query_time_count_05' => 'kq',\r\n 'Query_time_count_06' => 'kr',\r\n 'Query_time_count_07' => 'ks',\r\n 'Query_time_count_08' => 'kt',\r\n 'Query_time_count_09' => 'ku',\r\n 'Query_time_count_10' => 'kv',\r\n 'Query_time_count_11' => 'kw',\r\n 'Query_time_count_12' => 'kx',\r\n 'Query_time_count_13' => 'ky',\r\n 'Query_time_total_00' => 'kz',\r\n 'Query_time_total_01' => 'la',\r\n 'Query_time_total_02' => 'lb',\r\n 'Query_time_total_03' => 'lc',\r\n 'Query_time_total_04' => 'ld',\r\n 'Query_time_total_05' => 'le',\r\n 'Query_time_total_06' => 'lf',\r\n 'Query_time_total_07' => 'lg',\r\n 'Query_time_total_08' => 'lh',\r\n 'Query_time_total_09' => 'li',\r\n 'Query_time_total_10' => 'lj',\r\n 'Query_time_total_11' => 'lk',\r\n 'Query_time_total_12' => 'll',\r\n 'Query_time_total_13' => 'lm',\r\n );\r\n\r\n # Return the output.\r\n $output = array();\r\n foreach ($keys as $key => $short ) {\r\n # If the value isn't defined, return -1 which is lower than (most graphs')\r\n # minimum value of 0, so it'll be regarded as a missing value.\r\n $val = isset($status[$key]) ? $status[$key] : -1;\r\n $output[] = \"$short:$val\";\r\n }\r\n $result = implode(' ', $output);\r\n if ( $fp ) {\r\n if ( fwrite($fp, $result) === FALSE ) {\r\n die(\"Can't write '$cache_file'\");\r\n }\r\n fclose($fp);\r\n }\r\n return $result;\r\n}\r\n\r\n# ============================================================================\r\n# Given INNODB STATUS text, returns a key-value array of the parsed text. Each\r\n# line shows a sample of the input for both standard InnoDB as you would find in\r\n# MySQL 5.0, and XtraDB or enhanced InnoDB from Percona if applicable. Note\r\n# that extra leading spaces are ignored due to trim().\r\n# ============================================================================\r\nfunction get_innodb_array($text) {\r\n $results = array(\r\n 'spin_waits' => array(),\r\n 'spin_rounds' => array(),\r\n 'os_waits' => array(),\r\n 'pending_normal_aio_reads' => null,\r\n 'pending_normal_aio_writes' => null,\r\n 'pending_ibuf_aio_reads' => null,\r\n 'pending_aio_log_ios' => null,\r\n 'pending_aio_sync_ios' => null,\r\n 'pending_log_flushes' => null,\r\n 'pending_buf_pool_flushes' => null,\r\n 'file_reads' => null,\r\n 'file_writes' => null,\r\n 'file_fsyncs' => null,\r\n 'ibuf_inserts' => null,\r\n 'ibuf_merged' => null,\r\n 'ibuf_merges' => null,\r\n 'log_bytes_written' => null,\r\n 'unflushed_log' => null,\r\n 'log_bytes_flushed' => null,\r\n 'pending_log_writes' => null,\r\n 'pending_chkp_writes' => null,\r\n 'log_writes' => null,\r\n 'pool_size' => null,\r\n 'free_pages' => null,\r\n 'database_pages' => null,\r\n 'modified_pages' => null,\r\n 'pages_read' => null,\r\n 'pages_created' => null,\r\n 'pages_written' => null,\r\n 'queries_inside' => null,\r\n 'queries_queued' => null,\r\n 'read_views' => null,\r\n 'rows_inserted' => null,\r\n 'rows_updated' => null,\r\n 'rows_deleted' => null,\r\n 'rows_read' => null,\r\n 'innodb_transactions' => null,\r\n 'unpurged_txns' => null,\r\n 'history_list' => null,\r\n 'current_transactions' => null,\r\n 'hash_index_cells_total' => null,\r\n 'hash_index_cells_used' => null,\r\n 'total_mem_alloc' => null,\r\n 'additional_pool_alloc' => null,\r\n 'last_checkpoint' => null,\r\n 'uncheckpointed_bytes' => null,\r\n 'ibuf_used_cells' => null,\r\n 'ibuf_free_cells' => null,\r\n 'ibuf_cell_count' => null,\r\n 'adaptive_hash_memory' => null,\r\n 'page_hash_memory' => null,\r\n 'dictionary_cache_memory' => null,\r\n 'file_system_memory' => null,\r\n 'lock_system_memory' => null,\r\n 'recovery_system_memory' => null,\r\n 'thread_hash_memory' => null,\r\n 'innodb_sem_waits' => null,\r\n 'innodb_sem_wait_time_ms' => null,\r\n );\r\n $txn_seen = FALSE;\r\n foreach ( explode(\"\\n\", $text) as $line ) {\r\n $line = trim($line);\r\n $row = preg_split('\/ +\/', $line);\r\n\r\n # SEMAPHORES\r\n if (strpos($line, 'Mutex spin waits') === 0 ) {\r\n # Mutex spin waits 79626940, rounds 157459864, OS waits 698719\r\n # Mutex spin waits 0, rounds 247280272495, OS waits 316513438\r\n $results['spin_waits'][] = to_int($row[3]);\r\n $results['spin_rounds'][] = to_int($row[5]);\r\n $results['os_waits'][] = to_int($row[8]);\r\n }\r\n elseif (strpos($line, 'RW-shared spins') === 0\r\n && strpos($line, ';') > 0 ) {\r\n # RW-shared spins 3859028, OS waits 2100750; RW-excl spins 4641946, OS waits 1530310\r\n $results['spin_waits'][] = to_int($row[2]);\r\n $results['spin_waits'][] = to_int($row[8]);\r\n $results['os_waits'][] = to_int($row[5]);\r\n $results['os_waits'][] = to_int($row[11]);\r\n }\r\n elseif (strpos($line, 'RW-shared spins') === 0 && strpos($line, '; RW-excl spins') === FALSE) {\r\n # Post 5.5.17 SHOW ENGINE INNODB STATUS syntax\r\n # RW-shared spins 604733, rounds 8107431, OS waits 241268\r\n $results['spin_waits'][] = to_int($row[2]);\r\n $results['os_waits'][] = to_int($row[7]);\r\n }\r\n elseif (strpos($line, 'RW-excl spins') === 0) {\r\n # Post 5.5.17 SHOW ENGINE INNODB STATUS syntax\r\n # RW-excl spins 604733, rounds 8107431, OS waits 241268\r\n $results['spin_waits'][] = to_int($row[2]);\r\n $results['os_waits'][] = to_int($row[7]);\r\n }\r\n elseif (strpos($line, 'seconds the semaphore:') > 0) {\r\n # --Thread 907205 has waited at handler\/ha_innodb.cc line 7156 for 1.00 seconds the semaphore:\r\n increment($results, 'innodb_sem_waits', 1);\r\n increment($results,\r\n 'innodb_sem_wait_time_ms', to_int($row[9]) * 1000);\r\n }\r\n\r\n # TRANSACTIONS\r\n elseif ( strpos($line, 'Trx id counter') === 0 ) {\r\n # The beginning of the TRANSACTIONS section: start counting\r\n # transactions\r\n # Trx id counter 0 1170664159\r\n # Trx id counter 861B144C\r\n $results['innodb_transactions'] = make_bigint(\r\n $row[3], (isset($row[4]) ? $row[4] : null));\r\n $txn_seen = TRUE;\r\n }\r\n elseif ( strpos($line, 'Purge done for trx') === 0 ) {\r\n # Purge done for trx's n:o < 0 1170663853 undo n:o < 0 0\r\n # Purge done for trx's n:o < 861B135D undo n:o < 0 $purged_to = make_bigint($row[6], $row[7] == 'undo' ? null : $row[7]); $results['unpurged_txns'] = big_sub($results['innodb_transactions'], $purged_to); } elseif (strpos($line, 'History list length') === 0 ) { # History list length 132 $results['history_list'] = to_int($row[3]); } elseif ( $txn_seen && strpos($line, '---TRANSACTION') === 0 ) { # ---TRANSACTION 0, not started, process no 13510, OS thread id 1170446656 increment($results, 'current_transactions', 1); if ( strpos($line, 'ACTIVE') > 0 ) {\r\n increment($results, 'active_transactions', 1);\r\n }\r\n }\r\n elseif ( $txn_seen && strpos($line, '------- TRX HAS BEEN') === 0 ) {\r\n # ------- TRX HAS BEEN WAITING 32 SEC FOR THIS LOCK TO BE GRANTED:\r\n increment($results, 'innodb_lock_wait_secs', to_int($row[5]));\r\n }\r\n elseif ( strpos($line, 'read views open inside InnoDB') > 0 ) {\r\n # 1 read views open inside InnoDB\r\n $results['read_views'] = to_int($row[0]);\r\n }\r\n elseif ( strpos($line, 'mysql tables in use') === 0 ) {\r\n # mysql tables in use 2, locked 2\r\n increment($results, 'innodb_tables_in_use', to_int($row[4]));\r\n increment($results, 'innodb_locked_tables', to_int($row[6]));\r\n }\r\n elseif ( $txn_seen && strpos($line, 'lock struct(s)') > 0 ) {\r\n # 23 lock struct(s), heap size 3024, undo log entries 27\r\n # LOCK WAIT 12 lock struct(s), heap size 3024, undo log entries 5\r\n # LOCK WAIT 2 lock struct(s), heap size 368\r\n if ( strpos($line, 'LOCK WAIT') === 0 ) {\r\n increment($results, 'innodb_lock_structs', to_int($row[2]));\r\n increment($results, 'locked_transactions', 1);\r\n }\r\n else {\r\n increment($results, 'innodb_lock_structs', to_int($row[0]));\r\n }\r\n }\r\n\r\n # FILE I\/O\r\n elseif (strpos($line, ' OS file reads, ') > 0 ) {\r\n # 8782182 OS file reads, 15635445 OS file writes, 947800 OS fsyncs\r\n $results['file_reads'] = to_int($row[0]);\r\n $results['file_writes'] = to_int($row[4]);\r\n $results['file_fsyncs'] = to_int($row[8]);\r\n }\r\n elseif (strpos($line, 'Pending normal aio reads:') === 0 ) {\r\n # Pending normal aio reads: 0, aio writes: 0,\r\n $results['pending_normal_aio_reads'] = to_int($row[4]);\r\n $results['pending_normal_aio_writes'] = to_int($row[7]);\r\n }\r\n elseif (strpos($line, 'ibuf aio reads') === 0 ) {\r\n # ibuf aio reads: 0, log i\/o's: 0, sync i\/o's: 0\r\n $results['pending_ibuf_aio_reads'] = to_int($row[3]);\r\n $results['pending_aio_log_ios'] = to_int($row[6]);\r\n $results['pending_aio_sync_ios'] = to_int($row[9]);\r\n }\r\n elseif ( strpos($line, 'Pending flushes (fsync)') === 0 ) {\r\n # Pending flushes (fsync) log: 0; buffer pool: 0\r\n $results['pending_log_flushes'] = to_int($row[4]);\r\n $results['pending_buf_pool_flushes'] = to_int($row[7]);\r\n }\r\n\r\n # INSERT BUFFER AND ADAPTIVE HASH INDEX\r\n elseif (strpos($line, 'Ibuf for space 0: size ') === 0 ) {\r\n # Older InnoDB code seemed to be ready for an ibuf per tablespace. It\r\n # had two lines in the output. Newer has just one line, see below.\r\n # Ibuf for space 0: size 1, free list len 887, seg size 889, is not empty\r\n # Ibuf for space 0: size 1, free list len 887, seg size 889,\r\n $results['ibuf_used_cells'] = to_int($row[5]);\r\n $results['ibuf_free_cells'] = to_int($row[9]);\r\n $results['ibuf_cell_count'] = to_int($row[12]);\r\n }\r\n elseif (strpos($line, 'Ibuf: size ') === 0 ) {\r\n # Ibuf: size 1, free list len 4634, seg size 4636,\r\n $results['ibuf_used_cells'] = to_int($row[2]);\r\n $results['ibuf_free_cells'] = to_int($row[6]);\r\n $results['ibuf_cell_count'] = to_int($row[9]);\r\n if (strpos($line, 'merges')) {\r\n $results['ibuf_merges'] = to_int($row[10]);\r\n }\r\n }\r\n elseif (strpos($line, ', delete mark ') > 0 && strpos($prev_line, 'merged operations:') === 0 ) {\r\n # Output of show engine innodb status has changed in 5.5\r\n # merged operations:\r\n # insert 593983, delete mark 387006, delete 73092\r\n $results['ibuf_inserts'] = to_int($row[1]);\r\n $results['ibuf_merged'] = to_int($row[1]) + to_int($row[4]) + to_int($row[6]);\r\n }\r\n elseif (strpos($line, ' merged recs, ') > 0 ) {\r\n # 19817685 inserts, 19817684 merged recs, 3552620 merges\r\n $results['ibuf_inserts'] = to_int($row[0]);\r\n $results['ibuf_merged'] = to_int($row[2]);\r\n $results['ibuf_merges'] = to_int($row[5]);\r\n }\r\n elseif (strpos($line, 'Hash table size ') === 0 ) {\r\n # In some versions of InnoDB, the used cells is omitted.\r\n # Hash table size 4425293, used cells 4229064, ....\r\n # Hash table size 57374437, node heap has 72964 buffer(s) 0 ? to_int($row[6]) : '0';\r\n }\r\n\r\n # LOG\r\n elseif (strpos($line, \" log i\/o's done, \") > 0 ) {\r\n # 3430041 log i\/o's done, 17.44 log i\/o's\/second\r\n # 520835887 log i\/o's done, 17.28 log i\/o's\/second, 518724686 syncs, 2980893 checkpoints\r\n # TODO: graph syncs and checkpoints\r\n $results['log_writes'] = to_int($row[0]);\r\n }\r\n elseif (strpos($line, \" pending log writes, \") > 0 ) {\r\n # 0 pending log writes, 0 pending chkp writes\r\n $results['pending_log_writes'] = to_int($row[0]);\r\n $results['pending_chkp_writes'] = to_int($row[4]);\r\n }\r\n elseif (strpos($line, \"Log sequence number\") === 0 ) {\r\n # This number is NOT printed in hex in InnoDB plugin.\r\n # Log sequence number 13093949495856 \/\/plugin\r\n # Log sequence number 125 3934414864 \/\/normal\r\n $results['log_bytes_written']\r\n = isset($row[4])\r\n ? make_bigint($row[3], $row[4])\r\n : to_int($row[3]);\r\n }\r\n elseif (strpos($line, \"Log flushed up to\") === 0 ) {\r\n # This number is NOT printed in hex in InnoDB plugin.\r\n # Log flushed up to 13093948219327\r\n # Log flushed up to 125 3934414864\r\n $results['log_bytes_flushed']\r\n = isset($row[5])\r\n ? make_bigint($row[4], $row[5])\r\n : to_int($row[4]);\r\n }\r\n elseif (strpos($line, \"Last checkpoint at\") === 0 ) {\r\n # Last checkpoint at 125 3934293461\r\n $results['last_checkpoint']\r\n = isset($row[4])\r\n ? make_bigint($row[3], $row[4])\r\n : to_int($row[3]);\r\n }\r\n\r\n # BUFFER POOL AND MEMORY\r\n elseif (strpos($line, \"Total memory allocated\") === 0 ) {\r\n # Total memory allocated 29642194944; in additional pool allocated 0\r\n $results['total_mem_alloc'] = to_int($row[3]);\r\n $results['additional_pool_alloc'] = to_int($row[8]);\r\n }\r\n elseif(strpos($line, 'Adaptive hash index ') === 0 ) {\r\n # Adaptive hash index 1538240664 \t(186998824 + 1351241840)\r\n $results['adaptive_hash_memory'] = to_int($row[3]);\r\n }\r\n elseif(strpos($line, 'Page hash ') === 0 ) {\r\n # Page hash 11688584\r\n $results['page_hash_memory'] = to_int($row[2]);\r\n }\r\n elseif(strpos($line, 'Dictionary cache ') === 0 ) {\r\n # Dictionary cache 145525560 \t(140250984 + 5274576)\r\n $results['dictionary_cache_memory'] = to_int($row[2]);\r\n }\r\n elseif(strpos($line, 'File system ') === 0 ) {\r\n # File system 313848 \t(82672 + 231176)\r\n $results['file_system_memory'] = to_int($row[2]);\r\n }\r\n elseif(strpos($line, 'Lock system ') === 0 ) {\r\n # Lock system 29232616 \t(29219368 + 13248)\r\n $results['lock_system_memory'] = to_int($row[2]);\r\n }\r\n elseif(strpos($line, 'Recovery system ') === 0 ) {\r\n # Recovery system 0 \t(0 + 0)\r\n $results['recovery_system_memory'] = to_int($row[2]);\r\n }\r\n elseif(strpos($line, 'Threads ') === 0 ) {\r\n # Threads 409336 \t(406936 + 2400)\r\n $results['thread_hash_memory'] = to_int($row[1]);\r\n }\r\n elseif(strpos($line, 'innodb_io_pattern ') === 0 ) {\r\n # innodb_io_pattern 0 \t(0 + 0)\r\n $results['innodb_io_pattern_memory'] = to_int($row[1]);\r\n }\r\n elseif (strpos($line, \"Buffer pool size \") === 0 ) {\r\n # The \" \" after size is necessary to avoid matching the wrong line:\r\n # Buffer pool size 1769471\r\n # Buffer pool size, bytes 28991012864\r\n $results['pool_size'] = to_int($row[3]);\r\n }\r\n elseif (strpos($line, \"Free buffers\") === 0 ) {\r\n # Free buffers 0\r\n $results['free_pages'] = to_int($row[2]);\r\n }\r\n elseif (strpos($line, \"Database pages\") === 0 ) {\r\n # Database pages 1696503\r\n $results['database_pages'] = to_int($row[2]);\r\n }\r\n elseif (strpos($line, \"Modified db pages\") === 0 ) {\r\n # Modified db pages 160602\r\n $results['modified_pages'] = to_int($row[3]);\r\n }\r\n elseif (strpos($line, \"Pages read ahead\") === 0 ) {\r\n # Must do this BEFORE the next test, otherwise it'll get fooled by this\r\n # line from the new plugin (see samples\/innodb-015.txt):\r\n # Pages read ahead 0.00\/s, evicted without access 0.06\/s\r\n # TODO: No-op for now, see issue 134.\r\n }\r\n elseif (strpos($line, \"Pages read\") === 0 ) {\r\n # Pages read 15240822, created 1770238, written 21705836\r\n $results['pages_read'] = to_int($row[2]);\r\n $results['pages_created'] = to_int($row[4]);\r\n $results['pages_written'] = to_int($row[6]);\r\n }\r\n\r\n # ROW OPERATIONS\r\n elseif (strpos($line, 'Number of rows inserted') === 0 ) {\r\n # Number of rows inserted 50678311, updated 66425915, deleted 20605903, read 454561562\r\n $results['rows_inserted'] = to_int($row[4]);\r\n $results['rows_updated'] = to_int($row[6]);\r\n $results['rows_deleted'] = to_int($row[8]);\r\n $results['rows_read'] = to_int($row[10]);\r\n }\r\n elseif (strpos($line, \" queries inside InnoDB, \") > 0 ) {\r\n # 0 queries inside InnoDB, 0 queries in queue\r\n $results['queries_inside'] = to_int($row[0]);\r\n $results['queries_queued'] = to_int($row[4]);\r\n }\r\n $prev_line = $line;\r\n }\r\n\r\n foreach ( array('spin_waits', 'spin_rounds', 'os_waits') as $key ) {\r\n $results[$key] = to_int(array_sum($results[$key]));\r\n }\r\n $results['unflushed_log']\r\n = big_sub($results['log_bytes_written'], $results['log_bytes_flushed']);\r\n $results['uncheckpointed_bytes']\r\n = big_sub($results['log_bytes_written'], $results['last_checkpoint']);\r\n\r\n return $results;\r\n}\r\n\r\n# ============================================================================\r\n# Returns a bigint from two ulint or a single hex number. This is tested in\r\n# t\/mysql_stats.php and copied, without tests, to ss_get_by_ssh.php.\r\n# ============================================================================\r\nfunction make_bigint ($hi, $lo = null) {\r\n debug(array($hi, $lo));\r\n if ( is_null($lo) ) {\r\n # Assume it is a hex string representation.\r\n return base_convert($hi, 16, 10);\r\n }\r\n else {\r\n $hi = $hi ? $hi : '0'; # Handle empty-string or whatnot\r\n $lo = $lo ? $lo : '0';\r\n return big_add(big_multiply($hi, 4294967296), $lo);\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Extracts the numbers from a string. You can't reliably do this by casting to\r\n# an int, because numbers that are bigger than PHP's int (varies by platform)\r\n# will be truncated. And you can't use sprintf(%u) either, because the maximum\r\n# value that will return on some platforms is 4022289582. So this just handles\r\n# them as a string instead. It extracts digits until it finds a non-digit and\r\n# quits. This is tested in t\/mysql_stats.php and copied, without tests, to\r\n# ss_get_by_ssh.php.\r\n# ============================================================================\r\nfunction to_int ( $str ) {\r\n debug($str);\r\n global $debug;\r\n preg_match('{(\\d+)}', $str, $m);\r\n if ( isset($m[1]) ) {\r\n return $m[1];\r\n }\r\n elseif ( $debug ) {\r\n print_r(debug_backtrace());\r\n }\r\n else {\r\n return 0;\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Wrap mysql_query in error-handling, and instead of returning the result,\r\n# return an array of arrays in the result.\r\n# ============================================================================\r\nfunction run_query($sql, $conn) {\r\n global $debug;\r\n debug($sql);\r\n $result = @mysql_query($sql, $conn);\r\n if ( $debug ) {\r\n $error = @mysql_error($conn);\r\n if ( $error ) {\r\n debug(array($sql, $error));\r\n die(\"SQLERR $error in $sql\");\r\n }\r\n }\r\n $array = array();\r\n while ( $row = @mysql_fetch_array($result) ) {\r\n $array[] = $row;\r\n }\r\n debug(array($sql, $array));\r\n return $array;\r\n}\r\n\r\n# ============================================================================\r\n# Safely increments a value that might be null.\r\n# ============================================================================\r\nfunction increment(&$arr, $key, $howmuch) {\r\n debug(array($key, $howmuch));\r\n if ( array_key_exists($key, $arr) && isset($arr[$key]) ) {\r\n $arr[$key] = big_add($arr[$key], $howmuch);\r\n }\r\n else {\r\n $arr[$key] = $howmuch;\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Multiply two big integers together as accurately as possible with reasonable\r\n# effort. This is tested in t\/mysql_stats.php and copied, without tests, to\r\n# ss_get_by_ssh.php. $force is for testability.\r\n# ============================================================================\r\nfunction big_multiply ($left, $right, $force = null) {\r\n if ( function_exists(\"gmp_mul\") && (is_null($force) || $force == 'gmp') ) {\r\n debug(array('gmp_mul', $left, $right));\r\n return gmp_strval( gmp_mul( $left, $right ));\r\n }\r\n elseif ( function_exists(\"bcmul\") && (is_null($force) || $force == 'bc') ) {\r\n debug(array('bcmul', $left, $right));\r\n return bcmul( $left, $right );\r\n }\r\n else { # Or $force == 'something else'\r\n debug(array('sprintf', $left, $right));\r\n return sprintf(\"%.0f\", $left * $right);\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Subtract two big integers as accurately as possible with reasonable effort.\r\n# This is tested in t\/mysql_stats.php and copied, without tests, to\r\n# ss_get_by_ssh.php. $force is for testability.\r\n# ============================================================================\r\nfunction big_sub ($left, $right, $force = null) {\r\n debug(array($left, $right));\r\n if ( is_null($left) ) { $left = 0; }\r\n if ( is_null($right) ) { $right = 0; }\r\n if ( function_exists(\"gmp_sub\") && (is_null($force) || $force == 'gmp')) {\r\n debug(array('gmp_sub', $left, $right));\r\n return gmp_strval( gmp_sub( $left, $right ));\r\n }\r\n elseif ( function_exists(\"bcsub\") && (is_null($force) || $force == 'bc')) {\r\n debug(array('bcsub', $left, $right));\r\n return bcsub( $left, $right );\r\n }\r\n else { # Or $force == 'something else'\r\n debug(array('to_int', $left, $right));\r\n return to_int($left - $right);\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Add two big integers together as accurately as possible with reasonable\r\n# effort. This is tested in t\/mysql_stats.php and copied, without tests, to\r\n# ss_get_by_ssh.php. $force is for testability.\r\n# ============================================================================\r\nfunction big_add ($left, $right, $force = null) {\r\n if ( is_null($left) ) { $left = 0; }\r\n if ( is_null($right) ) { $right = 0; }\r\n if ( function_exists(\"gmp_add\") && (is_null($force) || $force == 'gmp')) {\r\n debug(array('gmp_add', $left, $right));\r\n return gmp_strval( gmp_add( $left, $right ));\r\n }\r\n elseif ( function_exists(\"bcadd\") && (is_null($force) || $force == 'bc')) {\r\n debug(array('bcadd', $left, $right));\r\n return bcadd( $left, $right );\r\n }\r\n else { # Or $force == 'something else'\r\n debug(array('to_int', $left, $right));\r\n return to_int($left + $right);\r\n }\r\n}\r\n\r\n# ============================================================================\r\n# Writes to a debugging log.\r\n# ============================================================================\r\nfunction debug($val) {\r\n global $debug_log;\r\n if ( !$debug_log ) {\r\n return;\r\n }\r\n if ( $fp = fopen($debug_log, 'a+') ) {\r\n $trace = debug_backtrace();\r\n $calls = array();\r\n $i = 0;\r\n $line = 0;\r\n $file = '';\r\n foreach ( debug_backtrace() as $arr ) {\r\n if ( $i++ ) {\r\n $calls[] = \"$arr[function]() at $file:$line\";\r\n }\r\n $line = array_key_exists('line', $arr) ? $arr['line'] : '?';\r\n $file = array_key_exists('file', $arr) ? $arr['file'] : '?';\r\n }\r\n if ( !count($calls) ) {\r\n $calls[] = \"at $file:$line\";\r\n }\r\n fwrite($fp, date('Y-m-d h:i:s') . ' ' . implode(' <- ', $calls));\r\n fwrite($fp, \"\\n\" . var_export($val, TRUE) . \"\\n\");\r\n fclose($fp);\r\n }\r\n else { # Disable logging\r\n print(\"Warning: disabling debug logging to $debug_log\\n\");\r\n $debug_log = FALSE;\r\n }\r\n}<\/pre>\n<zabbix_export date=\"11.11.10\" time=\"04.09\" version=\"1.0\">\r\n\r\n Template_MySQL:Process mysqld not running on {HOSTNAME}\r\n\r\n Template_MySQL:Slave lag more than 10m over 10m on {HOSTNAME}\r\n Template_MySQL:Process mysqld not running on {HOSTNAME}\r\n\r\n Template_MySQL:Process mysqld not running on {HOSTNAME}\r\n\r\n Template_MySQL:Process mysqld not running on {HOSTNAME}\r\n\r\n Template_MySQL:Process mysqld not running on {HOSTNAME}\r\n\r\n Template_MySQL:Process mysqld not running on {HOSTNAME}\r\n\r\n Template_MySQL:Process mysqld not running on {HOSTNAME}\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Key_read_requests\">\r\n <calc_fnc>2\r\n 157419\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Key_reads\">\r\n <calc_fnc>2\r\n AFECED\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Key_write_requests\">\r\n <calc_fnc>2\r\n 862F2F\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Key_writes\">\r\n <calc_fnc>2\r\n F51D30\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.setting.key_buffer_size\">\r\n <calc_fnc>2\r\n 99B898\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Key_buf_bytes_used\">\r\n <calc_fnc>2\r\n 2A363B\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Key_buf_bytes_unflushed\">\r\n <calc_fnc>2\r\n FECEA8\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.setting.pool_size\">\r\n <calc_fnc>2\r\n 3D1500\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.database_pages\">\r\n <calc_fnc>2\r\n EDAA41\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.free_pages\">\r\n <calc_fnc>2\r\n AA3B27\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.modified_pages\">\r\n <calc_fnc>2\r\n 13343B\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.file_reads\">\r\n <calc_fnc>2\r\n 402204\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.file_writes\">\r\n <calc_fnc>2\r\n B3092B\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.log_writes\">\r\n <calc_fnc>2\r\n FFBF00\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.file_fsyncs\">\r\n <calc_fnc>2\r\n 0ABFCC\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.ibuf_inserts\">\r\n <calc_fnc>2\r\n 157419\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.ibuf_merged\">\r\n <calc_fnc>2\r\n 0000FF\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.ibuf_merges\">\r\n <calc_fnc>2\r\n 862F2F\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.ibuf_cell_count\">\r\n <calc_fnc>2\r\n 793A57\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.ibuf_used_cells\">\r\n <calc_fnc>2\r\n 8C873E\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.ibuf_free_cells\">\r\n <calc_fnc>2\r\n A38A5F\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.spin_rounds\">\r\n <calc_fnc>2\r\n 306078\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.spin_waits\">\r\n <calc_fnc>2\r\n 4444FF\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.os_waits\">\r\n <calc_fnc>2\r\n 157419\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.rows_read\">\r\n <calc_fnc>2\r\n AFECED\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.rows_deleted\">\r\n <calc_fnc>2\r\n DA4725\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.rows_updated\">\r\n <calc_fnc>2\r\n EA8F00\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.rows_inserted\">\r\n <calc_fnc>2\r\n 35962B\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Table_locks_immediate\">\r\n <calc_fnc>2\r\n D2D8F9\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Table_locks_immediate\">\r\n <calc_fnc>2\r\n 002A8F\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Table_locks_waited\">\r\n <calc_fnc>2\r\n FF3932\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Slow_queries\">\r\n <calc_fnc>2\r\n 35962B\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.setting.max_connections\">\r\n <calc_fnc>2\r\n C0C0C0\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Max_used_connections\">\r\n <calc_fnc>2\r\n FFD660\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Aborted_clients\">\r\n <calc_fnc>2\r\n FF3932\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Aborted_connects\">\r\n <calc_fnc>2\r\n 00FF00\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Threads_connected\">\r\n <calc_fnc>2\r\n FF7D00\r\n 2\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Connections\">\r\n <calc_fnc>2\r\n 4444FF\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.slave_running\">\r\n <calc_fnc>2\r\n 96E78A\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.slave_stopped\">\r\n <calc_fnc>2\r\n CDCFC4\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.slave_lag\">\r\n <calc_fnc>2\r\n 4444FF\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Slave_open_temp_tables\">\r\n <calc_fnc>2\r\n 8D00BA\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Slave_retried_transactions\">\r\n <calc_fnc>2\r\n FF0000\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Qcache_queries_in_cache\">\r\n <calc_fnc>2\r\n 4444FF\r\n 2\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Qcache_hits\">\r\n <calc_fnc>2\r\n EAAF00\r\n 2\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Qcache_inserts\">\r\n <calc_fnc>2\r\n 157419\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Qcache_not_cached\">\r\n <calc_fnc>2\r\n 00A0C1\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Qcache_lowmem_prunes\">\r\n <calc_fnc>2\r\n FF0000\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.setting.query_cache_size\">\r\n <calc_fnc>2\r\n 74C366\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Qcache_free_memory\">\r\n <calc_fnc>2\r\n FFC3C0\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Qcache_total_blocks\">\r\n <calc_fnc>2\r\n 8D00BA\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Qcache_free_blocks\">\r\n <calc_fnc>2\r\n 837C04\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Questions\">\r\n <calc_fnc>2\r\n FFC3C0\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_select\">\r\n <calc_fnc>2\r\n FF0000\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_delete\">\r\n <calc_fnc>2\r\n FF7D00\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_insert\">\r\n <calc_fnc>2\r\n FFF200\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_update\">\r\n <calc_fnc>2\r\n 00CF00\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_replace\">\r\n <calc_fnc>2\r\n 2175D9\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_load\">\r\n <calc_fnc>2\r\n 55009D\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_delete_multi\">\r\n <calc_fnc>2\r\n 942D0C\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_insert_select\">\r\n <calc_fnc>2\r\n AAABA1\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_update_multi\">\r\n <calc_fnc>2\r\n D8ACE0\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Com_replace_select\">\r\n <calc_fnc>2\r\n 00B99B\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Select_full_join\">\r\n <calc_fnc>2\r\n 3D1500\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Select_full_range_join\">\r\n <calc_fnc>2\r\n AA3B27\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Select_range\">\r\n <calc_fnc>2\r\n EDAA41\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Select_range_check\">\r\n <calc_fnc>2\r\n 13343B\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Select_scan\">\r\n <calc_fnc>2\r\n 686240\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Sort_rows\">\r\n <calc_fnc>2\r\n FFAB00\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Sort_range\">\r\n <calc_fnc>2\r\n 157419\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Sort_merge_passes\">\r\n <calc_fnc>2\r\n DA4725\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Sort_scan\">\r\n <calc_fnc>2\r\n 4444FF\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Created_tmp_tables\">\r\n <calc_fnc>2\r\n FFAB00\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Created_tmp_tables\">\r\n <calc_fnc>2\r\n 837C04\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Created_tmp_disk_tables\">\r\n <calc_fnc>2\r\n F51D30\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Created_tmp_files\">\r\n <calc_fnc>2\r\n 157419\r\n 2\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Bytes_sent\">\r\n <calc_fnc>2\r\n 4B2744\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Bytes_received\">\r\n <calc_fnc>2\r\n E4C576\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.pages_created\">\r\n <calc_fnc>2\r\n D6883A\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pages_read\">\r\n <calc_fnc>2\r\n E6D883\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pages_written\">\r\n <calc_fnc>2\r\n 55AD84\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.pending_aio_log_ios\">\r\n <calc_fnc>2\r\n FF0000\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pending_aio_sync_ios\">\r\n <calc_fnc>2\r\n FF7D00\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pending_buf_pool_flushes\">\r\n <calc_fnc>2\r\n FFF200\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pending_chkp_writes\">\r\n <calc_fnc>2\r\n 00A348\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pending_ibuf_aio_reads\">\r\n <calc_fnc>2\r\n 6DC8FE\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pending_log_flushes\">\r\n <calc_fnc>2\r\n 4444FF\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pending_log_writes\">\r\n <calc_fnc>2\r\n 55009D\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pending_normal_aio_reads\">\r\n <calc_fnc>2\r\n B90054\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.pending_normal_aio_writes\">\r\n <calc_fnc>2\r\n 8F9286\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.innodb_log_buffer_size\">\r\n <calc_fnc>2\r\n 6E3803\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.log_bytes_written\">\r\n <calc_fnc>2\r\n 5B8257\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.log_bytes_flushed\">\r\n <calc_fnc>2\r\n AB4253\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.unflushed_log\">\r\n <calc_fnc>2\r\n AFECED\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Binlog_cache_use\">\r\n <calc_fnc>2\r\n 35962B\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Binlog_cache_disk_use\">\r\n <calc_fnc>2\r\n FF0000\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.binary_log_space\">\r\n <calc_fnc>2\r\n 8D00BA\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.relay_log_space\">\r\n <calc_fnc>2\r\n 8F005C\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.innodb_transactions\">\r\n <calc_fnc>2\r\n 8F005C\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.current_transactions\">\r\n <calc_fnc>2\r\n 4444FF\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.history_list\">\r\n <calc_fnc>2\r\n FF7D00\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.read_views\">\r\n <calc_fnc>2\r\n 74C366\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.active_transactions\">\r\n <calc_fnc>2\r\n C0C0C0\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.locked_transactions\">\r\n <calc_fnc>2\r\n FF0000\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.setting.table_cache\">\r\n <calc_fnc>2\r\n D09887\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Open_tables\">\r\n <calc_fnc>2\r\n 4A6959\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Open_files\">\r\n <calc_fnc>2\r\n 1D1159\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Opened_tables\">\r\n <calc_fnc>2\r\n DE0056\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.setting.thread_cache_size\">\r\n <calc_fnc>2\r\n D8ACE0\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Threads_created\">\r\n <calc_fnc>2\r\n DE0056\r\n 2\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.total_mem_alloc\">\r\n <calc_fnc>2\r\n 53777A\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.additional_pool_alloc\">\r\n <calc_fnc>2\r\n C02942\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.hash_index_cells_total\">\r\n <calc_fnc>2\r\n 0C4E5D\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.hash_index_cells_used\">\r\n <calc_fnc>2\r\n D9C7A3\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.adaptive_hash_memory\">\r\n <calc_fnc>2\r\n 793A57\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.page_hash_memory\">\r\n <calc_fnc>2\r\n 8C873E\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.dictionary_cache_memory\">\r\n <calc_fnc>2\r\n D1C5A5\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.file_system_memory\">\r\n <calc_fnc>2\r\n 4D3339\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.lock_system_memory\">\r\n <calc_fnc>2\r\n A38A5F\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.recovery_system_memory\">\r\n <calc_fnc>2\r\n E97F02\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.thread_hash_memory\">\r\n <calc_fnc>2\r\n 23B0BA\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.innodb_tables_in_use\">\r\n <calc_fnc>2\r\n D99362\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.innodb_locked_tables\">\r\n <calc_fnc>2\r\n 663344\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.innodb_lock_wait_secs\">\r\n <calc_fnc>2\r\n 201A33\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.innodb_lock_structs\">\r\n <calc_fnc>2\r\n 0C4E5D\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.uncheckpointed_bytes\">\r\n <calc_fnc>2\r\n 661100\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Innodb_row_lock_time\">\r\n <calc_fnc>2\r\n B11D03\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Innodb_row_lock_waits\">\r\n <calc_fnc>2\r\n E84A5F\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.innodb_sem_waits\">\r\n <calc_fnc>2\r\n 7020AF\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.innodb_sem_wait_time_ms\">\r\n <calc_fnc>2\r\n 708226\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.State_closing_tables\">\r\n <calc_fnc>2\r\n DE0056\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_copying_to_tmp_table\">\r\n <calc_fnc>2\r\n 784890\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_end\">\r\n <calc_fnc>2\r\n D1642E\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_freeing_items\">\r\n <calc_fnc>2\r\n 487860\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_init\">\r\n <calc_fnc>2\r\n 907890\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_locked\">\r\n <calc_fnc>2\r\n DE0056\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_login\">\r\n <calc_fnc>2\r\n 1693A7\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_preparing\">\r\n <calc_fnc>2\r\n 783030\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_reading_from_net\">\r\n <calc_fnc>2\r\n FF7F00\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_sending_data\">\r\n <calc_fnc>2\r\n 54382A\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_sorting_result\">\r\n <calc_fnc>2\r\n B83A04\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_statistics\">\r\n <calc_fnc>2\r\n 6E3803\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_updating\">\r\n <calc_fnc>2\r\n B56414\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_writing_to_net\">\r\n <calc_fnc>2\r\n 6E645A\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_none\">\r\n <calc_fnc>2\r\n 521808\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.State_other\">\r\n <calc_fnc>2\r\n 194240\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Handler_commit\">\r\n <calc_fnc>2\r\n DE0056\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_rollback\">\r\n <calc_fnc>2\r\n 784890\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_savepoint\">\r\n <calc_fnc>2\r\n D1642E\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_savepoint_rollback\">\r\n <calc_fnc>2\r\n 487860\r\n 0\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n MySQL\r\n\r\n <graph_elements>\r\n <graph_element item=\"Template_MySQL:mysql.Handler_write\">\r\n <calc_fnc>2\r\n 4D4A47\r\n 1\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_update\">\r\n <calc_fnc>2\r\n C79F71\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_delete\">\r\n <calc_fnc>2\r\n BDB8B3\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_read_first\">\r\n <calc_fnc>2\r\n 8C286E\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_read_key\">\r\n <calc_fnc>2\r\n BAB27F\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_read_next\">\r\n <calc_fnc>2\r\n C02942\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_read_prev\">\r\n <calc_fnc>2\r\n FA6900\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_read_rnd\">\r\n <calc_fnc>2\r\n 5A3D31\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n <graph_element item=\"Template_MySQL:mysql.Handler_read_rnd_next\">\r\n <calc_fnc>2\r\n 69D2E7\r\n 5\r\n <periods_cnt>5\r\n 0\r\n 1\r\n\r\n 0\r\n <percent_left>0.0000\r\n <percent_right>0.0000\r\n <show_3d>0\r\n <show_legend>1\r\n <show_triggers>1\r\n <show_work_period>1\r\n 100.0000\r\n 0.0000\r\n <ymax_item_key>\r\n <ymax_type>0\r\n <ymin_item_key>\r\n <ymin_type>0\r\n\r\n Templates\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Ibuf cell count\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Unflushed log\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State end\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Threads connected\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com update multi\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler read next\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Qcache queries in cache\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Spin waits\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Relay log space\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n InnoDB locked tables\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler read first\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Innodb row lock time\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Lock system memory\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 3600\r\n 0\r\n Pool size\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Page hash memory\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 3600\r\n 0\r\n Open files limit\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Ibuf merges\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State sending data\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Pending log flushes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Opened tables\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Qcache not cached\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Total mem alloc\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State locked\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n MyISAM Key read requests\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Open tables\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n InnoDB transactions\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Sort range\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler delete\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Threads created\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Rows read\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Read views\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler read key\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Sort rows\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Bytes sent\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Pending buf pool flushes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n InnoDB lock wait secs\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Slave lag\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State init\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Log bytes written\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Questions\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler rollback\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State updating\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Thread hash memory\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com replace select\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Slave retried transactions\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Qcache total blocks\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Created tmp files\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler read rnd\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n MyISAM Key reads\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com replace\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Qcache free blocks\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Select range check\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Slow launch threads\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n MyISAM Key buf bytes unflushed\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Select full range join\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Current transactions\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Active transactions\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Pending AIO sync ios\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Threads cached\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler read rnd next\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n InnoDB lock structs\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State reading from net\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State freeing items\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 3600\r\n 0\r\n Binlog cache size\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Select range\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n MyISAM Key writes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State sorting result\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Hash index cells used\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State none\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Open files\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Pages read\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Log bytes flushed\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com insert\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com delete\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Pending normal AIO writes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Free pages\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Additional pool alloc\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Created tmp disk tables\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Slave running\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State statistics\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Database pages\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Uncheckpointed bytes\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Select full join\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Pending chkp writes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Rows updated\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 3600\r\n 0\r\n Max connections\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Aborted clients\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Sort scan\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n MyISAM Key write requests\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Rows inserted\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Connections\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State preparing\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com select\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n OS waits\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Recovery system memory\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 3600\r\n 0\r\n Table cache\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Binlog cache use\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n InnoDB sem wait time ms\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com update\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Qcache free memory\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Spin rounds\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler savepoint\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com delete multi\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Pages created\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Qcache lowmem prunes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Bytes received\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler read prev\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Hash index cells total\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Qcache inserts\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com load\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State login\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n History list\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 60\r\n 0\r\n MySQL Processes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Qcache hits\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Binlog cache disk use\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler commit\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State other\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Slave open temp tables\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Pending ibuf AIO reads\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Adaptive hash memory\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler prepare\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Ibuf inserts\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Rows deleted\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Table locks immediate\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Modified pages\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Table locks waited\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n InnoDB tables in use\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n InnoDB sem waits\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Created tmp tables\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Aborted connects\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n File fsyncs\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 3600\r\n 0\r\n MyISAM key buffer size\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 3600\r\n 0\r\n Query cache size\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Innodb row lock waits\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n File system memory\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Binary log space\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Slave stopped\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler discover\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Pending normal AIO reads\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State copying to tmp table\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Ibuf merged\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Slow queries\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State closing tables\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 3600\r\n 0\r\n Thread cache size\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Pages written\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n File reads\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Ibuf used cells\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Com insert select\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Locked transactions\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Pending AIO log ios\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Pending log writes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n InnoDB log buffer size\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Ibuf free cells\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n File writes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Max used connections\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler write\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler savepoint rollback\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Threads running\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n MyISAM Key buf bytes used\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n Dictionary cache memory\r\n 60\r\n 0\r\n 365\r\n B\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Handler update\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n InnoDB open files\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Log writes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Sort merge passes\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 2\r\n Select scan\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex>\r\n\r\n MySQL\r\n\r\n <data_type>0\r\n 120\r\n 0\r\n State writing to net\r\n 60\r\n 0\r\n 365\r\n\r\n <delay_flex><\/pre>\n