Aborted clients
|
0
0
|
因客户端没有关闭连接而中止的连接数。
|
|
Aborted connects
|
0
0
|
尝试连接到 MySQL 服务器但失败的连接数。
|
|
Acl cache items count
|
0
0
|
|
|
Binlog cache disk use
|
0
0
|
因事务使用的临时二进制日志缓存超出 binlog_cache_size 的设置而使用临时文件存储的数量。
|
|
Binlog cache use
|
12
12
|
事务所用的临时二进制日志缓存的数量。
|
|
Binlog stmt cache disk use
|
0
0
|
|
|
Binlog stmt cache use
|
0
0
|
|
|
Bytes received
|
2.2 M
2235560
|
|
|
Bytes sent
|
8.2 M
8171976
|
|
|
Caching sha2 password rsa public key
|
-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY
3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu
gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n
Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ
vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT
j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg
4QIDAQAB
-----END PUBLIC KEY-----
-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY
3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu
gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n
Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ
vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT
j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg
4QIDAQAB
-----END PUBLIC KEY-----
|
|
|
Com admin commands
|
0
0
|
|
|
Com assign to keycache
|
0
0
|
|
|
Com alter db
|
0
0
|
|
|
Com alter event
|
0
0
|
|
|
Com alter function
|
0
0
|
|
|
Com alter instance
|
0
0
|
|
|
Com alter procedure
|
0
0
|
|
|
Com alter resource group
|
0
0
|
|
|
Com alter server
|
0
0
|
|
|
Com alter table
|
0
0
|
|
|
Com alter tablespace
|
0
0
|
|
|
Com alter user
|
0
0
|
|
|
Com alter user default role
|
0
0
|
|
|
Com analyze
|
0
0
|
|
|
Com begin
|
0
0
|
|
|
Com binlog
|
0
0
|
|
|
Com call procedure
|
0
0
|
|
|
Com change db
|
1.6 k
1583
|
|
|
Com change master
|
0
0
|
|
|
Com change repl filter
|
0
0
|
|
|
Com check
|
0
0
|
|
|
Com checksum
|
0
0
|
|
|
Com clone
|
0
0
|
|
|
Com commit
|
0
0
|
|
|
Com create db
|
10
10
|
|
|
Com create event
|
0
0
|
|
|
Com create function
|
0
0
|
|
|
Com create index
|
0
0
|
|
|
Com create procedure
|
0
0
|
|
|
Com create role
|
0
0
|
|
|
Com create server
|
0
0
|
|
|
Com create table
|
40
40
|
|
|
Com create resource group
|
0
0
|
|
|
Com create trigger
|
0
0
|
|
|
Com create udf
|
0
0
|
|
|
Com create user
|
0
0
|
|
|
Com create view
|
0
0
|
|
|
Com create spatial reference system
|
0
0
|
|
|
Com delete
|
0
0
|
|
|
Com delete multi
|
0
0
|
|
|
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 resource group
|
0
0
|
|
|
Com drop role
|
0
0
|
|
|
Com drop server
|
0
0
|
|
|
Com drop spatial reference system
|
0
0
|
|
|
Com drop table
|
0
0
|
|
|
Com drop trigger
|
0
0
|
|
|
Com drop user
|
0
0
|
|
|
Com drop view
|
0
0
|
|
|
Com empty query
|
0
0
|
|
|
Com explain other
|
0
0
|
|
|
Com flush
|
1
1
|
|
|
Com get diagnostics
|
0
0
|
|
|
Com grant
|
0
0
|
|
|
Com grant roles
|
0
0
|
|
|
Com ha close
|
0
0
|
|
|
Com ha open
|
0
0
|
|
|
Com ha read
|
0
0
|
|
|
Com help
|
0
0
|
|
|
Com import
|
0
0
|
|
|
Com insert
|
1
1
|
|
|
Com insert select
|
0
0
|
|
|
Com install component
|
0
0
|
|
|
Com install plugin
|
0
0
|
|
|
Com kill
|
0
0
|
|
|
Com load
|
0
0
|
|
|
Com lock instance
|
0
0
|
|
|
Com lock tables
|
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
|
0
0
|
|
|
Com replace select
|
0
0
|
|
|
Com reset
|
0
0
|
|
|
Com resignal
|
0
0
|
|
|
Com restart
|
0
0
|
|
|
Com revoke
|
0
0
|
|
|
Com revoke all
|
0
0
|
|
|
Com revoke roles
|
0
0
|
|
|
Com rollback
|
0
0
|
|
|
Com rollback to savepoint
|
0
0
|
|
|
Com savepoint
|
0
0
|
|
|
Com select
|
9.3 k
9263
|
|
|
Com set option
|
2.9 k
2851
|
|
|
Com set password
|
0
0
|
|
|
Com set resource group
|
0
0
|
|
|
Com set role
|
0
0
|
|
|
Com signal
|
0
0
|
|
|
Com show binlog events
|
0
0
|
|
|
Com show binlogs
|
49
49
|
|
|
Com show charsets
|
0
0
|
|
|
Com show collations
|
0
0
|
|
|
Com show create db
|
0
0
|
|
|
Com show create event
|
0
0
|
|
|
Com show create func
|
0
0
|
|
|
Com show create proc
|
0
0
|
|
|
Com show create table
|
143
143
|
|
|
Com show create trigger
|
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 events
|
0
0
|
|
|
Com show errors
|
0
0
|
|
|
Com show fields
|
287
287
|
|
|
Com show function code
|
0
0
|
|
|
Com show function status
|
0
0
|
|
|
Com show grants
|
436
436
|
|
|
Com show keys
|
156
156
|
|
|
Com show master status
|
67
67
|
|
|
Com show open tables
|
0
0
|
|
|
Com show plugins
|
0
0
|
|
|
Com show privileges
|
0
0
|
|
|
Com show procedure code
|
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
|
67
67
|
|
|
Com show status
|
8
8
|
|
|
Com show storage engines
|
7
7
|
|
|
Com show table status
|
44
44
|
|
|
Com show tables
|
1.3 k
1347
|
|
|
Com show triggers
|
0
0
|
|
|
Com show variables
|
446
446
|
|
|
Com show warnings
|
146
146
|
|
|
Com show create user
|
0
0
|
|
|
Com shutdown
|
0
0
|
|
|
Com slave start
|
0
0
|
|
|
Com slave stop
|
0
0
|
|
|
Com group replication start
|
0
0
|
|
|
Com group replication stop
|
0
0
|
|
|
Com stmt execute
|
27
27
|
|
|
Com stmt close
|
27
27
|
|
|
Com stmt fetch
|
0
0
|
|
|
Com stmt prepare
|
27
27
|
|
|
Com stmt reset
|
0
0
|
|
|
Com stmt send long data
|
0
0
|
|
|
Com truncate
|
0
0
|
|
|
Com uninstall component
|
0
0
|
|
|
Com uninstall plugin
|
0
0
|
|
|
Com unlock instance
|
0
0
|
|
|
Com unlock tables
|
0
0
|
|
|
Com update
|
0
0
|
|
|
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
|
|
|
Com stmt reprepare
|
0
0
|
|
|
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
|
1.9 k
1939
|
尝试连接到 MySQL 服务器的连接数 (不论成功或失败) 。
|
|
Created tmp disk tables
|
1
1
|
服务器执行语句时自动在磁盘上创建的临时表的数量。如果 Created_tmp_disk_tables 很大，你可以增加 tmp_table_size 的值，让服务器使用内存来存储临时表而非磁盘。
|
|
Created tmp files
|
6
6
|
mysqld 已创建的临时文件的数量。
|
|
Created tmp tables
|
13.9 k
13861
|
服务器执行语句时自动在内存中创建的临时表的数量。
|
|
Current tls ca
|
ca.pem
ca.pem
|
|
|
Current tls capath
|
|
|
|
Current tls cert
|
server-cert.pem
server-cert.pem
|
|
|
Current tls cipher
|
|
|
|
Current tls ciphersuites
|
|
|
|
Current tls crl
|
|
|
|
Current tls crlpath
|
|
|
|
Current tls key
|
server-key.pem
server-key.pem
|
|
|
Current tls version
|
TLSv1,TLSv1.1,TLSv1.2
TLSv1,TLSv1.1,TLSv1.2
|
|
|
Delayed errors
|
0
0
|
发生错误的延迟插入 (INSERT DELAYED) 行数 (可能是因为在唯一字段中存在重复值) 。
|
|
Delayed insert threads
|
0
0
|
正在使用的延迟插入处理线程的数量。每张使用延迟插入的表都有自己的线程。
|
|
Delayed writes
|
0
0
|
延迟插入已写入的行数。
|
|
Flush commands
|
3
3
|
已执行的强制更新 (FLUSH) 语句数。
|
|
Handler commit
|
11.5 k
11511
|
已执行的内部提交 (COMMIT) 语句数。
|
|
Handler delete
|
0
0
|
从表中删除行的次数。
|
|
Handler discover
|
0
0
|
如果知道一张表的名字，MySQL 服务器可以询问 NDB 集群存储引擎，这被称为“发现”。Handler_discovery 表明了一张表被发现的次数。
|
|
Handler external lock
|
72.3 k
72347
|
|
|
Handler mrr init
|
0
0
|
|
|
Handler prepare
|
48
48
|
|
|
Handler read first
|
7.9 k
7918
|
读取一个索引入口点的次数。如果该值很大，说明你的服务器执行了很多完整索引扫描。例如，假设字段 col1 已经建立了索引，然后执行 SELECT col1 FROM foo 。
|
|
Handler read key
|
143.3 k
143268
|
根据索引读取行的请求数。如果该值很大，说明你的查询和表都建立了很好的索引。
|
|
Handler read last
|
0
0
|
|
|
Handler read next
|
131.4 k
131429
|
根据索引顺序读取下一行的请求数。如果你在查询一个已索引的字段且限制了范围，或进行完整表扫描，该值将会不断增长。
|
|
Handler read prev
|
0
0
|
根据索引顺序读取上一行的请求数。这种读取方式通常用于优化带有 ORDER BY … DESC 的查询。
|
|
Handler read rnd
|
16.3 k
16276
|
根据固定位置读取行的请求数。如果你执行很多需要排序的查询，该值会很高。你可能有很多需要完整表扫描的查询，或者你使用了不正确的索引用来多表查询。
|
|
Handler read rnd next
|
1.2 M
1227522
|
从数据文件中读取行的请求数。如果你在扫描很多表，该值会很大。通常情况下这意味着你的表没有做好索引，或者你的查询语句没有使用好索引字段。
|
|
Handler rollback
|
0
0
|
内部回滚 (ROLLBACK) 语句数。
|
|
Handler savepoint
|
0
0
|
|
|
Handler savepoint rollback
|
0
0
|
|
|
Handler update
|
1.2 k
1185
|
表中更新行的请求数。
|
|
Handler write
|
981.9 k
981900
|
表中插入行的请求数。
|
|
Innodb buffer pool dump status
|
Dumping of buffer pool not started
Dumping of buffer pool not started
|
|
|
Innodb buffer pool load status
|
Buffer pool(s) load completed at 241220 8:30:47
Buffer pool(s) load completed at 241220 8:30:47
|
|
|
Innodb buffer pool resize status
|
|
|
|
Innodb buffer pool pages data
|
1.3 k
1309
|
非空页数 (含脏页) 。
|
|
Innodb buffer pool bytes data
|
21.4 M
21446656
|
|
|
Innodb buffer pool pages dirty
|
0
0
|
当前脏页数。
|
|
Innodb buffer pool bytes dirty
|
0
0
|
|
|
Innodb buffer pool pages flushed
|
492
492
|
请求更新的缓冲池页数。
|
|
Innodb buffer pool pages free
|
6.9 k
6870
|
空闲页数。
|
|
Innodb buffer pool pages misc
|
13
13
|
负载页的数量，像锁定行或适应性的散列索引这样的管理操作时分配的页。该值可用此公式计算： Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data 。
|
|
Innodb buffer pool pages total
|
8.2 k
8192
|
缓冲池总大小 (单位：页)。
|
|
Innodb buffer pool read ahead rnd
|
0
0
|
InnoDB 初始化的“随机”预读数。这通常会在对一张表进行大范围的随机排序查询时发生。
|
|
Innodb buffer pool read ahead
|
0
0
|
|
|
Innodb buffer pool read ahead evicted
|
0
0
|
|
|
Innodb buffer pool read requests
|
651.4 k
651404
|
InnoDB 完成的逻辑读请求数。
|
|
Innodb buffer pool reads
|
1.1 k
1146
|
InnoDB 进行逻辑读取时无法从缓冲池中获取而执行单页读取的次数。
|
|
Innodb buffer pool wait free
|
0
0
|
写入 InnoDB 缓冲池通常在后台进行，但有必要在没有干净页的时候读取或创建页，有必要先等待页被刷新。该计数器统计了这种等待的数量。如果缓冲池大小设置正确，这个值应该会很小。
|
|
Innodb buffer pool write requests
|
3 k
2992
|
写入 InnoDB 缓冲池的次数。
|
|
Innodb data fsyncs
|
363
363
|
fsync() 总操作的次数。
|
|
Innodb data pending fsyncs
|
0
0
|
当前挂起 fsync() 操作的数量。
|
|
Innodb data pending reads
|
0
0
|
当前挂起的读操作数。
|
|
Innodb data pending writes
|
0
0
|
当前挂起的写操作数。
|
|
Innodb data read
|
19 M
18977792
|
读取的总数据量 (单位：字节)。
|
|
Innodb data reads
|
1.3 k
1283
|
数据读取总数。
|
|
Innodb data writes
|
847
847
|
数据写入总数。
|
|
Innodb data written
|
14.4 M
14430208
|
写入的总数据量 (单位：字节)。
|
|
Innodb dblwr pages written
|
360
360
|
以双写入操作写入的页数。
|
|
Innodb dblwr writes
|
35
35
|
已经执行的双写入次数。
|
|
Innodb log waits
|
0
0
|
因日志缓存太小而必须等待其被写入所造成的等待数。
|
|
Innodb log write requests
|
1.7 k
1670
|
日志写入请求数。
|
|
Innodb log writes
|
233
233
|
日志物理写入次数。
|
|
Innodb os log fsyncs
|
183
183
|
使用 fsync() 写入日志文件的次数。
|
|
Innodb os log pending fsyncs
|
0
0
|
当前挂起的 fsync 日志文件数。
|
|
Innodb os log pending writes
|
0
0
|
当前挂起的日志写入数。
|
|
Innodb os log written
|
201.2 k
201216
|
写入日志文件的字节数。
|
|
Innodb page size
|
16.4 k
16384
|
编译的 InnoDB 页大小 (默认 16KB)。许多值都以页为单位进行统计，页大小可以很方便地将这些值转化为字节数。
|
|
Innodb pages created
|
166
166
|
创建的页数。
|
|
Innodb pages read
|
1.1 k
1146
|
读取的页数。
|
|
Innodb pages written
|
502
502
|
写入的页数。
|
|
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
|
0
0
|
从 InnoDB 表中删除的行数。
|
|
Innodb rows inserted
|
150
150
|
插入到 InnoDB 表中的行数。
|
|
Innodb rows read
|
361.6 k
361613
|
从 InnoDB 表中读取的行数。
|
|
Innodb rows updated
|
401
401
|
InnoDB 中更新的行数。
|
|
Innodb num open files
|
45
45
|
|
|
Innodb truncated status writes
|
0
0
|
|
|
Innodb undo tablespaces total
|
2
2
|
|
|
Innodb undo tablespaces implicit
|
2
2
|
|
|
Innodb undo tablespaces explicit
|
0
0
|
|
|
Innodb undo tablespaces active
|
2
2
|
|
|
Key blocks not flushed
|
0
0
|
键缓存中还没有被写入到磁盘的键块数。该值过去名为 Not_flushed_key_blocks 。
|
|
Key blocks unused
|
6.7 k
6698
|
键缓存中未使用的块数。你可以根据这个值判断当前使用了多少键缓存。
|
|
Key blocks used
|
0
0
|
键缓存中已经使用的块数。该值指示在某个时刻使用了最多块数的数量。
|
|
Key read requests
|
0
0
|
从缓存中读取键块的请求次数。
|
|
Key reads
|
0
0
|
从磁盘中物理读取键块的次数。如果 Key_reads 很大，则说明您的 key_buffer_size 可能设置得太小了。缓存缺失率可以由 Key_reads/Key_read_requests 计算得出。
|
|
Key write requests
|
0
0
|
将一个键块写入缓存的请求数。
|
|
Key writes
|
0
0
|
将键块物理写入到磁盘的次数。
|
|
Locked connects
|
0
0
|
|
|
Max execution time exceeded
|
0
0
|
|
|
Max execution time set
|
0
0
|
|
|
Max execution time set failed
|
0
0
|
|
|
Max used connections
|
10
10
|
自服务器启动以来的最高并发连接数。
|
|
Max used connections time
|
2024-12-20 08:31:02
2024-12-20 08:31:02
|
|
|
Mysqlx aborted clients
|
0
0
|
|
|
Mysqlx address
|
::
::
|
|
|
Mysqlx bytes received
|
0
0
|
|
|
Mysqlx bytes sent
|
0
0
|
|
|
Mysqlx connection accept errors
|
0
0
|
|
|
Mysqlx connection errors
|
0
0
|
|
|
Mysqlx connections accepted
|
0
0
|
|
|
Mysqlx connections closed
|
0
0
|
|
|
Mysqlx connections rejected
|
0
0
|
|
|
Mysqlx crud create view
|
0
0
|
|
|
Mysqlx crud delete
|
0
0
|
|
|
Mysqlx crud drop view
|
0
0
|
|
|
Mysqlx crud find
|
0
0
|
|
|
Mysqlx crud insert
|
0
0
|
|
|
Mysqlx crud modify view
|
0
0
|
|
|
Mysqlx crud update
|
0
0
|
|
|
Mysqlx cursor close
|
0
0
|
|
|
Mysqlx cursor fetch
|
0
0
|
|
|
Mysqlx cursor open
|
0
0
|
|
|
Mysqlx errors sent
|
0
0
|
|
|
Mysqlx errors unknown message type
|
0
0
|
|
|
Mysqlx expect close
|
0
0
|
|
|
Mysqlx expect open
|
0
0
|
|
|
Mysqlx init error
|
0
0
|
|
|
Mysqlx notice global sent
|
0
0
|
|
|
Mysqlx notice other sent
|
0
0
|
|
|
Mysqlx notice warning sent
|
0
0
|
|
|
Mysqlx notified by group replication
|
0
0
|
|
|
Mysqlx port
|
33.1 k
33060
|
|
|
Mysqlx prep deallocate
|
0
0
|
|
|
Mysqlx prep execute
|
0
0
|
|
|
Mysqlx prep prepare
|
0
0
|
|
|
Mysqlx rows sent
|
0
0
|
|
|
Mysqlx sessions
|
0
0
|
|
|
Mysqlx sessions accepted
|
0
0
|
|
|
Mysqlx sessions closed
|
0
0
|
|
|
Mysqlx sessions fatal error
|
0
0
|
|
|
Mysqlx sessions killed
|
0
0
|
|
|
Mysqlx sessions rejected
|
0
0
|
|
|
Mysqlx socket
|
/var/run/mysqld/mysqlx.sock
/var/run/mysqld/mysqlx.sock
|
|
|
Mysqlx ssl accepts
|
0
0
|
|
|
Mysqlx ssl active
|
|
|
|
Mysqlx ssl cipher
|
|
|
|
Mysqlx ssl cipher list
|
|
|
|
Mysqlx ssl ctx verify depth
|
18.4 E
18446744073709551615
|
|
|
Mysqlx ssl ctx verify mode
|
5
5
|
|
|
Mysqlx ssl finished accepts
|
0
0
|
|
|
Mysqlx ssl server not after
|
Oct 27 14:09:28 2029 GMT
Oct 27 14:09:28 2029 GMT
|
|
|
Mysqlx ssl server not before
|
Oct 30 14:09:28 2019 GMT
Oct 30 14:09:28 2019 GMT
|
|
|
Mysqlx ssl verify depth
|
|
|
|
Mysqlx ssl verify mode
|
|
|
|
Mysqlx ssl version
|
|
|
|
Mysqlx stmt create collection
|
0
0
|
|
|
Mysqlx stmt create collection index
|
0
0
|
|
|
Mysqlx stmt disable notices
|
0
0
|
|
|
Mysqlx stmt drop collection
|
0
0
|
|
|
Mysqlx stmt drop collection index
|
0
0
|
|
|
Mysqlx stmt enable notices
|
0
0
|
|
|
Mysqlx stmt ensure collection
|
0
0
|
|
|
Mysqlx stmt execute mysqlx
|
0
0
|
|
|
Mysqlx stmt execute sql
|
0
0
|
|
|
Mysqlx stmt execute xplugin
|
0
0
|
|
|
Mysqlx stmt kill client
|
0
0
|
|
|
Mysqlx stmt list clients
|
0
0
|
|
|
Mysqlx stmt list notices
|
0
0
|
|
|
Mysqlx stmt list objects
|
0
0
|
|
|
Mysqlx stmt ping
|
0
0
|
|
|
Mysqlx worker threads
|
2
2
|
|
|
Mysqlx worker threads active
|
0
0
|
|
|
Not flushed delayed rows
|
0
0
|
等待写入延迟插入队列的行数。
|
|
Ongoing anonymous transaction count
|
0
0
|
|
|
Open files
|
2
2
|
打开的文件个数。
|
|
Open streams
|
0
0
|
打开的流个数 (主要用于日志记录)。
|
|
Open table definitions
|
195
195
|
|
|
Open tables
|
608
608
|
打开的数据表个数。
|
|
Opened files
|
95
95
|
|
|
Opened table definitions
|
237
237
|
|
|
Opened tables
|
688
688
|
已经打开的表个数。如果打开的表很大，则说明table_open_cache的值可能设置过小。
|
|
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 index stat lost
|
0
0
|
|
|
Performance schema locker lost
|
0
0
|
|
|
Performance schema memory classes lost
|
0
0
|
|
|
Performance schema metadata lock lost
|
0
0
|
|
|
Performance schema mutex classes lost
|
0
0
|
|
|
Performance schema mutex instances lost
|
0
0
|
|
|
Performance schema nested statement lost
|
0
0
|
|
|
Performance schema prepared statements lost
|
0
0
|
|
|
Performance schema program lost
|
0
0
|
|
|
Performance schema rwlock classes lost
|
0
0
|
|
|
Performance schema rwlock instances lost
|
0
0
|
|
|
Performance schema session connect attrs longest seen
|
48
48
|
|
|
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 table lock stat 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
|
|
|
Queries
|
19.1 k
19050
|
|
|
Questions
|
18.9 k
18875
|
|
|
Rsa public key
|
-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY
3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu
gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n
Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ
vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT
j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg
4QIDAQAB
-----END PUBLIC KEY-----
-----BEGIN PUBLIC KEY-----
MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAx1vvT1kkedc7d0ezgTYY
3NhVHYM+zYotl6z32Viw9b/F9rPOc0v5Z6RrjQlAiEeCVi0fako5M0lTpUSEN9hu
gqeZFx3gujyxUEYLp+9XoFUdOfQJaB+1L8DwXw0yabdvrHWRiAPHsFLTDeZ+V+0n
Lq2BtzLq87yjd0dS8I68crLBBejJhgu0ClcBPHcrONBbLYZYViO97urugdKyj7yJ
vaTgWuldVld30Jlv95gIp/M+NY0ZYwjC4uLVkLD5T5gO6grtO3tWPb/quOJ0qKyT
j0264kS0jtMwxxIgFRFlggBhSSBbXurdespV6Cqop2r8SrAyjX5oUOJ88YGrqfzg
4QIDAQAB
-----END PUBLIC KEY-----
|
|
|
Secondary engine execution count
|
0
0
|
|
|
Select full join
|
2.6 k
2641
|
没有使用索引的多表查询数。如果该值不为0，您应该仔细检查是否已经为表建立了适当的索引。
|
|
Select full range join
|
0
0
|
使用在关联表上使用范围搜索的多表查询的数量。
|
|
Select range
|
2
2
|
在第一张表上使用范围查询的多表查询数。(即使该值很大，通常也不会有致命的影响。)
|
|
Select range check
|
0
0
|
没有使用索引但在每行之后检查索引使用的多表查询数。(如果该值不为 0，您应该仔细检查是否已经为表建立了适当的索引。)
|
|
Select scan
|
16.7 k
16721
|
在第一张表上进行了完整表扫描的多表查询数。
|
|
Slave open temp tables
|
0
0
|
副本SQL线程当前打开的临时表数量。
|
|
Slow launch threads
|
0
0
|
使用了比 slow_launch_time 更多的时间来启动的线程数量。
|
|
Slow queries
|
0
0
|
使用了比 long_query_time 更多时间的查询数。
|
|
Sort merge passes
|
0
0
|
排序算法使用归并的次数。如果该值很大，您应该考虑增加系统变量 sort_buffer_size 的值。
|
|
Sort range
|
2
2
|
局部范围完成的排序次数。
|
|
Sort rows
|
65.8 k
65765
|
排序的行数。
|
|
Sort scan
|
2.4 k
2372
|
扫描表完成的排序次数。
|
|
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
|
18.4 E
18446744073709551615
|
|
|
Ssl ctx verify mode
|
5
5
|
|
|
Ssl default timeout
|
0
0
|
|
|
Ssl finished accepts
|
0
0
|
|
|
Ssl finished connects
|
0
0
|
|
|
Ssl server not after
|
Oct 27 14:09:28 2029 GMT
Oct 27 14:09:28 2029 GMT
|
|
|
Ssl server not before
|
Oct 30 14:09:28 2019 GMT
Oct 30 14:09:28 2019 GMT
|
|
|
Ssl session cache hits
|
0
0
|
|
|
Ssl session cache misses
|
0
0
|
|
|
Ssl session cache mode
|
SERVER
SERVER
|
|
|
Ssl session cache overflows
|
0
0
|
|
|
Ssl session cache size
|
128
128
|
|
|
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
|
|
|
|
Table locks immediate
|
716
716
|
立即需要锁定表的次数。
|
|
Table locks waited
|
0
0
|
无法立即获得锁定表而必须等待的次数。如果该值很高，且您遇到了性能方面的问题，则应该首先检查您的查询语句，然后使用复制操作来分开表。
|
|
Table open cache hits
|
36.1 k
36098
|
|
|
Table open cache misses
|
688
688
|
|
|
Table open cache overflows
|
0
0
|
|
|
Tc log max pages used
|
0
0
|
|
|
Tc log page size
|
0
0
|
|
|
Tc log page waits
|
0
0
|
|
|
Threads cached
|
7
7
|
线程缓存中线程的数量。缓存命中率可以由 Threads_created/Connections 计算得出。如果该值是红色的，则应该增加 thread_cache_size 的值。
|
|
Threads connected
|
2
2
|
当前打开的连接数。
|
|
Threads created
|
11
11
|
当前用于控制连接的线程数。如果 Threads_created 很大，您可能需要增加 thread_cache_size 的值。(如果线程状况良好，这么做通常并不会带来显著的性能提升。)
|
|
Threads running
|
2
2
|
非睡眠状态的线程数量。
|
|
Uptime
|
0 天 0 小时，3 分 7 秒
187
|
|
|
Uptime since flush status
|
0 天 0 小时，3 分 7 秒
187
|
|
|
Key buffer fraction %
|
18.24 %
18.2373046875
|
已用键缓存百分比（计算值）
|
|
Threads cache hitrate %
|
99.43 %
99.432697266632
|
线程缓存命中率 （计算值）
|
