Aborted clients | 7 7 | 因客户端没有关闭毗连而中止的毗连数。。。 |
|---|
| Aborted connects | 601.9 k601865 | 实验毗连到 MySQL 效劳器但失败的毗连数。。。 |
|---|
| Access denied errors | 601.8 k601830 | |
|---|
| Acl column grants | 00 | |
|---|
| Acl database grants | 4 4 | |
|---|
| Acl function grants | 00 | |
|---|
| Acl procedure grants | 00 | |
|---|
| Acl proxy users | 1 1 | |
|---|
| Acl role grants | 00 | |
|---|
| Acl roles | 00 | |
|---|
| Acl table grants | 00 | |
|---|
| Acl users | 6 6 | |
|---|
| Aria pagecache blocks not flushed | 00 | |
|---|
| Aria pagecache blocks unused | 16 k15962 | |
|---|
| Aria pagecache blocks used | 52 52 | |
|---|
| Aria pagecache read requests | 20.8 M20845420 | |
|---|
| Aria pagecache reads | 2.1 M2100918 | |
|---|
| Aria pagecache write requests | 3.5 M3491569 | |
|---|
| Aria pagecache writes | 00 | |
|---|
| Aria transaction log syncs | 00 | |
|---|
| Binlog commits | 00 | |
|---|
| Binlog group commits | 00 | |
|---|
| Binlog group commit trigger count | 00 | |
|---|
| Binlog group commit trigger lock wait | 00 | |
|---|
| Binlog group commit trigger timeout | 00 | |
|---|
| Binlog snapshot file | | |
|---|
| Binlog snapshot position | 00 | |
|---|
| Binlog bytes written | 00 | |
|---|
| Binlog cache disk use | 00 | 因事务使用的暂时二进制日志缓存凌驾 binlog_cache_size 的设置而使用暂时文件存储的数目。。。 |
|---|
| Binlog cache use | 00 | 事务所用的暂时二进制日志缓存的数目。。。 |
|---|
| Binlog stmt cache disk use | 00 | |
|---|
| Binlog stmt cache use | 00 | |
|---|
| Busy time | 00.000000 | |
|---|
| Bytes received | 393.7 G393655832935 | |
|---|
| Bytes sent | 8.6 T8639741860024 | |
|---|
| Com admin commands | 37.9 M37903276 | |
|---|
| Com alter db | 00 | |
|---|
| Com alter db upgrade | 00 | |
|---|
| Com alter event | 00 | |
|---|
| Com alter function | 00 | |
|---|
| Com alter procedure | 00 | |
|---|
| Com alter server | 00 | |
|---|
| Com alter table | 00 | |
|---|
| Com alter tablespace | 00 | |
|---|
| Com analyze | 00 | |
|---|
| Com assign to keycache | 00 | |
|---|
| Com begin | 00 | |
|---|
| Com binlog | 00 | |
|---|
| Com call procedure | 00 | |
|---|
| Com change db | 17.3 M17345243 | |
|---|
| Com change master | 00 | |
|---|
| Com check | 00 | |
|---|
| Com checksum | 00 | |
|---|
| Com commit | 00 | |
|---|
| Com compound sql | 00 | |
|---|
| Com create db | 00 | |
|---|
| Com create event | 00 | |
|---|
| Com create function | 00 | |
|---|
| Com create index | 00 | |
|---|
| Com create procedure | 00 | |
|---|
| Com create role | 00 | |
|---|
| Com create server | 00 | |
|---|
| Com create table | 00 | |
|---|
| Com create temporary table | 00 | |
|---|
| Com create trigger | 00 | |
|---|
| Com create udf | 00 | |
|---|
| Com create user | 00 | |
|---|
| Com create view | 00 | |
|---|
| Com delete | 12 M12025389 | |
|---|
| Com delete multi | 00 | |
|---|
| Com do | 00 | |
|---|
| Com drop db | 00 | |
|---|
| Com drop event | 00 | |
|---|
| Com drop function | 00 | |
|---|
| Com drop index | 00 | |
|---|
| Com drop procedure | 00 | |
|---|
| Com drop role | 00 | |
|---|
| Com drop server | 00 | |
|---|
| Com drop table | 00 | |
|---|
| Com drop temporary table | 00 | |
|---|
| Com drop trigger | 00 | |
|---|
| Com drop user | 00 | |
|---|
| Com drop view | 00 | |
|---|
| Com empty query | 00 | |
|---|
| Com flush | 1.5 M1502441 | |
|---|
| Com get diagnostics | 00 | |
|---|
| Com grant | 00 | |
|---|
| Com grant role | 00 | |
|---|
| Com ha close | 00 | |
|---|
| Com ha open | 00 | |
|---|
| Com ha read | 00 | |
|---|
| Com help | 00 | |
|---|
| Com insert | 10.5 M10530152 | |
|---|
| Com insert select | 00 | |
|---|
| Com install plugin | 00 | |
|---|
| Com kill | 00 | |
|---|
| Com load | 00 | |
|---|
| Com lock tables | 00 | |
|---|
| Com optimize | 00 | |
|---|
| Com preload keys | 00 | |
|---|
| Com purge | 00 | |
|---|
| Com purge before date | 00 | |
|---|
| Com release savepoint | 00 | |
|---|
| Com rename table | 00 | |
|---|
| Com rename user | 00 | |
|---|
| Com repair | 00 | |
|---|
| Com replace | 704 704 | |
|---|
| Com replace select | 00 | |
|---|
| Com reset | 00 | |
|---|
| Com resignal | 00 | |
|---|
| Com revoke | 00 | |
|---|
| Com revoke all | 00 | |
|---|
| Com revoke role | 00 | |
|---|
| Com rollback | 00 | |
|---|
| Com rollback to savepoint | 00 | |
|---|
| Com savepoint | 00 | |
|---|
| Com select | 3.5 G3470668751 | |
|---|
| Com set option | 48.1 M48133916 | |
|---|
| Com show authors | 00 | |
|---|
| Com show binlog events | 00 | |
|---|
| Com show binlogs | 21.1 k21097 | |
|---|
| Com show charsets | 00 | |
|---|
| Com show collations | 00 | |
|---|
| Com show contributors | 00 | |
|---|
| Com show create db | 00 | |
|---|
| Com show create event | 00 | |
|---|
| Com show create func | 00 | |
|---|
| Com show create proc | 00 | |
|---|
| Com show create table | 170.8 k170834 | |
|---|
| Com show create trigger | 00 | |
|---|
| Com show databases | 5 5 | |
|---|
| Com show engine logs | 00 | |
|---|
| Com show engine mutex | 00 | |
|---|
| Com show engine status | 00 | |
|---|
| Com show errors | 00 | |
|---|
| Com show events | 00 | |
|---|
| Com show explain | 00 | |
|---|
| Com show fields | 1.8 M1810165 | |
|---|
| Com show function status | 00 | |
|---|
| Com show generic | 00 | |
|---|
| Com show grants | 40.7 k40682 | |
|---|
| Com show keys | 371.3 k371342 | |
|---|
| Com show master status | 43.5 k43497 | |
|---|
| Com show open tables | 00 | |
|---|
| Com show plugins | 48.9 k48934 | |
|---|
| Com show privileges | 00 | |
|---|
| Com show procedure status | 00 | |
|---|
| Com show processlist | 8 k8018 | |
|---|
| Com show profile | 00 | |
|---|
| Com show profiles | 00 | |
|---|
| Com show relaylog events | 00 | |
|---|
| Com show slave hosts | 00 | |
|---|
| Com show slave status | 45.8 k45780 | |
|---|
| Com show status | 22.6 k22573 | |
|---|
| Com show storage engines | 51.1 k51107 | |
|---|
| Com show table status | 97.7 k97653 | |
|---|
| Com show tables | 654.3 k654297 | |
|---|
| Com show triggers | 00 | |
|---|
| Com show variables | 551.5 k551484 | |
|---|
| Com show warnings | 00 | |
|---|
| Com shutdown | 00 | |
|---|
| Com signal | 00 | |
|---|
| Com start all slaves | 00 | |
|---|
| Com start slave | 00 | |
|---|
| Com stmt close | 00 | |
|---|
| Com stmt execute | 00 | |
|---|
| Com stmt fetch | 00 | |
|---|
| Com stmt prepare | 00 | |
|---|
| Com stmt reprepare | 00 | |
|---|
| Com stmt reset | 00 | |
|---|
| Com stmt send long data | 00 | |
|---|
| Com stop all slaves | 00 | |
|---|
| Com stop slave | 00 | |
|---|
| Com truncate | 00 | |
|---|
| Com uninstall plugin | 00 | |
|---|
| Com unlock tables | 00 | |
|---|
| Com update | 9.3 M9279103 | |
|---|
| Com update multi | 00 | |
|---|
| Com xa commit | 00 | |
|---|
| Com xa end | 00 | |
|---|
| Com xa prepare | 00 | |
|---|
| Com xa recover | 00 | |
|---|
| Com xa rollback | 00 | |
|---|
| Com xa start | 00 | |
|---|
| Compression | OFFOFF | |
|---|
| Connection errors accept | 00 | |
|---|
| Connection errors internal | 00 | |
|---|
| Connection errors max connections | 60 60 | |
|---|
| Connection errors peer address | 00 | |
|---|
| Connection errors select | 00 | |
|---|
| Connection errors tcpwrap | 00 | |
|---|
| Connections | 18.7 M18652143 | 实验毗连到 MySQL 效劳器的毗连数 (岂论乐成或失败) 。。。 |
|---|
| Cpu time | 00.000000 | |
|---|
| Created tmp disk tables | 2.2 M2219894 | 效劳器执行语句时自动在磁盘上建设的暂时表的数目。。。若是 Created_tmp_disk_tables 很大，，，，，，你可以增添 tmp_table_size 的值，，，，，，让效劳器使用内存来存储暂时表而非磁盘。。。 |
|---|
| Created tmp files | 5 5 | mysqld 已建设的暂时文件的数目。。。 |
|---|
| Created tmp tables | 20.8 M20794526 | 效劳器执行语句时自动在内存中建设的暂时表的数目。。。 |
|---|
| Delayed errors | 00 | 爆发过失的延迟插入 (INSERT DELAYED) 行数 (可能是由于在唯一字段中保存重复值) 。。。 |
|---|
| Delayed insert threads | 00 | 正在使用的延迟插入处置惩罚线程的数目。。。每张使用延迟插入的表都有自己的线程。。。 |
|---|
| Delayed writes | 00 | 延迟插入已写入的行数。。。 |
|---|
| Delete scan | 00 | |
|---|
| Empty queries | 25.7 M25674451 | |
|---|
| Executed events | 00 | |
|---|
| Executed triggers | 00 | |
|---|
| Feature delay key write | 00 | |
|---|
| Feature dynamic columns | 00 | |
|---|
| Feature fulltext | 00 | |
|---|
| Feature gis | 00 | |
|---|
| Feature locale | 00 | |
|---|
| Feature subquery | 2.7 M2704454 | |
|---|
| Feature timezone | 00 | |
|---|
| Feature trigger | 00 | |
|---|
| Feature xml | 00 | |
|---|
| Flush commands | 1 1 | 已执行的强制更新 (FLUSH) 语句数。。。 |
|---|
| Handler commit | 6.9 M6948259 | 已执行的内部提交 (COMMIT) 语句数。。。 |
|---|
| Handler delete | 6 M6001372 | 从表中删除行的次数。。。 |
|---|
| Handler discover | 52 52 | 若是知道一张表的名字，，，，，，MySQL 效劳器可以询问 NDB 集群存储引擎，，，，，，这被称为“发明”。。。Handler_discovery 批注晰一张表被发明的次数。。。 |
|---|
| Handler external lock | 00 | |
|---|
| Handler icp attempts | 630.3 M630256741 | |
|---|
| Handler icp match | 630.3 M630256741 | |
|---|
| Handler mrr init | 00 | |
|---|
| Handler mrr key refills | 00 | |
|---|
| Handler mrr rowid refills | 00 | |
|---|
| Handler prepare | 00 | |
|---|
| Handler read first | 3.3 M3262843 | 读取一个索引入口点的次数。。。若是该值很大，，，，，，说明你的效劳器执行了许多完整索引扫描。。。例如，，，，，，假设字段 col1 已经建设了索引，，，，，，然后执行 SELECT col1 FROM foo 。。。 |
|---|
| Handler read key | 1.8 G1836098949 | 凭证索引读取行的请求数。。。若是该值很大，，，，，，说明你的盘问和表都建设了很好的索引。。。 |
|---|
| Handler read last | 17 17 | |
|---|
| Handler read next | 1.2 G1206190044 | 凭证索引顺序读取下一行的请求数。。。若是你在盘问一个已索引的字段且限制了规模，，，，，，或举行完整表扫描，，，，，，该值将会一直增添。。。 |
|---|
| Handler read prev | 165.5 M165482429 | 凭证索引顺序读取上一行的请求数。。。这种读取方法通常用于优化带有 ORDER BY … DESC 的盘问。。。 |
|---|
| Handler read retry | 00 | |
|---|
| Handler read rnd | 3.2 G3223730649 | 凭证牢靠位置读取行的请求数。。。若是你执行许多需要排序的盘问，，，，，，该值会很高。。。你可能有许多需要完整表扫描的盘问，，，，，，或者你使用了不准确的索引用来多表盘问。。。 |
|---|
| Handler read rnd deleted | 4.6 M4626095 | |
|---|
| Handler read rnd next | 990.2 M990226100 | 从数据文件中读取行的请求数。。。若是你在扫描许多表，，，，，，该值会很大。。。通常情形下这意味着你的表没有做好索引，，，，，，或者你的盘问语句没有使用好索引字段。。。 |
|---|
| Handler rollback | 86 86 | 内部回滚 (ROLLBACK) 语句数。。。 |
|---|
| Handler savepoint | 00 | |
|---|
| Handler savepoint rollback | 00 | |
|---|
| Handler tmp update | 582.5 M582453992 | |
|---|
| Handler tmp write | 284.3 M284316881 | |
|---|
| Handler update | 4.1 M4104777 | 表中更新行的请求数。。。 |
|---|
| Handler write | 7 M6983345 | 表中插入行的请求数。。。 |
|---|
| Innodb available undo logs | 128 128 | |
|---|
| Innodb background log sync | 47.5 M47491422 | |
|---|
| Innodb buffer pool bytes data | 4.2 M4194304 | |
|---|
| Innodb buffer pool bytes dirty | 00 | |
|---|
| Innodb buffer pool dump status | Dumping buffer pool(s) not yet startedDumping buffer pool(s) not yet started | |
|---|
| Innodb buffer pool load status | Loading buffer pool(s) not yet startedLoading buffer pool(s) not yet started | |
|---|
| Innodb buffer pool pages data | 256 256 | 非空页数 (含脏页) 。。。 |
|---|
| Innodb buffer pool pages dirty | 00 | 目今脏页数。。。 |
|---|
| Innodb buffer pool pages flushed | 32 k31962 | 请求更新的缓冲池页数。。。 |
|---|
| Innodb buffer pool pages free | 766 766 | 空闲页数。。。 |
|---|
| Innodb buffer pool pages lru flushed | 00 | |
|---|
| Innodb buffer pool pages made not young | 00 | |
|---|
| Innodb buffer pool pages made young | 00 | |
|---|
| Innodb buffer pool pages misc | 1 1 | 负载页的数目，，，，，，像锁定行或顺应性的散列索引这样的治理操作时分派的页。。。该值可用此公式盘算： Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data 。。。 |
|---|
| Innodb buffer pool pages old | 00 | |
|---|
| Innodb buffer pool pages total | 1 k1023 | 缓冲池总巨细 (单位：页)。。。 |
|---|
| Innodb buffer pool read ahead | 00 | |
|---|
| Innodb buffer pool read ahead evicted | 00 | |
|---|
| Innodb buffer pool read ahead rnd | 00 | InnoDB 初始化的“随机”预读数。。。这通；；；；嵩诙砸徽疟砭傩写蠊婺５乃婊判蚺涛适北。。。 |
|---|
| Innodb buffer pool read requests | 32.6 M32576109 | InnoDB 完成的逻辑读请求数。。。 |
|---|
| Innodb buffer pool reads | 3.9 k3854 | InnoDB 举行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。。。 |
|---|
| Innodb buffer pool wait free | 00 | 写入 InnoDB 缓冲池通常在后台举行，，，，，，但有须要在没有清洁页的时间读取或建设页，，，，，，有须要先期待页被刷新。。。该计数器统计了这种期待的数目。。。若是缓冲池巨细设置准确，，，，，，这个值应该会很小。。。 |
|---|
| Innodb buffer pool write requests | 38.8 k38842 | 写入 InnoDB 缓冲池的次数。。。 |
|---|
| Innodb checkpoint age | 00 | |
|---|
| Innodb checkpoint max age | 7.8 M7782360 | |
|---|
| Innodb data fsyncs | 113.3 k113252 | fsync() 总操作的次数。。。 |
|---|
| Innodb data pending fsyncs | 00 | 目今挂起 fsync() 操作的数目。。。 |
|---|
| Innodb data pending reads | 00 | 目今挂起的读操作数。。。 |
|---|
| Innodb data pending writes | 00 | 目今挂起的写操作数。。。 |
|---|
| Innodb data read | 63.6 M63623680 | 读取的总数据量 (单位：字节)。。。 |
|---|
| Innodb data reads | 3.9 k3915 | 数据读取总数。。。 |
|---|
| Innodb data writes | 116.7 k116725 | 数据写入总数。。。 |
|---|
| Innodb data written | 1.1 G1079461376 | 写入的总数据量 (单位：字节)。。。 |
|---|
| Innodb dblwr pages written | 32 k31962 | 以双写入操作写入的页数。。。 |
|---|
| Innodb dblwr writes | 27.9 k27942 | 已经执行的双写入次数。。。 |
|---|
| Innodb deadlocks | 00 | |
|---|
| Innodb have atomic builtins | ONON | |
|---|
| Innodb history list length | 1.6 k1569 | |
|---|
| Innodb ibuf discarded delete marks | 00 | |
|---|
| Innodb ibuf discarded deletes | 00 | |
|---|
| Innodb ibuf discarded inserts | 00 | |
|---|
| Innodb ibuf free list | 00 | |
|---|
| Innodb ibuf merged delete marks | 00 | |
|---|
| Innodb ibuf merged deletes | 00 | |
|---|
| Innodb ibuf merged inserts | 00 | |
|---|
| Innodb ibuf merges | 00 | |
|---|
| Innodb ibuf segment size | 2 2 | |
|---|
| Innodb ibuf size | 1 1 | |
|---|
| Innodb log waits | 00 | 因日志缓存太小而必需期待其被写入所造成的期待数。。。 |
|---|
| Innodb log write requests | 10.5 k10491 | 日志写入请求数。。。 |
|---|
| Innodb log writes | 29.2 k29188 | 日志物理写入次数。。。 |
|---|
| Innodb lsn current | 5.6 M5598344 | |
|---|
| Innodb lsn flushed | 5.6 M5598344 | |
|---|
| Innodb lsn last checkpoint | 5.6 M5598344 | |
|---|
| Innodb master thread active loops | 971 971 | |
|---|
| Innodb master thread idle loops | 47.5 M47490511 | |
|---|
| Innodb max trx id | 10.5 M10540588 | |
|---|
| Innodb mem adaptive hash | 297.3 k297300 | |
|---|
| Innodb mem dictionary | 201.9 k201934 | |
|---|
| Innodb mem total | 17.2 M17219584 | |
|---|
| Innodb mutex os waits | 45.6 k45642 | |
|---|
| Innodb mutex spin rounds | 3.3 M3314777 | |
|---|
| Innodb mutex spin waits | 3.8 M3761909 | |
|---|
| Innodb oldest view low limit trx id | 00 | |
|---|
| Innodb os log fsyncs | 56.8 k56814 | 使用 fsync() 写入日志文件的次数。。。 |
|---|
| Innodb os log pending fsyncs | 00 | 目今挂起的 fsync 日志文件数。。。 |
|---|
| Innodb os log pending writes | 00 | 目今挂起的日志写入数。。。 |
|---|
| Innodb os log written | 18 M17986048 | 写入日志文件的字节数。。。 |
|---|
| Innodb page size | 16.4 k16384 | 编译的 InnoDB 页巨细 (默认 16KB)。。。许多值都以页为单位举行统计，，，，，，页巨细可以很利便地将这些值转化为字节数。。。 |
|---|
| Innodb pages created | 88 88 | 建设的页数。。。 |
|---|
| Innodb pages read | 3.9 k3853 | 读取的页数。。。 |
|---|
| Innodb pages0 read | 26 26 | |
|---|
| Innodb pages written | 32 k31962 | 写入的页数。。。 |
|---|
| Innodb purge trx id | 10.5 M10524008 | |
|---|
| Innodb purge undo no | 00 | |
|---|
| Innodb read views memory | 20.7 k20672 | |
|---|
| Innodb row lock current waits | 00 | 正在期待行锁的数目。。。 |
|---|
| Innodb row lock time | 3 3 | 期待获得行锁的总时间 (单位：毫秒)。。。 |
|---|
| Innodb row lock time avg | 1 1 | 期待获得行锁的平均时间 (单位：毫秒)。。。 |
|---|
| Innodb row lock time max | 3 3 | 期待获得行锁的最大时间 (单位：毫秒)。。。 |
|---|
| Innodb row lock waits | 2 2 | 期待行锁的次数。。。 |
|---|
| Innodb rows deleted | 00 | 从 InnoDB 表中删除的行数。。。 |
|---|
| Innodb rows inserted | 2 2 | 插入到 InnoDB 表中的行数。。。 |
|---|
| Innodb rows read | 176.2 k176230 | 从 InnoDB 表中读取的行数。。。 |
|---|
| Innodb rows updated | 2.1 k2087 | InnoDB 中更新的行数。。。 |
|---|
| Innodb system rows deleted | 00 | |
|---|
| Innodb system rows inserted | 00 | |
|---|
| Innodb system rows read | 182 182 | |
|---|
| Innodb system rows updated | 00 | |
|---|
| Innodb s lock os waits | 25.7 k25667 | |
|---|
| Innodb s lock spin rounds | 828.7 k828669 | |
|---|
| Innodb s lock spin waits | 27.6 k27631 | |
|---|
| Innodb truncated status writes | 00 | |
|---|
| Innodb x lock os waits | 11 11 | |
|---|
| Innodb x lock spin rounds | 330 330 | |
|---|
| Innodb x lock spin waits | 1 1 | |
|---|
| Innodb page compression saved | 00 | |
|---|
| Innodb page compression trim sect512 | 00 | |
|---|
| Innodb page compression trim sect1024 | 00 | |
|---|
| Innodb page compression trim sect2048 | 00 | |
|---|
| Innodb page compression trim sect4096 | 00 | |
|---|
| Innodb page compression trim sect8192 | 00 | |
|---|
| Innodb page compression trim sect16384 | 00 | |
|---|
| Innodb page compression trim sect32768 | 00 | |
|---|
| Innodb num index pages written | 652 652 | |
|---|
| Innodb num non index pages written | 116.1 k116073 | |
|---|
| Innodb num pages page compressed | 00 | |
|---|
| Innodb num page compressed trim op | 00 | |
|---|
| Innodb num page compressed trim op saved | 00 | |
|---|
| Innodb num pages page decompressed | 00 | |
|---|
| Innodb num pages page compression error | 00 | |
|---|
| Innodb num pages encrypted | 00 | |
|---|
| Innodb num pages decrypted | 00 | |
|---|
| Innodb have lz4 | OFFOFF | |
|---|
| Innodb have lzo | OFFOFF | |
|---|
| Innodb have lzma | OFFOFF | |
|---|
| Innodb have bzip2 | OFFOFF | |
|---|
| Innodb have snappy | OFFOFF | |
|---|
| Innodb defragment compression failures | 00 | |
|---|
| Innodb defragment failures | 00 | |
|---|
| Innodb defragment count | 00 | |
|---|
| Innodb onlineddl rowlog rows | 00 | |
|---|
| Innodb onlineddl rowlog pct used | 00 | |
|---|
| Innodb onlineddl pct progress | 00 | |
|---|
| Innodb secondary index triggered cluster reads | 00 | |
|---|
| Innodb secondary index triggered cluster reads avoided | 00 | |
|---|
| Innodb encryption rotation pages read from cache | 00 | |
|---|
| Innodb encryption rotation pages read from disk | 00 | |
|---|
| Innodb encryption rotation pages modified | 00 | |
|---|
| Innodb encryption rotation pages flushed | 00 | |
|---|
| Innodb encryption rotation estimated iops | 00 | |
|---|
| Innodb scrub background page reorganizations | 00 | |
|---|
| Innodb scrub background page splits | 00 | |
|---|
| Innodb scrub background page split failures underflow | 00 | |
|---|
| Innodb scrub background page split failures out of filespace | 00 | |
|---|
| Innodb scrub background page split failures missing index | 00 | |
|---|
| Innodb scrub background page split failures unknown | 00 | |
|---|
| Key blocks not flushed | 00 | 键缓存中还没有被写入到磁盘的键块数。。。该值已往名为 Not_flushed_key_blocks 。。。 |
|---|
| Key blocks unused | 6.4 k6440 | 键缓存中未使用的块数。。。你可以凭证这个值判断目今使用了几多键缓存。。。 |
|---|
| Key blocks used | 7.9 k7903 | 键缓存中已经使用的块数。。。该值指示在某个时刻使用了最多块数的数目。。。 |
|---|
| Key blocks warm | 34 34 | |
|---|
| Key read requests | 63 G62978046623 | 从缓存中读取键块的请求次数。。。 |
|---|
| Key reads | 168 168 | 从磁盘中物理读取键块的次数。。。若是 Key_reads 很大，，，，，，则说明您的 key_buffer_size 可能设置得太小了。。；；；；捍嫒笔士梢杂 Key_reads/Key_read_requests 盘算得出。。。 |
|---|
| Key write requests | 82.8 M82828377 | 将一个键块写入缓存的请求数。。。 |
|---|
| Key writes | 63.3 M63310136 | 将键块物理写入到磁盘的次数。。。 |
|---|
| Last query cost | 00.000000 | 最后编译的盘问的总开销由盘问优化器盘算得出，，，，，，可用于较量使用差别的盘问语句举行相同的盘问时的效率差别。。。默认值0体现还没有盘问被编译。。。 |
|---|
| Master gtid wait count | 00 | |
|---|
| Master gtid wait time | 00 | |
|---|
| Master gtid wait timeouts | 00 | |
|---|
| Max statement time exceeded | 00 | |
|---|
| Max used connections | 152 152 | 自效劳器启动以来的最高并发毗连数。。。 |
|---|
| Memory used | 187.3 M187305768 | |
|---|
| Not flushed delayed rows | 00 | 期待写入延迟插入行列的行数。。。 |
|---|
| Open files | 683 683 | 翻开的文件个数。。。 |
|---|
| Open streams | 00 | 翻开的流个数 (主要用于日志纪录)。。。 |
|---|
| Open table definitions | 132 132 | |
|---|
| Open tables | 715 715 | 翻开的数据表个数。。。 |
|---|
| Opened files | 13.7 M13712900 | |
|---|
| Opened plugin libraries | 00 | |
|---|
| Opened table definitions | 131 131 | |
|---|
| Opened tables | 721 721 | 已经翻开的表个数。。。若是该值很大，，，，，，则说明表缓冲巨细可能设置过小。。。 |
|---|
| Opened views | 00 | |
|---|
| Performance schema accounts lost | 00 | |
|---|
| Performance schema cond classes lost | 00 | |
|---|
| Performance schema cond instances lost | 00 | |
|---|
| Performance schema digest lost | 00 | |
|---|
| Performance schema file classes lost | 00 | |
|---|
| Performance schema file handles lost | 00 | |
|---|
| Performance schema file instances lost | 00 | |
|---|
| Performance schema hosts lost | 00 | |
|---|
| Performance schema locker lost | 00 | |
|---|
| Performance schema mutex classes lost | 00 | |
|---|
| Performance schema mutex instances lost | 00 | |
|---|
| Performance schema rwlock classes lost | 00 | |
|---|
| Performance schema rwlock instances lost | 00 | |
|---|
| Performance schema session connect attrs lost | 00 | |
|---|
| Performance schema socket classes lost | 00 | |
|---|
| Performance schema socket instances lost | 00 | |
|---|
| Performance schema stage classes lost | 00 | |
|---|
| Performance schema statement classes lost | 00 | |
|---|
| Performance schema table handles lost | 00 | |
|---|
| Performance schema table instances lost | 00 | |
|---|
| Performance schema thread classes lost | 00 | |
|---|
| Performance schema thread instances lost | 00 | |
|---|
| Performance schema users lost | 00 | |
|---|
| Prepared stmt count | 00 | |
|---|
| Qcache free blocks | 1 1 | 盘问缓存中的空闲内存块。。。过多的空闲内存块可能爆发碎片，，，，，，可通过执行 FLUSH QUERY CACHE 语句解决。。。 |
|---|
| Qcache free memory | 1 M1039880 | 盘问缓存中空闲的内存总数。。。 |
|---|
| Qcache hits | 00 | 缓存掷中数。。。 |
|---|
| Qcache inserts | 00 | 加入到缓存的盘问数。。。 |
|---|
| Qcache lowmem prunes | 00 | 为缓存新的盘问而被删除的已缓存盘问的个数，，，，，，由最近最少使用算法 (LRU) 确定应删除哪个已缓存的盘问。。。该信息可资助您调解盘问缓存巨细。。。 |
|---|
| Qcache not cached | 00 | 未缓存的盘问数 (包括不可被缓存，，，，，，或由于 query_cache_type 的设置而没有被缓存的盘问)。。。 |
|---|
| Qcache queries in cache | 00 | 在缓存中注册的盘问数。。。 |
|---|
| Qcache total blocks | 1 1 | 盘问缓存中的总块数。。。 |
|---|
| Queries | 3.6 G3591617238 | |
|---|
| Questions | 3.6 G3591617238 | |
|---|
| Rows read | 69 G68961018552 | |
|---|
| Rows sent | 6.4 G6377867409 | |
|---|
| Rows tmp read | 874.9 M874853302 | |
|---|
| Rpl status | AUTH_MASTERAUTH_MASTER | 失败；；；；て鞯淖刺 (尚未应用)。。。 |
|---|
| Select full join | 1.3 M1310950 | 没有使用索引的多表盘问数。。。若是该值不为0，，，，，，您应该仔细检查是否已经为表建设了适当的索引。。。 |
|---|
| Select full range join | 00 | 使用在关联表上使用规模搜索的多表盘问的数目。。。 |
|---|
| Select range | 95.1 M95137873 | 在第一张表上使用规模盘问的多表盘问数。。。(纵然该值很大，，，，，，通常也不会有致命的影响。。。) |
|---|
| Select range check | 00 | 没有使用索引但在每行之后检查索引使用的多表盘问数。。。(若是该值不为 0，，，，，，您应该仔细检查是否已经为表建设了适当的索引。。。) |
|---|
| Select scan | 71.6 M71560529 | 在第一张表上举行了完整表扫描的多表盘问数。。。 |
|---|
| Slave connections | 00 | |
|---|
| Slave heartbeat period | 00.000 | |
|---|
| Slave open temp tables | 00 | 目今由从 SQL 线程翻开的暂时表的数目。。。 |
|---|
| Slave received heartbeats | 00 | |
|---|
| Slave retried transactions | 00 | 从 SQL 线程总共重试事务复制数。。。 |
|---|
| Slave running | OFFOFF | 若是该值为 ON，，，，，，则这台效劳器是一台已经毗连到主效劳器的从效劳器。。。 |
|---|
| Slave skipped errors | 00 | |
|---|
| Slaves connected | 00 | |
|---|
| Slaves running | 00 | |
|---|
| Slow launch threads | 00 | 使用了比 slow_launch_time 更多的时间来启动的线程数目。。。 |
|---|
| Slow queries | 00 | 使用了比 long_query_time 更多时间的盘问数。。。 |
|---|
| Sort merge passes | 00 | 排序算法使用合并的次数。。。若是该值很大，，，，，，您应该思量增添系统变量 sort_buffer_size 的值。。。 |
|---|
| Sort priority queue sorts | 7.8 M7753784 | |
|---|
| Sort range | 789.8 M789792288 | 局部规模完成的排序次数。。。 |
|---|
| Sort rows | 888.9 M888898030 | 排序的行数。。。 |
|---|
| Sort scan | 17.6 M17584235 | 扫描表完成的排序次数。。。 |
|---|
| Ssl accept renegotiates | 00 | |
|---|
| Ssl accepts | 00 | |
|---|
| Ssl callback cache hits | 00 | |
|---|
| Ssl cipher | | |
|---|
| Ssl cipher list | | |
|---|
| Ssl client connects | 00 | |
|---|
| Ssl connect renegotiates | 00 | |
|---|
| Ssl ctx verify depth | 00 | |
|---|
| Ssl ctx verify mode | 00 | |
|---|
| Ssl default timeout | 00 | |
|---|
| Ssl finished accepts | 00 | |
|---|
| Ssl finished connects | 00 | |
|---|
| Ssl server not after | | |
|---|
| Ssl server not before | | |
|---|
| Ssl session cache hits | 00 | |
|---|
| Ssl session cache misses | 00 | |
|---|
| Ssl session cache mode | NONENONE | |
|---|
| Ssl session cache overflows | 00 | |
|---|
| Ssl session cache size | 00 | |
|---|
| Ssl session cache timeouts | 00 | |
|---|
| Ssl sessions reused | 00 | |
|---|
| Ssl used session cache entries | 00 | |
|---|
| Ssl verify depth | 00 | |
|---|
| Ssl verify mode | 00 | |
|---|
| Ssl version | | |
|---|
| Subquery cache hit | 00 | |
|---|
| Subquery cache miss | 00 | |
|---|
| Syncs | 3 3 | |
|---|
| Table locks immediate | 3.6 G3629559739 | 连忙需要锁定表的次数。。。 |
|---|
| Table locks waited | 203 k203009 | 无法连忙获得锁定表而必需期待的次数。。。若是该值很高，，，，，，且您遇到了性能方面的问题，，，，，，则应该首先检查您的盘问语句，，，，，，然后使用复制操作来脱离表。。。 |
|---|
| Tc log max pages used | 00 | |
|---|
| Tc log page size | 00 | |
|---|
| Tc log page waits | 00 | |
|---|
| Threadpool idle threads | 00 | |
|---|
| Threadpool threads | 4 4 | |
|---|
| Threads cached | 00 | 线程缓存中线程的数目。。；；；；捍嬷乐新士梢杂 Threads_created/Connections 盘算得出。。。若是该值是红色的，，，，，，则应该增添 thread_cache_size 的值。。。 |
|---|
| Threads connected | 2 2 | 目今翻开的毗连数。。。 |
|---|
| Threads created | 88.7 k88658 | 目今用于控制毗连的线程数。。。若是 Threads_created 很大，，，，，，您可能需要增添 thread_cache_size 的值。。。(若是线程状态优异，，，，，，这么做通常并不会带来显著的性能提升。。。) |
|---|
| Threads running | 1 1 | 非睡眠状态的线程数目。。。 |
|---|
| Update scan | 1 1 | |
|---|
| Uptime | 552 天 17 小时，，，，，，17 分 24 秒47755044 | |
|---|
| Uptime since flush status | 552 天 17 小时，，，，，，17 分 24 秒47755044 | |
|---|
| Key buffer fraction % | 60.69 %60.693359375 | 已用键缓存百分比（盘算值） |
|---|
| Key write ratio % | 76.44 %76.435321194329 | 物理写入数与写入请求数的百分比比值(盘算值) |
|---|
| Key read ratio % | <0.01 %2.6675962340605E-7 | Key cache miss calculated as rate of physical reads compared to read requests (calculated value) |
|---|
| Threads cache hitrate % | 99.52 %99.524676601504 | 线程缓存掷中率 （盘算值） |
|---|
