Aborted clients | 00 | 因客户端没有关闭连接而中止的连接数。 |
---|
Aborted connects | 34 34 | 尝试连接到 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 | 783 783 | |
---|
Aria pagecache read requests | 15.1 M15080123 | |
---|
Aria pagecache reads | 423.2 k423186 | |
---|
Aria pagecache write requests | 987.8 k987754 | |
---|
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 | 3.1 G3123980817 | |
---|
Bytes sent | 10.6 G10649345766 | |
---|
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 | 165.5 k165539 | |
---|
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 | 94.7 k94716 | |
---|
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 | 66.5 k66548 | |
---|
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 | 94.7 k94716 | |
---|
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 | 16.5 k16477 | |
---|
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 | 7.8 M7751958 | |
---|
Com set option | 133.1 k133096 | |
---|
Com show authors | 00 | |
---|
Com show binlog events | 00 | |
---|
Com show binlogs | 13.9 k13945 | |
---|
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 | 270 270 | |
---|
Com show create table | 148.9 k148854 | |
---|
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 | 399.9 k399935 | |
---|
Com show function status | 00 | |
---|
Com show generic | 00 | |
---|
Com show grants | 23.7 k23679 | |
---|
Com show keys | 388.5 k388468 | |
---|
Com show master status | 19.4 k19390 | |
---|
Com show open tables | 00 | |
---|
Com show plugins | 1.3 k1341 | |
---|
Com show privileges | 00 | |
---|
Com show procedure status | 00 | |
---|
Com show processlist | 9 9 | |
---|
Com show profile | 00 | |
---|
Com show profiles | 00 | |
---|
Com show relaylog events | 00 | |
---|
Com show slave hosts | 00 | |
---|
Com show slave status | 19.5 k19537 | |
---|
Com show status | 190 190 | |
---|
Com show storage engines | 778 778 | |
---|
Com show table status | 8.1 k8104 | |
---|
Com show tables | 143.7 k143656 | |
---|
Com show triggers | 00 | |
---|
Com show variables | 28 k28030 | |
---|
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 | 687 687 | |
---|
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 | 133.1 k133132 | 尝试连接到 MySQL 服务器的连接数 (不论成功或失败) 。 |
---|
Cpu time | 00.000000 | |
---|
Created tmp disk tables | 506.3 k506319 | 服务器执行语句时自动在磁盘上创建的临时表的数量。如果 Created_tmp_disk_tables 很大,你可以增加 tmp_table_size 的值,让服务器使用内存来存储临时表而非磁盘。 |
---|
Created tmp files | 5 5 | mysqld 已创建的临时文件的数量。 |
---|
Created tmp tables | 4.4 M4400716 | 服务器执行语句时自动在内存中创建的临时表的数量。 |
---|
Delayed errors | 00 | 发生错误的延迟插入 (INSERT DELAYED) 行数 (可能是因为在唯一字段中存在重复值) 。 |
---|
Delayed insert threads | 00 | 正在使用的延迟插入处理线程的数量。每张使用延迟插入的表都有自己的线程。 |
---|
Delayed writes | 00 | 延迟插入已写入的行数。 |
---|
Delete scan | 00 | |
---|
Empty queries | 2.8 M2768702 | |
---|
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 | 141 k141019 | |
---|
Feature timezone | 00 | |
---|
Feature trigger | 9 k8974 | |
---|
Feature xml | 00 | |
---|
Flush commands | 1 1 | 已执行的强制更新 (FLUSH) 语句数。 |
---|
Handler commit | 5.3 M5341959 | 已执行的内部提交 (COMMIT) 语句数。 |
---|
Handler delete | 00 | 从表中删除行的次数。 |
---|
Handler discover | 156.7 k156743 | 如果知道一张表的名字,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 | 1.1 M1120433 | 读取一个索引入口点的次数。如果该值很大,说明你的服务器执行了很多完整索引扫描。例如,假设字段 col1 已经建立了索引,然后执行 SELECT col1 FROM foo 。 |
---|
Handler read key | 4.4 M4392523 | 根据索引读取行的请求数。如果该值很大,说明你的查询和表都建立了很好的索引。 |
---|
Handler read last | 79 79 | |
---|
Handler read next | 5.3 G5296623899 | 根据索引顺序读取下一行的请求数。如果你在查询一个已索引的字段且限制了范围,或进行完整表扫描,该值将会不断增长。 |
---|
Handler read prev | 1.9 k1896 | 根据索引顺序读取上一行的请求数。这种读取方式通常用于优化带有 ORDER BY … DESC 的查询。 |
---|
Handler read retry | 00 | |
---|
Handler read rnd | 7.2 M7187993 | 根据固定位置读取行的请求数。如果你执行很多需要排序的查询,该值会很高。你可能有很多需要完整表扫描的查询,或者你使用了不正确的索引用来多表查询。 |
---|
Handler read rnd deleted | 67.7 k67691 | |
---|
Handler read rnd next | 97.5 M97534353 | 从数据文件中读取行的请求数。如果你在扫描很多表,该值会很大。通常情况下这意味着你的表没有做好索引,或者你的查询语句没有使用好索引字段。 |
---|
Handler rollback | 00 | 内部回滚 (ROLLBACK) 语句数。 |
---|
Handler savepoint | 00 | |
---|
Handler savepoint rollback | 00 | |
---|
Handler tmp update | 00 | |
---|
Handler tmp write | 97.4 M97356016 | |
---|
Handler update | 17.2 k17161 | 表中更新行的请求数。 |
---|
Handler write | 111.2 k111193 | 表中插入行的请求数。 |
---|
Innodb available undo logs | 128 128 | |
---|
Innodb background log sync | 27.3 k27323 | |
---|
Innodb buffer pool bytes data | 299.9 M299941888 | |
---|
Innodb buffer pool bytes dirty | 753.7 k753664 | |
---|
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 | 18.3 k18307 | 非空页数 (含脏页) 。 |
---|
Innodb buffer pool pages dirty | 46 46 | 当前脏页数。 |
---|
Innodb buffer pool pages flushed | 18.9 k18944 | 请求更新的缓冲池页数。 |
---|
Innodb buffer pool pages free | 14.4 k14444 | 空闲页数。 |
---|
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 | 6.8 k6777 | |
---|
Innodb buffer pool pages total | 32.8 k32767 | 缓冲池总大小 (单位:页)。 |
---|
Innodb buffer pool read ahead | 11.2 k11247 | |
---|
Innodb buffer pool read ahead evicted | 00 | |
---|
Innodb buffer pool read ahead rnd | 00 | InnoDB 初始化的“随机”预读数。这通常会在对一张表进行大范围的随机排序查询时发生。 |
---|
Innodb buffer pool read requests | 767.2 M767191413 | InnoDB 完成的逻辑读请求数。 |
---|
Innodb buffer pool reads | 6.8 k6847 | InnoDB 进行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。 |
---|
Innodb buffer pool wait free | 00 | 写入 InnoDB 缓冲池通常在后台进行,但有必要在没有干净页的时候读取或创建页,有必要先等待页被刷新。该计数器统计了这种等待的数量。如果缓冲池大小设置正确,这个值应该会很小。 |
---|
Innodb buffer pool write requests | 179.6 k179595 | 写入 InnoDB 缓冲池的次数。 |
---|
Innodb checkpoint age | 28.6 k28562 | |
---|
Innodb checkpoint max age | 7.8 M7782360 | |
---|
Innodb data fsyncs | 39.7 k39693 | fsync() 总操作的次数。 |
---|
Innodb data pending fsyncs | 00 | 当前挂起 fsync() 操作的数量。 |
---|
Innodb data pending reads | 00 | 当前挂起的读操作数。 |
---|
Innodb data pending writes | 00 | 当前挂起的写操作数。 |
---|
Innodb data read | 322 M322032128 | 读取的总数据量 (单位:字节)。 |
---|
Innodb data reads | 11.2 k11231 | 数据读取总数。 |
---|
Innodb data writes | 48.6 k48626 | 数据写入总数。 |
---|
Innodb data written | 661.6 M661628416 | 写入的总数据量 (单位:字节)。 |
---|
Innodb dblwr pages written | 18.9 k18944 | 以双写入操作写入的页数。 |
---|
Innodb dblwr writes | 433 433 | 已经执行的双写入次数。 |
---|
Innodb deadlocks | 00 | |
---|
Innodb have atomic builtins | ONON | |
---|
Innodb history list length | 1.4 k1400 | |
---|
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 | 39.9 k39904 | 日志写入请求数。 |
---|
Innodb log writes | 38.2 k38226 | 日志物理写入次数。 |
---|
Innodb lsn current | 22.9 G22897592638 | |
---|
Innodb lsn flushed | 22.9 G22897592618 | |
---|
Innodb lsn last checkpoint | 22.9 G22897564076 | |
---|
Innodb master thread active loops | 27.1 k27089 | |
---|
Innodb master thread idle loops | 234 234 | |
---|
Innodb max trx id | 2 G2012575636 | |
---|
Innodb mem adaptive hash | 9.1 M9117392 | |
---|
Innodb mem dictionary | 11.5 M11518841 | |
---|
Innodb mem total | 563.1 M563085312 | |
---|
Innodb mutex os waits | 124.1 k124051 | |
---|
Innodb mutex spin rounds | 4.7 M4734459 | |
---|
Innodb mutex spin waits | 153.8 k153839 | |
---|
Innodb oldest view low limit trx id | 00 | |
---|
Innodb os log fsyncs | 38.5 k38515 | 使用 fsync() 写入日志文件的次数。 |
---|
Innodb os log pending fsyncs | 00 | 当前挂起的 fsync 日志文件数。 |
---|
Innodb os log pending writes | 00 | 当前挂起的日志写入数。 |
---|
Innodb os log written | 38.6 M38625792 | 写入日志文件的字节数。 |
---|
Innodb page size | 16.4 k16384 | 编译的 InnoDB 页大小 (默认 16KB)。许多值都以页为单位进行统计,页大小可以很方便地将这些值转化为字节数。 |
---|
Innodb pages created | 176 176 | 创建的页数。 |
---|
Innodb pages read | 18.1 k18131 | 读取的页数。 |
---|
Innodb pages0 read | 2.7 k2671 | |
---|
Innodb pages written | 18.9 k18944 | 写入的页数。 |
---|
Innodb purge trx id | 2 G2012574571 | |
---|
Innodb purge undo no | 00 | |
---|
Innodb read views memory | 1.4 k1400 | |
---|
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 | 5.3 G5297039526 | 从 InnoDB 表中读取的行数。 |
---|
Innodb rows updated | 17.2 k17161 | InnoDB 中更新的行数。 |
---|
Innodb system rows deleted | 00 | |
---|
Innodb system rows inserted | 00 | |
---|
Innodb system rows read | 5.2 k5157 | |
---|
Innodb system rows updated | 00 | |
---|
Innodb s lock os waits | 1.1 k1050 | |
---|
Innodb s lock spin rounds | 42.4 k42363 | |
---|
Innodb s lock spin waits | 1.4 k1416 | |
---|
Innodb truncated status writes | 00 | |
---|
Innodb x lock os waits | 528 528 | |
---|
Innodb x lock spin rounds | 17.9 k17903 | |
---|
Innodb x lock spin waits | 148 148 | |
---|
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 | 319 319 | |
---|
Innodb num non index pages written | 57.7 k57733 | |
---|
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 | 25 25 | 键缓存中已经使用的块数。该值指示在某个时刻使用了最多块数的数量。 |
---|
Key blocks warm | 00 | |
---|
Key read requests | 2.1 M2145943 | 从缓存中读取键块的请求次数。 |
---|
Key reads | 405.3 k405291 | 从磁盘中物理读取键块的次数。如果 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 | 58 58 | 自服务器启动以来的最高并发连接数。 |
---|
Memory used | 176.9 M176923936 | |
---|
Not flushed delayed rows | 00 | 等待写入延迟插入队列的行数。 |
---|
Open files | 47 47 | 打开的文件个数。 |
---|
Open streams | 00 | 打开的流个数 (主要用于日志记录)。 |
---|
Open table definitions | 400 400 | |
---|
Open tables | 64 64 | 打开的数据表个数。 |
---|
Opened files | 19 M19024167 | |
---|
Opened plugin libraries | 210 210 | |
---|
Opened table definitions | 12.4 M12434288 | |
---|
Opened tables | 13.5 M13544767 | 已经打开的表个数。如果该值很大,则说明表缓冲大小可能设置过小。 |
---|
Opened views | 20.1 k20078 | |
---|
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 | 9.7 M9653027 | |
---|
Questions | 9.7 M9653027 | |
---|
Rows read | 5.3 G5298380587 | |
---|
Rows sent | 61.2 M61167812 | |
---|
Rows tmp read | 98.9 M98885410 | |
---|
Rpl status | AUTH_MASTERAUTH_MASTER | 失败保护器的状态 (尚未应用)。 |
---|
Select full join | 66.2 k66162 | 没有使用索引的多表查询数。如果该值不为0,您应该仔细检查是否已经为表建立了适当的索引。 |
---|
Select full range join | 00 | 使用在关联表上使用范围搜索的多表查询的数量。 |
---|
Select range | 00 | 在第一张表上使用范围查询的多表查询数。(即使该值很大,通常也不会有致命的影响。) |
---|
Select range check | 00 | 没有使用索引但在每行之后检查索引使用的多表查询数。(如果该值不为 0,您应该仔细检查是否已经为表建立了适当的索引。) |
---|
Select scan | 4.5 M4468166 | 在第一张表上进行了完整表扫描的多表查询数。 |
---|
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.1 k7088 | |
---|
Sort range | 793 793 | 局部范围完成的排序次数。 |
---|
Sort rows | 7.2 M7187995 | 排序的行数。 |
---|
Sort scan | 1.6 M1630985 | 扫描表完成的排序次数。 |
---|
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 | 27.2 k27182 | |
---|
Table locks immediate | 6.4 M6411033 | 立即需要锁定表的次数。 |
---|
Table locks waited | 2 2 | 无法立即获得锁定表而必须等待的次数。如果该值很高,且您遇到了性能方面的问题,则应该首先检查您的查询语句,然后使用复制操作来分开表。 |
---|
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 | 18 18 | 当前打开的连接数。 |
---|
Threads created | 133.1 k133130 | 当前用于控制连接的线程数。如果 Threads_created 很大,您可能需要增加 thread_cache_size 的值。(如果线程状况良好,这么做通常并不会带来显著的性能提升。) |
---|
Threads running | 6 6 | 非睡眠状态的线程数量。 |
---|
Update scan | 00 | |
---|
Uptime | 0 天 7 小时,36 分 46 秒27406 | |
---|
Uptime since flush status | 0 天 7 小时,36 分 46 秒27406 | |
---|
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 % | 18.89 %18.886382350323 | Key cache miss calculated as rate of physical reads compared to read requests (calculated value) |
---|
Threads cache hitrate % | <0.01 %0.0015022684253267 | 线程缓存命中率 (计算值) |
---|