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.9 M20869145 | |
|---|
| Aria pagecache reads | 2.1 M2103079 | |
|---|
| Aria pagecache write requests | 3.5 M3495709 | |
|---|
| 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 G393711554303 | |
|---|
| Bytes sent | 8.6 T8640001047355 | |
|---|
| Com admin commands | 37.9 M37903320 | |
|---|
| 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 M17349377 | |
|---|
| 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 M12044280 | |
|---|
| 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 M1504804 | |
|---|
| 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 M10539775 | |
|---|
| 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 | 728 728 | |
|---|
| 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 G3470892381 | |
|---|
| Com set option | 48.1 M48140196 | |
|---|
| Com show authors | 00 | |
|---|
| Com show binlog events | 00 | |
|---|
| Com show binlogs | 21.7 k21690 | |
|---|
| 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 | 171.2 k171182 | |
|---|
| 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 M1812231 | |
|---|
| Com show function status | 00 | |
|---|
| Com show generic | 00 | |
|---|
| Com show grants | 41.8 k41772 | |
|---|
| Com show keys | 372.3 k372296 | |
|---|
| Com show master status | 44.7 k44746 | |
|---|
| Com show open tables | 00 | |
|---|
| Com show plugins | 48.9 k48935 | |
|---|
| Com show privileges | 00 | |
|---|
| Com show procedure status | 00 | |
|---|
| Com show processlist | 8 k8021 | |
|---|
| Com show profile | 00 | |
|---|
| Com show profiles | 00 | |
|---|
| Com show relaylog events | 00 | |
|---|
| Com show slave hosts | 00 | |
|---|
| Com show slave status | 47.1 k47060 | |
|---|
| Com show status | 22.7 k22660 | |
|---|
| Com show storage engines | 51.2 k51181 | |
|---|
| Com show table status | 98.5 k98493 | |
|---|
| Com show tables | 660.6 k660623 | |
|---|
| Com show triggers | 00 | |
|---|
| Com show variables | 551.9 k551869 | |
|---|
| 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 M9288600 | |
|---|
| 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 M18657387 | 实验毗连到 MySQL 效劳器的毗连数 (岂论乐成或失败) 。。 |
|---|
| Cpu time | 00.000000 | |
|---|
| Created tmp disk tables | 2.2 M2223145 | 效劳器执行语句时自动在磁盘上建设的暂时表的数目。。若是 Created_tmp_disk_tables 很大，，，你可以增添 tmp_table_size 的值，，，让效劳器使用内存来存储暂时表而非磁盘。。 |
|---|
| Created tmp files | 5 5 | mysqld 已建设的暂时文件的数目。。 |
|---|
| Created tmp tables | 20.9 M20861935 | 效劳器执行语句时自动在内存中建设的暂时表的数目。。 |
|---|
| Delayed errors | 00 | 爆发过失的延迟插入 (INSERT DELAYED) 行数 (可能是由于在唯一字段中保存重复值) 。。 |
|---|
| Delayed insert threads | 00 | 正在使用的延迟插入处置惩罚线程的数目。。每张使用延迟插入的表都有自己的线程。。 |
|---|
| Delayed writes | 00 | 延迟插入已写入的行数。。 |
|---|
| Delete scan | 00 | |
|---|
| Empty queries | 25.7 M25714744 | |
|---|
| 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 M2709143 | |
|---|
| Feature timezone | 00 | |
|---|
| Feature trigger | 00 | |
|---|
| Feature xml | 00 | |
|---|
| Flush commands | 1 1 | 已执行的强制更新 (FLUSH) 语句数。。 |
|---|
| Handler commit | 7 M7005897 | 已执行的内部提交 (COMMIT) 语句数。。 |
|---|
| Handler delete | 6 M6010811 | 从表中删除行的次数。。 |
|---|
| Handler discover | 52 52 | 若是知道一张表的名字，，，MySQL 效劳器可以询问 NDB 集群存储引擎，，，这被称为“发明”。。Handler_discovery 批注晰一张表被发明的次数。。 |
|---|
| Handler external lock | 00 | |
|---|
| Handler icp attempts | 630.9 M630854547 | |
|---|
| Handler icp match | 630.9 M630854547 | |
|---|
| Handler mrr init | 00 | |
|---|
| Handler mrr key refills | 00 | |
|---|
| Handler mrr rowid refills | 00 | |
|---|
| Handler prepare | 00 | |
|---|
| Handler read first | 3.3 M3275116 | 读取一个索引入口点的次数。。若是该值很大，，，说明你的效劳器执行了许多完整索引扫描。。例如，，，假设字段 col1 已经建设了索引，，，然后执行 SELECT col1 FROM foo 。。 |
|---|
| Handler read key | 1.8 G1836432491 | 凭证索引读取行的请求数。。若是该值很大，，，说明你的盘问和表都建设了很好的索引。。 |
|---|
| Handler read last | 17 17 | |
|---|
| Handler read next | 1.2 G1206945632 | 凭证索引顺序读取下一行的请求数。。若是你在盘问一个已索引的字段且限制了规模，，，或举行完整表扫描，，，该值将会一直增添。。 |
|---|
| Handler read prev | 165.5 M165489108 | 凭证索引顺序读取上一行的请求数。。这种读取方法通常用于优化带有 ORDER BY … DESC 的盘问。。 |
|---|
| Handler read retry | 00 | |
|---|
| Handler read rnd | 3.2 G3224007427 | 凭证牢靠位置读取行的请求数。。若是你执行许多需要排序的盘问，，，该值会很高。。你可能有许多需要完整表扫描的盘问，，，或者你使用了不准确的索引用来多表盘问。。 |
|---|
| Handler read rnd deleted | 4.6 M4633283 | |
|---|
| Handler read rnd next | 991.8 M991834788 | 从数据文件中读取行的请求数。。若是你在扫描许多表，，，该值会很大。。通常情形下这意味着你的表没有做好索引，，，或者你的盘问语句没有使用好索引字段。。 |
|---|
| Handler rollback | 86 86 | 内部回滚 (ROLLBACK) 语句数。。 |
|---|
| Handler savepoint | 00 | |
|---|
| Handler savepoint rollback | 00 | |
|---|
| Handler tmp update | 582.5 M582453992 | |
|---|
| Handler tmp write | 285.8 M285830048 | |
|---|
| Handler update | 4.1 M4104859 | 表中更新行的请求数。。 |
|---|
| Handler write | 7 M6992825 | 表中插入行的请求数。。 |
|---|
| Innodb available undo logs | 128 128 | |
|---|
| Innodb background log sync | 47.5 M47492381 | |
|---|
| 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.3 k32262 | 请求更新的缓冲池页数。。 |
|---|
| 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.8 M32815877 | InnoDB 完成的逻辑读请求数。。 |
|---|
| Innodb buffer pool reads | 4 k3952 | InnoDB 举行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。。 |
|---|
| Innodb buffer pool wait free | 00 | 写入 InnoDB 缓冲池通常在后台举行，，，但有须要在没有清洁页的时间读取或建设页，，，有须要先期待页被刷新。。该计数器统计了这种期待的数目。。若是缓冲池巨细设置准确，，，这个值应该会很小。。 |
|---|
| Innodb buffer pool write requests | 39.2 k39195 | 写入 InnoDB 缓冲池的次数。。 |
|---|
| Innodb checkpoint age | 00 | |
|---|
| Innodb checkpoint max age | 7.8 M7782360 | |
|---|
| Innodb data fsyncs | 114.2 k114222 | fsync() 总操作的次数。。 |
|---|
| Innodb data pending fsyncs | 00 | 目今挂起 fsync() 操作的数目。。 |
|---|
| Innodb data pending reads | 00 | 目今挂起的读操作数。。 |
|---|
| Innodb data pending writes | 00 | 目今挂起的写操作数。。 |
|---|
| Innodb data read | 65.2 M65229312 | 读取的总数据量 (单位：字节)。。 |
|---|
| Innodb data reads | 4 k4013 | 数据读取总数。。 |
|---|
| Innodb data writes | 117.7 k117738 | 数据写入总数。。 |
|---|
| Innodb data written | 1.1 G1089565696 | 写入的总数据量 (单位：字节)。。 |
|---|
| Innodb dblwr pages written | 32.3 k32262 | 以双写入操作写入的页数。。 |
|---|
| Innodb dblwr writes | 28.2 k28177 | 已经执行的双写入次数。。 |
|---|
| Innodb deadlocks | 00 | |
|---|
| Innodb have atomic builtins | ONON | |
|---|
| Innodb history list length | 1.6 k1576 | |
|---|
| 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.6 k10571 | 日志写入请求数。。 |
|---|
| Innodb log writes | 29.4 k29437 | 日志物理写入次数。。 |
|---|
| Innodb lsn current | 5.6 M5627820 | |
|---|
| Innodb lsn flushed | 5.6 M5627820 | |
|---|
| Innodb lsn last checkpoint | 5.6 M5627820 | |
|---|
| Innodb master thread active loops | 995 995 | |
|---|
| Innodb master thread idle loops | 47.5 M47491446 | |
|---|
| Innodb max trx id | 10.6 M10598250 | |
|---|
| Innodb mem adaptive hash | 297.3 k297300 | |
|---|
| Innodb mem dictionary | 201.9 k201934 | |
|---|
| Innodb mem total | 17.2 M17219584 | |
|---|
| Innodb mutex os waits | 45.9 k45877 | |
|---|
| Innodb mutex spin rounds | 3.3 M3323076 | |
|---|
| Innodb mutex spin waits | 3.8 M3762509 | |
|---|
| Innodb oldest view low limit trx id | 00 | |
|---|
| Innodb os log fsyncs | 57.3 k57292 | 使用 fsync() 写入日志文件的次数。。 |
|---|
| Innodb os log pending fsyncs | 00 | 目今挂起的 fsync 日志文件数。。 |
|---|
| Innodb os log pending writes | 00 | 目今挂起的日志写入数。。 |
|---|
| Innodb os log written | 18.1 M18142720 | 写入日志文件的字节数。。 |
|---|
| Innodb page size | 16.4 k16384 | 编译的 InnoDB 页巨细 (默认 16KB)。。许多值都以页为单位举行统计，，，页巨细可以很利便地将这些值转化为字节数。。 |
|---|
| Innodb pages created | 88 88 | 建设的页数。。 |
|---|
| Innodb pages read | 4 k3951 | 读取的页数。。 |
|---|
| Innodb pages0 read | 26 26 | |
|---|
| Innodb pages written | 32.3 k32262 | 写入的页数。。 |
|---|
| Innodb purge trx id | 10.6 M10593991 | |
|---|
| Innodb purge undo no | 00 | |
|---|
| Innodb read views memory | 21 k20984 | |
|---|
| 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 | 184 k183976 | 从 InnoDB 表中读取的行数。。 |
|---|
| Innodb rows updated | 2.1 k2111 | InnoDB 中更新的行数。。 |
|---|
| Innodb system rows deleted | 00 | |
|---|
| Innodb system rows inserted | 00 | |
|---|
| Innodb system rows read | 248 248 | |
|---|
| Innodb system rows updated | 00 | |
|---|
| Innodb s lock os waits | 25.9 k25893 | |
|---|
| Innodb s lock spin rounds | 835.5 k835539 | |
|---|
| Innodb s lock spin waits | 27.9 k27860 | |
|---|
| Innodb truncated status writes | 00 | |
|---|
| Innodb x lock os waits | 11 11 | |
|---|
| Innodb x lock spin rounds | 333 333 | |
|---|
| Innodb x lock spin waits | 2 2 | |
|---|
| 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 | 676 676 | |
|---|
| Innodb num non index pages written | 117.1 k117062 | |
|---|
| 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 G62979794491 | 从缓存中读取键块的请求次数。。 |
|---|
| Key reads | 168 168 | 从磁盘中物理读取键块的次数。。若是 Key_reads 很大，，，则说明您的 key_buffer_size 可能设置得太小了。；；；；捍嫒笔士梢杂 Key_reads/Key_read_requests 盘算得出。。 |
|---|
| Key write requests | 83 M82958168 | 将一个键块写入缓存的请求数。。 |
|---|
| Key writes | 63.4 M63409260 | 将键块物理写入到磁盘的次数。。 |
|---|
| 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 M187306112 | |
|---|
| 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 M13726273 | |
|---|
| 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 G3591912220 | |
|---|
| Questions | 3.6 G3591912220 | |
|---|
| Rows read | 69 G68962327271 | |
|---|
| Rows sent | 6.4 G6378738396 | |
|---|
| Rows tmp read | 876.2 M876239987 | |
|---|
| Rpl status | AUTH_MASTERAUTH_MASTER | 失败；；；；て鞯淖刺 (尚未应用)。。 |
|---|
| Select full join | 1.3 M1310957 | 没有使用索引的多表盘问数。。若是该值不为0，，，您应该仔细检查是否已经为表建设了适当的索引。。 |
|---|
| Select full range join | 00 | 使用在关联表上使用规模搜索的多表盘问的数目。。 |
|---|
| Select range | 95.1 M95139461 | 在第一张表上使用规模盘问的多表盘问数。。(纵然该值很大，，，通常也不会有致命的影响。。) |
|---|
| Select range check | 00 | 没有使用索引但在每行之后检查索引使用的多表盘问数。。(若是该值不为 0，，，您应该仔细检查是否已经为表建设了适当的索引。。) |
|---|
| Select scan | 71.6 M71631844 | 在第一张表上举行了完整表扫描的多表盘问数。。 |
|---|
| 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 M7754029 | |
|---|
| Sort range | 789.8 M789815715 | 局部规模完成的排序次数。。 |
|---|
| Sort rows | 889.2 M889198795 | 排序的行数。。 |
|---|
| Sort scan | 17.6 M17592001 | 扫描表完成的排序次数。。 |
|---|
| 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 G3629798688 | 连忙需要锁定表的次数。。 |
|---|
| Table locks waited | 203 k203041 | 无法连忙获得锁定表而必需期待的次数。。若是该值很高，，，且您遇到了性能方面的问题，，，则应该首先检查您的盘问语句，，，然后使用复制操作来脱离表。。 |
|---|
| Tc log max pages used | 00 | |
|---|
| Tc log page size | 00 | |
|---|
| Tc log page waits | 00 | |
|---|
| Threadpool idle threads | 00 | |
|---|
| Threadpool threads | 5 5 | |
|---|
| Threads cached | 00 | 线程缓存中线程的数目。；；；；捍嬷乐新士梢杂 Threads_created/Connections 盘算得出。。若是该值是红色的，，，则应该增添 thread_cache_size 的值。。 |
|---|
| Threads connected | 2 2 | 目今翻开的毗连数。。 |
|---|
| Threads created | 88.7 k88661 | 目今用于控制毗连的线程数。。若是 Threads_created 很大，，，您可能需要增添 thread_cache_size 的值。。(若是线程状态优异，，，这么做通常并不会带来显著的性能提升。。) |
|---|
| Threads running | 1 1 | 非睡眠状态的线程数目。。 |
|---|
| Update scan | 1 1 | |
|---|
| Uptime | 552 天 17 小时，，，33 分 35 秒47756015 | |
|---|
| Uptime since flush status | 552 天 17 小时，，，33 分 35 秒47756015 | |
|---|
| Key buffer fraction % | 60.69 %60.693359375 | 已用键缓存百分比（盘算值） |
|---|
| Key write ratio % | 76.44 %76.435222147143 | 物理写入数与写入请求数的百分比比值(盘算值) |
|---|
| Key read ratio % | <0.01 %2.6675222006958E-7 | Key cache miss calculated as rate of physical reads compared to read requests (calculated value) |
|---|
| Threads cache hitrate % | 99.52 %99.52479412042 | 线程缓存掷中率 （盘算值） |
|---|
