Aborted clients
|
12
12
|
因客户端没有关闭连接而中止的连接数。
|
Aborted connects
|
0
0
|
尝试连接到 MySQL 服务器但失败的连接数。
|
Aborted connects preauth
|
0
0
|
|
Access denied errors
|
0
0
|
|
Acl column grants
|
0
0
|
|
Acl database grants
|
3
3
|
|
Acl function grants
|
0
0
|
|
Acl procedure grants
|
0
0
|
|
Acl package spec grants
|
0
0
|
|
Acl package body grants
|
0
0
|
|
Acl proxy users
|
1
1
|
|
Acl role grants
|
0
0
|
|
Acl roles
|
0
0
|
|
Acl table grants
|
0
0
|
|
Acl users
|
5
5
|
|
Aria pagecache blocks not flushed
|
0
0
|
|
Aria pagecache blocks unused
|
15.7 k
15706
|
|
Aria pagecache blocks used
|
134
134
|
|
Aria pagecache read requests
|
418.2 k
418209
|
|
Aria pagecache reads
|
23.9 k
23932
|
|
Aria pagecache write requests
|
42.5 k
42529
|
|
Aria pagecache writes
|
42.5 k
42529
|
|
Aria transaction log syncs
|
31
31
|
|
Binlog commits
|
0
0
|
|
Binlog group commits
|
0
0
|
|
Binlog group commit trigger count
|
0
0
|
|
Binlog group commit trigger lock wait
|
0
0
|
|
Binlog group commit trigger timeout
|
0
0
|
|
Binlog snapshot file
|
|
|
Binlog snapshot position
|
0
0
|
|
Binlog bytes written
|
0
0
|
|
Binlog cache disk use
|
0
0
|
因事务使用的临时二进制日志缓存超出 binlog_cache_size 的设置而使用临时文件存储的数量。
|
Binlog cache use
|
0
0
|
事务所用的临时二进制日志缓存的数量。
|
Binlog stmt cache disk use
|
0
0
|
|
Binlog stmt cache use
|
0
0
|
|
Busy time
|
0
0.000000
|
|
Bytes received
|
62.5 M
62548393
|
|
Bytes sent
|
1.2 G
1168514768
|
|
Column compressions
|
0
0
|
|
Column decompressions
|
0
0
|
|
Com admin commands
|
0
0
|
|
Com alter db
|
0
0
|
|
Com alter db upgrade
|
0
0
|
|
Com alter event
|
0
0
|
|
Com alter function
|
0
0
|
|
Com alter procedure
|
0
0
|
|
Com alter server
|
0
0
|
|
Com alter sequence
|
0
0
|
|
Com alter table
|
0
0
|
|
Com alter tablespace
|
0
0
|
|
Com alter user
|
0
0
|
|
Com analyze
|
0
0
|
|
Com assign to keycache
|
0
0
|
|
Com backup
|
0
0
|
|
Com backup lock
|
0
0
|
|
Com begin
|
0
0
|
|
Com binlog
|
0
0
|
|
Com call procedure
|
0
0
|
|
Com change db
|
17.5 k
17538
|
|
Com change master
|
0
0
|
|
Com check
|
0
0
|
|
Com checksum
|
0
0
|
|
Com commit
|
0
0
|
|
Com compound sql
|
0
0
|
|
Com create db
|
0
0
|
|
Com create event
|
0
0
|
|
Com create function
|
0
0
|
|
Com create index
|
0
0
|
|
Com create package
|
0
0
|
|
Com create package body
|
0
0
|
|
Com create procedure
|
0
0
|
|
Com create role
|
0
0
|
|
Com create sequence
|
0
0
|
|
Com create server
|
0
0
|
|
Com create table
|
0
0
|
|
Com create temporary table
|
0
0
|
|
Com create trigger
|
0
0
|
|
Com create udf
|
0
0
|
|
Com create user
|
0
0
|
|
Com create view
|
0
0
|
|
Com delete
|
1.3 k
1273
|
|
Com delete multi
|
4
4
|
|
Com do
|
0
0
|
|
Com drop db
|
0
0
|
|
Com drop event
|
0
0
|
|
Com drop function
|
0
0
|
|
Com drop index
|
0
0
|
|
Com drop procedure
|
0
0
|
|
Com drop package
|
0
0
|
|
Com drop package body
|
0
0
|
|
Com drop role
|
0
0
|
|
Com drop server
|
0
0
|
|
Com drop sequence
|
0
0
|
|
Com drop table
|
0
0
|
|
Com drop temporary table
|
0
0
|
|
Com drop trigger
|
0
0
|
|
Com drop user
|
0
0
|
|
Com drop view
|
0
0
|
|
Com empty query
|
0
0
|
|
Com execute immediate
|
0
0
|
|
Com flush
|
1
1
|
|
Com get diagnostics
|
0
0
|
|
Com grant
|
0
0
|
|
Com grant role
|
0
0
|
|
Com ha close
|
0
0
|
|
Com ha open
|
0
0
|
|
Com ha read
|
0
0
|
|
Com help
|
0
0
|
|
Com insert
|
3.4 k
3357
|
|
Com insert select
|
0
0
|
|
Com install plugin
|
0
0
|
|
Com kill
|
0
0
|
|
Com load
|
0
0
|
|
Com lock tables
|
0
0
|
|
Com multi
|
0
0
|
|
Com optimize
|
0
0
|
|
Com preload keys
|
0
0
|
|
Com purge
|
0
0
|
|
Com purge before date
|
0
0
|
|
Com release savepoint
|
0
0
|
|
Com rename table
|
0
0
|
|
Com rename user
|
0
0
|
|
Com repair
|
0
0
|
|
Com replace
|
1.5 k
1518
|
|
Com replace select
|
0
0
|
|
Com reset
|
0
0
|
|
Com resignal
|
0
0
|
|
Com revoke
|
0
0
|
|
Com revoke all
|
0
0
|
|
Com revoke role
|
0
0
|
|
Com rollback
|
0
0
|
|
Com rollback to savepoint
|
0
0
|
|
Com savepoint
|
0
0
|
|
Com select
|
460.4 k
460415
|
|
Com set option
|
23.5 k
23496
|
|
Com show authors
|
0
0
|
|
Com show binlog events
|
0
0
|
|
Com show binlogs
|
206
206
|
|
Com show charsets
|
0
0
|
|
Com show collations
|
0
0
|
|
Com show contributors
|
0
0
|
|
Com show create db
|
0
0
|
|
Com show create event
|
0
0
|
|
Com show create func
|
0
0
|
|
Com show create package
|
0
0
|
|
Com show create package body
|
0
0
|
|
Com show create proc
|
0
0
|
|
Com show create table
|
1.8 k
1811
|
|
Com show create trigger
|
0
0
|
|
Com show create user
|
0
0
|
|
Com show databases
|
0
0
|
|
Com show engine logs
|
0
0
|
|
Com show engine mutex
|
0
0
|
|
Com show engine status
|
0
0
|
|
Com show errors
|
0
0
|
|
Com show events
|
0
0
|
|
Com show explain
|
0
0
|
|
Com show fields
|
16.3 k
16347
|
|
Com show function status
|
0
0
|
|
Com show generic
|
0
0
|
|
Com show grants
|
2.6 k
2563
|
|
Com show keys
|
4.6 k
4629
|
|
Com show master status
|
39
39
|
|
Com show open tables
|
0
0
|
|
Com show package status
|
0
0
|
|
Com show package body status
|
0
0
|
|
Com show plugins
|
0
0
|
|
Com show privileges
|
0
0
|
|
Com show procedure status
|
0
0
|
|
Com show processlist
|
0
0
|
|
Com show profile
|
0
0
|
|
Com show profiles
|
0
0
|
|
Com show relaylog events
|
0
0
|
|
Com show slave hosts
|
0
0
|
|
Com show slave status
|
41
41
|
|
Com show status
|
4
4
|
|
Com show storage engines
|
365
365
|
|
Com show table status
|
21
21
|
|
Com show tables
|
20.5 k
20467
|
|
Com show triggers
|
0
0
|
|
Com show variables
|
4.2 k
4196
|
|
Com show warnings
|
1.3 k
1334
|
|
Com shutdown
|
0
0
|
|
Com signal
|
0
0
|
|
Com start all slaves
|
0
0
|
|
Com start slave
|
0
0
|
|
Com stmt close
|
788
788
|
|
Com stmt execute
|
788
788
|
|
Com stmt fetch
|
0
0
|
|
Com stmt prepare
|
808
808
|
|
Com stmt reprepare
|
0
0
|
|
Com stmt reset
|
0
0
|
|
Com stmt send long data
|
0
0
|
|
Com stop all slaves
|
0
0
|
|
Com stop slave
|
0
0
|
|
Com truncate
|
0
0
|
|
Com uninstall plugin
|
0
0
|
|
Com unlock tables
|
0
0
|
|
Com update
|
261
261
|
|
Com update multi
|
0
0
|
|
Com xa commit
|
0
0
|
|
Com xa end
|
0
0
|
|
Com xa prepare
|
0
0
|
|
Com xa recover
|
0
0
|
|
Com xa rollback
|
0
0
|
|
Com xa start
|
0
0
|
|
Compression
|
OFF
OFF
|
|
Connection errors accept
|
0
0
|
|
Connection errors internal
|
0
0
|
|
Connection errors max connections
|
0
0
|
|
Connection errors peer address
|
0
0
|
|
Connection errors select
|
0
0
|
|
Connection errors tcpwrap
|
0
0
|
|
Connections
|
11.1 k
11129
|
尝试连接到 MySQL 服务器的连接数 (不论成功或失败) 。
|
Cpu time
|
0
0.000000
|
|
Created tmp disk tables
|
25 k
25046
|
服务器执行语句时自动在磁盘上创建的临时表的数量。如果 Created_tmp_disk_tables 很大,你可以增加 tmp_table_size 的值,让服务器使用内存来存储临时表而非磁盘。
|
Created tmp files
|
2.4 k
2358
|
mysqld 已创建的临时文件的数量。
|
Created tmp tables
|
150.7 k
150717
|
服务器执行语句时自动在内存中创建的临时表的数量。
|
Delayed errors
|
0
0
|
发生错误的延迟插入 (INSERT DELAYED) 行数 (可能是因为在唯一字段中存在重复值) 。
|
Delayed insert threads
|
0
0
|
正在使用的延迟插入处理线程的数量。每张使用延迟插入的表都有自己的线程。
|
Delayed writes
|
0
0
|
延迟插入已写入的行数。
|
Delete scan
|
1
1
|
|
Empty queries
|
263.5 k
263529
|
|
Executed events
|
0
0
|
|
Executed triggers
|
0
0
|
|
Feature application time periods
|
0
0
|
|
Feature check constraint
|
362
362
|
|
Feature custom aggregate functions
|
0
0
|
|
Feature delay key write
|
0
0
|
|
Feature dynamic columns
|
0
0
|
|
Feature fulltext
|
0
0
|
|
Feature gis
|
0
0
|
|
Feature invisible columns
|
0
0
|
|
Feature json
|
735
735
|
|
Feature locale
|
3.2 k
3196
|
|
Feature subquery
|
2.6 k
2617
|
|
Feature system versioning
|
0
0
|
|
Feature timezone
|
0
0
|
|
Feature trigger
|
0
0
|
|
Feature window functions
|
0
0
|
|
Feature xml
|
0
0
|
|
Flush commands
|
1
1
|
已执行的强制更新 (FLUSH) 语句数。
|
Handler commit
|
413.9 k
413868
|
已执行的内部提交 (COMMIT) 语句数。
|
Handler delete
|
1.4 k
1381
|
从表中删除行的次数。
|
Handler discover
|
2.2 k
2234
|
如果知道一张表的名字,MySQL 服务器可以询问 NDB 集群存储引擎,这被称为“发现”。Handler_discovery 表明了一张表被发现的次数。
|
Handler external lock
|
0
0
|
|
Handler icp attempts
|
1.7 M
1712221
|
|
Handler icp match
|
1.7 M
1712220
|
|
Handler mrr init
|
0
0
|
|
Handler mrr key refills
|
0
0
|
|
Handler mrr rowid refills
|
0
0
|
|
Handler prepare
|
0
0
|
|
Handler read first
|
9.5 k
9465
|
读取一个索引入口点的次数。如果该值很大,说明你的服务器执行了很多完整索引扫描。例如,假设字段 col1 已经建立了索引,然后执行 SELECT col1 FROM foo 。
|
Handler read key
|
1.6 M
1602440
|
根据索引读取行的请求数。如果该值很大,说明你的查询和表都建立了很好的索引。
|
Handler read last
|
9
9
|
|
Handler read next
|
3.6 M
3603726
|
根据索引顺序读取下一行的请求数。如果你在查询一个已索引的字段且限制了范围,或进行完整表扫描,该值将会不断增长。
|
Handler read prev
|
1 M
1037735
|
根据索引顺序读取上一行的请求数。这种读取方式通常用于优化带有 ORDER BY … DESC 的查询。
|
Handler read retry
|
0
0
|
|
Handler read rnd
|
535.3 k
535325
|
根据固定位置读取行的请求数。如果你执行很多需要排序的查询,该值会很高。你可能有很多需要完整表扫描的查询,或者你使用了不正确的索引用来多表查询。
|
Handler read rnd deleted
|
4.1 k
4112
|
|
Handler read rnd next
|
4.4 M
4357974
|
从数据文件中读取行的请求数。如果你在扫描很多表,该值会很大。通常情况下这意味着你的表没有做好索引,或者你的查询语句没有使用好索引字段。
|
Handler rollback
|
0
0
|
内部回滚 (ROLLBACK) 语句数。
|
Handler savepoint
|
0
0
|
|
Handler savepoint rollback
|
0
0
|
|
Handler tmp delete
|
0
0
|
|
Handler tmp update
|
463 k
463043
|
|
Handler tmp write
|
2.8 M
2763994
|
|
Handler update
|
3.7 k
3693
|
表中更新行的请求数。
|
Handler write
|
4.9 k
4875
|
表中插入行的请求数。
|
Innodb buffer pool dump status
|
|
|
Innodb buffer pool load status
|
Buffer pool(s) load completed at 241225 10:53:27
Buffer pool(s) load completed at 241225 10:53:27
|
|
Innodb buffer pool resize status
|
|
|
Innodb buffer pool load incomplete
|
OFF
OFF
|
|
Innodb buffer pool pages data
|
256
256
|
非空页数 (含脏页) 。
|
Innodb buffer pool bytes data
|
4.2 M
4194304
|
|
Innodb buffer pool pages dirty
|
0
0
|
当前脏页数。
|
Innodb buffer pool bytes dirty
|
0
0
|
|
Innodb buffer pool pages flushed
|
32 k
31980
|
请求更新的缓冲池页数。
|
Innodb buffer pool pages free
|
737
737
|
空闲页数。
|
Innodb buffer pool pages misc
|
10
10
|
负载页的数量,像锁定行或适应性的散列索引这样的管理操作时分配的页。该值可用此公式计算: Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data 。
|
Innodb buffer pool pages total
|
1 k
1003
|
缓冲池总大小 (单位:页)。
|
Innodb buffer pool read ahead rnd
|
0
0
|
InnoDB 初始化的“随机”预读数。这通常会在对一张表进行大范围的随机排序查询时发生。
|
Innodb buffer pool read ahead
|
14.3 k
14282
|
|
Innodb buffer pool read ahead evicted
|
20
20
|
|
Innodb buffer pool read requests
|
12.6 M
12616850
|
InnoDB 完成的逻辑读请求数。
|
Innodb buffer pool reads
|
347.6 k
347620
|
InnoDB 进行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。
|
Innodb buffer pool wait free
|
0
0
|
写入 InnoDB 缓冲池通常在后台进行,但有必要在没有干净页的时候读取或创建页,有必要先等待页被刷新。该计数器统计了这种等待的数量。如果缓冲池大小设置正确,这个值应该会很小。
|
Innodb buffer pool write requests
|
86.9 k
86947
|
写入 InnoDB 缓冲池的次数。
|
Innodb data fsyncs
|
29.1 k
29137
|
fsync() 总操作的次数。
|
Innodb data pending fsyncs
|
0
0
|
当前挂起 fsync() 操作的数量。
|
Innodb data pending reads
|
0
0
|
当前挂起的读操作数。
|
Innodb data pending writes
|
0
0
|
当前挂起的写操作数。
|
Innodb data read
|
5.9 G
5939448320
|
读取的总数据量 (单位:字节)。
|
Innodb data reads
|
362.9 k
362871
|
数据读取总数。
|
Innodb data writes
|
54.4 k
54371
|
数据写入总数。
|
Innodb data written
|
1.1 G
1073019392
|
写入的总数据量 (单位:字节)。
|
Innodb dblwr pages written
|
31.8 k
31849
|
以双写入操作写入的页数。
|
Innodb dblwr writes
|
4.1 k
4082
|
已经执行的双写入次数。
|
Innodb log waits
|
0
0
|
因日志缓存太小而必须等待其被写入所造成的等待数。
|
Innodb log write requests
|
28.5 k
28548
|
日志写入请求数。
|
Innodb log writes
|
13.9 k
13918
|
日志物理写入次数。
|
Innodb os log fsyncs
|
18.3 k
18305
|
使用 fsync() 写入日志文件的次数。
|
Innodb os log pending fsyncs
|
0
0
|
当前挂起的 fsync 日志文件数。
|
Innodb os log pending writes
|
0
0
|
当前挂起的日志写入数。
|
Innodb os log written
|
25 M
24998400
|
写入日志文件的字节数。
|
Innodb page size
|
16.4 k
16384
|
编译的 InnoDB 页大小 (默认 16KB)。许多值都以页为单位进行统计,页大小可以很方便地将这些值转化为字节数。
|
Innodb pages created
|
370
370
|
创建的页数。
|
Innodb pages read
|
362.5 k
362506
|
读取的页数。
|
Innodb pages written
|
32 k
31980
|
写入的页数。
|
Innodb row lock current waits
|
0
0
|
正在等待行锁的数量。
|
Innodb row lock time
|
0
0
|
等待获得行锁的总时间 (单位:毫秒)。
|
Innodb row lock time avg
|
0
0
|
等待获得行锁的平均时间 (单位:毫秒)。
|
Innodb row lock time max
|
0
0
|
等待获得行锁的最大时间 (单位:毫秒)。
|
Innodb row lock waits
|
0
0
|
等待行锁的次数。
|
Innodb rows deleted
|
1.4 k
1381
|
从 InnoDB 表中删除的行数。
|
Innodb rows inserted
|
1.4 k
1439
|
插入到 InnoDB 表中的行数。
|
Innodb rows read
|
7.2 M
7176939
|
从 InnoDB 表中读取的行数。
|
Innodb rows updated
|
3.7 k
3690
|
InnoDB 中更新的行数。
|
Innodb system rows deleted
|
0
0
|
|
Innodb system rows inserted
|
0
0
|
|
Innodb system rows read
|
58 k
58020
|
|
Innodb system rows updated
|
0
0
|
|
Innodb num open files
|
300
300
|
|
Innodb truncated status writes
|
0
0
|
|
Innodb available undo logs
|
128
128
|
|
Innodb undo truncations
|
0
0
|
|
Innodb page compression saved
|
0
0
|
|
Innodb num pages page compressed
|
0
0
|
|
Innodb num page compressed trim op
|
0
0
|
|
Innodb num pages page decompressed
|
0
0
|
|
Innodb num pages page compression error
|
0
0
|
|
Innodb num pages encrypted
|
0
0
|
|
Innodb num pages decrypted
|
0
0
|
|
Innodb have lz4
|
OFF
OFF
|
|
Innodb have lzo
|
OFF
OFF
|
|
Innodb have lzma
|
OFF
OFF
|
|
Innodb have bzip2
|
ON
ON
|
|
Innodb have snappy
|
OFF
OFF
|
|
Innodb have punch hole
|
ON
ON
|
|
Innodb defragment compression failures
|
0
0
|
|
Innodb defragment failures
|
0
0
|
|
Innodb defragment count
|
0
0
|
|
Innodb instant alter column
|
0
0
|
|
Innodb onlineddl rowlog rows
|
0
0
|
|
Innodb onlineddl rowlog pct used
|
0
0
|
|
Innodb onlineddl pct progress
|
0
0
|
|
Innodb secondary index triggered cluster reads
|
2 M
2013279
|
|
Innodb secondary index triggered cluster reads avoided
|
0
0
|
|
Innodb encryption rotation pages read from cache
|
0
0
|
|
Innodb encryption rotation pages read from disk
|
0
0
|
|
Innodb encryption rotation pages modified
|
0
0
|
|
Innodb encryption rotation pages flushed
|
0
0
|
|
Innodb encryption rotation estimated iops
|
0
0
|
|
Innodb encryption n merge blocks encrypted
|
0
0
|
|
Innodb encryption n merge blocks decrypted
|
0
0
|
|
Innodb encryption n rowlog blocks encrypted
|
0
0
|
|
Innodb encryption n rowlog blocks decrypted
|
0
0
|
|
Innodb encryption n temp blocks encrypted
|
0
0
|
|
Innodb encryption n temp blocks decrypted
|
0
0
|
|
Innodb scrub background page reorganizations
|
0
0
|
|
Innodb scrub background page splits
|
0
0
|
|
Innodb scrub background page split failures underflow
|
0
0
|
|
Innodb scrub background page split failures out of filespace
|
0
0
|
|
Innodb scrub background page split failures missing index
|
0
0
|
|
Innodb scrub background page split failures unknown
|
0
0
|
|
Innodb scrub log
|
0
0
|
|
Innodb encryption num key requests
|
0
0
|
|
Key blocks not flushed
|
0
0
|
键缓存中还没有被写入到磁盘的键块数。该值过去名为 Not_flushed_key_blocks 。
|
Key blocks unused
|
13.4 k
13387
|
键缓存中未使用的块数。你可以根据这个值判断当前使用了多少键缓存。
|
Key blocks used
|
7
7
|
键缓存中已经使用的块数。该值指示在某个时刻使用了最多块数的数量。
|
Key blocks warm
|
0
0
|
|
Key read requests
|
6.7 k
6679
|
从缓存中读取键块的请求次数。
|
Key reads
|
198
198
|
从磁盘中物理读取键块的次数。如果 Key_reads 很大,则说明您的 key_buffer_size 可能设置得太小了。缓存缺失率可以由 Key_reads/Key_read_requests 计算得出。
|
Key write requests
|
0
0
|
将一个键块写入缓存的请求数。
|
Key writes
|
0
0
|
将键块物理写入到磁盘的次数。
|
Last query cost
|
0
0.000000
|
最后编译的查询的总开销由查询优化器计算得出,可用于比较使用不同的查询语句进行相同的查询时的效率差异。默认值0表示还没有查询被编译。
|
Master gtid wait count
|
0
0
|
|
Master gtid wait time
|
0
0
|
|
Master gtid wait timeouts
|
0
0
|
|
Max statement time exceeded
|
0
0
|
|
Max used connections
|
97
97
|
自服务器启动以来的最高并发连接数。
|
Memory used
|
167.5 M
167477920
|
|
Memory used initial
|
156.1 M
156146632
|
|
Not flushed delayed rows
|
0
0
|
等待写入延迟插入队列的行数。
|
Open files
|
58
58
|
打开的文件个数。
|
Open streams
|
0
0
|
打开的流个数 (主要用于日志记录)。
|
Open table definitions
|
400
400
|
|
Open tables
|
64
64
|
打开的数据表个数。
|
Opened files
|
126.9 k
126860
|
|
Opened plugin libraries
|
148
148
|
|
Opened table definitions
|
17.1 k
17082
|
|
Opened tables
|
29.9 k
29891
|
已经打开的表个数。如果打开的表很大,则说明table_open_cache的值可能设置过小。
|
Opened views
|
0
0
|
|
Performance schema accounts lost
|
0
0
|
|
Performance schema cond classes lost
|
0
0
|
|
Performance schema cond instances lost
|
0
0
|
|
Performance schema digest lost
|
0
0
|
|
Performance schema file classes lost
|
0
0
|
|
Performance schema file handles lost
|
0
0
|
|
Performance schema file instances lost
|
0
0
|
|
Performance schema hosts lost
|
0
0
|
|
Performance schema locker lost
|
0
0
|
|
Performance schema mutex classes lost
|
0
0
|
|
Performance schema mutex instances lost
|
0
0
|
|
Performance schema rwlock classes lost
|
0
0
|
|
Performance schema rwlock instances lost
|
0
0
|
|
Performance schema session connect attrs lost
|
0
0
|
|
Performance schema socket classes lost
|
0
0
|
|
Performance schema socket instances lost
|
0
0
|
|
Performance schema stage classes lost
|
0
0
|
|
Performance schema statement classes lost
|
0
0
|
|
Performance schema table handles lost
|
0
0
|
|
Performance schema table instances lost
|
0
0
|
|
Performance schema thread classes lost
|
0
0
|
|
Performance schema thread instances lost
|
0
0
|
|
Performance schema users lost
|
0
0
|
|
Prepared stmt count
|
0
0
|
|
Qcache free blocks
|
1
1
|
查询缓存中的空闲内存块。过多的空闲内存块可能产生碎片,可通过执行 FLUSH QUERY CACHE 语句解决。
|
Qcache free memory
|
1 M
1031320
|
查询缓存中空闲的内存总数。
|
Qcache hits
|
0
0
|
缓存命中数。
|
Qcache inserts
|
0
0
|
加入到缓存的查询数。
|
Qcache lowmem prunes
|
0
0
|
为缓存新的查询而被删除的已缓存查询的个数,由最近最少使用算法 (LRU) 确定应删除哪个已缓存的查询。该信息可帮助您调整查询缓存大小。
|
Qcache not cached
|
0
0
|
未缓存的查询数 (包括不能被缓存,或因为 query_cache_type 的设置而没有被缓存的查询)。
|
Qcache queries in cache
|
0
0
|
在缓存中注册的查询数。
|
Qcache total blocks
|
1
1
|
查询缓存中的总块数。
|
Queries
|
572.7 k
572736
|
|
Questions
|
571.1 k
571140
|
|
Rows read
|
7.2 M
7241449
|
|
Rows sent
|
2.9 M
2907858
|
|
Rows tmp read
|
3.4 M
3429603
|
|
Rpl semi sync master clients
|
0
0
|
|
Rpl semi sync master get ack
|
0
0
|
|
Rpl semi sync master net avg wait time
|
0
0
|
|
Rpl semi sync master net wait time
|
0
0
|
|
Rpl semi sync master net waits
|
0
0
|
|
Rpl semi sync master no times
|
0
0
|
|
Rpl semi sync master no tx
|
0
0
|
|
Rpl semi sync master request ack
|
0
0
|
|
Rpl semi sync master status
|
OFF
OFF
|
|
Rpl semi sync master timefunc failures
|
0
0
|
|
Rpl semi sync master tx avg wait time
|
0
0
|
|
Rpl semi sync master tx wait time
|
0
0
|
|
Rpl semi sync master tx waits
|
0
0
|
|
Rpl semi sync master wait pos backtraverse
|
0
0
|
|
Rpl semi sync master wait sessions
|
0
0
|
|
Rpl semi sync master yes tx
|
0
0
|
|
Rpl semi sync slave send ack
|
0
0
|
|
Rpl semi sync slave status
|
OFF
OFF
|
|
Rpl status
|
AUTH_MASTER
AUTH_MASTER
|
失败保护器的状态 (尚未应用)。
|
Rpl transactions multi engine
|
0
0
|
|
Select full join
|
2.6 k
2571
|
没有使用索引的多表查询数。如果该值不为0,您应该仔细检查是否已经为表建立了适当的索引。
|
Select full range join
|
0
0
|
使用在关联表上使用范围搜索的多表查询的数量。
|
Select range
|
27.5 k
27505
|
在第一张表上使用范围查询的多表查询数。(即使该值很大,通常也不会有致命的影响。)
|
Select range check
|
0
0
|
没有使用索引但在每行之后检查索引使用的多表查询数。(如果该值不为 0,您应该仔细检查是否已经为表建立了适当的索引。)
|
Select scan
|
120.9 k
120918
|
在第一张表上进行了完整表扫描的多表查询数。
|
Slave connections
|
0
0
|
|
Slave heartbeat period
|
0
0.000
|
|
Slave open temp tables
|
0
0
|
副本SQL线程当前打开的临时表数量。
|
Slave received heartbeats
|
0
0
|
|
Slave retried transactions
|
0
0
|
副本SQL线程重试事务的总次数(自启动以来)。
|
Slave running
|
OFF
OFF
|
如果该值为 ON,则这台服务器是一台已经连接到主服务器的从服务器。
|
Slave skipped errors
|
0
0
|
|
Slaves connected
|
0
0
|
|
Slaves running
|
0
0
|
|
Slow launch threads
|
0
0
|
使用了比 slow_launch_time 更多的时间来启动的线程数量。
|
Slow queries
|
0
0
|
使用了比 long_query_time 更多时间的查询数。
|
Sort merge passes
|
1.2 k
1177
|
排序算法使用归并的次数。如果该值很大,您应该考虑增加系统变量 sort_buffer_size 的值。
|
Sort priority queue sorts
|
7.7 k
7650
|
|
Sort range
|
14.5 k
14537
|
局部范围完成的排序次数。
|
Sort rows
|
1.9 M
1873185
|
排序的行数。
|
Sort scan
|
35 k
34969
|
扫描表完成的排序次数。
|
Ssl accept renegotiates
|
0
0
|
|
Ssl accepts
|
0
0
|
|
Ssl callback cache hits
|
0
0
|
|
Ssl cipher
|
|
|
Ssl cipher list
|
|
|
Ssl client connects
|
0
0
|
|
Ssl connect renegotiates
|
0
0
|
|
Ssl ctx verify depth
|
0
0
|
|
Ssl ctx verify mode
|
0
0
|
|
Ssl default timeout
|
0
0
|
|
Ssl finished accepts
|
0
0
|
|
Ssl finished connects
|
0
0
|
|
Ssl server not after
|
|
|
Ssl server not before
|
|
|
Ssl session cache hits
|
0
0
|
|
Ssl session cache misses
|
0
0
|
|
Ssl session cache mode
|
NONE
NONE
|
|
Ssl session cache overflows
|
0
0
|
|
Ssl session cache size
|
0
0
|
|
Ssl session cache timeouts
|
0
0
|
|
Ssl sessions reused
|
0
0
|
|
Ssl used session cache entries
|
0
0
|
|
Ssl verify depth
|
0
0
|
|
Ssl verify mode
|
0
0
|
|
Ssl version
|
|
|
Subquery cache hit
|
0
0
|
|
Subquery cache miss
|
0
0
|
|
Syncs
|
271
271
|
|
Table locks immediate
|
1.3 M
1270868
|
立即需要锁定表的次数。
|
Table locks waited
|
0
0
|
无法立即获得锁定表而必须等待的次数。如果该值很高,且您遇到了性能方面的问题,则应该首先检查您的查询语句,然后使用复制操作来分开表。
|
Table open cache active instances
|
1
1
|
|
Table open cache hits
|
1.8 M
1760050
|
|
Table open cache misses
|
63.2 k
63199
|
|
Table open cache overflows
|
29.8 k
29813
|
|
Tc log max pages used
|
0
0
|
|
Tc log page size
|
0
0
|
|
Tc log page waits
|
0
0
|
|
Threadpool idle threads
|
0
0
|
|
Threadpool threads
|
0
0
|
|
Threads cached
|
14
14
|
线程缓存中线程的数量。缓存命中率可以由 Threads_created/Connections 计算得出。如果该值是红色的,则应该增加 thread_cache_size 的值。
|
Threads connected
|
2
2
|
当前打开的连接数。
|
Threads created
|
97
97
|
当前用于控制连接的线程数。如果 Threads_created 很大,您可能需要增加 thread_cache_size 的值。(如果线程状况良好,这么做通常并不会带来显著的性能提升。)
|
Threads running
|
6
6
|
非睡眠状态的线程数量。
|
Transactions gtid foreign engine
|
0
0
|
|
Transactions multi engine
|
0
0
|
|
Update scan
|
0
0
|
|
Uptime
|
0 天 8 小时,57 分 29 秒
32249
|
|
Uptime since flush status
|
0 天 8 小时,57 分 29 秒
32249
|
|
wsrep
|
245.7 G
245688840755
|
|
wsrep applier thread count
|
0
0
|
|
wsrep cluster capabilities
|
|
|
wsrep cluster conf id
|
18.4 E
18446744073709551615
|
|
wsrep cluster size
|
0
0
|
|
wsrep cluster state uuid
|
|
|
wsrep cluster status
|
Disconnected
Disconnected
|
|
wsrep connected
|
OFF
OFF
|
|
wsrep local bf aborts
|
0
0
|
|
wsrep local index
|
18.4 E
18446744073709551615
|
|
wsrep provider capabilities
|
|
|
wsrep provider name
|
|
|
wsrep provider vendor
|
|
|
wsrep provider version
|
|
|
wsrep ready
|
OFF
OFF
|
|
wsrep rollbacker thread count
|
0
0
|
|
wsrep thread count
|
0
0
|
|
Key buffer fraction %
|
18.29 %
18.292236328125
|
已用键缓存百分比(计算值)
|
Key read ratio %
|
2.96 %
2.9645156460548
|
由物理读取数与读取请求数相比计算出的键缓存未命中率(计算值)
|
Threads cache hitrate %
|
99.13 %
99.128403270734
|
线程缓存命中率 (计算值)
|