按 Ctrl+Enter 键执行查询按 Enter 执行查询
崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: herp 查询时间: 在当前会话期间
SELECT * FROM `contractreqts`崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: herp 查询时间: 在当前会话期间
SELECT * FROM `addissue`- 表收藏夹为空。
将文件拖动至此
控制台| 变量 | 值 | 说明 |
|---|---|---|
| Aborted clients | 0 | 因客户端没有关闭连接而中止的连接数。 |
| Aborted connects | 5 | 尝试连接到 MySQL 服务器但失败的连接数。 |
| Access denied errors | 0 | |
| Acl column grants | 0 | |
| Acl database grants | 4 | |
| Acl function grants | 0 | |
| Acl procedure grants | 0 | |
| Acl proxy users | 1 | |
| Acl role grants | 0 | |
| Acl roles | 0 | |
| Acl table grants | 0 | |
| Acl users | 9 | |
| Aria pagecache blocks not flushed | 0 | |
| Aria pagecache blocks unused | 15.7 k | |
| Aria pagecache blocks used | 797 | |
| Aria pagecache read requests | 11.6 M | |
| Aria pagecache reads | 386.4 k | |
| Aria pagecache write requests | 870.6 k | |
| Aria pagecache writes | 0 | |
| Aria transaction log syncs | 0 | |
| Binlog commits | 0 | |
| Binlog group commits | 0 | |
| Binlog group commit trigger count | 0 | |
| Binlog group commit trigger lock wait | 0 | |
| Binlog group commit trigger timeout | 0 | |
| Binlog snapshot file | ||
| Binlog snapshot position | 0 | |
| Binlog bytes written | 0 | |
| Binlog cache disk use | 0 | 因事务使用的临时二进制日志缓存超出 binlog_cache_size 的设置而使用临时文件存储的数量。 |
| Binlog cache use | 0 | 事务所用的临时二进制日志缓存的数量。 |
| Binlog stmt cache disk use | 0 | |
| Binlog stmt cache use | 0 | |
| Busy time | 0 | |
| Bytes received | 1.8 G | |
| Bytes sent | 6.4 G | |
| Com admin commands | 0 | |
| Com alter db | 0 | |
| Com alter db upgrade | 0 | |
| Com alter event | 0 | |
| Com alter function | 0 | |
| Com alter procedure | 0 | |
| Com alter server | 0 | |
| Com alter table | 0 | |
| Com alter tablespace | 0 | |
| Com analyze | 0 | |
| Com assign to keycache | 0 | |
| Com begin | 0 | |
| Com binlog | 0 | |
| Com call procedure | 0 | |
| Com change db | 87.8 k | |
| Com change master | 0 | |
| Com check | 0 | |
| Com checksum | 0 | |
| Com commit | 0 | |
| Com compound sql | 0 | |
| Com create db | 0 | |
| Com create event | 0 | |
| Com create function | 0 | |
| Com create index | 0 | |
| Com create procedure | 0 | |
| Com create role | 0 | |
| Com create server | 0 | |
| Com create table | 0 | |
| Com create temporary table | 0 | |
| Com create trigger | 0 | |
| Com create udf | 0 | |
| Com create user | 0 | |
| Com create view | 0 | |
| Com delete | 21.5 k | |
| Com delete multi | 0 | |
| Com do | 0 | |
| Com drop db | 0 | |
| Com drop event | 0 | |
| Com drop function | 0 | |
| Com drop index | 0 | |
| Com drop procedure | 0 | |
| Com drop role | 0 | |
| Com drop server | 0 | |
| Com drop table | 0 | |
| Com drop temporary table | 0 | |
| Com drop trigger | 0 | |
| Com drop user | 0 | |
| Com drop view | 0 | |
| Com empty query | 0 | |
| Com flush | 26.3 k | |
| Com get diagnostics | 0 | |
| Com grant | 0 | |
| Com grant role | 0 | |
| Com ha close | 0 | |
| Com ha open | 0 | |
| Com ha read | 0 | |
| Com help | 0 | |
| Com insert | 21.5 k | |
| Com insert select | 0 | |
| Com install plugin | 0 | |
| Com kill | 0 | |
| Com load | 0 | |
| Com lock tables | 0 | |
| Com optimize | 0 | |
| Com preload keys | 0 | |
| Com purge | 0 | |
| Com purge before date | 0 | |
| Com release savepoint | 0 | |
| Com rename table | 0 | |
| Com rename user | 0 | |
| Com repair | 0 | |
| Com replace | 5.1 k | |
| Com replace select | 0 | |
| Com reset | 0 | |
| Com resignal | 0 | |
| Com revoke | 0 | |
| Com revoke all | 0 | |
| Com revoke role | 0 | |
| Com rollback | 0 | |
| Com rollback to savepoint | 0 | |
| Com savepoint | 0 | |
| Com select | 4.4 M | |
| Com set option | 52.6 k | |
| Com show authors | 0 | |
| Com show binlog events | 0 | |
| Com show binlogs | 3 k | |
| Com show charsets | 0 | |
| Com show collations | 0 | |
| Com show contributors | 0 | |
| Com show create db | 0 | |
| Com show create event | 0 | |
| Com show create func | 0 | |
| Com show create proc | 274 | |
| Com show create table | 165.1 k | |
| Com show create trigger | 0 | |
| Com show databases | 0 | |
| Com show engine logs | 0 | |
| Com show engine mutex | 0 | |
| Com show engine status | 0 | |
| Com show errors | 0 | |
| Com show events | 0 | |
| Com show explain | 0 | |
| Com show fields | 377.6 k | |
| Com show function status | 0 | |
| Com show generic | 0 | |
| Com show grants | 5.4 k | |
| Com show keys | 375.5 k | |
| Com show master status | 8.5 k | |
| Com show open tables | 0 | |
| Com show plugins | 257 | |
| Com show privileges | 0 | |
| Com show procedure status | 0 | |
| Com show processlist | 6 | |
| Com show profile | 0 | |
| Com show profiles | 0 | |
| Com show relaylog events | 0 | |
| Com show slave hosts | 0 | |
| Com show slave status | 8.6 k | |
| Com show status | 144 | |
| Com show storage engines | 305 | |
| Com show table status | 4.5 k | |
| Com show tables | 61.9 k | |
| Com show triggers | 0 | |
| Com show variables | 11.1 k | |
| Com show warnings | 0 | |
| Com shutdown | 0 | |
| Com signal | 0 | |
| Com start all slaves | 0 | |
| Com start slave | 0 | |
| Com stmt close | 0 | |
| Com stmt execute | 0 | |
| Com stmt fetch | 0 | |
| Com stmt prepare | 0 | |
| Com stmt reprepare | 0 | |
| Com stmt reset | 0 | |
| Com stmt send long data | 0 | |
| Com stop all slaves | 0 | |
| Com stop slave | 0 | |
| Com truncate | 0 | |
| Com uninstall plugin | 0 | |
| Com unlock tables | 0 | |
| Com update | 274 | |
| Com update multi | 0 | |
| Com xa commit | 0 | |
| Com xa end | 0 | |
| Com xa prepare | 0 | |
| Com xa recover | 0 | |
| Com xa rollback | 0 | |
| Com xa start | 0 | |
| Compression | OFF | |
| Connection errors accept | 0 | |
| Connection errors internal | 0 | |
| Connection errors max connections | 0 | |
| Connection errors peer address | 0 | |
| Connection errors select | 0 | |
| Connection errors tcpwrap | 0 | |
| Connections | 52.6 k | 尝试连接到 MySQL 服务器的连接数 (不论成功或失败) 。 |
| Cpu time | 0 | |
| Created tmp disk tables | 415 k | 服务器执行语句时自动在磁盘上创建的临时表的数量。如果 Created_tmp_disk_tables 很大，你可以增加 tmp_table_size 的值，让服务器使用内存来存储临时表而非磁盘。 |
| Created tmp files | 5 | mysqld 已创建的临时文件的数量。 |
| Created tmp tables | 2.3 M | 服务器执行语句时自动在内存中创建的临时表的数量。 |
| Delayed errors | 0 | 发生错误的延迟插入 (INSERT DELAYED) 行数 (可能是因为在唯一字段中存在重复值) 。 |
| Delayed insert threads | 0 | 正在使用的延迟插入处理线程的数量。每张使用延迟插入的表都有自己的线程。 |
| Delayed writes | 0 | 延迟插入已写入的行数。 |
| Delete scan | 0 | |
| Empty queries | 1.9 M | |
| Executed events | 0 | |
| Executed triggers | 0 | |
| Feature delay key write | 0 | |
| Feature dynamic columns | 0 | |
| Feature fulltext | 0 | |
| Feature gis | 0 | |
| Feature locale | 0 | |
| Feature subquery | 57.3 k | |
| Feature timezone | 0 | |
| Feature trigger | 4.9 k | |
| Feature xml | 0 | |
| Flush commands | 1 | 已执行的强制更新 (FLUSH) 语句数。 |
| Handler commit | 3.3 M | 已执行的内部提交 (COMMIT) 语句数。 |
| Handler delete | 0 | 从表中删除行的次数。 |
| Handler discover | 53.1 k | 如果知道一张表的名字，MySQL 服务器可以询问 NDB 集群存储引擎，这被称为“发现”。Handler_discovery 表明了一张表被发现的次数。 |
| Handler external lock | 0 | |
| Handler icp attempts | 0 | |
| Handler icp match | 0 | |
| Handler mrr init | 0 | |
| Handler mrr key refills | 0 | |
| Handler mrr rowid refills | 0 | |
| Handler prepare | 0 | |
| Handler read first | 572.8 k | 读取一个索引入口点的次数。如果该值很大，说明你的服务器执行了很多完整索引扫描。例如，假设字段 col1 已经建立了索引，然后执行 SELECT col1 FROM foo 。 |
| Handler read key | 2.8 M | 根据索引读取行的请求数。如果该值很大，说明你的查询和表都建立了很好的索引。 |
| Handler read last | 56 | |
| Handler read next | 2.9 G | 根据索引顺序读取下一行的请求数。如果你在查询一个已索引的字段且限制了范围，或进行完整表扫描，该值将会不断增长。 |
| Handler read prev | 1.3 k | 根据索引顺序读取上一行的请求数。这种读取方式通常用于优化带有 ORDER BY … DESC 的查询。 |
| Handler read retry | 0 | |
| Handler read rnd | 3.6 M | 根据固定位置读取行的请求数。如果你执行很多需要排序的查询，该值会很高。你可能有很多需要完整表扫描的查询，或者你使用了不正确的索引用来多表查询。 |
| Handler read rnd deleted | 26.7 k | |
| Handler read rnd next | 50.2 M | 从数据文件中读取行的请求数。如果你在扫描很多表，该值会很大。通常情况下这意味着你的表没有做好索引，或者你的查询语句没有使用好索引字段。 |
| Handler rollback | 0 | 内部回滚 (ROLLBACK) 语句数。 |
| Handler savepoint | 0 | |
| Handler savepoint rollback | 0 | |
| Handler tmp update | 0 | |
| Handler tmp write | 48.7 M | |
| Handler update | 5.3 k | 表中更新行的请求数。 |
| Handler write | 26.5 k | 表中插入行的请求数。 |
| Innodb available undo logs | 128 | |
| Innodb background log sync | 15.6 k | |
| Innodb buffer pool bytes data | 193.2 M | |
| Innodb buffer pool bytes dirty | 2.7 M | |
| Innodb buffer pool dump status | Dumping buffer pool(s) not yet started | |
| Innodb buffer pool load status | Loading buffer pool(s) not yet started | |
| Innodb buffer pool pages data | 11.8 k | 非空页数 (含脏页) 。 |
| Innodb buffer pool pages dirty | 163 | 当前脏页数。 |
| Innodb buffer pool pages flushed | 7.4 k | 请求更新的缓冲池页数。 |
| Innodb buffer pool pages free | 21 k | 空闲页数。 |
| Innodb buffer pool pages lru flushed | 0 | |
| Innodb buffer pool pages made not young | 0 | |
| Innodb buffer pool pages made young | 0 | |
| Innodb buffer pool pages misc | 16 | 负载页的数量，像锁定行或适应性的散列索引这样的管理操作时分配的页。该值可用此公式计算： Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data 。 |
| Innodb buffer pool pages old | 4.3 k | |
| Innodb buffer pool pages total | 32.8 k | 缓冲池总大小 (单位：页)。 |
| Innodb buffer pool read ahead | 4.8 k | |
| Innodb buffer pool read ahead evicted | 0 | |
| Innodb buffer pool read ahead rnd | 0 | InnoDB 初始化的“随机”预读数。这通常会在对一张表进行大范围的随机排序查询时发生。 |
| Innodb buffer pool read requests | 423.1 M | InnoDB 完成的逻辑读请求数。 |
| Innodb buffer pool reads | 6.7 k | InnoDB 进行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。 |
| Innodb buffer pool wait free | 0 | 写入 InnoDB 缓冲池通常在后台进行，但有必要在没有干净页的时候读取或创建页，有必要先等待页被刷新。该计数器统计了这种等待的数量。如果缓冲池大小设置正确，这个值应该会很小。 |
| Innodb buffer pool write requests | 72.8 k | 写入 InnoDB 缓冲池的次数。 |
| Innodb checkpoint age | 118.2 k | |
| Innodb checkpoint max age | 7.8 M | |
| Innodb data fsyncs | 19.2 k | fsync() 总操作的次数。 |
| Innodb data pending fsyncs | 0 | 当前挂起 fsync() 操作的数量。 |
| Innodb data pending reads | 0 | 当前挂起的读操作数。 |
| Innodb data pending writes | 0 | 当前挂起的写操作数。 |
| Innodb data read | 213.8 M | 读取的总数据量 (单位：字节)。 |
| Innodb data reads | 11 k | 数据读取总数。 |
| Innodb data writes | 23.4 k | 数据写入总数。 |
| Innodb data written | 259.9 M | 写入的总数据量 (单位：字节)。 |
| Innodb dblwr pages written | 7.4 k | 以双写入操作写入的页数。 |
| Innodb dblwr writes | 438 | 已经执行的双写入次数。 |
| Innodb deadlocks | 0 | |
| Innodb have atomic builtins | ON | |
| Innodb history list length | 1.2 k | |
| Innodb ibuf discarded delete marks | 0 | |
| Innodb ibuf discarded deletes | 0 | |
| Innodb ibuf discarded inserts | 0 | |
| Innodb ibuf free list | 224 | |
| Innodb ibuf merged delete marks | 0 | |
| Innodb ibuf merged deletes | 0 | |
| Innodb ibuf merged inserts | 0 | |
| Innodb ibuf merges | 0 | |
| Innodb ibuf segment size | 226 | |
| Innodb ibuf size | 1 | |
| Innodb log waits | 0 | 因日志缓存太小而必须等待其被写入所造成的等待数。 |
| Innodb log write requests | 12 k | 日志写入请求数。 |
| Innodb log writes | 17.7 k | 日志物理写入次数。 |
| Innodb lsn current | 23.4 G | |
| Innodb lsn flushed | 23.4 G | |
| Innodb lsn last checkpoint | 23.4 G | |
| Innodb master thread active loops | 14.9 k | |
| Innodb master thread idle loops | 685 | |
| Innodb max trx id | 2.5 G | |
| Innodb mem adaptive hash | 9.1 M | |
| Innodb mem dictionary | 11.5 M | |
| Innodb mem total | 563.1 M | |
| Innodb mutex os waits | 43.5 k | |
| Innodb mutex spin rounds | 1.7 M | |
| Innodb mutex spin waits | 54.6 k | |
| Innodb oldest view low limit trx id | 0 | |
| Innodb os log fsyncs | 18.1 k | 使用 fsync() 写入日志文件的次数。 |
| Innodb os log pending fsyncs | 0 | 当前挂起的 fsync 日志文件数。 |
| Innodb os log pending writes | 0 | 当前挂起的日志写入数。 |
| Innodb os log written | 14.8 M | 写入日志文件的字节数。 |
| Innodb page size | 16.4 k | 编译的 InnoDB 页大小 (默认 16KB)。许多值都以页为单位进行统计，页大小可以很方便地将这些值转化为字节数。 |
| Innodb pages created | 206 | 创建的页数。 |
| Innodb pages read | 11.6 k | 读取的页数。 |
| Innodb pages0 read | 2.7 k | |
| Innodb pages written | 7.4 k | 写入的页数。 |
| Innodb purge trx id | 2.5 G | |
| Innodb purge undo no | 0 | |
| Innodb read views memory | 448 | |
| Innodb row lock current waits | 0 | 正在等待行锁的数量。 |
| Innodb row lock time | 0 | 等待获得行锁的总时间 (单位：毫秒)。 |
| Innodb row lock time avg | 0 | 等待获得行锁的平均时间 (单位：毫秒)。 |
| Innodb row lock time max | 0 | 等待获得行锁的最大时间 (单位：毫秒)。 |
| Innodb row lock waits | 0 | 等待行锁的次数。 |
| Innodb rows deleted | 0 | 从 InnoDB 表中删除的行数。 |
| Innodb rows inserted | 0 | 插入到 InnoDB 表中的行数。 |
| Innodb rows read | 2.9 G | 从 InnoDB 表中读取的行数。 |
| Innodb rows updated | 5.3 k | InnoDB 中更新的行数。 |
| Innodb system rows deleted | 0 | |
| Innodb system rows inserted | 0 | |
| Innodb system rows read | 1.7 k | |
| Innodb system rows updated | 0 | |
| Innodb s lock os waits | 653 | |
| Innodb s lock spin rounds | 24 k | |
| Innodb s lock spin waits | 803 | |
| Innodb truncated status writes | 0 | |
| Innodb x lock os waits | 183 | |
| Innodb x lock spin rounds | 6.3 k | |
| Innodb x lock spin waits | 46 | |
| Innodb page compression saved | 0 | |
| Innodb page compression trim sect512 | 0 | |
| Innodb page compression trim sect1024 | 0 | |
| Innodb page compression trim sect2048 | 0 | |
| Innodb page compression trim sect4096 | 0 | |
| Innodb page compression trim sect8192 | 0 | |
| Innodb page compression trim sect16384 | 0 | |
| Innodb page compression trim sect32768 | 0 | |
| Innodb num index pages written | 274 | |
| Innodb num non index pages written | 25.7 k | |
| Innodb num pages page compressed | 0 | |
| Innodb num page compressed trim op | 0 | |
| Innodb num page compressed trim op saved | 0 | |
| Innodb num pages page decompressed | 0 | |
| Innodb num pages page compression error | 0 | |
| Innodb num pages encrypted | 0 | |
| Innodb num pages decrypted | 0 | |
| Innodb have lz4 | OFF | |
| Innodb have lzo | OFF | |
| Innodb have lzma | OFF | |
| Innodb have bzip2 | ON | |
| Innodb have snappy | OFF | |
| Innodb defragment compression failures | 0 | |
| Innodb defragment failures | 0 | |
| Innodb defragment count | 0 | |
| Innodb onlineddl rowlog rows | 0 | |
| Innodb onlineddl rowlog pct used | 0 | |
| Innodb onlineddl pct progress | 0 | |
| Innodb secondary index triggered cluster reads | 0 | |
| Innodb secondary index triggered cluster reads avoided | 0 | |
| Innodb encryption rotation pages read from cache | 0 | |
| Innodb encryption rotation pages read from disk | 0 | |
| Innodb encryption rotation pages modified | 0 | |
| Innodb encryption rotation pages flushed | 0 | |
| Innodb encryption rotation estimated iops | 0 | |
| Innodb scrub background page reorganizations | 0 | |
| Innodb scrub background page splits | 0 | |
| Innodb scrub background page split failures underflow | 0 | |
| Innodb scrub background page split failures out of filespace | 0 | |
| Innodb scrub background page split failures missing index | 0 | |
| Innodb scrub background page split failures unknown | 0 | |
| Key blocks not flushed | 0 | 键缓存中还没有被写入到磁盘的键块数。该值过去名为 Not_flushed_key_blocks 。 |
| Key blocks unused | 13.4 k | 键缓存中未使用的块数。你可以根据这个值判断当前使用了多少键缓存。 |
| Key blocks used | 25 | 键缓存中已经使用的块数。该值指示在某个时刻使用了最多块数的数量。 |
| Key blocks warm | 0 | |
| Key read requests | 672 k | 从缓存中读取键块的请求次数。 |
| Key reads | 148 k | 从磁盘中物理读取键块的次数。如果 Key_reads 很大，则说明您的 key_buffer_size 可能设置得太小了。缓存缺失率可以由 Key_reads/Key_read_requests 计算得出。 |
| Key write requests | 0 | 将一个键块写入缓存的请求数。 |
| Key writes | 0 | 将键块物理写入到磁盘的次数。 |
| Last query cost | 0 | 最后编译的查询的总开销由查询优化器计算得出，可用于比较使用不同的查询语句进行相同的查询时的效率差异。默认值0表示还没有查询被编译。 |
| Master gtid wait count | 0 | |
| Master gtid wait time | 0 | |
| Master gtid wait timeouts | 0 | |
| Max statement time exceeded | 0 | |
| Max used connections | 47 | 自服务器启动以来的最高并发连接数。 |
| Memory used | 163 M | |
| Not flushed delayed rows | 0 | 等待写入延迟插入队列的行数。 |
| Open files | 59 | 打开的文件个数。 |
| Open streams | 0 | 打开的流个数 (主要用于日志记录)。 |
| Open table definitions | 400 | |
| Open tables | 64 | 打开的数据表个数。 |
| Opened files | 11.2 M | |
| Opened plugin libraries | 0 | |
| Opened table definitions | 7.1 M | |
| Opened tables | 7.5 M | 已经打开的表个数。如果该值很大，则说明表缓冲大小可能设置过小。 |
| Opened views | 11.9 k | |
| Performance schema accounts lost | 0 | |
| Performance schema cond classes lost | 0 | |
| Performance schema cond instances lost | 0 | |
| Performance schema digest lost | 0 | |
| Performance schema file classes lost | 0 | |
| Performance schema file handles lost | 0 | |
| Performance schema file instances lost | 0 | |
| Performance schema hosts lost | 0 | |
| Performance schema locker lost | 0 | |
| Performance schema mutex classes lost | 0 | |
| Performance schema mutex instances lost | 0 | |
| Performance schema rwlock classes lost | 0 | |
| Performance schema rwlock instances lost | 0 | |
| Performance schema session connect attrs lost | 0 | |
| Performance schema socket classes lost | 0 | |
| Performance schema socket instances lost | 0 | |
| Performance schema stage classes lost | 0 | |
| Performance schema statement classes lost | 0 | |
| Performance schema table handles lost | 0 | |
| Performance schema table instances lost | 0 | |
| Performance schema thread classes lost | 0 | |
| Performance schema thread instances lost | 0 | |
| Performance schema users lost | 0 | |
| Prepared stmt count | 0 | |
| Qcache free blocks | 1 | 查询缓存中的空闲内存块。过多的空闲内存块可能产生碎片，可通过执行 FLUSH QUERY CACHE 语句解决。 |
| Qcache free memory | 1 M | 查询缓存中空闲的内存总数。 |
| Qcache hits | 0 | 缓存命中数。 |
| Qcache inserts | 0 | 加入到缓存的查询数。 |
| Qcache lowmem prunes | 0 | 为缓存新的查询而被删除的已缓存查询的个数，由最近最少使用算法 (LRU) 确定应删除哪个已缓存的查询。该信息可帮助您调整查询缓存大小。 |
| Qcache not cached | 0 | 未缓存的查询数 (包括不能被缓存，或因为 query_cache_type 的设置而没有被缓存的查询)。 |
| Qcache queries in cache | 0 | 在缓存中注册的查询数。 |
| Qcache total blocks | 1 | 查询缓存中的总块数。 |
| Queries | 5.7 M | |
| Questions | 5.7 M | |
| Rows read | 2.9 G | |
| Rows sent | 34.2 M | |
| Rows tmp read | 51.1 M | |
| Rpl status | AUTH_MASTER | 失败保护器的状态 (尚未应用)。 |
| Select full join | 26 k | 没有使用索引的多表查询数。如果该值不为0，您应该仔细检查是否已经为表建立了适当的索引。 |
| Select full range join | 0 | 使用在关联表上使用范围搜索的多表查询的数量。 |
| Select range | 0 | 在第一张表上使用范围查询的多表查询数。(即使该值很大，通常也不会有致命的影响。) |
| Select range check | 0 | 没有使用索引但在每行之后检查索引使用的多表查询数。(如果该值不为 0，您应该仔细检查是否已经为表建立了适当的索引。) |
| Select scan | 2.5 M | 在第一张表上进行了完整表扫描的多表查询数。 |
| Slave connections | 0 | |
| Slave heartbeat period | 0 | |
| Slave open temp tables | 0 | 当前由从 SQL 线程打开的临时表的数量。 |
| Slave received heartbeats | 0 | |
| Slave retried transactions | 0 | 从 SQL 线程总共重试事务复制数。 |
| Slave running | OFF | 如果该值为 ON，则这台服务器是一台已经连接到主服务器的从服务器。 |
| Slave skipped errors | 0 | |
| Slaves connected | 0 | |
| Slaves running | 0 | |
| Slow launch threads | 0 | 使用了比 slow_launch_time 更多的时间来启动的线程数量。 |
| Slow queries | 0 | 使用了比 long_query_time 更多时间的查询数。 |
| Sort merge passes | 0 | 排序算法使用归并的次数。如果该值很大，您应该考虑增加系统变量 sort_buffer_size 的值。 |
| Sort priority queue sorts | 3.7 k | |
| Sort range | 477 | 局部范围完成的排序次数。 |
| Sort rows | 3.6 M | 排序的行数。 |
| Sort scan | 808.5 k | 扫描表完成的排序次数。 |
| Ssl accept renegotiates | 0 | |
| Ssl accepts | 0 | |
| Ssl callback cache hits | 0 | |
| Ssl cipher | ||
| Ssl cipher list | ||
| Ssl client connects | 0 | |
| Ssl connect renegotiates | 0 | |
| Ssl ctx verify depth | 0 | |
| Ssl ctx verify mode | 0 | |
| Ssl default timeout | 0 | |
| Ssl finished accepts | 0 | |
| Ssl finished connects | 0 | |
| Ssl server not after | ||
| Ssl server not before | ||
| Ssl session cache hits | 0 | |
| Ssl session cache misses | 0 | |
| Ssl session cache mode | NONE | |
| Ssl session cache overflows | 0 | |
| Ssl session cache size | 0 | |
| Ssl session cache timeouts | 0 | |
| Ssl sessions reused | 0 | |
| Ssl used session cache entries | 0 | |
| Ssl verify depth | 0 | |
| Ssl verify mode | 0 | |
| Ssl version | ||
| Subquery cache hit | 0 | |
| Subquery cache miss | 0 | |
| Syncs | 10.7 k | |
| Table locks immediate | 3.7 M | 立即需要锁定表的次数。 |
| Table locks waited | 1 | 无法立即获得锁定表而必须等待的次数。如果该值很高，且您遇到了性能方面的问题，则应该首先检查您的查询语句，然后使用复制操作来分开表。 |
| Tc log max pages used | 0 | |
| Tc log page size | 4.1 k | |
| Tc log page waits | 0 | |
| Threadpool idle threads | 0 | |
| Threadpool threads | 0 | |
| Threads cached | 0 | 线程缓存中线程的数量。缓存命中率可以由 Threads_created/Connections 计算得出。如果该值是红色的，则应该增加 thread_cache_size 的值。 |
| Threads connected | 4 | 当前打开的连接数。 |
| Threads created | 52.6 k | 当前用于控制连接的线程数。如果 Threads_created 很大，您可能需要增加 thread_cache_size 的值。(如果线程状况良好，这么做通常并不会带来显著的性能提升。) |
| Threads running | 2 | 非睡眠状态的线程数量。 |
| Update scan | 0 | |
| Uptime | 0 天 4 小时，20 分 21 秒 | |
| Uptime since flush status | 0 天 4 小时，20 分 21 秒 | |
| wsrep cluster conf id | 18.4 E | |
| wsrep cluster size | 0 | |
| wsrep cluster state uuid | ||
| wsrep cluster status | Disconnected | |
| wsrep connected | OFF | |
| wsrep local bf aborts | 0 | |
| wsrep local index | 18.4 E | |
| wsrep provider name | ||
| wsrep provider vendor | ||
| wsrep provider version | ||
| wsrep ready | OFF | |
| wsrep thread count | 0 | |
| Key buffer fraction % | 18.33 % | 已用键缓存百分比（计算值） |
| Key read ratio % | 22.02 % | Key cache miss calculated as rate of physical reads compared to read requests (calculated value) |
| Threads cache hitrate % | <0.01 % | 线程缓存命中率 （计算值） |