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
|
2
2
|
使用暫存二進位記錄快取的交易數。
|
Binlog stmt cache disk use
|
0
0
|
|
Binlog stmt cache use
|
0
0
|
|
Bytes received
|
1.9 M
1862532
|
|
Bytes sent
|
7.1 M
7132590
|
|
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.1 k
1076
|
|
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
|
3
3
|
|
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
|
34
34
|
|
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
|
0
0
|
|
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
|
8.5 k
8523
|
|
Com set option
|
1.7 k
1718
|
|
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
|
43
43
|
|
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
|
22
22
|
|
Com show create proc
|
27
27
|
|
Com show create table
|
184
184
|
|
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
|
376
376
|
|
Com show function code
|
0
0
|
|
Com show function status
|
0
0
|
|
Com show grants
|
458
458
|
|
Com show keys
|
293
293
|
|
Com show master status
|
21
21
|
|
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
|
21
21
|
|
Com show status
|
1
1
|
|
Com show storage engines
|
7
7
|
|
Com show table status
|
70
70
|
|
Com show tables
|
900
900
|
|
Com show triggers
|
0
0
|
|
Com show variables
|
408
408
|
|
Com show warnings
|
172
172
|
|
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
|
1
1
|
|
Com stmt close
|
1
1
|
|
Com stmt fetch
|
0
0
|
|
Com stmt prepare
|
1
1
|
|
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.2 k
1197
|
嘗試連到 MySQL 伺服器的連線數 (不論成功或失敗)。
|
Created tmp disk tables
|
4
4
|
伺服器執行指令時,自動在硬碟建立的暫存表的數量。如果 Created_tmp_disk_tables 很大,您可以增加 tmp_table_size 的值,令伺服器使用記憶體而非硬碟來儲存暫存表。
|
Created tmp files
|
6
6
|
mysqld 已建立的暫存檔案的數量。
|
Created tmp tables
|
11.2 k
11187
|
伺服器執行指令時,自動在記憶體建立的暫存表的數量。
|
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
|
9.3 k
9258
|
已執行的內部送出 (COMMIT) 指令數。
|
Handler delete
|
0
0
|
從資料表中刪除行的次數。
|
Handler discover
|
0
0
|
在已知資料表名稱的情況下,MySQL 伺服器可以詢問 NDB 叢集儲存引擎該資料表是否存在。這個動作稱為「探索(Discovery)」。Handler_discover 參數指的是資料表被探索到的次數。
|
Handler external lock
|
67.3 k
67257
|
|
Handler mrr init
|
0
0
|
|
Handler prepare
|
8
8
|
|
Handler read first
|
8.6 k
8607
|
第一筆索引資料被讀取的次數。若這個值很大,代表您的伺服器執行了很多完整索引掃描。例子:欄位 col1 已經建立了索引,然後執行 SELECT col1 FROM foo。
|
Handler read key
|
274.2 k
274249
|
根據鍵值查詢到資料列的請求次數。若這個值很大,代表您的查詢條件和資料表都有正確的索引。
|
Handler read last
|
0
0
|
|
Handler read next
|
232.8 k
232809
|
查詢下一筆索引資料的請求次數。若查詢條件使用了索引的欄位做一段區間範圍的查詢,或者進行了索引掃描,會使這個值不斷增加。
|
Handler read prev
|
0
0
|
查詢上一筆索引資料的請求次數。這種讀取方式通常用於最佳化有關 ORDER BY … DESC 的查詢。
|
Handler read rnd
|
16 k
16028
|
使用固定位置讀取資料列的請求次數。如果執行很多需要排序的查詢,該值會很高。您可能有很多需要完整表掃描的查詢,或者您使用了不正確的索引用來多表查詢(joins)。
|
Handler read rnd next
|
990.7 k
990659
|
查詢資料檔下一筆資料列的請求次數。此值會因掃描資料表的次數增加而增加。在一般情況,這代表您的資料表未正確建立索引,或者您使用的查詢指令沒有使用已建立索引的欄位。
|
Handler rollback
|
0
0
|
使用內部回退(ROLLBACK)敘述句的次數。
|
Handler savepoint
|
0
0
|
|
Handler savepoint rollback
|
0
0
|
|
Handler update
|
48.5 k
48500
|
資料表中更新資料列的請求次數。
|
Handler write
|
804.9 k
804890
|
資料表中新增資料列的請求數。
|
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 240928 21:15:47
Buffer pool(s) load completed at 240928 21:15:47
|
|
Innodb buffer pool resize status
|
|
|
Innodb buffer pool pages data
|
1.5 k
1495
|
含資料頁數 (異動未儲存或已儲存)。
|
Innodb buffer pool bytes data
|
24.5 M
24494080
|
|
Innodb buffer pool pages dirty
|
0
0
|
目前異動未儲存的頁數。
|
Innodb buffer pool bytes dirty
|
0
0
|
|
Innodb buffer pool pages flushed
|
488
488
|
請求更新的緩衝池頁數。
|
Innodb buffer pool pages free
|
6.6 k
6626
|
空閒頁數。
|
Innodb buffer pool pages misc
|
71
71
|
負載頁的數量,像鎖定行或適應性的散列索引這樣的管理操作時分配的頁。該值可用此公式計算: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
|
881.2 k
881219
|
InnoDB 完成的邏輯讀取請求數。
|
Innodb buffer pool reads
|
1.4 k
1350
|
InnoDB 進行邏輯讀取時,無法從緩衝池取得,而執行單頁讀取的次數。
|
Innodb buffer pool wait free
|
0
0
|
寫入 InnoDB 緩衝池通常在背景進行,但有必要在沒有乾淨頁的時候讀取或建立頁,有必要先等待頁被重新整理。該計數器統計了這種等待的數量。如果緩衝池大小設定正確,這個值應該會很小。
|
Innodb buffer pool write requests
|
2.6 k
2609
|
寫入 InnoDB 緩衝池的次數。
|
Innodb data fsyncs
|
222
222
|
到目前為止 fsync() 執行的次數。
|
Innodb data pending fsyncs
|
0
0
|
目前待執行 fsync() 的數量。
|
Innodb data pending reads
|
0
0
|
目前待執行的讀取次數。
|
Innodb data pending writes
|
0
0
|
目前待執行的寫入次數。
|
Innodb data read
|
22.3 M
22320128
|
到目前為止已讀取的總資料量 (以位元組為單位)。
|
Innodb data reads
|
1.5 k
1473
|
資料讀取總數。
|
Innodb data writes
|
757
757
|
資料寫入總數。
|
Innodb data written
|
14.1 M
14143488
|
到目前為止已寫入的總資料量 (以位元組為單位)。
|
Innodb dblwr pages written
|
354
354
|
已經以雙寫(doublewrite)操作寫入的頁數。
|
Innodb dblwr writes
|
16
16
|
已經執行的雙寫入次數。
|
Innodb log waits
|
0
0
|
因記錄緩衝太小而必須等待其被寫入所造成的等待數。
|
Innodb log write requests
|
1.1 k
1104
|
記錄寫入請求數。
|
Innodb log writes
|
187
187
|
記錄檔案物理寫入次數。
|
Innodb os log fsyncs
|
132
132
|
使用 fsync() 寫入記錄檔案的次數。
|
Innodb os log pending fsyncs
|
0
0
|
在記錄檔案中待執行的 fsync 數。
|
Innodb os log pending writes
|
0
0
|
目前待執行的記錄檔案寫入數。
|
Innodb os log written
|
130 k
130048
|
寫入記錄檔案的位元組。
|
Innodb page size
|
16.4 k
16384
|
編譯的 InnoDB 頁大小 (預設 16KB)。許多值都以頁為單位進行統計,頁大小可以很容易地將這些值轉換為位元組數目。
|
Innodb pages created
|
157
157
|
已建立的頁數。
|
Innodb pages read
|
1.4 k
1350
|
已讀取的頁數。
|
Innodb pages written
|
498
498
|
已寫入的頁數。
|
Innodb row lock current waits
|
0
0
|
目前正等待的列鎖定(Row Lock)數量。
|
Innodb row lock time
|
0
0
|
等待取得列鎖定(Row lock)的總時間 (毫秒)。
|
Innodb row lock time avg
|
0
0
|
等待取得列鎖定(Row lock)的平均時間 (毫秒)。
|
Innodb row lock time max
|
0
0
|
等待取得列鎖定(Row lock)的最大時間 (毫秒)。
|
Innodb row lock waits
|
0
0
|
等待列鎖定(Row lock)的次數。
|
Innodb rows deleted
|
0
0
|
從 InnoDB 資料表刪除的列數。
|
Innodb rows inserted
|
184
184
|
新增到 InnoDB 資料表的列數。
|
Innodb rows read
|
408.2 k
408157
|
從 InnoDB 資料表讀取的列數。
|
Innodb rows updated
|
388
388
|
InnoDB 更新的列數。
|
Innodb num open files
|
34
34
|
|
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
|
6
6
|
自伺服器啟動以來,最大的同時連線數量。
|
Max used connections time
|
2024-09-28 21:16:01
2024-09-28 21:16:01
|
|
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
|
8
8
|
已開啟的檔案個數。
|
Open streams
|
0
0
|
已開啟的串流數 (主要用於記錄)。
|
Open table definitions
|
100
100
|
|
Open tables
|
527
527
|
已開啟的資料表數。
|
Opened files
|
98
98
|
|
Opened table definitions
|
138
138
|
|
Opened tables
|
593
593
|
已經開啟的資料表數。如果該值很大,則代表資料表快取(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
|
15.7 k
15727
|
|
Questions
|
15.5 k
15514
|
|
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
|
3.4 k
3395
|
沒有使用索引的多表查詢數。如果該值不為0,您應該仔細檢查是否已經為資料表建立了適當的索引。
|
Select full range join
|
0
0
|
使用在關聯表上使用範圍搜尋的多表查詢的數量。
|
Select range
|
2
2
|
在第一個資料表上使用範圍查詢的多表查詢數。 (即使該值很大,通常也不會有致命的影響。)
|
Select range check
|
0
0
|
沒有使用索引但在每行之後檢查索引使用的多表查詢數。 (如果該值不為 0,您應該仔細檢查是否已經為資料表建立了適當的索引。)
|
Select scan
|
14.1 k
14096
|
在第一個資料表上進行了完整表掃描的多表查詢數。
|
Slave open temp tables
|
0
0
|
The number of temporary tables currently open by the replica SQL thread.
|
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
|
50.9 k
50853
|
已排序的列數。
|
Sort scan
|
2.2 k
2188
|
掃描表完成的排序次數。
|
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
|
694
694
|
立即需要鎖定表的次數。
|
Table locks waited
|
0
0
|
無法立即取得鎖定表而必須等待的次數。如果該值很高,且遇到了性能方面的問題,則應該首先最佳化您的查詢指令,然後分割資料表,又或使用備援操作。
|
Table open cache hits
|
33.6 k
33596
|
|
Table open cache misses
|
593
593
|
|
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
|
0
0
|
執行緒快取中執行緒的數量。快取命中率可以由 Threads_created/Connections 計算得出。如果該值是紅色的,則應該增加 thread_cache_size 的值。
|
Threads connected
|
6
6
|
目前開啟的連線數。
|
Threads created
|
6
6
|
目前用於處理連線的執行緒數量。如果 Threads_created 很大,您可能需要增加 thread_cache_size 的值 (如果執行緒狀況良好,這麼做通常並不會帶來顯著的性能提升)
|
Threads running
|
2
2
|
非睡眠狀態的執行緒數量。
|
Uptime
|
0 天 0 小時,3 分 4 秒
184
|
|
Uptime since flush status
|
0 天 0 小時,3 分 4 秒
184
|
|
Key buffer fraction %
|
18.24 %
18.2373046875
|
已使用鍵值快取的百分比 (計算值)
|
Threads cache hitrate %
|
99.50 %
99.498746867168
|
執行緒快取命中率 (計算值)
|