Aborted clients | 00 | 因客户端没有关闭连接而中止的连接数。 |
---|
Aborted connects | 37 37 | 尝试连接到 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 | 705 705 | |
---|
Aria pagecache read requests | 56.6 M56559905 | |
---|
Aria pagecache reads | 2 M1990430 | |
---|
Aria pagecache write requests | 4.4 M4394417 | |
---|
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 | 12.7 G12674977180 | |
---|
Bytes sent | 41.9 G41876782185 | |
---|
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 | 705.5 k705532 | |
---|
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 | 331.5 k331472 | |
---|
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 | 240.3 k240295 | |
---|
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 | 331.5 k331472 | |
---|
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 | 52.9 k52933 | |
---|
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 | 31.1 M31091577 | |
---|
Com set option | 480.6 k480614 | |
---|
Com show authors | 00 | |
---|
Com show binlog events | 00 | |
---|
Com show binlogs | 57.5 k57522 | |
---|
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 | 860 860 | |
---|
Com show create table | 798.6 k798584 | |
---|
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 | 1.9 M1914009 | |
---|
Com show function status | 00 | |
---|
Com show generic | 00 | |
---|
Com show grants | 82.9 k82868 | |
---|
Com show keys | 1.9 M1897071 | |
---|
Com show master status | 78.5 k78466 | |
---|
Com show open tables | 00 | |
---|
Com show plugins | 3.7 k3674 | |
---|
Com show privileges | 00 | |
---|
Com show procedure status | 00 | |
---|
Com show processlist | 23 23 | |
---|
Com show profile | 00 | |
---|
Com show profiles | 00 | |
---|
Com show relaylog events | 00 | |
---|
Com show slave hosts | 00 | |
---|
Com show slave status | 78.9 k78940 | |
---|
Com show status | 597 597 | |
---|
Com show storage engines | 2.7 k2700 | |
---|
Com show table status | 26.6 k26589 | |
---|
Com show tables | 515.6 k515639 | |
---|
Com show triggers | 00 | |
---|
Com show variables | 95.5 k95486 | |
---|
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 | 2.5 k2500 | |
---|
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 | 1 1 | |
---|
Connection errors select | 00 | |
---|
Connection errors tcpwrap | 00 | |
---|
Connections | 480.7 k480653 | 尝试连接到 MySQL 服务器的连接数 (不论成功或失败) 。 |
---|
Cpu time | 00.000000 | |
---|
Created tmp disk tables | 2.3 M2347707 | 服务器执行语句时自动在磁盘上创建的临时表的数量。如果 Created_tmp_disk_tables 很大,你可以增加 tmp_table_size 的值,让服务器使用内存来存储临时表而非磁盘。 |
---|
Created tmp files | 5 5 | mysqld 已创建的临时文件的数量。 |
---|
Created tmp tables | 17.5 M17496334 | 服务器执行语句时自动在内存中创建的临时表的数量。 |
---|
Delayed errors | 00 | 发生错误的延迟插入 (INSERT DELAYED) 行数 (可能是因为在唯一字段中存在重复值) 。 |
---|
Delayed insert threads | 00 | 正在使用的延迟插入处理线程的数量。每张使用延迟插入的表都有自己的线程。 |
---|
Delayed writes | 00 | 延迟插入已写入的行数。 |
---|
Delete scan | 00 | |
---|
Empty queries | 12.7 M12658518 | |
---|
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 | 509.1 k509108 | |
---|
Feature timezone | 00 | |
---|
Feature trigger | 30.4 k30403 | |
---|
Feature xml | 00 | |
---|
Flush commands | 1 1 | 已执行的强制更新 (FLUSH) 语句数。 |
---|
Handler commit | 22.2 M22160915 | 已执行的内部提交 (COMMIT) 语句数。 |
---|
Handler delete | 00 | 从表中删除行的次数。 |
---|
Handler discover | 611.8 k611761 | 如果知道一张表的名字,MySQL 服务器可以询问 NDB 集群存储引擎,这被称为“发现”。Handler_discovery 表明了一张表被发现的次数。 |
---|
Handler external lock | 00 | |
---|
Handler icp attempts | 4 4 | |
---|
Handler icp match | 4 4 | |
---|
Handler mrr init | 00 | |
---|
Handler mrr key refills | 00 | |
---|
Handler mrr rowid refills | 00 | |
---|
Handler prepare | 00 | |
---|
Handler read first | 4.1 M4094527 | 读取一个索引入口点的次数。如果该值很大,说明你的服务器执行了很多完整索引扫描。例如,假设字段 col1 已经建立了索引,然后执行 SELECT col1 FROM foo 。 |
---|
Handler read key | 18.7 M18671864 | 根据索引读取行的请求数。如果该值很大,说明你的查询和表都建立了很好的索引。 |
---|
Handler read last | 379 379 | |
---|
Handler read next | 19.5 G19489634746 | 根据索引顺序读取下一行的请求数。如果你在查询一个已索引的字段且限制了范围,或进行完整表扫描,该值将会不断增长。 |
---|
Handler read prev | 9.1 k9096 | 根据索引顺序读取上一行的请求数。这种读取方式通常用于优化带有 ORDER BY … DESC 的查询。 |
---|
Handler read retry | 00 | |
---|
Handler read rnd | 26.3 M26251300 | 根据固定位置读取行的请求数。如果你执行很多需要排序的查询,该值会很高。你可能有很多需要完整表扫描的查询,或者你使用了不正确的索引用来多表查询。 |
---|
Handler read rnd deleted | 244.1 k244111 | |
---|
Handler read rnd next | 347.9 M347855235 | 从数据文件中读取行的请求数。如果你在扫描很多表,该值会很大。通常情况下这意味着你的表没有做好索引,或者你的查询语句没有使用好索引字段。 |
---|
Handler rollback | 00 | 内部回滚 (ROLLBACK) 语句数。 |
---|
Handler savepoint | 00 | |
---|
Handler savepoint rollback | 00 | |
---|
Handler tmp update | 00 | |
---|
Handler tmp write | 342.9 M342899835 | |
---|
Handler update | 55.4 k55428 | 表中更新行的请求数。 |
---|
Handler write | 384.4 k384405 | 表中插入行的请求数。 |
---|
Innodb available undo logs | 128 128 | |
---|
Innodb background log sync | 104.3 k104307 | |
---|
Innodb buffer pool bytes data | 193.6 M193560576 | |
---|
Innodb buffer pool bytes dirty | 4.2 M4210688 | |
---|
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 k11814 | 非空页数 (含脏页) 。 |
---|
Innodb buffer pool pages dirty | 257 257 | 当前脏页数。 |
---|
Innodb buffer pool pages flushed | 63.1 k63075 | 请求更新的缓冲池页数。 |
---|
Innodb buffer pool pages free | 20.9 k20937 | 空闲页数。 |
---|
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 k4348 | |
---|
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 | 2.8 G2821755098 | InnoDB 完成的逻辑读请求数。 |
---|
Innodb buffer pool reads | 6.8 k6756 | InnoDB 进行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。 |
---|
Innodb buffer pool wait free | 00 | 写入 InnoDB 缓冲池通常在后台进行,但有必要在没有干净页的时候读取或创建页,有必要先等待页被刷新。该计数器统计了这种等待的数量。如果缓冲池大小设置正确,这个值应该会很小。 |
---|
Innodb buffer pool write requests | 612 k611998 | 写入 InnoDB 缓冲池的次数。 |
---|
Innodb checkpoint age | 321.2 k321249 | |
---|
Innodb checkpoint max age | 7.8 M7782360 | |
---|
Innodb data fsyncs | 142.7 k142748 | fsync() 总操作的次数。 |
---|
Innodb data pending fsyncs | 00 | 当前挂起 fsync() 操作的数量。 |
---|
Innodb data pending reads | 00 | 当前挂起的读操作数。 |
---|
Innodb data pending writes | 00 | 当前挂起的写操作数。 |
---|
Innodb data read | 214.5 M214471168 | 读取的总数据量 (单位:字节)。 |
---|
Innodb data reads | 11 k11004 | 数据读取总数。 |
---|
Innodb data writes | 171 k171020 | 数据写入总数。 |
---|
Innodb data written | 2.2 G2201236480 | 写入的总数据量 (单位:字节)。 |
---|
Innodb dblwr pages written | 63.1 k63075 | 以双写入操作写入的页数。 |
---|
Innodb dblwr writes | 1.1 k1080 | 已经执行的双写入次数。 |
---|
Innodb deadlocks | 00 | |
---|
Innodb have atomic builtins | ONON | |
---|
Innodb history list length | 1.3 k1270 | |
---|
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 | 123.9 k123865 | 日志写入请求数。 |
---|
Innodb log writes | 138.9 k138936 | 日志物理写入次数。 |
---|
Innodb lsn current | 23 G23012866688 | |
---|
Innodb lsn flushed | 23 G23012866688 | |
---|
Innodb lsn last checkpoint | 23 G23012545439 | |
---|
Innodb master thread active loops | 103.5 k103499 | |
---|
Innodb master thread idle loops | 810 810 | |
---|
Innodb max trx id | 2.1 G2131295899 | |
---|
Innodb mem adaptive hash | 9.1 M9117392 | |
---|
Innodb mem dictionary | 11.5 M11518841 | |
---|
Innodb mem total | 563.1 M563085312 | |
---|
Innodb mutex os waits | 361.9 k361906 | |
---|
Innodb mutex spin rounds | 14.1 M14144621 | |
---|
Innodb mutex spin waits | 465.2 k465214 | |
---|
Innodb oldest view low limit trx id | 00 | |
---|
Innodb os log fsyncs | 139.7 k139653 | 使用 fsync() 写入日志文件的次数。 |
---|
Innodb os log pending fsyncs | 00 | 当前挂起的 fsync 日志文件数。 |
---|
Innodb os log pending writes | 00 | 当前挂起的日志写入数。 |
---|
Innodb os log written | 131.9 M131926016 | 写入日志文件的字节数。 |
---|
Innodb page size | 16.4 k16384 | 编译的 InnoDB 页大小 (默认 16KB)。许多值都以页为单位进行统计,页大小可以很方便地将这些值转化为字节数。 |
---|
Innodb pages created | 200 200 | 创建的页数。 |
---|
Innodb pages read | 11.6 k11614 | 读取的页数。 |
---|
Innodb pages0 read | 2.7 k2671 | |
---|
Innodb pages written | 63.1 k63075 | 写入的页数。 |
---|
Innodb purge trx id | 2.1 G2131295783 | |
---|
Innodb purge undo no | 00 | |
---|
Innodb read views memory | 1.1 k1120 | |
---|
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 | 19.5 G19489505677 | 从 InnoDB 表中读取的行数。 |
---|
Innodb rows updated | 55.4 k55428 | InnoDB 中更新的行数。 |
---|
Innodb system rows deleted | 00 | |
---|
Innodb system rows inserted | 00 | |
---|
Innodb system rows read | 15.1 k15059 | |
---|
Innodb system rows updated | 00 | |
---|
Innodb s lock os waits | 2 k1981 | |
---|
Innodb s lock spin rounds | 81.3 k81302 | |
---|
Innodb s lock spin waits | 2.7 k2714 | |
---|
Innodb truncated status writes | 00 | |
---|
Innodb x lock os waits | 1.5 k1474 | |
---|
Innodb x lock spin rounds | 50.7 k50746 | |
---|
Innodb x lock spin waits | 422 422 | |
---|
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 | 949 949 | |
---|
Innodb num non index pages written | 203.4 k203411 | |
---|
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 | 4 4 | |
---|
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 k13370 | 键缓存中未使用的块数。你可以根据这个值判断当前使用了多少键缓存。 |
---|
Key blocks used | 23 23 | 键缓存中已经使用的块数。该值指示在某个时刻使用了最多块数的数量。 |
---|
Key blocks warm | 00 | |
---|
Key read requests | 7.6 M7621734 | 从缓存中读取键块的请求次数。 |
---|
Key reads | 1.4 M1446955 | 从磁盘中物理读取键块的次数。如果 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 | 50 50 | 自服务器启动以来的最高并发连接数。 |
---|
Memory used | 164.2 M164199152 | |
---|
Not flushed delayed rows | 00 | 等待写入延迟插入队列的行数。 |
---|
Open files | 53 53 | 打开的文件个数。 |
---|
Open streams | 00 | 打开的流个数 (主要用于日志记录)。 |
---|
Open table definitions | 400 400 | |
---|
Open tables | 64 64 | 打开的数据表个数。 |
---|
Opened files | 69.4 M69391112 | |
---|
Opened plugin libraries | 1 k1015 | |
---|
Opened table definitions | 44.1 M44080227 | |
---|
Opened tables | 48 M48044124 | 已经打开的表个数。如果该值很大,则说明表缓冲大小可能设置过小。 |
---|
Opened views | 73.3 k73270 | |
---|
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 | 39.3 M39270035 | |
---|
Questions | 39.3 M39270035 | |
---|
Rows read | 19.5 G19494298680 | |
---|
Rows sent | 221.9 M221917092 | |
---|
Rows tmp read | 353.5 M353484491 | |
---|
Rpl status | AUTH_MASTERAUTH_MASTER | 失败保护器的状态 (尚未应用)。 |
---|
Select full join | 238.7 k238677 | 没有使用索引的多表查询数。如果该值不为0,您应该仔细检查是否已经为表建立了适当的索引。 |
---|
Select full range join | 00 | 使用在关联表上使用范围搜索的多表查询的数量。 |
---|
Select range | 00 | 在第一张表上使用范围查询的多表查询数。(即使该值很大,通常也不会有致命的影响。) |
---|
Select range check | 00 | 没有使用索引但在每行之后检查索引使用的多表查询数。(如果该值不为 0,您应该仔细检查是否已经为表建立了适当的索引。) |
---|
Select scan | 17.4 M17382898 | 在第一张表上进行了完整表扫描的多表查询数。 |
---|
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 | 23.7 k23719 | |
---|
Sort range | 2.8 k2789 | 局部范围完成的排序次数。 |
---|
Sort rows | 26.3 M26251300 | 排序的行数。 |
---|
Sort scan | 6.2 M6196745 | 扫描表完成的排序次数。 |
---|
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 | 87.5 k87490 | |
---|
Table locks immediate | 26 M25982093 | 立即需要锁定表的次数。 |
---|
Table locks waited | 1 1 | 无法立即获得锁定表而必须等待的次数。如果该值很高,且您遇到了性能方面的问题,则应该首先检查您的查询语句,然后使用复制操作来分开表。 |
---|
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 | 12 12 | 当前打开的连接数。 |
---|
Threads created | 480.7 k480651 | 当前用于控制连接的线程数。如果 Threads_created 很大,您可能需要增加 thread_cache_size 的值。(如果线程状况良好,这么做通常并不会带来显著的性能提升。) |
---|
Threads running | 3 3 | 非睡眠状态的线程数量。 |
---|
Update scan | 00 | |
---|
Uptime | 1 天 5 小时,3 分 45 秒104625 | |
---|
Uptime since flush status | 1 天 5 小时,3 分 45 秒104625 | |
---|
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.40 %18.39599609375 | 已用键缓存百分比(计算值) |
---|
Key read ratio % | 18.98 %18.984590645646 | Key cache miss calculated as rate of physical reads compared to read requests (calculated value) |
---|
Threads cache hitrate % | <0.01 %0.00041610059648178 | 线程缓存命中率 (计算值) |
---|