Aborted clients | 00 | 因客户端没有关闭连接而中止的连接数。 |
---|
Aborted connects | 2 2 | 尝试连接到 MySQL 服务器但失败的连接数。 |
---|
Access denied errors | 00 | |
---|
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 | 9 9 | |
---|
Aria pagecache blocks not flushed | 00 | |
---|
Aria pagecache blocks unused | 15.7 k15706 | |
---|
Aria pagecache blocks used | 575 575 | |
---|
Aria pagecache read requests | 3.6 M3610455 | |
---|
Aria pagecache reads | 130.6 k130563 | |
---|
Aria pagecache write requests | 284.8 k284782 | |
---|
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 | 804.1 M804075921 | |
---|
Bytes sent | 2.7 G2670787690 | |
---|
Com admin commands | 00 | |
---|
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 | 42.5 k42524 | |
---|
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 | 17.9 k17876 | |
---|
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 | 14.8 k14825 | |
---|
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 | 17.9 k17876 | |
---|
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 | 3.9 k3914 | |
---|
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 | 2 M1993192 | |
---|
Com set option | 29.7 k29650 | |
---|
Com show authors | 00 | |
---|
Com show binlog events | 00 | |
---|
Com show binlogs | 2.7 k2650 | |
---|
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 | 56 56 | |
---|
Com show create table | 51.5 k51531 | |
---|
Com show create trigger | 00 | |
---|
Com show databases | 00 | |
---|
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 | 124.9 k124869 | |
---|
Com show function status | 00 | |
---|
Com show generic | 00 | |
---|
Com show grants | 4.5 k4469 | |
---|
Com show keys | 123.9 k123889 | |
---|
Com show master status | 3.7 k3722 | |
---|
Com show open tables | 00 | |
---|
Com show plugins | 281 281 | |
---|
Com show privileges | 00 | |
---|
Com show procedure status | 00 | |
---|
Com show processlist | 3 3 | |
---|
Com show profile | 00 | |
---|
Com show profiles | 00 | |
---|
Com show relaylog events | 00 | |
---|
Com show slave hosts | 00 | |
---|
Com show slave status | 3.8 k3750 | |
---|
Com show status | 38 38 | |
---|
Com show storage engines | 206 206 | |
---|
Com show table status | 1.8 k1776 | |
---|
Com show tables | 32 k32002 | |
---|
Com show triggers | 00 | |
---|
Com show variables | 6.8 k6755 | |
---|
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 | 193 193 | |
---|
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 | 00 | |
---|
Connection errors peer address | 00 | |
---|
Connection errors select | 00 | |
---|
Connection errors tcpwrap | 00 | |
---|
Connections | 29.7 k29654 | 尝试连接到 MySQL 服务器的连接数 (不论成功或失败) 。 |
---|
Cpu time | 00.000000 | |
---|
Created tmp disk tables | 150.6 k150635 | 服务器执行语句时自动在磁盘上创建的临时表的数量。如果 Created_tmp_disk_tables 很大,你可以增加 tmp_table_size 的值,让服务器使用内存来存储临时表而非磁盘。 |
---|
Created tmp files | 5 5 | mysqld 已创建的临时文件的数量。 |
---|
Created tmp tables | 1.1 M1091277 | 服务器执行语句时自动在内存中创建的临时表的数量。 |
---|
Delayed errors | 00 | 发生错误的延迟插入 (INSERT DELAYED) 行数 (可能是因为在唯一字段中存在重复值) 。 |
---|
Delayed insert threads | 00 | 正在使用的延迟插入处理线程的数量。每张使用延迟插入的表都有自己的线程。 |
---|
Delayed writes | 00 | 延迟插入已写入的行数。 |
---|
Delete scan | 00 | |
---|
Empty queries | 781.2 k781168 | |
---|
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 | 31.6 k31644 | |
---|
Feature timezone | 00 | |
---|
Feature trigger | 2.1 k2097 | |
---|
Feature xml | 00 | |
---|
Flush commands | 1 1 | 已执行的强制更新 (FLUSH) 语句数。 |
---|
Handler commit | 1.4 M1429449 | 已执行的内部提交 (COMMIT) 语句数。 |
---|
Handler delete | 00 | 从表中删除行的次数。 |
---|
Handler discover | 35.4 k35448 | 如果知道一张表的名字,MySQL 服务器可以询问 NDB 集群存储引擎,这被称为“发现”。Handler_discovery 表明了一张表被发现的次数。 |
---|
Handler external lock | 00 | |
---|
Handler icp attempts | 00 | |
---|
Handler icp match | 00 | |
---|
Handler mrr init | 00 | |
---|
Handler mrr key refills | 00 | |
---|
Handler mrr rowid refills | 00 | |
---|
Handler prepare | 00 | |
---|
Handler read first | 272.7 k272681 | 读取一个索引入口点的次数。如果该值很大,说明你的服务器执行了很多完整索引扫描。例如,假设字段 col1 已经建立了索引,然后执行 SELECT col1 FROM foo 。 |
---|
Handler read key | 1.2 M1191077 | 根据索引读取行的请求数。如果该值很大,说明你的查询和表都建立了很好的索引。 |
---|
Handler read last | 27 27 | |
---|
Handler read next | 1.3 G1299442172 | 根据索引顺序读取下一行的请求数。如果你在查询一个已索引的字段且限制了范围,或进行完整表扫描,该值将会不断增长。 |
---|
Handler read prev | 648 648 | 根据索引顺序读取上一行的请求数。这种读取方式通常用于优化带有 ORDER BY … DESC 的查询。 |
---|
Handler read retry | 00 | |
---|
Handler read rnd | 1.7 M1723021 | 根据固定位置读取行的请求数。如果你执行很多需要排序的查询,该值会很高。你可能有很多需要完整表扫描的查询,或者你使用了不正确的索引用来多表查询。 |
---|
Handler read rnd deleted | 15.1 k15143 | |
---|
Handler read rnd next | 22.5 M22490043 | 从数据文件中读取行的请求数。如果你在扫描很多表,该值会很大。通常情况下这意味着你的表没有做好索引,或者你的查询语句没有使用好索引字段。 |
---|
Handler rollback | 00 | 内部回滚 (ROLLBACK) 语句数。 |
---|
Handler savepoint | 00 | |
---|
Handler savepoint rollback | 00 | |
---|
Handler tmp update | 00 | |
---|
Handler tmp write | 22 M22018494 | |
---|
Handler update | 4.1 k4106 | 表中更新行的请求数。 |
---|
Handler write | 21.8 k21790 | 表中插入行的请求数。 |
---|
Innodb available undo logs | 128 128 | |
---|
Innodb background log sync | 7 k6981 | |
---|
Innodb buffer pool bytes data | 193.3 M193282048 | |
---|
Innodb buffer pool bytes dirty | 3.3 M3309568 | |
---|
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 | 11.8 k11797 | 非空页数 (含脏页) 。 |
---|
Innodb buffer pool pages dirty | 202 202 | 当前脏页数。 |
---|
Innodb buffer pool pages flushed | 4.1 k4105 | 请求更新的缓冲池页数。 |
---|
Innodb buffer pool pages free | 21 k20954 | 空闲页数。 |
---|
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 | 16 16 | 负载页的数量,像锁定行或适应性的散列索引这样的管理操作时分配的页。该值可用此公式计算: Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data 。 |
---|
Innodb buffer pool pages old | 4.3 k4336 | |
---|
Innodb buffer pool pages total | 32.8 k32767 | 缓冲池总大小 (单位:页)。 |
---|
Innodb buffer pool read ahead | 4.8 k4848 | |
---|
Innodb buffer pool read ahead evicted | 00 | |
---|
Innodb buffer pool read ahead rnd | 00 | InnoDB 初始化的“随机”预读数。这通常会在对一张表进行大范围的随机排序查询时发生。 |
---|
Innodb buffer pool read requests | 188.7 M188663643 | InnoDB 完成的逻辑读请求数。 |
---|
Innodb buffer pool reads | 6.7 k6738 | InnoDB 进行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。 |
---|
Innodb buffer pool wait free | 00 | 写入 InnoDB 缓冲池通常在后台进行,但有必要在没有干净页的时候读取或创建页,有必要先等待页被刷新。该计数器统计了这种等待的数量。如果缓冲池大小设置正确,这个值应该会很小。 |
---|
Innodb buffer pool write requests | 43.7 k43672 | 写入 InnoDB 缓冲池的次数。 |
---|
Innodb checkpoint age | 197 k196957 | |
---|
Innodb checkpoint max age | 7.8 M7782360 | |
---|
Innodb data fsyncs | 9.8 k9788 | fsync() 总操作的次数。 |
---|
Innodb data pending fsyncs | 00 | 当前挂起 fsync() 操作的数量。 |
---|
Innodb data pending reads | 00 | 当前挂起的读操作数。 |
---|
Innodb data pending writes | 00 | 当前挂起的写操作数。 |
---|
Innodb data read | 215.1 M215060992 | 读取的总数据量 (单位:字节)。 |
---|
Innodb data reads | 11 k11011 | 数据读取总数。 |
---|
Innodb data writes | 11.5 k11463 | 数据写入总数。 |
---|
Innodb data written | 146 M146026496 | 写入的总数据量 (单位:字节)。 |
---|
Innodb dblwr pages written | 4.1 k4105 | 以双写入操作写入的页数。 |
---|
Innodb dblwr writes | 56 56 | 已经执行的双写入次数。 |
---|
Innodb deadlocks | 00 | |
---|
Innodb have atomic builtins | ONON | |
---|
Innodb history list length | 1.3 k1284 | |
---|
Innodb ibuf discarded delete marks | 00 | |
---|
Innodb ibuf discarded deletes | 00 | |
---|
Innodb ibuf discarded inserts | 00 | |
---|
Innodb ibuf free list | 224 224 | |
---|
Innodb ibuf merged delete marks | 00 | |
---|
Innodb ibuf merged deletes | 00 | |
---|
Innodb ibuf merged inserts | 00 | |
---|
Innodb ibuf merges | 00 | |
---|
Innodb ibuf segment size | 226 226 | |
---|
Innodb ibuf size | 1 1 | |
---|
Innodb log waits | 00 | 因日志缓存太小而必须等待其被写入所造成的等待数。 |
---|
Innodb log write requests | 9.2 k9226 | 日志写入请求数。 |
---|
Innodb log writes | 9.6 k9591 | 日志物理写入次数。 |
---|
Innodb lsn current | 23.2 G23191879073 | |
---|
Innodb lsn flushed | 23.2 G23191879073 | |
---|
Innodb lsn last checkpoint | 23.2 G23191682116 | |
---|
Innodb master thread active loops | 6.9 k6945 | |
---|
Innodb master thread idle loops | 36 36 | |
---|
Innodb max trx id | 2.3 G2283353186 | |
---|
Innodb mem adaptive hash | 9.1 M9117392 | |
---|
Innodb mem dictionary | 11.5 M11518841 | |
---|
Innodb mem total | 563.1 M563085312 | |
---|
Innodb mutex os waits | 25.8 k25795 | |
---|
Innodb mutex spin rounds | 1 M1020779 | |
---|
Innodb mutex spin waits | 33.6 k33633 | |
---|
Innodb oldest view low limit trx id | 00 | |
---|
Innodb os log fsyncs | 9.6 k9625 | 使用 fsync() 写入日志文件的次数。 |
---|
Innodb os log pending fsyncs | 00 | 当前挂起的 fsync 日志文件数。 |
---|
Innodb os log pending writes | 00 | 当前挂起的日志写入数。 |
---|
Innodb os log written | 9.4 M9399296 | 写入日志文件的字节数。 |
---|
Innodb page size | 16.4 k16384 | 编译的 InnoDB 页大小 (默认 16KB)。许多值都以页为单位进行统计,页大小可以很方便地将这些值转化为字节数。 |
---|
Innodb pages created | 175 175 | 创建的页数。 |
---|
Innodb pages read | 11.6 k11622 | 读取的页数。 |
---|
Innodb pages0 read | 2.7 k2671 | |
---|
Innodb pages written | 4.1 k4105 | 写入的页数。 |
---|
Innodb purge trx id | 2.3 G2283352638 | |
---|
Innodb purge undo no | 00 | |
---|
Innodb read views memory | 696 696 | |
---|
Innodb row lock current waits | 00 | 正在等待行锁的数量。 |
---|
Innodb row lock time | 00 | 等待获得行锁的总时间 (单位:毫秒)。 |
---|
Innodb row lock time avg | 00 | 等待获得行锁的平均时间 (单位:毫秒)。 |
---|
Innodb row lock time max | 00 | 等待获得行锁的最大时间 (单位:毫秒)。 |
---|
Innodb row lock waits | 00 | 等待行锁的次数。 |
---|
Innodb rows deleted | 00 | 从 InnoDB 表中删除的行数。 |
---|
Innodb rows inserted | 00 | 插入到 InnoDB 表中的行数。 |
---|
Innodb rows read | 1.3 G1299434304 | 从 InnoDB 表中读取的行数。 |
---|
Innodb rows updated | 4.1 k4106 | InnoDB 中更新的行数。 |
---|
Innodb system rows deleted | 00 | |
---|
Innodb system rows inserted | 00 | |
---|
Innodb system rows read | 1 k1048 | |
---|
Innodb system rows updated | 00 | |
---|
Innodb s lock os waits | 146 146 | |
---|
Innodb s lock spin rounds | 7.2 k7215 | |
---|
Innodb s lock spin waits | 243 243 | |
---|
Innodb truncated status writes | 00 | |
---|
Innodb x lock os waits | 120 120 | |
---|
Innodb x lock spin rounds | 3.9 k3908 | |
---|
Innodb x lock spin waits | 30 30 | |
---|
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 | 52 52 | |
---|
Innodb num non index pages written | 13.8 k13775 | |
---|
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 | ONON | |
---|
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 | 13.4 k13389 | 键缓存中未使用的块数。你可以根据这个值判断当前使用了多少键缓存。 |
---|
Key blocks used | 21 21 | 键缓存中已经使用的块数。该值指示在某个时刻使用了最多块数的数量。 |
---|
Key blocks warm | 00 | |
---|
Key read requests | 444.6 k444597 | 从缓存中读取键块的请求次数。 |
---|
Key reads | 90.6 k90582 | 从磁盘中物理读取键块的次数。如果 Key_reads 很大,则说明您的 key_buffer_size 可能设置得太小了。缓存缺失率可以由 Key_reads/Key_read_requests 计算得出。 |
---|
Key write requests | 00 | 将一个键块写入缓存的请求数。 |
---|
Key writes | 00 | 将键块物理写入到磁盘的次数。 |
---|
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 | 42 42 | 自服务器启动以来的最高并发连接数。 |
---|
Memory used | 175.3 M175250848 | |
---|
Not flushed delayed rows | 00 | 等待写入延迟插入队列的行数。 |
---|
Open files | 23 23 | 打开的文件个数。 |
---|
Open streams | 00 | 打开的流个数 (主要用于日志记录)。 |
---|
Open table definitions | 400 400 | |
---|
Open tables | 64 64 | 打开的数据表个数。 |
---|
Opened files | 4.7 M4694725 | |
---|
Opened plugin libraries | 70 70 | |
---|
Opened table definitions | 3 M2999733 | |
---|
Opened tables | 3.3 M3270861 | 已经打开的表个数。如果该值很大,则说明表缓冲大小可能设置过小。 |
---|
Opened views | 5.1 k5083 | |
---|
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 M1031336 | 查询缓存中空闲的内存总数。 |
---|
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 | 2.5 M2505702 | |
---|
Questions | 2.5 M2505702 | |
---|
Rows read | 1.3 G1299729332 | |
---|
Rows sent | 14.4 M14440666 | |
---|
Rows tmp read | 22.9 M22911458 | |
---|
Rpl status | AUTH_MASTERAUTH_MASTER | 失败保护器的状态 (尚未应用)。 |
---|
Select full join | 14.7 k14715 | 没有使用索引的多表查询数。如果该值不为0,您应该仔细检查是否已经为表建立了适当的索引。 |
---|
Select full range join | 00 | 使用在关联表上使用范围搜索的多表查询的数量。 |
---|
Select range | 00 | 在第一张表上使用范围查询的多表查询数。(即使该值很大,通常也不会有致命的影响。) |
---|
Select range check | 00 | 没有使用索引但在每行之后检查索引使用的多表查询数。(如果该值不为 0,您应该仔细检查是否已经为表建立了适当的索引。) |
---|
Select scan | 1.1 M1119132 | 在第一张表上进行了完整表扫描的多表查询数。 |
---|
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 | 1.6 k1632 | |
---|
Sort range | 183 183 | 局部范围完成的排序次数。 |
---|
Sort rows | 1.7 M1723021 | 排序的行数。 |
---|
Sort scan | 396.6 k396617 | 扫描表完成的排序次数。 |
---|
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 | 6 k6024 | |
---|
Table locks immediate | 1.7 M1658489 | 立即需要锁定表的次数。 |
---|
Table locks waited | 00 | 无法立即获得锁定表而必须等待的次数。如果该值很高,且您遇到了性能方面的问题,则应该首先检查您的查询语句,然后使用复制操作来分开表。 |
---|
Tc log max pages used | 00 | |
---|
Tc log page size | 4.1 k4096 | |
---|
Tc log page waits | 00 | |
---|
Threadpool idle threads | 00 | |
---|
Threadpool threads | 00 | |
---|
Threads cached | 00 | 线程缓存中线程的数量。缓存命中率可以由 Threads_created/Connections 计算得出。如果该值是红色的,则应该增加 thread_cache_size 的值。 |
---|
Threads connected | 10 10 | 当前打开的连接数。 |
---|
Threads created | 29.7 k29652 | 当前用于控制连接的线程数。如果 Threads_created 很大,您可能需要增加 thread_cache_size 的值。(如果线程状况良好,这么做通常并不会带来显著的性能提升。) |
---|
Threads running | 4 4 | 非睡眠状态的线程数量。 |
---|
Update scan | 00 | |
---|
Uptime | 0 天 1 小时,56 分 44 秒7004 | |
---|
Uptime since flush status | 0 天 1 小时,56 分 44 秒7004 | |
---|
wsrep cluster conf id | 18.4 E18446744073709551615 | |
---|
wsrep cluster size | 00 | |
---|
wsrep cluster state uuid | | |
---|
wsrep cluster status | DisconnectedDisconnected | |
---|
wsrep connected | OFFOFF | |
---|
wsrep local bf aborts | 00 | |
---|
wsrep local index | 18.4 E18446744073709551615 | |
---|
wsrep provider name | | |
---|
wsrep provider vendor | | |
---|
wsrep provider version | | |
---|
wsrep ready | OFFOFF | |
---|
wsrep thread count | 00 | |
---|
Key buffer fraction % | 18.28 %18.280029296875 | 已用键缓存百分比(计算值) |
---|
Key read ratio % | 20.37 %20.373956639384 | Key cache miss calculated as rate of physical reads compared to read requests (calculated value) |
---|
Threads cache hitrate % | 0.01 %0.0067444526876699 | 线程缓存命中率 (计算值) |
---|