devbox
AI程序代码艺术家
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Zabbix 监控MySQL脚本（Python二次开发）_通过python zabbix数据推送 mysql

作者：AI程序代码艺术家 | 2024-01-30 20:28:50

赞

踩

通过python zabbix数据推送 mysql

环境：

        操作系统版本：Rocky8.6或CentOS7.9

        MysqlServe版本：8.0

        Zabbix.Server版本：6.0LTS

        Zabbix.agent版本：Agent2

功能：

        监控数据库信息

        监控数据库状态

        可以检测主从状态

        监控指标如下所示：

                

  1.       'Key_read_requests'           :  'gg',
  2.       'Key_reads'                   :  'gh',
  3.       'Key_write_requests'          :  'gi',
  4.       'Key_writes'                  :  'gj',
  5.       'history_list'                :  'gk',
  6.       'innodb_transactions'         :  'gl',
  7.       'read_views'                  :  'gm',
  8.       'current_transactions'        :  'gn',
  9.       'locked_transactions'         :  'go',
  10.       'active_transactions'         :  'gp',
  11.       'pool_size'                   :  'gq',
  12.       'free_pages'                  :  'gr',
  13.       'database_pages'              :  'gs',
  14.       'modified_pages'              :  'gt',
  15.       'pages_read'                  :  'gu',
  16.       'pages_created'               :  'gv',
  17.       'pages_written'               :  'gw',
  18.       'file_fsyncs'                 :  'gx',
  19.       'file_reads'                  :  'gy',
  20.       'file_writes'                 :  'gz',
  21.       'log_writes'                  :  'hg',
  22.       'pending_aio_log_ios'         :  'hh',
  23.       'pending_aio_sync_ios'        :  'hi',
  24.       'pending_buf_pool_flushes'    :  'hj',
  25.       'pending_chkp_writes'         :  'hk',
  26.       'pending_ibuf_aio_reads'      :  'hl',
  27.       'pending_log_flushes'         :  'hm',
  28.       'pending_log_writes'          :  'hn',
  29.       'pending_normal_aio_reads'    :  'ho',
  30.       'pending_normal_aio_writes'   :  'hp',
  31.       'ibuf_inserts'                :  'hq',
  32.       'ibuf_merged'                 :  'hr',
  33.       'ibuf_merges'                 :  'hs',
  34.       'spin_waits'                  :  'ht',
  35.       'spin_rounds'                 :  'hu',
  36.       'os_waits'                    :  'hv',
  37.       'rows_inserted'               :  'hw',
  38.       'rows_updated'                :  'hx',
  39.       'rows_deleted'                :  'hy',
  40.       'rows_read'                   :  'hz',
  41.       'Table_locks_waited'          :  'ig',
  42.       'Table_locks_immediate'       :  'ih',
  43.       'Slow_queries'                :  'ii',
  44.       'Open_files'                  :  'ij',
  45.       'Open_tables'                 :  'ik',
  46.       'Opened_tables'               :  'il',
  47.       'innodb_open_files'           :  'im',
  48.       'open_files_limit'            :  'in',
  49.       'table_cache'                 :  'io',
  50.       'Aborted_clients'             :  'ip',
  51.       'Aborted_connects'            :  'iq',
  52.       'Max_used_connections'        :  'ir',
  53.       'Slow_launch_threads'         :  'is',
  54.       'Threads_cached'              :  'it',
  55.       'Threads_connected'           :  'iu',
  56.       'Threads_created'             :  'iv',
  57.       'Threads_running'             :  'iw',
  58.       'max_connections'             :  'ix',
  59.       'thread_cache_size'           :  'iy',
  60.       'Connections'                 :  'iz',
  61.       'slave_running'               :  'jg',
  62.       'slave_stopped'               :  'jh',
  63.       'Slave_retried_transactions'  :  'ji',
  64.       'slave_lag'                   :  'jj',
  65.       'Slave_open_temp_tables'      :  'jk',
  66.       'Qcache_free_blocks'          :  'jl',
  67.       'Qcache_free_memory'          :  'jm',
  68.       'Qcache_hits'                 :  'jn',
  69.       'Qcache_inserts'              :  'jo',
  70.       'Qcache_lowmem_prunes'        :  'jp',
  71.       'Qcache_not_cached'           :  'jq',
  72.       'Qcache_queries_in_cache'     :  'jr',
  73.       'Qcache_total_blocks'         :  'js',
  74.       'query_cache_size'            :  'jt',
  75.       'Questions'                   :  'ju',
  76.       'Com_update'                  :  'jv',
  77.       'Com_insert'                  :  'jw',
  78.       'Com_select'                  :  'jx',
  79.       'Com_delete'                  :  'jy',
  80.       'Com_replace'                 :  'jz',
  81.       'Com_load'                    :  'kg',
  82.       'Com_update_multi'            :  'kh',
  83.       'Com_insert_select'           :  'ki',
  84.       'Com_delete_multi'            :  'kj',
  85.       'Com_replace_select'          :  'kk',
  86.       'Select_full_join'            :  'kl',
  87.       'Select_full_range_join'      :  'km',
  88.       'Select_range'                :  'kn',
  89.       'Select_range_check'          :  'ko',
  90.       'Select_scan'                 :  'kp',
  91.       'Sort_merge_passes'           :  'kq',
  92.       'Sort_range'                  :  'kr',
  93.       'Sort_rows'                   :  'ks',
  94.       'Sort_scan'                   :  'kt',
  95.       'Created_tmp_tables'          :  'ku',
  96.       'Created_tmp_disk_tables'     :  'kv',
  97.       'Created_tmp_files'           :  'kw',
  98.       'Bytes_sent'                  :  'kx',
  99.       'Bytes_received'              :  'ky',
  100.       'innodb_log_buffer_size'      :  'kz',
  101.       'unflushed_log'               :  'lg',
  102.       'log_bytes_flushed'           :  'lh',
  103.       'log_bytes_written'           :  'li',
  104.       'relay_log_space'             :  'lj',
  105.       'binlog_cache_size'           :  'lk',
  106.       'Binlog_cache_disk_use'       :  'll',
  107.       'Binlog_cache_use'            :  'lm',
  108.       'binary_log_space'            :  'ln',
  109.       'innodb_locked_tables'        :  'lo',
  110.       'innodb_lock_structs'         :  'lp',
  111.       'State_closing_tables'        :  'lq',
  112.       'State_copying_to_tmp_table'  :  'lr',
  113.       'State_end'                   :  'ls',
  114.       'State_freeing_items'         :  'lt',
  115.       'State_init'                  :  'lu',
  116.       'State_locked'                :  'lv',
  117.       'State_login'                 :  'lw',
  118.       'State_preparing'             :  'lx',
  119.       'State_reading_from_net'      :  'ly',
  120.       'State_sending_data'          :  'lz',
  121.       'State_sorting_result'        :  'mg',
  122.       'State_statistics'            :  'mh',
  123.       'State_updating'              :  'mi',
  124.       'State_writing_to_net'        :  'mj',
  125.       'State_none'                  :  'mk',
  126.       'State_other'                 :  'ml',
  127.       'Handler_commit'              :  'mm',
  128.       'Handler_delete'              :  'mn',
  129.       'Handler_discover'            :  'mo',
  130.       'Handler_prepare'             :  'mp',
  131.       'Handler_read_first'          :  'mq',
  132.       'Handler_read_key'            :  'mr',
  133.       'Handler_read_next'           :  'ms',
  134.       'Handler_read_prev'           :  'mt',
  135.       'Handler_read_rnd'            :  'mu',
  136.       'Handler_read_rnd_next'       :  'mv',
  137.       'Handler_rollback'            :  'mw',
  138.       'Handler_savepoint'           :  'mx',
  139.       'Handler_savepoint_rollback'  :  'my',
  140.       'Handler_update'              :  'mz',
  141.       'Handler_write'               :  'ng',
  142.       'innodb_tables_in_use'        :  'nh',
  143.       'innodb_lock_wait_secs'       :  'ni',
  144.       'hash_index_cells_total'      :  'nj',
  145.       'hash_index_cells_used'       :  'nk',
  146.       'total_mem_alloc'             :  'nl',
  147.       'additional_pool_alloc'       :  'nm',
  148.       'uncheckpointed_bytes'        :  'nn',
  149.       'ibuf_used_cells'             :  'no',
  150.       'ibuf_free_cells'             :  'np',
  151.       'ibuf_cell_count'             :  'nq',
  152.       'adaptive_hash_memory'        :  'nr',
  153.       'page_hash_memory'            :  'ns',
  154.       'dictionary_cache_memory'     :  'nt',
  155.       'file_system_memory'          :  'nu',
  156.       'lock_system_memory'          :  'nv',
  157.       'recovery_system_memory'      :  'nw',
  158.       'thread_hash_memory'          :  'nx',
  159.       'innodb_sem_waits'            :  'ny',
  160.       'innodb_sem_wait_time_ms'     :  'nz',
  161.       'Key_buf_bytes_unflushed'     :  'og',
  162.       'Key_buf_bytes_used'          :  'oh',
  163.       'key_buffer_size'             :  'oi',
  164.       'Innodb_row_lock_time'        :  'oj',
  165.       'Innodb_row_lock_waits'       :  'ok',
  166.       'Query_time_count_00'         :  'ol',
  167.       'Query_time_count_01'         :  'om',
  168.       'Query_time_count_02'         :  'on',
  169.       'Query_time_count_03'         :  'oo',
  170.       'Query_time_count_04'         :  'op',
  171.       'Query_time_count_05'         :  'oq',
  172.       'Query_time_count_06'         :  'or',
  173.       'Query_time_count_07'         :  'os',
  174.       'Query_time_count_08'         :  'ot',
  175.       'Query_time_count_09'         :  'ou',
  176.       'Query_time_count_10'         :  'ov',
  177.       'Query_time_count_11'         :  'ow',
  178.       'Query_time_count_12'         :  'ox',
  179.       'Query_time_count_13'         :  'oy',
  180.       'Query_time_total_00'         :  'oz',
  181.       'Query_time_total_01'         :  'pg',
  182.       'Query_time_total_02'         :  'ph',
  183.       'Query_time_total_03'         :  'pi',
  184.       'Query_time_total_04'         :  'pj',
  185.       'Query_time_total_05'         :  'pk',
  186.       'Query_time_total_06'         :  'pl',
  187.       'Query_time_total_07'         :  'pm',
  188.       'Query_time_total_08'         :  'pn',
  189.       'Query_time_total_09'         :  'po',
  190.       'Query_time_total_10'         :  'pp',
  191.       'Query_time_total_11'         :  'pq',
  192.       'Query_time_total_12'         :  'pr',
  193.       'Query_time_total_13'         :  'ps',
  194.       'wsrep_replicated_bytes'      :  'pt',
  195.       'wsrep_received_bytes'        :  'pu',
  196.       'wsrep_replicated'            :  'pv',
  197.       'wsrep_received'              :  'pw',
  198.       'wsrep_local_cert_failures'   :  'px',
  199.       'wsrep_local_bf_aborts'       :  'py',
  200.       'wsrep_local_send_queue'      :  'pz',
  201.       'wsrep_local_recv_queue'      :  'qg',
  202.       'wsrep_cluster_size'          :  'qh',
  203.       'wsrep_cert_deps_distance'    :  'qi',
  204.       'wsrep_apply_window'          :  'qj',
  205.       'wsrep_commit_window'         :  'qk',
  206.       'wsrep_flow_control_paused'   :  'ql',
  207.       'wsrep_flow_control_sent'     :  'qm',
  208.       'wsrep_flow_control_recv'     :  'qn',
  209.       'pool_reads'                  :  'qo',
  210.       'pool_read_requests'          :  'qp',

安装步骤

1）安装

备注：预先装载好Zabbix-Server(我之前教程里有)

1）安装Zabbix.Agent2(参考网址)Download and install Zabbix 6.0 LTS for Rocky Linux 8, MySQL, Nginxicon-default.png?t=MBR7https://www.zabbix.com/download?zabbix=6.0&os_distribution=rocky_linux&os_version=8&components=server_frontend_agent&db=mysql&ws=nginx

  1. # rpm -Uvh https://repo.zabbix.com/zabbix/6.0/rhel/8/x86_64/zabbix-release-6.0-4.el8.noarch.rpm
  2. # dnf clean all
  3. # dnf install zabbix-server-mysql zabbix-web-mysql zabbix-nginx-conf zabbix-sql-scripts zabbix-selinux-policy zabbix-agent
  4. # mysql -uroot -p
  5. password
  6. mysql> create database zabbix character set utf8mb4 collate utf8mb4_bin;
  7. mysql> create user zabbix@localhost identified by 'password';
  8. mysql> grant all privileges on zabbix.* to zabbix@localhost;
  9. mysql> set global log_bin_trust_function_creators = 1;
  10. mysql> quit;
  11. # zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix
  12. # mysql -uroot -p
  13. password
  14. mysql> set global log_bin_trust_function_creators = 0;
  15. mysql> quit;
  16. DBPassword=password
  17. # listen 8080;
  18. # server_name example.com;
  19. # systemctl restart zabbix-server zabbix-agent nginx php-fpm
  20. # systemctl enable zabbix-server zabbix-agent nginx php-fpm

2)编写配置文件（注：可以只加需要的选项没有必要都加）

  1. UserParameter=MySQL.Sort-scan,python3 /usr/local/src/MySQL_Zabbix.py kt
  2. UserParameter=MySQL.slave-stopped,python3 /usr/local/src/MySQL_Zabbix.py jh
  3. UserParameter=MySQL.Com-replace,python3 /usr/local/src/MySQL_Zabbix.py jz
  4. UserParameter=MySQL.innodb-lock-structs,python3 /usr/local/src/MySQL_Zabbix.py lp
  5. UserParameter=MySQL.Com-load,python3 /usr/local/src/MySQL_Zabbix.py kg
  6. UserParameter=MySQL.State-updating,python3 /usr/local/src/MySQL_Zabbix.py mi
  7. UserParameter=MySQL.Aborted-clients,python3 /usr/local/src/MySQL_Zabbix.py ip
  8. UserParameter=MySQL.innodb-lock-wait-secs,python3 /usr/local/src/MySQL_Zabbix.py ni
  9. UserParameter=MySQL.Handler-read-key,python3 /usr/local/src/MySQL_Zabbix.py mr
  10. UserParameter=MySQL.file-reads,python3 /usr/local/src/MySQL_Zabbix.py gy
  11. UserParameter=MySQL.Query-time-count-12,python3 /usr/local/src/MySQL_Zabbix.py ox
  12. UserParameter=MySQL.relay-log-space,python3 /usr/local/src/MySQL_Zabbix.py lj
  13. UserParameter=MySQL.Threads-connected,python3 /usr/local/src/MySQL_Zabbix.py iu
  14. UserParameter=MySQL.Qcache-lowmem-prunes,python3 /usr/local/src/MySQL_Zabbix.py jp
  15. UserParameter=MySQL.Binlog-cache-use,python3 /usr/local/src/MySQL_Zabbix.py lm
  16. UserParameter=MySQL.State-freeing-items,python3 /usr/local/src/MySQL_Zabbix.py lt
  17. UserParameter=MySQL.Query-time-count-10,python3 /usr/local/src/MySQL_Zabbix.py ov
  18. UserParameter=MySQL.read-views,python3 /usr/local/src/MySQL_Zabbix.py gm
  19. UserParameter=MySQL.Bytes-received,python3 /usr/local/src/MySQL_Zabbix.py ky
  20. UserParameter=MySQL.os-waits,python3 /usr/local/src/MySQL_Zabbix.py hv
  21. UserParameter=MySQL.Handler-commit,python3 /usr/local/src/MySQL_Zabbix.py mm
  22. UserParameter=MySQL.Com-select,python3 /usr/local/src/MySQL_Zabbix.py jx
  23. UserParameter=MySQL.Qcache-total-blocks,python3 /usr/local/src/MySQL_Zabbix.py js
  24. UserParameter=MySQL.Handler-read-prev,python3 /usr/local/src/MySQL_Zabbix.py mt
  25. UserParameter=MySQL.Sort-rows,python3 /usr/local/src/MySQL_Zabbix.py ks
  26. UserParameter=MySQL.Qcache-free-memory,python3 /usr/local/src/MySQL_Zabbix.py jm
  27. UserParameter=MySQL.pages-read,python3 /usr/local/src/MySQL_Zabbix.py gu
  28. UserParameter=MySQL.Key-read-requests,python3 /usr/local/src/MySQL_Zabbix.py gg
  29. UserParameter=MySQL.State-other,python3 /usr/local/src/MySQL_Zabbix.py ml
  30. UserParameter=MySQL.Qcache-inserts,python3 /usr/local/src/MySQL_Zabbix.py jo
  31. UserParameter=MySQL.State-none,python3 /usr/local/src/MySQL_Zabbix.py mk
  32. UserParameter=MySQL.pending-normal-aio-writes,python3 /usr/local/src/MySQL_Zabbix.py hp
  33. UserParameter=MySQL.hash-index-cells-total,python3 /usr/local/src/MySQL_Zabbix.py nj
  34. UserParameter=MySQL.pool-size,python3 /usr/local/src/MySQL_Zabbix.py gq
  35. UserParameter=MySQL.pending-ibuf-aio-reads,python3 /usr/local/src/MySQL_Zabbix.py hl
  36. UserParameter=MySQL.Handler-write,python3 /usr/local/src/MySQL_Zabbix.py ng
  37. UserParameter=MySQL.innodb-sem-waits,python3 /usr/local/src/MySQL_Zabbix.py ny
  38. UserParameter=MySQL.Handler-savepoint-rollback,python3 /usr/local/src/MySQL_Zabbix.py my
  39. UserParameter=MySQL.Query-time-total-01,python3 /usr/local/src/MySQL_Zabbix.py pg
  40. UserParameter=MySQL.Query-time-total-00,python3 /usr/local/src/MySQL_Zabbix.py oz
  41. UserParameter=MySQL.Table-locks-waited,python3 /usr/local/src/MySQL_Zabbix.py ig
  42. UserParameter=MySQL.Handler-rollback,python3 /usr/local/src/MySQL_Zabbix.py mw
  43. UserParameter=MySQL.unflushed-log,python3 /usr/local/src/MySQL_Zabbix.py lg
  44. UserParameter=MySQL.Query-time-total-04,python3 /usr/local/src/MySQL_Zabbix.py pj
  45. UserParameter=MySQL.Query-time-total-07,python3 /usr/local/src/MySQL_Zabbix.py pm
  46. UserParameter=MySQL.Handler-savepoint,python3 /usr/local/src/MySQL_Zabbix.py mx
  47. UserParameter=MySQL.Query-time-total-09,python3 /usr/local/src/MySQL_Zabbix.py po
  48. UserParameter=MySQL.Query-time-total-08,python3 /usr/local/src/MySQL_Zabbix.py pn
  49. UserParameter=MySQL.Select-range-check,python3 /usr/local/src/MySQL_Zabbix.py ko
  50. UserParameter=MySQL.Threads-running,python3 /usr/local/src/MySQL_Zabbix.py iw
  51. UserParameter=MySQL.State-init,python3 /usr/local/src/MySQL_Zabbix.py lu
  52. UserParameter=MySQL.Aborted-connects,python3 /usr/local/src/MySQL_Zabbix.py iq
  53. UserParameter=MySQL.Handler-read-first,python3 /usr/local/src/MySQL_Zabbix.py mq
  54. UserParameter=MySQL.Created-tmp-tables,python3 /usr/local/src/MySQL_Zabbix.py ku
  55. UserParameter=MySQL.Created-tmp-disk-tables,python3 /usr/local/src/MySQL_Zabbix.py kv
  56. UserParameter=MySQL.Select-full-range-join,python3 /usr/local/src/MySQL_Zabbix.py km
  57. UserParameter=MySQL.Connections,python3 /usr/local/src/MySQL_Zabbix.py iz
  58. UserParameter=MySQL.Com-insert,python3 /usr/local/src/MySQL_Zabbix.py jw
  59. UserParameter=MySQL.Query-time-total-11,python3 /usr/local/src/MySQL_Zabbix.py pq
  60. UserParameter=MySQL.innodb-transactions,python3 /usr/local/src/MySQL_Zabbix.py gl
  61. UserParameter=MySQL.State-sorting-result,python3 /usr/local/src/MySQL_Zabbix.py mg
  62. UserParameter=MySQL.State-statistics,python3 /usr/local/src/MySQL_Zabbix.py mh
  63. UserParameter=MySQL.innodb-locked-tables,python3 /usr/local/src/MySQL_Zabbix.py lo
  64. UserParameter=MySQL.log-bytes-written,python3 /usr/local/src/MySQL_Zabbix.py li
  65. UserParameter=MySQL.innodb-log-buffer-size,python3 /usr/local/src/MySQL_Zabbix.py kz
  66. UserParameter=MySQL.Select-full-join,python3 /usr/local/src/MySQL_Zabbix.py kl
  67. UserParameter=MySQL.locked-transactions,python3 /usr/local/src/MySQL_Zabbix.py go
  68. UserParameter=MySQL.Handler-read-rnd,python3 /usr/local/src/MySQL_Zabbix.py mu
  69. UserParameter=MySQL.Handler-delete,python3 /usr/local/src/MySQL_Zabbix.py mn
  70. UserParameter=MySQL.Query-time-total-13,python3 /usr/local/src/MySQL_Zabbix.py ps
  71. UserParameter=MySQL.Query-time-total-10,python3 /usr/local/src/MySQL_Zabbix.py pp
  72. UserParameter=MySQL.Key-buf-bytes-used,python3 /usr/local/src/MySQL_Zabbix.py oh
  73. UserParameter=MySQL.Com-delete-multi,python3 /usr/local/src/MySQL_Zabbix.py kj
  74. UserParameter=MySQL.Select-range,python3 /usr/local/src/MySQL_Zabbix.py kn
  75. UserParameter=MySQL.pending-aio-log-ios,python3 /usr/local/src/MySQL_Zabbix.py hh
  76. UserParameter=MySQL.ibuf-inserts,python3 /usr/local/src/MySQL_Zabbix.py hq
  77. UserParameter=MySQL.State-copying-to-tmp-table,python3 /usr/local/src/MySQL_Zabbix.py lr
  78. UserParameter=MySQL.Com-replace-select,python3 /usr/local/src/MySQL_Zabbix.py kk
  79. UserParameter=MySQL.modified-pages,python3 /usr/local/src/MySQL_Zabbix.py gt
  80. UserParameter=MySQL.Com-delete,python3 /usr/local/src/MySQL_Zabbix.py jy
  81. UserParameter=MySQL.Threads-cached,python3 /usr/local/src/MySQL_Zabbix.py it
  82. UserParameter=MySQL.hash-index-cells-used,python3 /usr/local/src/MySQL_Zabbix.py nk
  83. UserParameter=MySQL.uncheckpointed-bytes,python3 /usr/local/src/MySQL_Zabbix.py nn
  84. UserParameter=MySQL.Query-time-total-12,python3 /usr/local/src/MySQL_Zabbix.py pr
  85. UserParameter=MySQL.Qcache-hits,python3 /usr/local/src/MySQL_Zabbix.py jn
  86. UserParameter=MySQL.Questions,python3 /usr/local/src/MySQL_Zabbix.py ju
  87. UserParameter=MySQL.Qcache-queries-in-cache,python3 /usr/local/src/MySQL_Zabbix.py jr
  88. UserParameter=MySQL.key-buffer-size,python3 /usr/local/src/MySQL_Zabbix.py oi
  89. UserParameter=MySQL.total-mem-alloc,python3 /usr/local/src/MySQL_Zabbix.py nl
  90. UserParameter=MySQL.spin-rounds,python3 /usr/local/src/MySQL_Zabbix.py hu
  91. UserParameter=MySQL.ibuf-merged,python3 /usr/local/src/MySQL_Zabbix.py hr
  92. UserParameter=MySQL.rows-inserted,python3 /usr/local/src/MySQL_Zabbix.py hw
  93. UserParameter=MySQL.file-fsyncs,python3 /usr/local/src/MySQL_Zabbix.py gx
  94. UserParameter=MySQL.Bytes-sent,python3 /usr/local/src/MySQL_Zabbix.py kx
  95. UserParameter=MySQL.Query-time-total-03,python3 /usr/local/src/MySQL_Zabbix.py pi
  96. UserParameter=MySQL.ibuf-merges,python3 /usr/local/src/MySQL_Zabbix.py hs
  97. UserParameter=MySQL.Query-time-total-02,python3 /usr/local/src/MySQL_Zabbix.py ph
  98. UserParameter=MySQL.pool-reads,python3 /usr/local/src/MySQL_Zabbix.py qo
  99. UserParameter=MySQL.history-list,python3 /usr/local/src/MySQL_Zabbix.py gk
  100. UserParameter=MySQL.Query-time-total-05,python3 /usr/local/src/MySQL_Zabbix.py pk
  101. UserParameter=MySQL.rows-updated,python3 /usr/local/src/MySQL_Zabbix.py hx
  102. UserParameter=MySQL.max-connections,python3 /usr/local/src/MySQL_Zabbix.py ix
  103. UserParameter=MySQL.free-pages,python3 /usr/local/src/MySQL_Zabbix.py gr
  104. UserParameter=MySQL.Select-scan,python3 /usr/local/src/MySQL_Zabbix.py kp
  105. UserParameter=MySQL.pending-aio-sync-ios,python3 /usr/local/src/MySQL_Zabbix.py hi
  106. UserParameter=MySQL.recovery-system-memory,python3 /usr/local/src/MySQL_Zabbix.py nw
  107. UserParameter=MySQL.Query-time-total-06,python3 /usr/local/src/MySQL_Zabbix.py pl
  108. UserParameter=MySQL.innodb-sem-wait-time-ms,python3 /usr/local/src/MySQL_Zabbix.py nz
  109. UserParameter=MySQL.thread-hash-memory,python3 /usr/local/src/MySQL_Zabbix.py nx
  110. UserParameter=MySQL.dictionary-cache-memory,python3 /usr/local/src/MySQL_Zabbix.py nt
  111. UserParameter=MySQL.ibuf-used-cells,python3 /usr/local/src/MySQL_Zabbix.py no
  112. UserParameter=MySQL.State-end,python3 /usr/local/src/MySQL_Zabbix.py ls
  113. UserParameter=MySQL.slave-running,python3 /usr/local/src/MySQL_Zabbix.py jg
  114. UserParameter=MySQL.pending-normal-aio-reads,python3 /usr/local/src/MySQL_Zabbix.py ho
  115. UserParameter=MySQL.Innodb-row-lock-waits,python3 /usr/local/src/MySQL_Zabbix.py ok
  116. UserParameter=MySQL.active-transactions,python3 /usr/local/src/MySQL_Zabbix.py gp
  117. UserParameter=MySQL.Sort-range,python3 /usr/local/src/MySQL_Zabbix.py kr
  118. UserParameter=MySQL.spin-waits,python3 /usr/local/src/MySQL_Zabbix.py ht
  119. UserParameter=MySQL.Slow-queries,python3 /usr/local/src/MySQL_Zabbix.py ii
  120. UserParameter=MySQL.ibuf-cell-count,python3 /usr/local/src/MySQL_Zabbix.py nq
  121. UserParameter=MySQL.Qcache-free-blocks,python3 /usr/local/src/MySQL_Zabbix.py jl
  122. UserParameter=MySQL.Sort-merge-passes,python3 /usr/local/src/MySQL_Zabbix.py kq
  123. UserParameter=MySQL.thread-cache-size,python3 /usr/local/src/MySQL_Zabbix.py iy
  124. UserParameter=MySQL.Key-write-requests,python3 /usr/local/src/MySQL_Zabbix.py gi
  125. UserParameter=MySQL.pending-buf-pool-flushes,python3 /usr/local/src/MySQL_Zabbix.py hj
  126. UserParameter=MySQL.pending-log-writes,python3 /usr/local/src/MySQL_Zabbix.py hn
  127. UserParameter=MySQL.Com-update-multi,python3 /usr/local/src/MySQL_Zabbix.py kh
  128. UserParameter=MySQL.State-login,python3 /usr/local/src/MySQL_Zabbix.py lw
  129. UserParameter=MySQL.State-reading-from-net,python3 /usr/local/src/MySQL_Zabbix.py ly
  130. UserParameter=MySQL.State-locked,python3 /usr/local/src/MySQL_Zabbix.py lv
  131. UserParameter=MySQL.log-bytes-flushed,python3 /usr/local/src/MySQL_Zabbix.py lh
  132. UserParameter=MySQL.ibuf-free-cells,python3 /usr/local/src/MySQL_Zabbix.py np
  133. UserParameter=MySQL.Qcache-not-cached,python3 /usr/local/src/MySQL_Zabbix.py jq
  134. UserParameter=MySQL.pending-log-flushes,python3 /usr/local/src/MySQL_Zabbix.py hm
  135. UserParameter=MySQL.Max-used-connections,python3 /usr/local/src/MySQL_Zabbix.py ir
  136. UserParameter=MySQL.State-sending-data,python3 /usr/local/src/MySQL_Zabbix.py lz
  137. UserParameter=MySQL.rows-read,python3 /usr/local/src/MySQL_Zabbix.py hz
  138. UserParameter=MySQL.lock-system-memory,python3 /usr/local/src/MySQL_Zabbix.py nv
  139. UserParameter=MySQL.Handler-read-rnd-next,python3 /usr/local/src/MySQL_Zabbix.py mv
  140. UserParameter=MySQL.table-cache,python3 /usr/local/src/MySQL_Zabbix.py io
  141. UserParameter=MySQL.rows-deleted,python3 /usr/local/src/MySQL_Zabbix.py hy
  142. UserParameter=MySQL.file-system-memory,python3 /usr/local/src/MySQL_Zabbix.py nu
  143. UserParameter=MySQL.file-writes,python3 /usr/local/src/MySQL_Zabbix.py gz
  144. UserParameter=MySQL.pending-chkp-writes,python3 /usr/local/src/MySQL_Zabbix.py hk
  145. UserParameter=MySQL.additional-pool-alloc,python3 /usr/local/src/MySQL_Zabbix.py nm
  146. UserParameter=MySQL.current-transactions,python3 /usr/local/src/MySQL_Zabbix.py gn
  147. UserParameter=MySQL.Key-reads,python3 /usr/local/src/MySQL_Zabbix.py gh
  148. UserParameter=MySQL.Handler-read-next,python3 /usr/local/src/MySQL_Zabbix.py ms
  149. UserParameter=MySQL.Key-writes,python3 /usr/local/src/MySQL_Zabbix.py gj
  150. UserParameter=MySQL.Query-time-count-01,python3 /usr/local/src/MySQL_Zabbix.py om
  151. UserParameter=MySQL.pool-read-requests,python3 /usr/local/src/MySQL_Zabbix.py qp
  152. UserParameter=MySQL.Open-tables,python3 /usr/local/src/MySQL_Zabbix.py ik
  153. UserParameter=MySQL.Query-time-count-13,python3 /usr/local/src/MySQL_Zabbix.py oy
  154. UserParameter=MySQL.Com-insert-select,python3 /usr/local/src/MySQL_Zabbix.py ki
  155. UserParameter=MySQL.Query-time-count-11,python3 /usr/local/src/MySQL_Zabbix.py ow
  156. UserParameter=MySQL.Query-time-count-03,python3 /usr/local/src/MySQL_Zabbix.py oo
  157. UserParameter=MySQL.slave-lag,python3 /usr/local/src/MySQL_Zabbix.py jj
  158. UserParameter=MySQL.Handler-update,python3 /usr/local/src/MySQL_Zabbix.py mz
  159. UserParameter=MySQL.Created-tmp-files,python3 /usr/local/src/MySQL_Zabbix.py kw
  160. UserParameter=MySQL.Key-buf-bytes-unflushed,python3 /usr/local/src/MySQL_Zabbix.py og
  161. UserParameter=MySQL.State-preparing,python3 /usr/local/src/MySQL_Zabbix.py lx
  162. UserParameter=MySQL.Binlog-cache-disk-use,python3 /usr/local/src/MySQL_Zabbix.py ll
  163. UserParameter=MySQL.Slave-open-temp-tables,python3 /usr/local/src/MySQL_Zabbix.py jk
  164. UserParameter=MySQL.innodb-tables-in-use,python3 /usr/local/src/MySQL_Zabbix.py nh
  165. UserParameter=MySQL.Threads-created,python3 /usr/local/src/MySQL_Zabbix.py iv
  166. UserParameter=MySQL.Slave-retried-transactions,python3 /usr/local/src/MySQL_Zabbix.py ji
  167. UserParameter=MySQL.State-writing-to-net,python3 /usr/local/src/MySQL_Zabbix.py mj
  168. UserParameter=MySQL.pages-created,python3 /usr/local/src/MySQL_Zabbix.py gv
  169. UserParameter=MySQL.Opened-tables,python3 /usr/local/src/MySQL_Zabbix.py il
  170. UserParameter=MySQL.pages-written,python3 /usr/local/src/MySQL_Zabbix.py gw
  171. UserParameter=MySQL.database-pages,python3 /usr/local/src/MySQL_Zabbix.py gs
  172. UserParameter=MySQL.query-cache-size,python3 /usr/local/src/MySQL_Zabbix.py jt
  173. UserParameter=MySQL.page-hash-memory,python3 /usr/local/src/MySQL_Zabbix.py ns
  174. UserParameter=MySQL.Innodb-row-lock-time,python3 /usr/local/src/MySQL_Zabbix.py oj
  175. UserParameter=MySQL.Table-locks-immediate,python3 /usr/local/src/MySQL_Zabbix.py ih
  176. UserParameter=MySQL.binary-log-space,python3 /usr/local/src/MySQL_Zabbix.py ln
  177. UserParameter=MySQL.Com-update,python3 /usr/local/src/MySQL_Zabbix.py jv
  178. UserParameter=MySQL.Query-time-count-00,python3 /usr/local/src/MySQL_Zabbix.py ol
  179. UserParameter=MySQL.adaptive-hash-memory,python3 /usr/local/src/MySQL_Zabbix.py nr
  180. UserParameter=MySQL.Query-time-count-02,python3 /usr/local/src/MySQL_Zabbix.py on
  181. UserParameter=MySQL.log-writes,python3 /usr/local/src/MySQL_Zabbix.py hg
  182. UserParameter=MySQL.Query-time-count-04,python3 /usr/local/src/MySQL_Zabbix.py op
  183. UserParameter=MySQL.Query-time-count-05,python3 /usr/local/src/MySQL_Zabbix.py oq
  184. UserParameter=MySQL.Query-time-count-06,python3 /usr/local/src/MySQL_Zabbix.py or
  185. UserParameter=MySQL.Query-time-count-07,python3 /usr/local/src/MySQL_Zabbix.py os
  186. UserParameter=MySQL.Query-time-count-08,python3 /usr/local/src/MySQL_Zabbix.py ot
  187. UserParameter=MySQL.Query-time-count-09,python3 /usr/local/src/MySQL_Zabbix.py ou
  188. UserParameter=MySQL.Open-files,python3 /usr/local/src/MySQL_Zabbix.py ij
  189. UserParameter=MySQL.State-closing-tables,python3 /usr/local/src/MySQL_Zabbix.py lq
  190. UserParameter=MySQL.running-slave,python3 /usr/local/src/MySQL_Zabbix.py running-slave

3）编写Python脚本

  1. #vim MySQL_Zabbix.py 
  2.  
  3.  
  4. #!/usr/bin/python3
  5. #
  6. #****************************************************
  7. #Author:           caojidong
  8. #QQ:               1549396190
  9. #Date:             2022-2-31
  10. #FileName:         MySQL_Zabbix.py
  11. #cell-phone number:               13739548267
  12. #Description:      test
  13. #Copyright(C):     2022 All right
  14. #***************************************************
  15. #!/bin/bash env
  16. #_*_coding:utf8_*_
  17.  
  18.  
  19. import MySQLdb
  20. import re
  21. import sys
  22. import json
  23. import os
  24. import datetime
  25. import time
  26.  
  27.  
  28. mysql_user = 'root' #数据库的根用户
  29. mysql_pass = 'xxxxx' #用户密码
  30. mysql_host = 'xxxxxxxxx'#mysql所在服务器的ip
  31. mysql_port = 3306 #端口号
  32. mysql_socket = "/tmp.msyql.sock"
  33. mysql_flags = 0;
  34. mysql_ssl  = False  # Whether to use SSL to connect to MySQL.
  35. mysql_ssl_key  = '/etc/pki/tls/certs/mysql/client-key.pem'
  36. mysql_ssl_cert = '/etc/pki/tls/certs/mysql/client-cert.pem'
  37. mysql_ssl_ca   = '/etc/pki/tls/certs/mysql/ca-cert.pem'
  38. mysql_connection_timeout = 5
  39.  
  40. heartbeat = False      
  41. heartbeat_utc = False   
  42. heartbeat_table = 'percona.heartbeat'	
  43. heartbeat_server_id = 0 
  44.  
  45. cache_dir  = '/tmp' 
  46. poll_time  = 300    
  47. timezone   = None  
  48. chk_options =  {
  49.    'innodb'  : True,   
  50.    'master'  : True,    
  51.    'slave'   : True,    
  52.    'procs'   : True,   
  53.    'get_qrt' : True,   
  54. }
  55.  
  56. use_ss    = False 
  57. debug     = False 
  58. debug_log = False 
  59.  
  60.  
  61. version = '8.0' #MySQL的版本号
  62.  
  63.  
  64. def ss_get_mysql_stats(*args, **kwargs):
  65.     global debug, mysql_user, mysql_pass, cache_dir, poll_time, chk_options
  66.     global mysql_port, mysql_socket, mysql_flags
  67.     global mysql_ssl, mysql_ssl_key, mysql_ssl_cert, mysql_ssl_ca
  68.     global mysql_connection_timeout
  69.     global heartbeat, heartbeat_table, heartbeat_server_id, heartbeat_utc
  70.  
  71.     user= kwargs.get('user') if kwargs.has_key('user') else mysql_user
  72.     passwd = kwargs.get('passwd') if kwargs.has_key('passwd') else mysql_pass
  73.     host= kwargs.get('host') if kwargs.has_key('host') else mysql_host
  74.     port = kwargs.get('port') if kwargs.has_key('port') else mysql_port
  75.     socket = kwargs.get('socket') if kwargs.has_key('socket') else mysql_socket
  76.     flags = kwargs.get('flags') if kwargs.has_key('flags') else mysql_flags
  77.     connection_timeout = kwargs.get('connection-timeout') if kwargs.has_key('connection-timeout') else mysql_connection_timeout
  78.     heartbeat_server_id = kwargs.get('heartbeat_server_id') if kwargs.has_key('heartbeat_server_id') else heartbeat_server_id
  79.  
  80.     sanitized_host= host.replace(":","/").replace("","_")
  81.     cache_file = "/tmp/mysql_zabbix_monitor_cache"
  82.  
  83.     fp =None
  84.     if cache_dir and not kwargs.has_key('nocache'):
  85.         if not os.path.exists(cache_file):
  86.             fp = open(cache_file,'wb',)
  87.         else:
  88.             cache_file_ctime = os.stat(cache_file).st_ctime
  89.             current_time = time.time()
  90.             if int(current_time - cache_file_ctime) < 300:
  91.                 fp = open(cache_file,'rb')
  92.                 output_dic = json.load(fp)
  93.                 return output_dic
  94.             else:
  95.                 fp = open(cache_file,'wb')
  96.     else:
  97.         fp = None
  98.  
  99.     #connect to MySQL
  100.     conn = MySQLdb.Connect(host=host,port=port,user=user,passwd=passwd,unix_socket=mysql_socket)
  101.     cursor = conn.cursor()
  102.     """
  103.     //ssl 相关设定
  104.     获取mysql版本信息
  105.     """
  106.     #设置变量
  107.     status = {
  108.         'relay_log_space'            : 0 ,
  109.         'binary_log_space'           : 0,
  110.         'current_transactions'       : 0,
  111.         'locked_transactions'        : 0,
  112.         'active_transactions'        : 0,
  113.         'innodb_locked_tables'       : 0,
  114.         'innodb_tables_in_use'       : 0,
  115.         'innodb_lock_structs'        : 0,
  116.         'innodb_lock_wait_secs'      : 0,
  117.         'innodb_sem_waits'           : 0,
  118.         'innodb_sem_wait_time_ms'    : 0,
  119.         #
  120.         'State_closing_tables'       : 0,
  121.         'State_copying_to_tmp_table' : 0,
  122.         'State_end'                  : 0,
  123.         'State_freeing_items'        : 0,
  124.         'State_init'                 : 0,
  125.         'State_locked'               : 0,
  126.         'State_login'                : 0,
  127.         'State_preparing'            : 0,
  128.         'State_reading_from_net'     : 0,
  129.         'State_sending_data'         : 0,
  130.         'State_sorting_result'       : 0,
  131.         'State_statistics'           : 0,
  132.         'State_updating'             : 0,
  133.         'State_writing_to_net'       : 0,
  134.         'State_none'                 : 0,
  135.         'State_other'                : 0,
  136.     }
  137.     # Get SHOW STATUS and convert the name-value array into a simple
  138.     # associative array.
  139.     cursor.execute("SHOW /*!50002 GLOBAL */ STATUS")
  140.     for item in cursor.fetchall():
  141.         status[item[0]] = item[1]
  142.  
  143.     # Get SHOW VARIABLES and do the same thing, adding it to the $status array.
  144.     cursor.execute('SHOW VARIABLES')
  145.     for item in cursor.fetchall():
  146.         status[item[0]] = item[1]
  147.  
  148.  
  149.    
  150.     #监控mysql主从状态
  151.  
  152.     if chk_options['master']:
  153.         pass
  154.  
  155.  
  156.  
  157.     #返回的不是字典，根据自己实际情况调整
  158.     if chk_options['procs']:
  159.         cursor.execute('SHOW PROCESSLIST')
  160.         for item in cursor.fetchall():
  161.             state = item[6] if item[6] else None
  162.  
  163.  
  164.  
  165.     engines = {}
  166.     cursor.execute("SHOW ENGINES")
  167.     for item in cursor.fetchall():
  168.         engines[item[0]] = item[1]
  169.  
  170.  
  171.  
  172.  
  173.     if chk_options.get('innodb') and engines.has_key('InnoDB') and engines['InnoDB'] == 'DEFAULT':
  174.         cursor.execute("SHOW /*!50000 ENGINE*/ INNODB STATUS")
  175.         innodb_status_txt = cursor.fetchall()[0][2]
  176.         result = get_innodb_array(innodb_status_txt,None)
  177.         for item in result.keys():
  178.             status[item] = result.get(item)
  179.  
  180.  
  181.  
  182.     if status.get('table_open_cache'):
  183.         status['table_cache'] = status.get('table_open_cache')
  184.    
  185.     status['Key_buf_bytes_used'] = big_sub(status['key_buffer_size'],
  186.                                            big_multiply(status['Key_blocks_unused'],status['key_cache_block_size']))
  187.     status['Key_buf_bytes_unflushed'] = big_multiply(status['Key_blocks_not_flushed'],
  188.                                                      status['key_cache_block_size'])
  189.  
  190.     if status.has_key('unflushed_log') and status.get('unflushed_log'):
  191.         status['unflushed_log'] = max(status['unflushed_log'],status['innodb_log_buffer_size'])
  192.  
  193.  
  194.     keys = {
  195.       'Key_read_requests'           :  'gg',
  196.       'Key_reads'                   :  'gh',
  197.       'Key_write_requests'          :  'gi',
  198.       'Key_writes'                  :  'gj',
  199.       'history_list'                :  'gk',
  200.       'innodb_transactions'         :  'gl',
  201.       'read_views'                  :  'gm',
  202.       'current_transactions'        :  'gn',
  203.       'locked_transactions'         :  'go',
  204.       'active_transactions'         :  'gp',
  205.       'pool_size'                   :  'gq',
  206.       'free_pages'                  :  'gr',
  207.       'database_pages'              :  'gs',
  208.       'modified_pages'              :  'gt',
  209.       'pages_read'                  :  'gu',
  210.       'pages_created'               :  'gv',
  211.       'pages_written'               :  'gw',
  212.       'file_fsyncs'                 :  'gx',
  213.       'file_reads'                  :  'gy',
  214.       'file_writes'                 :  'gz',
  215.       'log_writes'                  :  'hg',
  216.       'pending_aio_log_ios'         :  'hh',
  217.       'pending_aio_sync_ios'        :  'hi',
  218.       'pending_buf_pool_flushes'    :  'hj',
  219.       'pending_chkp_writes'         :  'hk',
  220.       'pending_ibuf_aio_reads'      :  'hl',
  221.       'pending_log_flushes'         :  'hm',
  222.       'pending_log_writes'          :  'hn',
  223.       'pending_normal_aio_reads'    :  'ho',
  224.       'pending_normal_aio_writes'   :  'hp',
  225.       'ibuf_inserts'                :  'hq',
  226.       'ibuf_merged'                 :  'hr',
  227.       'ibuf_merges'                 :  'hs',
  228.       'spin_waits'                  :  'ht',
  229.       'spin_rounds'                 :  'hu',
  230.       'os_waits'                    :  'hv',
  231.       'rows_inserted'               :  'hw',
  232.       'rows_updated'                :  'hx',
  233.       'rows_deleted'                :  'hy',
  234.       'rows_read'                   :  'hz',
  235.       'Table_locks_waited'          :  'ig',
  236.       'Table_locks_immediate'       :  'ih',
  237.       'Slow_queries'                :  'ii',
  238.       'Open_files'                  :  'ij',
  239.       'Open_tables'                 :  'ik',
  240.       'Opened_tables'               :  'il',
  241.       'innodb_open_files'           :  'im',
  242.       'open_files_limit'            :  'in',
  243.       'table_cache'                 :  'io',
  244.       'Aborted_clients'             :  'ip',
  245.       'Aborted_connects'            :  'iq',
  246.       'Max_used_connections'        :  'ir',
  247.       'Slow_launch_threads'         :  'is',
  248.       'Threads_cached'              :  'it',
  249.       'Threads_connected'           :  'iu',
  250.       'Threads_created'             :  'iv',
  251.       'Threads_running'             :  'iw',
  252.       'max_connections'             :  'ix',
  253.       'thread_cache_size'           :  'iy',
  254.       'Connections'                 :  'iz',
  255.       'slave_running'               :  'jg',
  256.       'slave_stopped'               :  'jh',
  257.       'Slave_retried_transactions'  :  'ji',
  258.       'slave_lag'                   :  'jj',
  259.       'Slave_open_temp_tables'      :  'jk',
  260.       'Qcache_free_blocks'          :  'jl',
  261.       'Qcache_free_memory'          :  'jm',
  262.       'Qcache_hits'                 :  'jn',
  263.       'Qcache_inserts'              :  'jo',
  264.       'Qcache_lowmem_prunes'        :  'jp',
  265.       'Qcache_not_cached'           :  'jq',
  266.       'Qcache_queries_in_cache'     :  'jr',
  267.       'Qcache_total_blocks'         :  'js',
  268.       'query_cache_size'            :  'jt',
  269.       'Questions'                   :  'ju',
  270.       'Com_update'                  :  'jv',
  271.       'Com_insert'                  :  'jw',
  272.       'Com_select'                  :  'jx',
  273.       'Com_delete'                  :  'jy',
  274.       'Com_replace'                 :  'jz',
  275.       'Com_load'                    :  'kg',
  276.       'Com_update_multi'            :  'kh',
  277.       'Com_insert_select'           :  'ki',
  278.       'Com_delete_multi'            :  'kj',
  279.       'Com_replace_select'          :  'kk',
  280.       'Select_full_join'            :  'kl',
  281.       'Select_full_range_join'      :  'km',
  282.       'Select_range'                :  'kn',
  283.       'Select_range_check'          :  'ko',
  284.       'Select_scan'                 :  'kp',
  285.       'Sort_merge_passes'           :  'kq',
  286.       'Sort_range'                  :  'kr',
  287.       'Sort_rows'                   :  'ks',
  288.       'Sort_scan'                   :  'kt',
  289.       'Created_tmp_tables'          :  'ku',
  290.       'Created_tmp_disk_tables'     :  'kv',
  291.       'Created_tmp_files'           :  'kw',
  292.       'Bytes_sent'                  :  'kx',
  293.       'Bytes_received'              :  'ky',
  294.       'innodb_log_buffer_size'      :  'kz',
  295.       'unflushed_log'               :  'lg',
  296.       'log_bytes_flushed'           :  'lh',
  297.       'log_bytes_written'           :  'li',
  298.       'relay_log_space'             :  'lj',
  299.       'binlog_cache_size'           :  'lk',
  300.       'Binlog_cache_disk_use'       :  'll',
  301.       'Binlog_cache_use'            :  'lm',
  302.       'binary_log_space'            :  'ln',
  303.       'innodb_locked_tables'        :  'lo',
  304.       'innodb_lock_structs'         :  'lp',
  305.       'State_closing_tables'        :  'lq',
  306.       'State_copying_to_tmp_table'  :  'lr',
  307.       'State_end'                   :  'ls',
  308.       'State_freeing_items'         :  'lt',
  309.       'State_init'                  :  'lu',
  310.       'State_locked'                :  'lv',
  311.       'State_login'                 :  'lw',
  312.       'State_preparing'             :  'lx',
  313.       'State_reading_from_net'      :  'ly',
  314.       'State_sending_data'          :  'lz',
  315.       'State_sorting_result'        :  'mg',
  316.       'State_statistics'            :  'mh',
  317.       'State_updating'              :  'mi',
  318.       'State_writing_to_net'        :  'mj',
  319.       'State_none'                  :  'mk',
  320.       'State_other'                 :  'ml',
  321.       'Handler_commit'              :  'mm',
  322.       'Handler_delete'              :  'mn',
  323.       'Handler_discover'            :  'mo',
  324.       'Handler_prepare'             :  'mp',
  325.       'Handler_read_first'          :  'mq',
  326.       'Handler_read_key'            :  'mr',
  327.       'Handler_read_next'           :  'ms',
  328.       'Handler_read_prev'           :  'mt',
  329.       'Handler_read_rnd'            :  'mu',
  330.       'Handler_read_rnd_next'       :  'mv',
  331.       'Handler_rollback'            :  'mw',
  332.       'Handler_savepoint'           :  'mx',
  333.       'Handler_savepoint_rollback'  :  'my',
  334.       'Handler_update'              :  'mz',
  335.       'Handler_write'               :  'ng',
  336.       'innodb_tables_in_use'        :  'nh',
  337.       'innodb_lock_wait_secs'       :  'ni',
  338.       'hash_index_cells_total'      :  'nj',
  339.       'hash_index_cells_used'       :  'nk',
  340.       'total_mem_alloc'             :  'nl',
  341.       'additional_pool_alloc'       :  'nm',
  342.       'uncheckpointed_bytes'        :  'nn',
  343.       'ibuf_used_cells'             :  'no',
  344.       'ibuf_free_cells'             :  'np',
  345.       'ibuf_cell_count'             :  'nq',
  346.       'adaptive_hash_memory'        :  'nr',
  347.       'page_hash_memory'            :  'ns',
  348.       'dictionary_cache_memory'     :  'nt',
  349.       'file_system_memory'          :  'nu',
  350.       'lock_system_memory'          :  'nv',
  351.       'recovery_system_memory'      :  'nw',
  352.       'thread_hash_memory'          :  'nx',
  353.       'innodb_sem_waits'            :  'ny',
  354.       'innodb_sem_wait_time_ms'     :  'nz',
  355.       'Key_buf_bytes_unflushed'     :  'og',
  356.       'Key_buf_bytes_used'          :  'oh',
  357.       'key_buffer_size'             :  'oi',
  358.       'Innodb_row_lock_time'        :  'oj',
  359.       'Innodb_row_lock_waits'       :  'ok',
  360.       'Query_time_count_00'         :  'ol',
  361.       'Query_time_count_01'         :  'om',
  362.       'Query_time_count_02'         :  'on',
  363.       'Query_time_count_03'         :  'oo',
  364.       'Query_time_count_04'         :  'op',
  365.       'Query_time_count_05'         :  'oq',
  366.       'Query_time_count_06'         :  'or',
  367.       'Query_time_count_07'         :  'os',
  368.       'Query_time_count_08'         :  'ot',
  369.       'Query_time_count_09'         :  'ou',
  370.       'Query_time_count_10'         :  'ov',
  371.       'Query_time_count_11'         :  'ow',
  372.       'Query_time_count_12'         :  'ox',
  373.       'Query_time_count_13'         :  'oy',
  374.       'Query_time_total_00'         :  'oz',
  375.       'Query_time_total_01'         :  'pg',
  376.       'Query_time_total_02'         :  'ph',
  377.       'Query_time_total_03'         :  'pi',
  378.       'Query_time_total_04'         :  'pj',
  379.       'Query_time_total_05'         :  'pk',
  380.       'Query_time_total_06'         :  'pl',
  381.       'Query_time_total_07'         :  'pm',
  382.       'Query_time_total_08'         :  'pn',
  383.       'Query_time_total_09'         :  'po',
  384.       'Query_time_total_10'         :  'pp',
  385.       'Query_time_total_11'         :  'pq',
  386.       'Query_time_total_12'         :  'pr',
  387.       'Query_time_total_13'         :  'ps',
  388.       'wsrep_replicated_bytes'      :  'pt',
  389.       'wsrep_received_bytes'        :  'pu',
  390.       'wsrep_replicated'            :  'pv',
  391.       'wsrep_received'              :  'pw',
  392.       'wsrep_local_cert_failures'   :  'px',
  393.       'wsrep_local_bf_aborts'       :  'py',
  394.       'wsrep_local_send_queue'      :  'pz',
  395.       'wsrep_local_recv_queue'      :  'qg',
  396.       'wsrep_cluster_size'          :  'qh',
  397.       'wsrep_cert_deps_distance'    :  'qi',
  398.       'wsrep_apply_window'          :  'qj',
  399.       'wsrep_commit_window'         :  'qk',
  400.       'wsrep_flow_control_paused'   :  'ql',
  401.       'wsrep_flow_control_sent'     :  'qm',
  402.       'wsrep_flow_control_recv'     :  'qn',
  403.       'pool_reads'                  :  'qo',
  404.       'pool_read_requests'          :  'qp',
  405.     };
  406.  
  407.  
  408.     output_dic = {}
  409.     for key in keys.keys():
  410.         val = str(status[key]) if status.has_key(key) else "-1"
  411.         output_dic[keys.get(key)] = val
  412.  
  413.     if fp is not None:
  414.         json.dump(output_dic,fp)
  415.     return output_dic
  416.     """
  417.     write to log
  418.     """
  419.  
  420. def big_multiply(left, right, force = None):
  421.     left = float(left) if left is not None else 0
  422.     right = float(right) if right is not None else 0
  423.     if force == 'bc':
  424.         return int(left-right)
  425.     else:
  426.         return int(left*right)
  427.  
  428. def big_sub(left, right, force = None):
  429.     left = float(left) if left is not None else 0
  430.     right = float(right) if right is not None else 0
  431.     return int(left-right)
  432.  
  433. def big_add(left,right,force =None):
  434.     left = float(left) if left is not None else 0
  435.     right = float(right) if right is not None else 0
  436.     if force == 'bc':
  437.         return int(left+right)
  438.     return int(left+right)
  439.  
  440.  
  441.  
  442. def get_innodb_array(text, mysql_version):
  443.     mysql_version = 57000
  444.     results  = {
  445.       'spin_waits'  : [],
  446.       'spin_rounds' : [],
  447.       'os_waits'    : [],
  448.       'pending_normal_aio_reads'  : -1,
  449.       'pending_normal_aio_writes' : -1,
  450.       'pending_ibuf_aio_reads'    : -1,
  451.       'pending_aio_log_ios'       : -1,
  452.       'pending_aio_sync_ios'      : -1,
  453.       'pending_log_flushes'       : -1,
  454.       'pending_buf_pool_flushes'  : -1,
  455.       'file_reads'                : -1,
  456.       'file_writes'               : -1,
  457.       'file_fsyncs'               : -1,
  458.       'ibuf_inserts'              : -1,
  459.       'ibuf_merged'               : -1,
  460.       'ibuf_merges'               : -1,
  461.       'log_bytes_written'         : -1,
  462.       'unflushed_log'             : -1,
  463.       'log_bytes_flushed'         : -1,
  464.       'pending_log_writes'        : -1,
  465.       'pending_chkp_writes'       : -1,
  466.       'log_writes'                : -1,
  467.       'pool_size'                 : -1,
  468.       'free_pages'                : -1,
  469.       'database_pages'            : -1,
  470.       'modified_pages'            : -1,
  471.       'pages_read'                : -1,
  472.       'pages_created'             : -1,
  473.       'pages_written'             : -1,
  474.       'queries_inside'            : -1,
  475.       'queries_queued'            : -1,
  476.       'read_views'                : -1,
  477.       'rows_inserted'             : -1,
  478.       'rows_updated'              : -1,
  479.       'rows_deleted'              : -1,
  480.       'rows_read'                 : -1,
  481.       'innodb_transactions'       : -1,
  482.       'unpurged_txns'             : -1,
  483.       'history_list'              : -1,
  484.       'current_transactions'      : -1,
  485.       'hash_index_cells_total'    : -1,
  486.       'hash_index_cells_used'     : -1,
  487.       'total_mem_alloc'           : -1,
  488.       'additional_pool_alloc'     : -1,
  489.       'last_checkpoint'           : -1,
  490.       'uncheckpointed_bytes'      : -1,
  491.       'ibuf_used_cells'           : -1,
  492.       'ibuf_free_cells'           : -1,
  493.       'ibuf_cell_count'           : -1,
  494.       'adaptive_hash_memory'      : -1,
  495.       'page_hash_memory'          : -1,
  496.       'dictionary_cache_memory'   : -1,
  497.       'file_system_memory'        : -1,
  498.       'lock_system_memory'        : -1,
  499.       'recovery_system_memory'    : -1,
  500.       'thread_hash_memory'        : -1,
  501.       'innodb_sem_waits'          : -1,
  502.       'innodb_sem_wait_time_ms'   : -1,
  503.     };
  504.     txn_seen = False
  505.     for line in text.split('\n'):
  506.         line = line.strip()
  507.         row = re.split(' ',line)
  508.  
  509.         # SEMAPHORES
  510.         if line.find('Mutex spin waits') == 0:
  511.             #['Mutex', 'spin', 'waits', '90,', 'rounds', '2700,', 'OS', 'waits', '82']
  512.             results['spin_waits'] = int(row[3].strip(','))
  513.             results['spin_rounds'] = int(row[5].strip(','))
  514.             results['os_waits'] = int(row[8].strip(','))
  515.         elif line.find("RW-shared spins") == 0 and line.find(";") > 0:
  516.             # RW-shared spins 3859028, OS waits 2100750; RW-excl spins 4641946, OS waits 1530310
  517.             results['spin_waits'] = int(row[2].strip(','))
  518.             results['spin_waits'] = int(row[8].strip(','))
  519.             results['os_waits'] = int(row[5].strip(';'))
  520.             results['os_waits'] = int(row[11].strip(';'))
  521.         elif line.find("RW-shared spins") == 0:
  522.             #['RW-shared', 'spins', '2826,', 'rounds', '84780,', 'OS', 'waits', '2814']
  523.             results['spin_waits'] = int(row[2].strip(','))
  524.             results['spin_rounds'] = int(row[4].strip(','))
  525.             results['os_waits'] = int(row[7].strip(','))
  526.         elif line.find("RW-shared spins") == 0 and line.find("RW-excl spins") < 0:
  527.             #RW-shared spins 604733, rounds 8107431, OS waits 241268
  528.             results['spin_waits'] = int(row[2].strip(','))
  529.             results['spin_rounds'] = int(row[4].strip(';'))
  530.             results['os_waits'] = int(row[7].strip(';'))
  531.         elif line.find("RW-excl spins") == 0:
  532.             #['RW-excl', 'spins', '2,', 'rounds', '2040,', 'OS', 'waits', '68']
  533.             results['spin_waits'] = int(row[2].strip(','))
  534.             results['spin_rounds'] = int(row[4].strip(','))
  535.             results['os_waits'] = int(row[7].strip(','))
  536.         elif line.find("seconds the semaphore:") > 0:
  537.             # --Thread 907205 has waited at handler/ha_innodb.cc line 7156 for 1.00 seconds the semaphore:
  538.             results['innodb_sem_waits'] = 1
  539.             results['innodb_sem_wait_time_ms'] = int(row[9].strip(','))*100
  540.         # TRANSACTIONS
  541.         elif line.find("Trx id counter") == 0:
  542.             if mysql_version < 50600:
  543.                 # For versions prior 5.6: two decimals or one hex
  544.                 # Trx id counter 0 1170664159
  545.                 # Trx id counter 861B144C
  546.                 results['innodb_transactions'] = max(int(row[3].strip(',')),int(row[4].strip(','))) if row[4] else int(row[3].strip(','),16)
  547.             else:
  548.                 results['innodb_transactions'] = int(row[3].strip(','))
  549.             txn_seen = True
  550.         elif line.find("Purge done for trx") == 0:
  551.             #['Purge', 'done', 'for', "trx's", 'n:o', '<', '214608', 'undo', 'n:o', '<', '0', 'state:', 'running', 'but','idle']
  552.             if mysql_version < 506000:
  553.                 # For versions prior 5.6: two decimals or one hex
  554.                 # Purge done for trx's n:o < 0 1170663853 undo n:o < 0 0
  555.                 # Purge done for trx's n:o < 861B135D undo n:o < 0
  556.                 purged_to = int(row[6].strip(','),16) if row[7] == 'undo' else max(int(row[6].strip(','),16),int(row[6].strip(','),16))
  557.             else:
  558.                 # For versions 5.6+ and MariaDB 10.x: one decimal
  559.                 # Purge done for trx's n:o < 2903354 undo n:o < 0 state: running but idle
  560.                 purged_to = int(row[6].strip(','),16)
  561.             results['unpurged_txns'] = big_sub(results['innodb_transactions'],purged_to)
  562.         elif txn_seen and line.find("---TRANSACTION") == 0:
  563.             results['current_transactions'] = 1
  564.             if line.find('ACTIVE') >= 0:
  565.                 results['active_transactions'] = 1
  566.         elif txn_seen and line.find("------- TRX HAS BEEN") == 0:
  567.             # ------- TRX HAS BEEN WAITING 32 SEC FOR THIS LOCK TO BE GRANTED:
  568.             results['innodb_lock_wait_secs'] = int(row[5].strip((',')))
  569.         elif line.find("read views open inside InnoDB") > 0:
  570.             # 1 read views open inside InnoDB
  571.             #['0', 'read', 'views', 'open', 'inside', 'InnoDB']
  572.             results['read_views'] = int(row[0])
  573.         elif line.find("mysql tables in use") == 0:
  574.             # mysql tables in use 2, locked 2
  575.             results['innodb_tables_in_user'] = int(row[4].strip(','))
  576.             results['innodb_locked_tables'] = int(row[6].strip(','))
  577.         elif txn_seen and line.find("lock struct(s)") > 0:
  578.             # 23 lock struct(s), heap size 3024, undo log entries 27
  579.             # LOCK WAIT 12 lock struct(s), heap size 3024, undo log entries 5
  580.             # LOCK WAIT 2 lock struct(s), heap size 368
  581.             if line.find("LOCK WAIT") == 0:
  582.                 results['innodb_lock_structs'] = int(row[2].strip(','))
  583.                 results['locked_transactions'] = 1
  584.             else:
  585.                 results['innodb_lock_structs'] = int(row[0].strip(','))
  586.  
  587.         # FILE I/O
  588.         elif line.find("OS file reads") > 0:
  589.             #['1186', 'OS', 'file', 'reads,', '68341', 'OS', 'file', 'writes,', '33879', 'OS', 'fsyncs']
  590.             results['file_reads'] = int(row[0])
  591.             results['file_writes'] = int(row[4])
  592.             results['file_fsyncs'] = int(row[8])
  593.         elif line.find("Pending normal aio reads:") == 0:
  594.             #['Pending', 'normal', 'aio', 'reads:', '0', '[0,', '0,', '0,', '0]', ',', 'aio', 'writes:', '0', '[0,', '0,', '0,', '0]', ',']
  595.             results['pending_normal_aio_reads'] = int(row[4])
  596.             results['pending_normal_aio_writes'] = int(row[12])
  597.         elif line.find("ibuf aio reads") == 0:
  598.             #['ibuf', 'aio', 'reads:', '0,', 'log', "i/o's:", '0,', 'sync', "i/o's:", '0']
  599.             results['pending_ibuf_aio_reads'] = int(row[3].strip(','))
  600.             results['pending_aio_log_ios'] = int(row[6].strip(','))
  601.             results['pending_aio_sync_ios'] = int(row[9].strip(','))
  602.         elif line.find("Pending flushes (fsync)") == 0:
  603.             #['Pending', 'flushes', '(fsync)', 'log:', '0;', 'buffer', 'pool:', '0']
  604.             results['pending_log_flushes'] = int(row[4].strip(';'))
  605.             results['pending_buf_pool_flushes'] = int(row[7])
  606.         elif line.find("Ibuf for space 0: size") >= 0:
  607.             # Older InnoDB code seemed to be ready for an ibuf per tablespace.  It
  608.             # had two lines in the output.  Newer has just one line, see below.
  609.             # Ibuf for space 0: size 1, free list len 887, seg size 889, is not empty
  610.             # Ibuf for space 0: size 1, free list len 887, seg size 889,
  611.             results['ibuf_used_cells'] = int(row[5].strip(':').strip(','))
  612.             results['ibuf_free_cells'] = int(row[9].strip(';').strip(','))
  613.             results['ibuf_cell_count'] = int(row[12].strip(';').strip(','))
  614.         elif line.find("Ibuf: size") == 0:
  615.             #['Ibuf:', 'size', '1,', 'free', 'list', 'len', '0,', 'seg', 'size', '2,', '40', 'merges']
  616.             results['ibuf_used_cells'] = int(row[2].strip(','))
  617.             results['ibuf_free_cells'] = int(row[6].strip(','))
  618.             results['ibuf_cell_count'] = int(row[9].strip(','))
  619.             if line.find('merges') > 0:
  620.                 results['ibuf_merges'] = int(row[10].strip(','))
  621.         # elif line.find("merged operations:") == 0 and line.find('delete mark') >= 0:
  622.         #     pass
  623.         elif line.find(', delete mark') >= 0 :
  624.             #['insert', '44,', 'delete', 'mark', '0,', 'delete', '0']
  625.             results['ibuf_inserts'] = int(row[1].strip(','))
  626.             results['ibuf_merged'] = int(row[1].strip(',')) + int(row[4].strip(',')) + int(row[6].strip(','))
  627.  
  628.         elif line.find(" merged recs, ") > 0:
  629.             # 19817685 inserts, 19817684 merged recs, 3552620 merges
  630.             results['ibuf_inserts'] = int(row[0].strip(','))
  631.             results['ibuf_merged'] = int(row[2].strip(','))
  632.             results['ibuf_merges'] = int(row[5].strip(','))
  633.         elif line.find('Hash table size') == 0:
  634.             #['Hash', 'table', 'size', '276707,', 'node', 'heap', 'has', '33', 'buffer(s)']
  635.             results['hash_index_cells_total'] = int(row[3].strip(','))
  636.             results['hash_index_cells_used'] = int(row[7].strip(','))
  637.         elif line.find(" log i/o's done, ")> 0:
  638.             #['24255', 'log', "i/o's", 'done,', '0.83', 'log', "i/o's/second"]
  639.             results['log_writes'] = int(row[0])
  640.         elif line.find(" pending log writes, ") > 0:
  641.             #['0', 'pending', 'log', 'writes,', '0', 'pending', 'chkp', 'writes']
  642.             results['pending_log_writes'] = int(row[0])
  643.             results['pending_chkp_writes'] = int(row[4])
  644.         elif line.find("Log sequence number") == 0:
  645.             # Log sequence number 13093949495856 //plugin
  646.             # Log sequence number 125 3934414864 //normal
  647.             #['Log', 'sequence', 'number', '25184569']
  648.             if len(row) > 4:
  649.                 results['log_bytes_written'] = max(int(row[3]),int(row[4]))
  650.             else:
  651.                 results['log_bytes_written'] = int(row[3])
  652.         elif line.find("Log flushed up to") >= 0:
  653.             #['Log', 'flushed', 'up', 'to', '', '', '25255663']
  654.             # Log flushed up to   13093948219327
  655.             # Log flushed up to   125 3934414864
  656.             if len(row) > 8:
  657.                 results['log_bytes_flushed'] = max(int(row[6]),int(row[7]))
  658.             else:
  659.                 results['log_bytes_flushed'] = int(row[6])
  660.         elif line.find("Total memory allocated") >= 0 and line.find("in additional pool allocated") > 0:
  661.             #['Total', 'memory', 'allocated', '137363456;', 'in', 'additional', 'pool', 'allocated', '0']
  662.             results['total_mem_alloc'] = int(row[3].strip(';'))
  663.             results['additional_pool_alloc'] = int(row[8])
  664.         elif line.find("Adaptive hash index ") == 0:
  665.             #Adaptive hash index 1538240664 	(186998824 + 1351241840)
  666.             results['active_transactions'] = int(row[3])
  667.         elif line.find("Page hash     ") >=0 :
  668.             ##   Page hash           11688584
  669.             #results['page_hash_memory'] = int(row[2])
  670.             pass
  671.         elif line.find("Dictionary cache") >= 0:
  672.             #   Page hash           11688584
  673.             #results['page_hash_memory'] = int(row[2])
  674.             pass
  675.         elif line.find("File system") >= 0:
  676.             #   File system         313848 	(82672 + 231176)
  677.             #results['file_system_memory'] = to_int(row[2])
  678.             pass
  679.         elif line.find("Lock system") >= 0:
  680.             #   Lock system         29232616 	(29219368 + 13248)
  681.             #results['lock_system_memory'] = int(row[2])
  682.             pass
  683.         elif line.find("Recovery system") >= 0:
  684.             #   Recovery system     0 	(0 + 0)
  685.             #results['recovery_system_memory'] = int(row[2]);
  686.             pass
  687.         elif line.find("Threads            ") >= 0:
  688.             #   Threads             409336 	(406936 + 2400)
  689.             #results['thread_hash_memory'] = int(row[1]);
  690.             pass
  691.         elif line.find("innodb_io_pattern   ") >= 0:
  692.             #   innodb_io_pattern   0 	(0 + 0)
  693.             #results['innodb_io_pattern_memory'] = int(row[1]);
  694.             pass
  695.         elif line.find("Buffer pool size ") >= 0:
  696.             #['Buffer', 'pool', 'size', '', '', '8192']
  697.             # The " " after size is necessary to avoid matching the wrong line:
  698.             # Buffer pool size        1769471
  699.             # Buffer pool size, bytes 28991012864
  700.             results['pool_size'] = int(row[5])
  701.         elif line.find("Database pages") >= 0:
  702.             #['Database', 'pages', '', '', '', '', '994']
  703.             results['database_pages'] = int(row[6])
  704.         elif line.find("Modified db pages") >= 0:
  705.             #['Modified', 'db', 'pages', '', '45']
  706.             results['modified_pages'] = int(row[4])
  707.         elif line.find("Pages read ahead") >= 0:
  708.             #['Pages', 'read', 'ahead', '0.00/s,', 'evicted', 'without', 'access', '0.00/s,', 'Random', 'read', 'ahead', '0.00/s']
  709.             ## Must do this BEFORE the next test, otherwise it'll get fooled by this
  710.             # line from the new plugin (see samples/innodb-015.txt):
  711.             # Pages read ahead 0.00/s, evicted without access 0.06/s
  712.             # TODO: No-op for now, see issue 134.
  713.             pass
  714.         elif line.find("Pages read") == 0:
  715.             #['Pages', 'read', '845,', 'created', '149,', 'written', '53991']
  716.             results['pages_read'] = int(row[2].strip(','))
  717.             results['pages_created'] = int(row[4].strip(','))
  718.             results['pages_written'] = int(row[6].strip(','))
  719.         elif line.find("Number of rows inserted") == 0:
  720.             #['Number', 'of', 'rows', 'inserted', '16243,', 'updated', '7859,', 'deleted', '10849,', 'read', '1488153']
  721.             results['rows_inserted'] = int(row[4].strip(','))
  722.             results['rows_updated'] = int(row[6].strip(','))
  723.             results['rows_deleted'] = int(row[8].strip(','))
  724.             results['rows_read'] = int(row[10].strip(','))
  725.         elif line.find(" queries inside InnoDB, ") >= 0:
  726.             #['0', 'queries', 'inside', 'InnoDB,', '0', 'queries', 'in', 'queue']
  727.             results['queries_inside'] = int(row[0])
  728.             results['queries_queued'] = int(row[4])
  729.     for key in ['spin_waits','spin_rounds','os_waits']:
  730.         results[key] = int(results[key])
  731.     return results
  732.  
  733.  
  734. def main(*args,**kwargs):
  735.     status_out = ss_get_mysql_stats()
  736.  
  737.  
  738.     result = status_out.get(sys.argv[1]) if status_out.has_key(sys.argv[1]) else '-1'
  739.     print result
  740.  
  741.  
  742. if __name__ == "__main__":
  743.     main()

4)增加权限

chmod +x MySQL_Zabbix.py

5)重启服务生效

systemctl restart zabbix-agent2

MIT License

注：一下是原创的license请务必遵守，开发不易，谢谢

MIT License

Copyright (c) 2017 

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/article/detail/49213
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号