MySQL Main performance indicators

1.mysql connections->threads cached->threads cachedmysql connections->threads  cached->threads connected (number of connections used, connection pool) mysql connections->threads cached-> Connections per second2. Table cache, number of tables already open 3. Number of files opened 4.qps/tpsshow status like  ' queries ' Qps:query per second, query volume per second show status like  ' Com_commit ' tps:transaction per  Second, amount of things per second tps =  (Com_commit + com_rollback)  / Seconds5.DML  The Persecond icon corresponds to Mysql innodb rows 6.transaction persecond (mysql innodb transactions ) commit/rollback7.innodb  (Mysql innodb buffer pool) innodb buffer pool  readsinnodb buffer pool pages flushed8.key bufferkey buffer read  Ratekey buffer write ratekey blocks used rate9.networkbytes_received,bytes_ Sent10.abortedaborted_clients,aborted_connects11. Mysql innodb, mysql innodb buffer pooldatabase pages    innodb  buffer pool pages datafree pages    innodb buffer pool  Pages freemodified pages   innodb rows modified per second12. Mysql performancemysqltransactions handlerhandler commit  innodb transaction  Committinghandler rollback  InnoDB Transaction Rolling Backhandler  savepoint handler savepoint rollbackinnodb last checkpoint at per  second  (mysql innodb, mysql innodb log file) 13.MySQLProcesslist specific as follows show  processlist;show full processlist;show open tables;show status like  '%lock% ' show engine innodb status\g;show variables like  '%timeout% '; 1. Thread Pool thread_cache_ Size = 32thread_stAck = 512k#innodb_file_io_threads = 8innodb_thread_concurrency = 16#thread_stack  = 192k#thread_concurrency = 128 pay particular attention to the following monitoring items mysql innodb buffer poolpool  Size database pages    innodb buffer pool pages datafree  pages     InnoDB Buffer Pool Pages Freemodified  pagesuserparameter=mysql.pool-size,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  gquserparameter=mysql.modified-pages,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  gtuserparameter=mysql.free-pages,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  gruserparameter=mysql.database-pages,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gs  Mysqltransactions handlerhandler commit  innodb transaction committinghandler  rollback  innodb transaction roLling backhandler savepoint handler savepoint rollback  userparameter= Mysql.handler-rollback,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh mwuserparameter= Mysql.modified-pages,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh gtuserparameter= mysql.handler-savepoint-rollback,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  myuserparameter=mysql.handler-savepoint,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  mxuserparameter=mysql.handler-commit,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh mm  mysqlprocesslistuserparameter=mysql.state-updating,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  miuserparameter=mysql.state-freeing-items,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  ltUserParameter=MySQL.State-other,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  Mluserparameter=mysql.state-none,/var/lib/zabbix/percona/scripTs/get_mysql_stats_wrapper.sh mkuserparameter=mysql.state-init,/var/lib/zabbix/percona/scripts/get_mysql_ Stats_wrapper.sh luuserparameter=mysql.state-sorting-result,/var/lib/zabbix/percona/scripts/get_mysql_ Stats_wrapper.sh mguserparameter=mysql.state-statistics,/var/lib/zabbix/percona/scripts/get_mysql_stats_ Wrapper.sh mhuserparameter=mysql.state-copying-to-tmp-table,/var/lib/zabbix/percona/scripts/get_mysql_ Stats_wrapper.sh lruserparameter=mysql.state-end,/var/lib/zabbix/percona/scripts/get_mysql_stats_ wrapper.sh lsuserparameter=mysql.state-login,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  lwuserparameter=mysql.state-reading-from-net,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  lyUserParameter=MySQL.State-locked,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  lvuserparameter=mysql.state-sending-data,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh  Lzuserparameter=mysql.state-preparing,/var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh lxuserparameter=mysql.state-writing-to-net,/ Var/lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh mjuserparameter=mysql.state-closing-tables,/var /lib/zabbix/percona/scripts/get_mysql_stats_wrapper.sh lq  5.6last ("Mysql.innodb[Innodb_node_ Heap_buffers] ", 0) *last (" mysql.status[innodb_page_size] ", 0)    (mysql innodb) Last (" Qcache_used_ Blocks ", 0)/last (" Mysql.status[qcache_queries_in_cache] ", 0)    (mysql query cache) Last (" Qcache_used_memory ", 0)/last (" Qcache_used_blocks ", 0) (Mysql query cache) Last (" Mysql.status[qcache_ Total_blocks] ", 0)-last (" Mysql.status[qcache_used_blocks ", 0)   (mysql query cache)

This article is from the "Python Operation" blog, declined reprint!

MySQL Main performance indicators