將檔案拖放至此處
主控台
| 變數 | 值 | 說明 |
|---|---|---|
|
Aborted clients
|
0 | 由於用戶端沒有正常關閉連線，這些連線已被中斷。 |
|
Aborted connects
|
0 | 無法正常連接 MySQL 伺服器的連線數。 |
|
Aborted connects preauth
|
0 | |
|
Access denied errors
|
0 | |
|
Acl column grants
|
29 | |
|
Acl database grants
|
3 | |
|
Acl function grants
|
0 | |
|
Acl procedure grants
|
0 | |
|
Acl package spec grants
|
0 | |
|
Acl package body grants
|
0 | |
|
Acl proxy users
|
2 | |
|
Acl role grants
|
0 | |
|
Acl roles
|
0 | |
|
Acl table grants
|
4 | |
|
Acl users
|
8 | |
|
Aria pagecache blocks not flushed
|
0 | |
|
Aria pagecache blocks unused
|
15.7 k | |
|
Aria pagecache blocks used
|
141 | |
|
Aria pagecache read requests
|
65.6 k | |
|
Aria pagecache reads
|
2.1 k | |
|
Aria pagecache write requests
|
4.8 k | |
|
Aria pagecache writes
|
4.8 k | |
|
Aria transaction log syncs
|
3 | |
|
Binlog commits
|
865 | |
|
Binlog group commits
|
865 | |
|
Binlog group commit trigger count
|
0 | |
|
Binlog group commit trigger lock wait
|
0 | |
|
Binlog group commit trigger timeout
|
0 | |
|
Binlog snapshot file
|
mariadb-bin.000057 | |
|
Binlog snapshot position
|
320.7 k | |
|
Binlog bytes written
|
322.7 k | |
|
Binlog cache disk use
|
0 | 使用暫存二進位記錄快取的交易數，但因超出 binlog_cache_size 限制而採用暫存檔案儲存交易指令的數量。 |
|
Binlog cache use
|
865 | 使用暫存二進位記錄快取的交易數。 |
|
Binlog stmt cache disk use
|
0 | |
|
Binlog stmt cache use
|
0 | |
|
Busy time
|
0 | |
|
Bytes received
|
9.3 M | |
|
Bytes sent
|
17.6 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
|
8 | |
|
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
|
2.1 k | |
|
Com change master
|
0 | |
|
Com check
|
0 | |
|
Com checksum
|
0 | |
|
Com commit
|
0 | |
|
Com compound sql
|
0 | |
|
Com create db
|
5 | |
|
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
|
18 | |
|
Com create temporary table
|
0 | |
|
Com create trigger
|
0 | |
|
Com create udf
|
0 | |
|
Com create user
|
1 | |
|
Com create view
|
0 | |
|
Com delete
|
96 | |
|
Com delete multi
|
0 | |
|
Com do
|
0 | |
|
Com drop db
|
8 | |
|
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
|
15 | |
|
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
|
1 | |
|
Com get diagnostics
|
0 | |
|
Com grant
|
3 | |
|
Com grant role
|
0 | |
|
Com ha close
|
0 | |
|
Com ha open
|
0 | |
|
Com ha read
|
0 | |
|
Com help
|
0 | |
|
Com insert
|
474 | |
|
Com insert select
|
0 | |
|
Com install plugin
|
0 | |
|
Com kill
|
0 | |
|
Com load
|
0 | |
|
Com lock tables
|
4 | |
|
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
|
175 | |
|
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
|
70.6 k | |
|
Com set option
|
4.2 k | |
|
Com show authors
|
0 | |
|
Com show binlog events
|
3 | |
|
Com show binlogs
|
206 | |
|
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
|
200 | |
|
Com show create trigger
|
0 | |
|
Com show create user
|
0 | |
|
Com show databases
|
14 | |
|
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
|
1.9 k | |
|
Com show function status
|
0 | |
|
Com show generic
|
0 | |
|
Com show grants
|
435 | |
|
Com show keys
|
479 | |
|
Com show master status
|
39 | |
|
Com show open tables
|
0 | |
|
Com show package status
|
0 | |
|
Com show package body status
|
0 | |
|
Com show plugins
|
1 | |
|
Com show privileges
|
0 | |
|
Com show procedure status
|
0 | |
|
Com show processlist
|
0 | |
|
Com show profile
|
0 | |
|
Com show profiles
|
0 | |
|
Com show relaylog events
|
0 | |
|
Com show slave hosts
|
2 | |
|
Com show slave status
|
41 | |
|
Com show status
|
12 | |
|
Com show storage engines
|
17 | |
|
Com show table status
|
74 | |
|
Com show tables
|
3 k | |
|
Com show triggers
|
0 | |
|
Com show variables
|
731 | |
|
Com show warnings
|
189 | |
|
Com shutdown
|
0 | |
|
Com signal
|
0 | |
|
Com start all slaves
|
0 | |
|
Com start slave
|
0 | |
|
Com stmt close
|
66 | |
|
Com stmt execute
|
66 | |
|
Com stmt fetch
|
0 | |
|
Com stmt prepare
|
126 | |
|
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
|
4 | |
|
Com update
|
120 | |
|
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
|
2.9 k | 嘗試連到 MySQL 伺服器的連線數 (不論成功或失敗)。 |
|
Cpu time
|
0 | |
|
Created tmp disk tables
|
2.5 k | 伺服器執行指令時，自動在硬碟建立的暫存表的數量。如果 Created_tmp_disk_tables 很大，您可以增加 tmp_table_size 的值，令伺服器使用記憶體而非硬碟來儲存暫存表。 |
|
Created tmp files
|
5 | mysqld 已建立的暫存檔案的數量。 |
|
Created tmp tables
|
30.5 k | 伺服器執行指令時，自動在記憶體建立的暫存表的數量。 |
|
Delayed errors
|
0 | 延遲新增 (INSERT DELAYED) 發生錯誤的列數 (可能為重複鍵值造成)。 |
|
Delayed insert threads
|
0 | 正在使用的延遲新增處理程序執行緒的數量。每張使用延遲新增的表都有自己的執行緒。 |
|
Delayed writes
|
0 | 延遲新增已寫入的列數。 |
|
Delete scan
|
32 | |
|
Empty queries
|
54.6 k | |
|
Executed events
|
0 | |
|
Executed triggers
|
0 | |
|
Feature application time periods
|
0 | |
|
Feature check constraint
|
0 | |
|
Feature custom aggregate functions
|
0 | |
|
Feature delay key write
|
0 | |
|
Feature dynamic columns
|
0 | |
|
Feature fulltext
|
0 | |
|
Feature gis
|
5 | |
|
Feature invisible columns
|
0 | |
|
Feature json
|
0 | |
|
Feature locale
|
1.4 k | |
|
Feature subquery
|
40 | |
|
Feature system versioning
|
0 | |
|
Feature timezone
|
1 | |
|
Feature trigger
|
24 | |
|
Feature window functions
|
0 | |
|
Feature xml
|
0 | |
|
Flush commands
|
1 | 已執行的強制更新 (FLUSH) 指令數。 |
|
Handler commit
|
3.3 k | 已執行的內部送出 (COMMIT) 指令數。 |
|
Handler delete
|
0 | 從資料表中刪除行的次數。 |
|
Handler discover
|
52 | 在已知資料表名稱的情況下，MySQL 伺服器可以詢問 NDB 叢集儲存引擎該資料表是否存在。這個動作稱為「探索(Discovery)」。Handler_discover 參數指的是資料表被探索到的次數。 |
|
Handler external lock
|
0 | |
|
Handler icp attempts
|
4 | |
|
Handler icp match
|
3 | |
|
Handler mrr init
|
0 | |
|
Handler mrr key refills
|
0 | |
|
Handler mrr rowid refills
|
0 | |
|
Handler prepare
|
1.5 k | |
|
Handler read first
|
1.2 k | 第一筆索引資料被讀取的次數。若這個值很大，代表您的伺服器執行了很多完整索引掃描。例子：欄位 col1 已經建立了索引，然後執行 SELECT col1 FROM foo。 |
|
Handler read key
|
18 k | 根據鍵值查詢到資料列的請求次數。若這個值很大，代表您的查詢條件和資料表都有正確的索引。 |
|
Handler read last
|
0 | |
|
Handler read next
|
61.8 k | 查詢下一筆索引資料的請求次數。若查詢條件使用了索引的欄位做一段區間範圍的查詢，或者進行了索引掃描，會使這個值不斷增加。 |
|
Handler read prev
|
0 | 查詢上一筆索引資料的請求次數。這種讀取方式通常用於最佳化有關 ORDER BY … DESC 的查詢。 |
|
Handler read retry
|
0 | |
|
Handler read rnd
|
28.1 k | 使用固定位置讀取資料列的請求次數。如果執行很多需要排序的查詢，該值會很高。您可能有很多需要完整表掃描的查詢，或者您使用了不正確的索引用來多表查詢(joins)。 |
|
Handler read rnd deleted
|
989 | |
|
Handler read rnd next
|
992.7 k | 查詢資料檔下一筆資料列的請求次數。此值會因掃描資料表的次數增加而增加。在一般情況，這代表您的資料表未正確建立索引，或者您使用的查詢指令沒有使用已建立索引的欄位。 |
|
Handler rollback
|
0 | 使用內部回退(ROLLBACK)敘述句的次數。 |
|
Handler savepoint
|
0 | |
|
Handler savepoint rollback
|
0 | |
|
Handler tmp delete
|
0 | |
|
Handler tmp update
|
123 | |
|
Handler tmp write
|
1 M | |
|
Handler update
|
293 | 資料表中更新資料列的請求次數。 |
|
Handler write
|
660 | 資料表中新增資料列的請求數。 |
|
Innodb buffer pool dump status
|
||
|
Innodb buffer pool load status
|
Buffer pool(s) load completed at 241115 11:31:45 | |
|
Innodb buffer pool resize status
|
||
|
Innodb buffer pool load incomplete
|
OFF | |
|
Innodb buffer pool pages data
|
836 | 含資料頁數 (異動未儲存或已儲存)。 |
|
Innodb buffer pool bytes data
|
13.7 M | |
|
Innodb buffer pool pages dirty
|
0 | 目前異動未儲存的頁數。 |
|
Innodb buffer pool bytes dirty
|
0 | |
|
Innodb buffer pool pages flushed
|
2.5 k | 請求更新的緩衝池頁數。 |
|
Innodb buffer pool pages free
|
15.2 k | 空閒頁數。 |
|
Innodb buffer pool pages misc
|
365 | 負載頁的數量，像鎖定行或適應性的散列索引這樣的管理操作時分配的頁。該值可用此公式計算：Innodb_buffer_pool_pages_total - Innodb_buffer_pool_pages_free - Innodb_buffer_pool_pages_data。 |
|
Innodb buffer pool pages total
|
16.4 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
|
66 k | InnoDB 完成的邏輯讀取請求數。 |
|
Innodb buffer pool reads
|
623 | InnoDB 進行邏輯讀取時，無法從緩衝池取得，而執行單頁讀取的次數。 |
|
Innodb buffer pool wait free
|
0 | 寫入 InnoDB 緩衝池通常在背景進行，但有必要在沒有乾淨頁的時候讀取或建立頁，有必要先等待頁被重新整理。該計數器統計了這種等待的數量。如果緩衝池大小設定正確，這個值應該會很小。 |
|
Innodb buffer pool write requests
|
14.3 k | 寫入 InnoDB 緩衝池的次數。 |
|
Innodb data fsyncs
|
3.2 k | 到目前為止 fsync() 執行的次數。 |
|
Innodb data pending fsyncs
|
0 | 目前待執行 fsync() 的數量。 |
|
Innodb data pending reads
|
0 | 目前待執行的讀取次數。 |
|
Innodb data pending writes
|
0 | 目前待執行的寫入次數。 |
|
Innodb data read
|
12.1 M | 到目前為止已讀取的總資料量 (以位元組為單位)。 |
|
Innodb data reads
|
781 | 資料讀取總數。 |
|
Innodb data writes
|
5.1 k | 資料寫入總數。 |
|
Innodb data written
|
82.5 M | 到目前為止已寫入的總資料量 (以位元組為單位)。 |
|
Innodb dblwr pages written
|
2.4 k | 已經以雙寫(doublewrite)操作寫入的頁數。 |
|
Innodb dblwr writes
|
299 | 已經執行的雙寫入次數。 |
|
Innodb log waits
|
0 | 因記錄緩衝太小而必須等待其被寫入所造成的等待數。 |
|
Innodb log write requests
|
2.3 k | 記錄寫入請求數。 |
|
Innodb log writes
|
1.8 k | 記錄檔案物理寫入次數。 |
|
Innodb os log fsyncs
|
2.3 k | 使用 fsync() 寫入記錄檔案的次數。 |
|
Innodb os log pending fsyncs
|
0 | 在記錄檔案中待執行的 fsync 數。 |
|
Innodb os log pending writes
|
0 | 目前待執行的記錄檔案寫入數。 |
|
Innodb os log written
|
2.5 M | 寫入記錄檔案的位元組。 |
|
Innodb page size
|
16.4 k | 編譯的 InnoDB 頁大小 (預設 16KB)。許多值都以頁為單位進行統計，頁大小可以很容易地將這些值轉換為位元組數目。 |
|
Innodb pages created
|
214 | 已建立的頁數。 |
|
Innodb pages read
|
622 | 已讀取的頁數。 |
|
Innodb pages written
|
2.5 k | 已寫入的頁數。 |
|
Innodb row lock current waits
|
0 | 目前正等待的列鎖定(Row Lock)數量。 |
|
Innodb row lock time
|
0 | 等待取得列鎖定(Row lock)的總時間 (毫秒)。 |
|
Innodb row lock time avg
|
0 | 等待取得列鎖定(Row lock)的平均時間 (毫秒)。 |
|
Innodb row lock time max
|
0 | 等待取得列鎖定(Row lock)的最大時間 (毫秒)。 |
|
Innodb row lock waits
|
0 | 等待列鎖定(Row lock)的次數。 |
|
Innodb rows deleted
|
0 | 從 InnoDB 資料表刪除的列數。 |
|
Innodb rows inserted
|
482 | 新增到 InnoDB 資料表的列數。 |
|
Innodb rows read
|
75.8 k | 從 InnoDB 資料表讀取的列數。 |
|
Innodb rows updated
|
290 | InnoDB 更新的列數。 |
|
Innodb system rows deleted
|
0 | |
|
Innodb system rows inserted
|
0 | |
|
Innodb system rows read
|
1.3 k | |
|
Innodb system rows updated
|
0 | |
|
Innodb num open files
|
26 | |
|
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
|
288 | |
|
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
|
35 | 鍵快取中已經使用的塊數。該值指示在某個時刻使用了最多塊數的數量。 |
|
Key blocks warm
|
0 | |
|
Key read requests
|
3.2 k | 從快取中讀取鍵塊的請求次數。 |
|
Key reads
|
35 | 從硬碟中物理讀取鍵塊的次數。如果 Key_reads 很大，則代表您的 key_buffer_size 可能設定得太小了。快取缺失率可以由 Key_reads/Key_read_requests 計算得出。 |
|
Key write requests
|
12 | 將鍵塊寫入快取的請求數。 |
|
Key writes
|
12 | 將鍵塊實體寫入到硬碟的次數。 |
|
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
|
4 | 自伺服器啟動以來，最大的同時連線數量。 |
|
Memory used
|
177.1 M | |
|
Memory used initial
|
172 M | |
|
Not flushed delayed rows
|
0 | 延遲新增等待寫入序列的列數。 |
|
Open files
|
60 | 已開啟的檔案個數。 |
|
Open streams
|
0 | 已開啟的串流數 (主要用於記錄)。 |
|
Open table definitions
|
101 | |
|
Open tables
|
103 | 已開啟的資料表數。 |
|
Opened files
|
10.3 k | |
|
Opened plugin libraries
|
1 | |
|
Opened table definitions
|
165 | |
|
Opened tables
|
159 | 已經開啟的資料表數。如果該值很大，則代表資料表快取(table_open_cache )可能設得太小。 |
|
Opened views
|
234 | |
|
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
|
99 | 查詢快取中的閒置區塊數。數字越高表示有記憶體碎片問題，也許可用 FLUSH QUERY CACHE 語句解決。 |
|
Qcache free memory
|
16.1 M | 查詢快取中，空閒的記憶體總數。 |
|
Qcache hits
|
55 k | 快取命中數。 |
|
Qcache inserts
|
1.5 k | 加入到快取的查詢數。 |
|
Qcache lowmem prunes
|
0 | 為快取新的查詢而被刪除的已快取查詢的個數，由最近最少使用算法 (LRU) 確定應刪除哪個已快取的查詢。該資訊可幫助您調整查詢快取大小。 |
|
Qcache not cached
|
14 k | 未快取的查詢數 (包括不能被快取，或因為 query_cache_type 的設定而沒有被快取的查詢)。 |
|
Qcache queries in cache
|
638 | 在快取中註冊的查詢數。 |
|
Qcache total blocks
|
1.4 k | 查詢快取中的總區塊數。 |
|
Queries
|
88.2 k | |
|
Questions
|
88 k | |
|
Rows read
|
87.5 k | |
|
Rows sent
|
168.3 k | |
|
Rows tmp read
|
982 k | |
|
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
|
747 | 沒有使用索引的多表查詢數。如果該值不為0，您應該仔細檢查是否已經為資料表建立了適當的索引。 |
|
Select full range join
|
0 | 使用在關聯表上使用範圍搜尋的多表查詢的數量。 |
|
Select range
|
11 | 在第一個資料表上使用範圍查詢的多表查詢數。 (即使該值很大，通常也不會有致命的影響。) |
|
Select range check
|
0 | 沒有使用索引但在每行之後檢查索引使用的多表查詢數。 (如果該值不為 0，您應該仔細檢查是否已經為資料表建立了適當的索引。) |
|
Select scan
|
26.8 k | 在第一個資料表上進行了完整表掃描的多表查詢數。 |
|
Slave connections
|
0 | |
|
Slave heartbeat period
|
0 | |
|
Slave open temp tables
|
0 | The number of temporary tables currently open by the replica SQL thread. |
|
Slave received heartbeats
|
0 | |
|
Slave retried transactions
|
0 | Total (since startup) number of times the replication replica SQL thread has retried transactions. |
|
Slave running
|
OFF | This is ON if this server is a replica that is connected to a primary. |
|
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
|
0 | |
|
Sort range
|
4 | 局部範圍完成的排序次數。 |
|
Sort rows
|
28.4 k | 已排序的列數。 |
|
Sort scan
|
1.9 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
|
49 | |
|
Table locks immediate
|
3.1 k | 立即需要鎖定表的次數。 |
|
Table locks waited
|
0 | 無法立即取得鎖定表而必須等待的次數。如果該值很高，且遇到了性能方面的問題，則應該首先最佳化您的查詢指令，然後分割資料表，又或使用備援操作。 |
|
Table open cache active instances
|
1 | |
|
Table open cache hits
|
10.2 k | |
|
Table open cache misses
|
405 | |
|
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
|
0 | |
|
Threads cached
|
2 | 執行緒快取中執行緒的數量。快取命中率可以由 Threads_created/Connections 計算得出。如果該值是紅色的，則應該增加 thread_cache_size 的值。 |
|
Threads connected
|
2 | 目前開啟的連線數。 |
|
Threads created
|
4 | 目前用於處理連線的執行緒數量。如果 Threads_created 很大，您可能需要增加 thread_cache_size 的值 (如果執行緒狀況良好，這麼做通常並不會帶來顯著的性能提升) |
|
Threads running
|
6 | 非睡眠狀態的執行緒數量。 |
|
Transactions gtid foreign engine
|
0 | |
|
Transactions multi engine
|
0 | |
|
Update scan
|
0 | |
|
Uptime
|
0 天 1 小時，58 分 6 秒 | |
|
Uptime since flush status
|
0 天 1 小時，58 分 6 秒 | |
|
wsrep
|
909.7 M | |
|
wsrep applier thread count
|
0 | |
|
wsrep cluster capabilities
|
||
|
wsrep cluster conf id
|
18.4 E | |
|
wsrep cluster size
|
0 | |
|
wsrep cluster state uuid
|
||
|
wsrep cluster status
|
Disconnected | |
|
wsrep connected
|
OFF | |
|
wsrep local bf aborts
|
0 | |
|
wsrep local index
|
18.4 E | |
|
wsrep provider capabilities
|
||
|
wsrep provider name
|
||
|
wsrep provider vendor
|
||
|
wsrep provider version
|
||
|
wsrep ready
|
OFF | |
|
wsrep rollbacker thread count
|
0 | |
|
wsrep thread count
|
0 | |
| Key buffer fraction % | 18.46 % | 已使用鍵值快取的百分比 (計算值) |
| Key write ratio % | 100.00 % | 實際寫入數和寫入請求數的百分比值 (計算值) |
| Key read ratio % | 1.08 % | 由實際讀取數和讀取請求數比對，計算出的鍵值快取未命中率 (計算值) |
| Threads cache hitrate % | 99.86 % | 執行緒快取命中率 (計算值) |