- 表收藏夹为空。
将文件拖动至此
控制台
| 变量 | 值 | 说明 |
|---|---|---|
|
Aborted clients
|
0 | 因客户端没有关闭连接而中止的连接数。 |
|
Aborted connects
|
0 | 尝试连接到 MySQL 服务器但失败的连接数。 |
|
Aborted connects preauth
|
0 | |
|
Access denied errors
|
0 | |
|
Acl column grants
|
0 | |
|
Acl database grants
|
5 | |
|
Acl function grants
|
0 | |
|
Acl procedure grants
|
0 | |
|
Acl package spec grants
|
0 | |
|
Acl package body grants
|
0 | |
|
Acl proxy users
|
1 | |
|
Acl role grants
|
0 | |
|
Acl roles
|
0 | |
|
Acl table grants
|
0 | |
|
Acl users
|
6 | |
|
Aria pagecache blocks not flushed
|
0 | |
|
Aria pagecache blocks unused
|
15.6 k | |
|
Aria pagecache blocks used
|
117 | |
|
Aria pagecache read requests
|
3.6 M | |
|
Aria pagecache reads
|
113.4 k | |
|
Aria pagecache write requests
|
238.3 k | |
|
Aria pagecache writes
|
238.3 k | |
|
Aria transaction log syncs
|
170 | |
|
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
|
205.9 M | |
|
Bytes sent
|
779.5 M | |
| Column compressions | 0 | |
| Column decompressions | 0 | |
|
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 sequence
|
0 | |
|
Com alter table
|
0 | |
|
Com alter tablespace
|
0 | |
|
Com alter user
|
0 | |
|
Com analyze
|
0 | |
|
Com assign to keycache
|
0 | |
|
Com backup
|
0 | |
|
Com backup lock
|
0 | |
|
Com begin
|
0 | |
|
Com binlog
|
0 | |
|
Com call procedure
|
0 | |
|
Com change db
|
59.1 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 package
|
0 | |
|
Com create package body
|
0 | |
|
Com create procedure
|
0 | |
|
Com create role
|
0 | |
|
Com create sequence
|
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
|
0 | |
|
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 package
|
0 | |
|
Com drop package body
|
0 | |
|
Com drop role
|
0 | |
|
Com drop server
|
0 | |
|
Com drop sequence
|
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 execute immediate
|
0 | |
|
Com flush
|
3 | |
|
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
|
1 | |
|
Com insert select
|
0 | |
|
Com install plugin
|
0 | |
|
Com kill
|
0 | |
|
Com load
|
0 | |
|
Com lock tables
|
0 | |
|
Com multi
|
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
|
16.4 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
|
1.5 M | |
|
Com set option
|
88.2 k | |
|
Com show authors
|
0 | |
|
Com show binlog events
|
0 | |
|
Com show binlogs
|
657 | |
|
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 package
|
0 | |
|
Com show create package body
|
0 | |
|
Com show create proc
|
0 | |
|
Com show create table
|
25.1 k | |
|
Com show create trigger
|
0 | |
|
Com show create user
|
0 | |
|
Com show databases
|
3 | |
|
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
|
106.3 k | |
|
Com show function status
|
0 | |
|
Com show generic
|
0 | |
|
Com show grants
|
26.5 k | |
|
Com show keys
|
118 k | |
|
Com show master status
|
209 | |
|
Com show open tables
|
0 | |
|
Com show package status
|
0 | |
|
Com show package body status
|
0 | |
|
Com show plugins
|
0 | |
|
Com show privileges
|
0 | |
|
Com show procedure status
|
0 | |
|
Com show processlist
|
7 | |
|
Com show profile
|
0 | |
|
Com show profiles
|
0 | |
|
Com show relaylog events
|
0 | |
|
Com show slave hosts
|
0 | |
|
Com show slave status
|
220 | |
|
Com show status
|
38 | |
|
Com show storage engines
|
1.2 k | |
|
Com show table status
|
112 | |
|
Com show tables
|
37.1 k | |
|
Com show triggers
|
0 | |
| Com show variables | 45.2 k | |
|
Com show warnings
|
21.3 k | |
|
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
|
34 | |
|
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
|
58.8 k | 尝试连接到 MySQL 服务器的连接数 (不论成功或失败) 。 |
|
Cpu time
|
0 | |
|
Created tmp disk tables
|
133.5 k | 服务器执行语句时自动在磁盘上创建的临时表的数量。如果 Created_tmp_disk_tables 很大，你可以增加 tmp_table_size 的值，让服务器使用内存来存储临时表而非磁盘。 |
|
Created tmp files
|
4 | mysqld 已创建的临时文件的数量。 |
|
Created tmp tables
|
1.4 M | 服务器执行语句时自动在内存中创建的临时表的数量。 |
|
Delayed errors
|
0 | 发生错误的延迟插入 (INSERT DELAYED) 行数 (可能是因为在唯一字段中存在重复值) 。 |
|
Delayed insert threads
|
0 | 正在使用的延迟插入处理线程的数量。每张使用延迟插入的表都有自己的线程。 |
|
Delayed writes
|
0 | 延迟插入已写入的行数。 |
|
Delete scan
|
0 | |
|
Empty queries
|
852.9 k | |
|
Executed events
|
0 | |
|
Executed triggers
|
0 | |
|
Feature application time periods
|
0 | |
|
Feature check constraint
|
1 | |
|
Feature custom aggregate functions
|
0 | |
|
Feature delay key write
|
0 | |
|
Feature dynamic columns
|
0 | |
|
Feature fulltext
|
0 | |
|
Feature gis
|
0 | |
|
Feature invisible columns
|
0 | |
|
Feature json
|
8.5 M | |
|
Feature locale
|
29.4 k | |
|
Feature subquery
|
27 k | |
|
Feature system versioning
|
0 | |
|
Feature timezone
|
0 | |
|
Feature trigger
|
0 | |
|
Feature window functions
|
0 | |
|
Feature xml
|
0 | |
|
Flush commands
|
1 | 已执行的强制更新 (FLUSH) 语句数。 |
|
Handler commit
|
844.7 k | 已执行的内部提交 (COMMIT) 语句数。 |
|
Handler delete
|
0 | 从表中删除行的次数。 |
|
Handler discover
|
52 | 如果知道一张表的名字，MySQL 服务器可以询问 NDB 集群存储引擎，这被称为“发现”。Handler_discovery 表明了一张表被发现的次数。 |
|
Handler external lock
|
0 | |
|
Handler icp attempts
|
53 | |
|
Handler icp match
|
46 | |
|
Handler mrr init
|
0 | |
|
Handler mrr key refills
|
0 | |
|
Handler mrr rowid refills
|
0 | |
|
Handler prepare
|
0 | |
|
Handler read first
|
28.2 k | 读取一个索引入口点的次数。如果该值很大，说明你的服务器执行了很多完整索引扫描。例如，假设字段 col1 已经建立了索引，然后执行 SELECT col1 FROM foo 。 |
|
Handler read key
|
288.3 k | 根据索引读取行的请求数。如果该值很大，说明你的查询和表都建立了很好的索引。 |
|
Handler read last
|
0 | |
|
Handler read next
|
7.4 k | 根据索引顺序读取下一行的请求数。如果你在查询一个已索引的字段且限制了范围，或进行完整表扫描，该值将会不断增长。 |
|
Handler read prev
|
0 | 根据索引顺序读取上一行的请求数。这种读取方式通常用于优化带有 ORDER BY … DESC 的查询。 |
|
Handler read retry
|
0 | |
|
Handler read rnd
|
419.7 k | 根据固定位置读取行的请求数。如果你执行很多需要排序的查询，该值会很高。你可能有很多需要完整表扫描的查询，或者你使用了不正确的索引用来多表查询。 |
|
Handler read rnd deleted
|
26.9 k | |
|
Handler read rnd next
|
25.7 M | 从数据文件中读取行的请求数。如果你在扫描很多表，该值会很大。通常情况下这意味着你的表没有做好索引，或者你的查询语句没有使用好索引字段。 |
|
Handler rollback
|
0 | 内部回滚 (ROLLBACK) 语句数。 |
|
Handler savepoint
|
0 | |
|
Handler savepoint rollback
|
0 | |
|
Handler tmp delete
|
0 | |
|
Handler tmp update
|
0 | |
|
Handler tmp write
|
28.2 M | |
|
Handler update
|
16.4 k | 表中更新行的请求数。 |
|
Handler write
|
16.4 k | 表中插入行的请求数。 |
|
Innodb buffer pool dump status
|
||
|
Innodb buffer pool load status
|
Buffer pool(s) load completed at 250925 11:03:18 | |
|
Innodb buffer pool resize status
|
||
|
Innodb buffer pool load incomplete
|
OFF | |
|
Innodb buffer pool pages data
|
258 | 非空页数 (含脏页) 。 |
|
Innodb buffer pool bytes data
|
4.2 M | |
|
Innodb buffer pool pages dirty
|
0 | 当前脏页数。 |
|
Innodb buffer pool bytes dirty
|
0 | |
|
Innodb buffer pool pages flushed
|
74.6 k | 请求更新的缓冲池页数。 |
|
Innodb buffer pool pages free
|
742 | 空闲页数。 |
|
Innodb buffer pool pages misc
|
2 | 负载页的数量，像锁定行或适应性的散列索引这样的管理操作时分配的页。该值可用此公式计算： Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data 。 |
|
Innodb buffer pool pages total
|
1 k | 缓冲池总大小 (单位：页)。 |
|
Innodb buffer pool read ahead rnd
|
0 | InnoDB 初始化的“随机”预读数。这通常会在对一张表进行大范围的随机排序查询时发生。 |
|
Innodb buffer pool read ahead
|
0 | |
|
Innodb buffer pool read ahead evicted
|
0 | |
|
Innodb buffer pool read requests
|
1.2 M | InnoDB 完成的逻辑读请求数。 |
|
Innodb buffer pool reads
|
24.5 k | InnoDB 进行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。 |
|
Innodb buffer pool wait free
|
0 | 写入 InnoDB 缓冲池通常在后台进行，但有必要在没有干净页的时候读取或创建页，有必要先等待页被刷新。该计数器统计了这种等待的数量。如果缓冲池大小设置正确，这个值应该会很小。 |
|
Innodb buffer pool write requests
|
126.4 k | 写入 InnoDB 缓冲池的次数。 |
|
Innodb data fsyncs
|
85.6 k | fsync() 总操作的次数。 |
|
Innodb data pending fsyncs
|
0 | 当前挂起 fsync() 操作的数量。 |
|
Innodb data pending reads
|
0 | 当前挂起的读操作数。 |
|
Innodb data pending writes
|
0 | 当前挂起的写操作数。 |
|
Innodb data read
|
404.2 M | 读取的总数据量 (单位：字节)。 |
|
Innodb data reads
|
24.7 k | 数据读取总数。 |
|
Innodb data writes
|
137.6 k | 数据写入总数。 |
|
Innodb data written
|
2.5 G | 写入的总数据量 (单位：字节)。 |
|
Innodb dblwr pages written
|
74.5 k | 以双写入操作写入的页数。 |
|
Innodb dblwr writes
|
12.3 k | 已经执行的双写入次数。 |
|
Innodb log waits
|
0 | 因日志缓存太小而必须等待其被写入所造成的等待数。 |
|
Innodb log write requests
|
97.3 k | 日志写入请求数。 |
|
Innodb log writes
|
39.9 k | 日志物理写入次数。 |
|
Innodb os log fsyncs
|
50.7 k | 使用 fsync() 写入日志文件的次数。 |
|
Innodb os log pending fsyncs
|
0 | 当前挂起的 fsync 日志文件数。 |
|
Innodb os log pending writes
|
0 | 当前挂起的日志写入数。 |
|
Innodb os log written
|
60.1 M | 写入日志文件的字节数。 |
|
Innodb page size
|
16.4 k | 编译的 InnoDB 页大小 (默认 16KB)。许多值都以页为单位进行统计，页大小可以很方便地将这些值转化为字节数。 |
|
Innodb pages created
|
885 | 创建的页数。 |
|
Innodb pages read
|
24.5 k | 读取的页数。 |
|
Innodb pages written
|
74.6 k | 写入的页数。 |
|
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 | 6 | 等待行锁的次数。 |
|
Innodb rows deleted
|
0 | 从 InnoDB 表中删除的行数。 |
|
Innodb rows inserted
|
1 | 插入到 InnoDB 表中的行数。 |
|
Innodb rows read
|
126.4 k | 从 InnoDB 表中读取的行数。 |
|
Innodb rows updated
|
16.3 k | InnoDB 中更新的行数。 |
|
Innodb system rows deleted
|
0 | |
|
Innodb system rows inserted
|
0 | |
|
Innodb system rows read
|
6.9 k | |
|
Innodb system rows updated
|
0 | |
|
Innodb num open files
|
29 | |
|
Innodb truncated status writes
|
0 | |
|
Innodb available undo logs
|
128 | |
|
Innodb undo truncations
|
0 | |
|
Innodb page compression saved
|
0 | |
|
Innodb num index pages written
|
0 | |
|
Innodb num non index pages written
|
0 | |
|
Innodb num pages page compressed
|
0 | |
|
Innodb num page compressed trim op
|
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
|
OFF | |
|
Innodb have snappy
|
OFF | |
|
Innodb have punch hole
|
ON | |
|
Innodb defragment compression failures
|
0 | |
|
Innodb defragment failures
|
0 | |
|
Innodb defragment count
|
0 | |
|
Innodb instant alter column
|
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 encryption key rotation list length | 0 | |
|
Innodb encryption n merge blocks encrypted
|
0 | |
|
Innodb encryption n merge blocks decrypted
|
0 | |
|
Innodb encryption n rowlog blocks encrypted
|
0 | |
|
Innodb encryption n rowlog blocks decrypted
|
0 | |
| Innodb encryption n temp blocks encrypted | 0 | |
| Innodb encryption n temp blocks decrypted | 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 | |
|
Innodb scrub log
|
0 | |
|
Innodb encryption num key requests
|
0 | |
|
Key blocks not flushed
|
0 | 键缓存中还没有被写入到磁盘的键块数。该值过去名为 Not_flushed_key_blocks 。 |
|
Key blocks unused
|
13.4 k | 键缓存中未使用的块数。你可以根据这个值判断当前使用了多少键缓存。 |
|
Key blocks used
|
0 | 键缓存中已经使用的块数。该值指示在某个时刻使用了最多块数的数量。 |
|
Key blocks warm
|
0 | |
|
Key read requests
|
0 | 从缓存中读取键块的请求次数。 |
|
Key reads
|
0 | 从磁盘中物理读取键块的次数。如果 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
|
20 | 自服务器启动以来的最高并发连接数。 |
|
Memory used
|
161.2 M | |
|
Memory used initial
|
157.6 M | |
|
Not flushed delayed rows
|
0 | 等待写入延迟插入队列的行数。 |
|
Open files
|
55 | 打开的文件个数。 |
|
Open streams
|
0 | 打开的流个数 (主要用于日志记录)。 |
|
Open table definitions
|
104 | |
|
Open tables
|
130 | 打开的数据表个数。 |
|
Opened files
|
534 k | |
|
Opened plugin libraries
|
0 | |
|
Opened table definitions
|
102 | |
|
Opened tables
|
136 | 已经打开的表个数。如果该值很大，则说明表缓冲大小可能设置过小。 |
|
Opened views
|
189.5 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
|
2.1 M | |
|
Questions
|
2.1 M | |
|
Rows read
|
270.4 k | |
|
Rows sent
|
5.2 M | |
|
Rows tmp read
|
24.7 M | |
|
Rpl semi sync master clients
|
0 | |
| Rpl semi sync master get ack | 0 | |
|
Rpl semi sync master net avg wait time
|
0 | |
|
Rpl semi sync master net wait time
|
0 | |
|
Rpl semi sync master net waits
|
0 | |
|
Rpl semi sync master no times
|
0 | |
|
Rpl semi sync master no tx
|
0 | |
| Rpl semi sync master request ack | 0 | |
|
Rpl semi sync master status
|
OFF | |
|
Rpl semi sync master timefunc failures
|
0 | |
|
Rpl semi sync master tx avg wait time
|
0 | |
|
Rpl semi sync master tx wait time
|
0 | |
|
Rpl semi sync master tx waits
|
0 | |
|
Rpl semi sync master wait pos backtraverse
|
0 | |
|
Rpl semi sync master wait sessions
|
0 | |
|
Rpl semi sync master yes tx
|
0 | |
| Rpl semi sync slave send ack | 0 | |
|
Rpl semi sync slave status
|
OFF | |
|
Rpl status
|
AUTH_MASTER | 失败保护器的状态 (尚未应用)。 |
|
Rpl transactions multi engine
|
0 | |
|
Select full join
|
28.6 k | 没有使用索引的多表查询数。如果该值不为0，您应该仔细检查是否已经为表建立了适当的索引。 |
|
Select full range join
|
0 | 使用在关联表上使用范围搜索的多表查询的数量。 |
|
Select range
|
0 | 在第一张表上使用范围查询的多表查询数。(即使该值很大，通常也不会有致命的影响。) |
|
Select range check
|
0 | 没有使用索引但在每行之后检查索引使用的多表查询数。(如果该值不为 0，您应该仔细检查是否已经为表建立了适当的索引。) |
|
Select scan
|
1.2 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
|
34 | |
|
Sort range
|
48 | 局部范围完成的排序次数。 |
|
Sort rows
|
422.9 k | 排序的行数。 |
|
Sort scan
|
116.7 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
|
358 | |
|
Table locks immediate
|
53.4 k | 立即需要锁定表的次数。 |
|
Table locks waited
|
0 | 无法立即获得锁定表而必须等待的次数。如果该值很高，且您遇到了性能方面的问题，则应该首先检查您的查询语句，然后使用复制操作来分开表。 |
|
Table open cache active instances
|
1 | |
|
Table open cache hits
|
1.2 M | |
|
Table open cache misses
|
162.8 k | |
|
Table open cache overflows
|
0 | |
|
Tc log max pages used
|
0 | |
|
Tc log page size
|
0 | |
|
Tc log page waits
|
0 | |
|
Threadpool idle threads
|
0 | |
|
Threadpool threads
|
3 | |
|
Threads cached
|
0 | 线程缓存中线程的数量。缓存命中率可以由 Threads_created/Connections 计算得出。如果该值是红色的，则应该增加 thread_cache_size 的值。 |
|
Threads connected
|
2 | 当前打开的连接数。 |
|
Threads created
|
731 | 当前用于控制连接的线程数。如果 Threads_created 很大，您可能需要增加 thread_cache_size 的值。(如果线程状况良好，这么做通常并不会带来显著的性能提升。) |
|
Threads running
|
6 | 非睡眠状态的线程数量。 |
|
Transactions gtid foreign engine
|
0 | |
|
Transactions multi engine
|
0 | |
|
Update scan
|
0 | |
|
Uptime
|
39 天 14 小时，6 分 59 秒 | |
|
Uptime since flush status
|
39 天 14 小时，6 分 59 秒 | |
| Key buffer fraction % | 18.28 % | 已用键缓存百分比（计算值） |
| Threads cache hitrate % | 98.76 % | 线程缓存命中率 （计算值） |