Aborted clients | 00 | 因客户端没有关闭连接而中止的连接数。 |
---|
Aborted connects | 1 1 | 尝试连接到 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 | 486 486 | |
---|
Aria pagecache read requests | 5.1 M5073658 | |
---|
Aria pagecache reads | 189.8 k189838 | |
---|
Aria pagecache write requests | 413.5 k413534 | |
---|
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 | 1.2 G1177724140 | |
---|
Bytes sent | 3.9 G3850010792 | |
---|
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 | 71.9 k71923 | |
---|
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 | 40.6 k40572 | |
---|
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 | 23.7 k23740 | |
---|
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 | 40.6 k40572 | |
---|
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 | 4.5 k4539 | |
---|
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 M2962637 | |
---|
Com set option | 47.5 k47482 | |
---|
Com show authors | 00 | |
---|
Com show binlog events | 00 | |
---|
Com show binlogs | 6.7 k6661 | |
---|
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 | 78 78 | |
---|
Com show create table | 78.6 k78581 | |
---|
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 | 183.3 k183310 | |
---|
Com show function status | 00 | |
---|
Com show generic | 00 | |
---|
Com show grants | 10.1 k10143 | |
---|
Com show keys | 178.8 k178762 | |
---|
Com show master status | 9 k9005 | |
---|
Com show open tables | 00 | |
---|
Com show plugins | 310 310 | |
---|
Com show privileges | 00 | |
---|
Com show procedure status | 00 | |
---|
Com show processlist | 1 1 | |
---|
Com show profile | 00 | |
---|
Com show profiles | 00 | |
---|
Com show relaylog events | 00 | |
---|
Com show slave hosts | 00 | |
---|
Com show slave status | 9 k9041 | |
---|
Com show status | 49 49 | |
---|
Com show storage engines | 226 226 | |
---|
Com show table status | 2.4 k2424 | |
---|
Com show tables | 52.3 k52310 | |
---|
Com show triggers | 00 | |
---|
Com show variables | 8.2 k8172 | |
---|
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 | 272 272 | |
---|
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 | 47.5 k47485 | 尝试连接到 MySQL 服务器的连接数 (不论成功或失败) 。 |
---|
Cpu time | 00.000000 | |
---|
Created tmp disk tables | 216.4 k216393 | 服务器执行语句时自动在磁盘上创建的临时表的数量。如果 Created_tmp_disk_tables 很大,你可以增加 tmp_table_size 的值,让服务器使用内存来存储临时表而非磁盘。 |
---|
Created tmp files | 5 5 | mysqld 已创建的临时文件的数量。 |
---|
Created tmp tables | 1.6 M1622094 | 服务器执行语句时自动在内存中创建的临时表的数量。 |
---|
Delayed errors | 00 | 发生错误的延迟插入 (INSERT DELAYED) 行数 (可能是因为在唯一字段中存在重复值) 。 |
---|
Delayed insert threads | 00 | 正在使用的延迟插入处理线程的数量。每张使用延迟插入的表都有自己的线程。 |
---|
Delayed writes | 00 | 延迟插入已写入的行数。 |
---|
Delete scan | 00 | |
---|
Empty queries | 1.2 M1220417 | |
---|
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 | 50.1 k50084 | |
---|
Feature timezone | 00 | |
---|
Feature trigger | 2.7 k2721 | |
---|
Feature xml | 00 | |
---|
Flush commands | 1 1 | 已执行的强制更新 (FLUSH) 语句数。 |
---|
Handler commit | 2.1 M2100145 | 已执行的内部提交 (COMMIT) 语句数。 |
---|
Handler delete | 00 | 从表中删除行的次数。 |
---|
Handler discover | 44.1 k44126 | 如果知道一张表的名字,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 | 394.6 k394566 | 读取一个索引入口点的次数。如果该值很大,说明你的服务器执行了很多完整索引扫描。例如,假设字段 col1 已经建立了索引,然后执行 SELECT col1 FROM foo 。 |
---|
Handler read key | 1.8 M1775846 | 根据索引读取行的请求数。如果该值很大,说明你的查询和表都建立了很好的索引。 |
---|
Handler read last | 29 29 | |
---|
Handler read next | 1.7 G1734666765 | 根据索引顺序读取下一行的请求数。如果你在查询一个已索引的字段且限制了范围,或进行完整表扫描,该值将会不断增长。 |
---|
Handler read prev | 696 696 | 根据索引顺序读取上一行的请求数。这种读取方式通常用于优化带有 ORDER BY … DESC 的查询。 |
---|
Handler read retry | 00 | |
---|
Handler read rnd | 2.4 M2392237 | 根据固定位置读取行的请求数。如果你执行很多需要排序的查询,该值会很高。你可能有很多需要完整表扫描的查询,或者你使用了不正确的索引用来多表查询。 |
---|
Handler read rnd deleted | 24.1 k24074 | |
---|
Handler read rnd next | 33.4 M33420104 | 从数据文件中读取行的请求数。如果你在扫描很多表,该值会很大。通常情况下这意味着你的表没有做好索引,或者你的查询语句没有使用好索引字段。 |
---|
Handler rollback | 00 | 内部回滚 (ROLLBACK) 语句数。 |
---|
Handler savepoint | 00 | |
---|
Handler savepoint rollback | 00 | |
---|
Handler tmp update | 00 | |
---|
Handler tmp write | 33.4 M33431944 | |
---|
Handler update | 4.8 k4811 | 表中更新行的请求数。 |
---|
Handler write | 45.1 k45111 | 表中插入行的请求数。 |
---|
Innodb available undo logs | 128 128 | |
---|
Innodb background log sync | 9.8 k9792 | |
---|
Innodb buffer pool bytes data | 193.3 M193298432 | |
---|
Innodb buffer pool bytes dirty | 4.1 M4063232 | |
---|
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 k11798 | 非空页数 (含脏页) 。 |
---|
Innodb buffer pool pages dirty | 248 248 | 当前脏页数。 |
---|
Innodb buffer pool pages flushed | 4.9 k4880 | 请求更新的缓冲池页数。 |
---|
Innodb buffer pool pages free | 21 k20953 | 空闲页数。 |
---|
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 k4335 | |
---|
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 | 253.2 M253155692 | InnoDB 完成的逻辑读请求数。 |
---|
Innodb buffer pool reads | 6.7 k6744 | InnoDB 进行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。 |
---|
Innodb buffer pool wait free | 00 | 写入 InnoDB 缓冲池通常在后台进行,但有必要在没有干净页的时候读取或创建页,有必要先等待页被刷新。该计数器统计了这种等待的数量。如果缓冲池大小设置正确,这个值应该会很小。 |
---|
Innodb buffer pool write requests | 54.3 k54323 | 写入 InnoDB 缓冲池的次数。 |
---|
Innodb checkpoint age | 414.8 k414824 | |
---|
Innodb checkpoint max age | 7.8 M7782360 | |
---|
Innodb data fsyncs | 13.1 k13111 | fsync() 总操作的次数。 |
---|
Innodb data pending fsyncs | 00 | 当前挂起 fsync() 操作的数量。 |
---|
Innodb data pending reads | 00 | 当前挂起的读操作数。 |
---|
Innodb data pending writes | 00 | 当前挂起的写操作数。 |
---|
Innodb data read | 214.3 M214274560 | 读取的总数据量 (单位:字节)。 |
---|
Innodb data reads | 11 k10992 | 数据读取总数。 |
---|
Innodb data writes | 15.3 k15310 | 数据写入总数。 |
---|
Innodb data written | 173.8 M173838848 | 写入的总数据量 (单位:字节)。 |
---|
Innodb dblwr pages written | 4.9 k4880 | 以双写入操作写入的页数。 |
---|
Innodb dblwr writes | 76 76 | 已经执行的双写入次数。 |
---|
Innodb deadlocks | 00 | |
---|
Innodb have atomic builtins | ONON | |
---|
Innodb history list length | 1.3 k1306 | |
---|
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 | 10.7 k10689 | 日志写入请求数。 |
---|
Innodb log writes | 12.8 k12830 | 日志物理写入次数。 |
---|
Innodb lsn current | 23 G22957308198 | |
---|
Innodb lsn flushed | 23 G22957308198 | |
---|
Innodb lsn last checkpoint | 23 G22956893374 | |
---|
Innodb master thread active loops | 9.7 k9729 | |
---|
Innodb master thread idle loops | 64 64 | |
---|
Innodb max trx id | 2.1 G2075936696 | |
---|
Innodb mem adaptive hash | 9.1 M9117392 | |
---|
Innodb mem dictionary | 11.5 M11518841 | |
---|
Innodb mem total | 563.1 M563085312 | |
---|
Innodb mutex os waits | 39.2 k39199 | |
---|
Innodb mutex spin rounds | 1.5 M1520941 | |
---|
Innodb mutex spin waits | 49.9 k49926 | |
---|
Innodb oldest view low limit trx id | 00 | |
---|
Innodb os log fsyncs | 12.9 k12883 | 使用 fsync() 写入日志文件的次数。 |
---|
Innodb os log pending fsyncs | 00 | 当前挂起的 fsync 日志文件数。 |
---|
Innodb os log pending writes | 00 | 当前挂起的日志写入数。 |
---|
Innodb os log written | 11.8 M11806208 | 写入日志文件的字节数。 |
---|
Innodb page size | 16.4 k16384 | 编译的 InnoDB 页大小 (默认 16KB)。许多值都以页为单位进行统计,页大小可以很方便地将这些值转化为字节数。 |
---|
Innodb pages created | 196 196 | 创建的页数。 |
---|
Innodb pages read | 11.6 k11602 | 读取的页数。 |
---|
Innodb pages0 read | 2.7 k2671 | |
---|
Innodb pages written | 4.9 k4880 | 写入的页数。 |
---|
Innodb purge trx id | 2.1 G2075935044 | |
---|
Innodb purge undo no | 00 | |
---|
Innodb read views memory | 1.2 k1176 | |
---|
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.7 G1734655620 | 从 InnoDB 表中读取的行数。 |
---|
Innodb rows updated | 4.8 k4811 | InnoDB 中更新的行数。 |
---|
Innodb system rows deleted | 00 | |
---|
Innodb system rows inserted | 00 | |
---|
Innodb system rows read | 1.3 k1279 | |
---|
Innodb system rows updated | 00 | |
---|
Innodb s lock os waits | 209 209 | |
---|
Innodb s lock spin rounds | 10.4 k10443 | |
---|
Innodb s lock spin waits | 349 349 | |
---|
Innodb truncated status writes | 00 | |
---|
Innodb x lock os waits | 168 168 | |
---|
Innodb x lock spin rounds | 5.8 k5757 | |
---|
Innodb x lock spin waits | 53 53 | |
---|
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 | 77 77 | |
---|
Innodb num non index pages written | 17.8 k17809 | |
---|
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 | 23 23 | 键缓存中已经使用的块数。该值指示在某个时刻使用了最多块数的数量。 |
---|
Key blocks warm | 00 | |
---|
Key read requests | 837.6 k837560 | 从缓存中读取键块的请求次数。 |
---|
Key reads | 148 k147953 | 从磁盘中物理读取键块的次数。如果 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 | 170 M170011912 | |
---|
Not flushed delayed rows | 00 | 等待写入延迟插入队列的行数。 |
---|
Open files | 55 55 | 打开的文件个数。 |
---|
Open streams | 00 | 打开的流个数 (主要用于日志记录)。 |
---|
Open table definitions | 400 400 | |
---|
Open tables | 64 64 | 打开的数据表个数。 |
---|
Opened files | 6.2 M6232383 | |
---|
Opened plugin libraries | 245 245 | |
---|
Opened table definitions | 3.9 M3918209 | |
---|
Opened tables | 4.3 M4325782 | 已经打开的表个数。如果该值很大,则说明表缓冲大小可能设置过小。 |
---|
Opened views | 6.8 k6757 | |
---|
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 | 3.8 M3778274 | |
---|
Questions | 3.8 M3778274 | |
---|
Rows read | 1.7 G1735141473 | |
---|
Rows sent | 20.8 M20777060 | |
---|
Rows tmp read | 33.8 M33821310 | |
---|
Rpl status | AUTH_MASTERAUTH_MASTER | 失败保护器的状态 (尚未应用)。 |
---|
Select full join | 23.6 k23563 | 没有使用索引的多表查询数。如果该值不为0,您应该仔细检查是否已经为表建立了适当的索引。 |
---|
Select full range join | 00 | 使用在关联表上使用范围搜索的多表查询的数量。 |
---|
Select range | 00 | 在第一张表上使用范围查询的多表查询数。(即使该值很大,通常也不会有致命的影响。) |
---|
Select range check | 00 | 没有使用索引但在每行之后检查索引使用的多表查询数。(如果该值不为 0,您应该仔细检查是否已经为表建立了适当的索引。) |
---|
Select scan | 1.7 M1663730 | 在第一张表上进行了完整表扫描的多表查询数。 |
---|
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 | 2.1 k2127 | |
---|
Sort range | 252 252 | 局部范围完成的排序次数。 |
---|
Sort rows | 2.4 M2392237 | 排序的行数。 |
---|
Sort scan | 564.7 k564706 | 扫描表完成的排序次数。 |
---|
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 | 7.7 k7738 | |
---|
Table locks immediate | 2.5 M2501929 | 立即需要锁定表的次数。 |
---|
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 | 18 18 | 当前打开的连接数。 |
---|
Threads created | 47.5 k47483 | 当前用于控制连接的线程数。如果 Threads_created 很大,您可能需要增加 thread_cache_size 的值。(如果线程状况良好,这么做通常并不会带来显著的性能提升。) |
---|
Threads running | 6 6 | 非睡眠状态的线程数量。 |
---|
Update scan | 00 | |
---|
Uptime | 0 天 2 小时,43 分 45 秒9825 | |
---|
Uptime since flush status | 0 天 2 小时,43 分 45 秒9825 | |
---|
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 % | 17.66 %17.664764315392 | Key cache miss calculated as rate of physical reads compared to read requests (calculated value) |
---|
Threads cache hitrate % | <0.01 %0.0042118563757043 | 线程缓存命中率 (计算值) |
---|