目前伺服器:
(伺服器) ...
phpMyAdmin demo - MariaDB (root)
phpMyAdmin demo - MySQL (root)
最近使用
沒有最近使用的資料表。
最愛
沒有「最愛」資料表。
X
新增
booking
Bookstore.b5
fgh
information_schema
mysql
performance_schema
php data base
Portfolio_Marcus
PRUEBA
pw
rupsaguhasaundariya
sakila
serveruwebcoBressolia
shoe_db
sklepSerohenko
sku
StdMdDB
Stefano
students
students 2020
STUDENT_ATTENDENCE
superpos
sys
table
Table_insertion
tb
test19
teste_teste
TlapaleriaMalfoy
Trickysolo
vedettfak
victory 2020
wisedb
world
wps
wpworld
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ
аа
導覽面板
導覽樹
伺服器
資料庫
資料表
導覽面板
自訂導覽面版外觀。
導覽面板
以樹狀顯示資料庫導覽面版
於導覽面版,將資料庫樹狀選單改為下拉式選單
連結主面板
在主面板凸顯目前的資料庫或資料表。
顯示標誌
在導覽面板顯示標誌。
標誌連結網址
導覽面板標誌所連結的網址。
標誌連結目標
以主視窗 (
main
) 還是新視窗 (
new
) 開啟目標連結。
main
new
開啟加強標示
當滑鼠指標移至伺服器上時,將之凸顯。
導覽樹第一層項目數量上限
導覽樹每一頁可以顯示的第一層項目數量。
設定顯示篩選框的項目數量下限
設定篩選框要顯示的項目最小數量 (資料表、檢視表、預存程序和事件) 。
最近使用的資料表
最多顯示幾個最近使用的資料表;0 代表不顯示。
最愛資料表
顯示最愛資料表的數量上限;設為 0 則關閉此功能。
導覽面板寬度
設為 0 則摺疊導覽面板。
導覽樹
自訂導覽樹。
導覽樹
導覽樹分支的項目數量上限
導覽樹每一頁可以顯示的項目數量。
將導覽樹的項目分組
將導覽樹內的項目分組 (依上方「資料庫與資料表」分頁定義的分隔符號來分組)。
開啟導覽樹展開功能
於導覽面版,是否提供樹狀選單的展開功能。
在導覽樹顯示資料表
在導覽樹,是否於資料庫底下顯示資料表
在導覽樹顯示檢視表
在導覽樹,是否於資料庫底下顯示檢視表
在導覽樹顯示函式
在導覽樹,是否於資料庫底下顯示函式
在導覽樹顯示預存程序
在導覽樹,是否於資料庫底下顯示預存程序
在導覽樹顯示事件
在導覽樹,是否於資料庫底下顯示事件
展開單一資料庫
是否於導覽樹自動展開單一資料庫。
伺服器
伺服器顯示選項。
伺服器
顯示伺服器選擇
在導覽面板上方,顯示伺服器清單。
使用清單方式顯示伺服器
顯示伺服器列表時,以清單取代下拉式選單。
資料庫
資料庫顯示選項。
資料庫
設定顯示篩選框的資料庫數量下限
資料庫導覽樹的分隔符號
會依據此分隔符號,將資料庫分為不同階層的樹狀。
資料表
資料表顯示選項。
資料表
快速存取圖示要顯示的目標頁面
結構
SQL
搜尋
新增
瀏覽
第二快速存取圖示的目標頁面
結構
SQL
搜尋
新增
瀏覽
資料表導覽樹的分隔符號
會依據此分隔符號將資料表分為不同階層的樹狀。
資料表導覽樹深度限制
將檔案拖放至此處
SQL 上載 (
0
)
x
-
顯示隱藏的導覽樹項目。
新增檢視表
瀏覽器有此網域的 phpMyAdmin 設定,是否匯入到目前的連線階段?
是
/
否
/
刪除設定
必須啟用 Javascript 才能繼續!
伺服器: phpMyAdmin demo - MySQL
資料庫: performance_schema
結構
SQL
搜尋
查詢
(在此)
匯出
root@192.168.30.%
phpMyAdmin 說明文件
MySQL 說明文件
設定
登出
主控台
清除
歷史記錄
選項
請按 Ctrl+Enter 執行查詢
請按 Enter 執行查詢
遞增
遞減
排序:
SQL 偵錯
次數
執行排序
使用時間
排序依:
群組查詢
解除群組查詢
摺疊
展開
顯示追蹤
隱藏追蹤
次數:
使用時間:
選項
還原預設值
必定展開查詢訊息
於一開始顯示查詢記錄
顯示目前瀏覽的查詢
按 Enter 執行查詢,或以 Shift+Enter 輸入新的一行。要永久儲存此設定,請檢視設定項目。
切換為深色主題
摺疊
展開
重新查詢
編輯
語句分析
效能分析
查詢失敗
資料庫:
查詢時間:
載入中
ENUM/SET 編輯器
新增檢視表
查詢視窗
*
USER
HOST
CURRENT_CONNECTIONS
TOTAL_CONNECTIONS
*
NAME
OBJECT_INSTANCE_BEGIN
*
ENGINE
REQUESTING_ENGINE_LOCK_ID
REQUESTING_ENGINE_TRANSACTION_ID
REQUESTING_THREAD_ID
REQUESTING_EVENT_ID
REQUESTING_OBJECT_INSTANCE_BEGIN
BLOCKING_ENGINE_LOCK_ID
BLOCKING_ENGINE_TRANSACTION_ID
BLOCKING_THREAD_ID
BLOCKING_EVENT_ID
BLOCKING_OBJECT_INSTANCE_BEGIN
*
ENGINE
ENGINE_LOCK_ID
ENGINE_TRANSACTION_ID
THREAD_ID
EVENT_ID
OBJECT_SCHEMA
OBJECT_NAME
PARTITION_NAME
SUBPARTITION_NAME
INDEX_NAME
OBJECT_INSTANCE_BEGIN
LOCK_TYPE
LOCK_MODE
LOCK_STATUS
LOCK_DATA
*
USER
HOST
ERROR_NUMBER
ERROR_NAME
SQL_STATE
SUM_ERROR_RAISED
SUM_ERROR_HANDLED
FIRST_SEEN
LAST_SEEN
*
HOST
ERROR_NUMBER
ERROR_NAME
SQL_STATE
SUM_ERROR_RAISED
SUM_ERROR_HANDLED
FIRST_SEEN
LAST_SEEN
*
THREAD_ID
ERROR_NUMBER
ERROR_NAME
SQL_STATE
SUM_ERROR_RAISED
SUM_ERROR_HANDLED
FIRST_SEEN
LAST_SEEN
*
USER
ERROR_NUMBER
ERROR_NAME
SQL_STATE
SUM_ERROR_RAISED
SUM_ERROR_HANDLED
FIRST_SEEN
LAST_SEEN
*
ERROR_NUMBER
ERROR_NAME
SQL_STATE
SUM_ERROR_RAISED
SUM_ERROR_HANDLED
FIRST_SEEN
LAST_SEEN
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
WORK_COMPLETED
WORK_ESTIMATED
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
WORK_COMPLETED
WORK_ESTIMATED
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
WORK_COMPLETED
WORK_ESTIMATED
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
USER
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
THREAD_ID
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
USER
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
LOCK_TIME
SQL_TEXT
DIGEST
DIGEST_TEXT
CURRENT_SCHEMA
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_INSTANCE_BEGIN
MYSQL_ERRNO
RETURNED_SQLSTATE
MESSAGE_TEXT
ERRORS
WARNINGS
ROWS_AFFECTED
ROWS_SENT
ROWS_EXAMINED
CREATED_TMP_DISK_TABLES
CREATED_TMP_TABLES
SELECT_FULL_JOIN
SELECT_FULL_RANGE_JOIN
SELECT_RANGE
SELECT_RANGE_CHECK
SELECT_SCAN
SORT_MERGE_PASSES
SORT_RANGE
SORT_ROWS
SORT_SCAN
NO_INDEX_USED
NO_GOOD_INDEX_USED
NESTING_EVENT_ID
NESTING_EVENT_TYPE
NESTING_EVENT_LEVEL
STATEMENT_ID
*
SCHEMA_NAME
DIGEST
BUCKET_NUMBER
BUCKET_TIMER_LOW
BUCKET_TIMER_HIGH
COUNT_BUCKET
COUNT_BUCKET_AND_LOWER
BUCKET_QUANTILE
*
BUCKET_NUMBER
BUCKET_TIMER_LOW
BUCKET_TIMER_HIGH
COUNT_BUCKET
COUNT_BUCKET_AND_LOWER
BUCKET_QUANTILE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
LOCK_TIME
SQL_TEXT
DIGEST
DIGEST_TEXT
CURRENT_SCHEMA
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_INSTANCE_BEGIN
MYSQL_ERRNO
RETURNED_SQLSTATE
MESSAGE_TEXT
ERRORS
WARNINGS
ROWS_AFFECTED
ROWS_SENT
ROWS_EXAMINED
CREATED_TMP_DISK_TABLES
CREATED_TMP_TABLES
SELECT_FULL_JOIN
SELECT_FULL_RANGE_JOIN
SELECT_RANGE
SELECT_RANGE_CHECK
SELECT_SCAN
SORT_MERGE_PASSES
SORT_RANGE
SORT_ROWS
SORT_SCAN
NO_INDEX_USED
NO_GOOD_INDEX_USED
NESTING_EVENT_ID
NESTING_EVENT_TYPE
NESTING_EVENT_LEVEL
STATEMENT_ID
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
LOCK_TIME
SQL_TEXT
DIGEST
DIGEST_TEXT
CURRENT_SCHEMA
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_INSTANCE_BEGIN
MYSQL_ERRNO
RETURNED_SQLSTATE
MESSAGE_TEXT
ERRORS
WARNINGS
ROWS_AFFECTED
ROWS_SENT
ROWS_EXAMINED
CREATED_TMP_DISK_TABLES
CREATED_TMP_TABLES
SELECT_FULL_JOIN
SELECT_FULL_RANGE_JOIN
SELECT_RANGE
SELECT_RANGE_CHECK
SELECT_SCAN
SORT_MERGE_PASSES
SORT_RANGE
SORT_ROWS
SORT_SCAN
NO_INDEX_USED
NO_GOOD_INDEX_USED
NESTING_EVENT_ID
NESTING_EVENT_TYPE
NESTING_EVENT_LEVEL
STATEMENT_ID
*
USER
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
SCHEMA_NAME
DIGEST
DIGEST_TEXT
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
FIRST_SEEN
LAST_SEEN
QUANTILE_95
QUANTILE_99
QUANTILE_999
QUERY_SAMPLE_TEXT
QUERY_SAMPLE_SEEN
QUERY_SAMPLE_TIMER_WAIT
*
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_STATEMENTS
SUM_STATEMENTS_WAIT
MIN_STATEMENTS_WAIT
AVG_STATEMENTS_WAIT
MAX_STATEMENTS_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
THREAD_ID
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
USER
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
STATE
TRX_ID
GTID
XID_FORMAT_ID
XID_GTRID
XID_BQUAL
XA_STATE
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
ACCESS_MODE
ISOLATION_LEVEL
AUTOCOMMIT
NUMBER_OF_SAVEPOINTS
NUMBER_OF_ROLLBACK_TO_SAVEPOINT
NUMBER_OF_RELEASE_SAVEPOINT
OBJECT_INSTANCE_BEGIN
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
STATE
TRX_ID
GTID
XID_FORMAT_ID
XID_GTRID
XID_BQUAL
XA_STATE
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
ACCESS_MODE
ISOLATION_LEVEL
AUTOCOMMIT
NUMBER_OF_SAVEPOINTS
NUMBER_OF_ROLLBACK_TO_SAVEPOINT
NUMBER_OF_RELEASE_SAVEPOINT
OBJECT_INSTANCE_BEGIN
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
STATE
TRX_ID
GTID
XID_FORMAT_ID
XID_GTRID
XID_BQUAL
XA_STATE
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
ACCESS_MODE
ISOLATION_LEVEL
AUTOCOMMIT
NUMBER_OF_SAVEPOINTS
NUMBER_OF_ROLLBACK_TO_SAVEPOINT
NUMBER_OF_RELEASE_SAVEPOINT
OBJECT_INSTANCE_BEGIN
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
USER
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ_WRITE
SUM_TIMER_READ_WRITE
MIN_TIMER_READ_WRITE
AVG_TIMER_READ_WRITE
MAX_TIMER_READ_WRITE
COUNT_READ_ONLY
SUM_TIMER_READ_ONLY
MIN_TIMER_READ_ONLY
AVG_TIMER_READ_ONLY
MAX_TIMER_READ_ONLY
*
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ_WRITE
SUM_TIMER_READ_WRITE
MIN_TIMER_READ_WRITE
AVG_TIMER_READ_WRITE
MAX_TIMER_READ_WRITE
COUNT_READ_ONLY
SUM_TIMER_READ_ONLY
MIN_TIMER_READ_ONLY
AVG_TIMER_READ_ONLY
MAX_TIMER_READ_ONLY
*
THREAD_ID
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ_WRITE
SUM_TIMER_READ_WRITE
MIN_TIMER_READ_WRITE
AVG_TIMER_READ_WRITE
MAX_TIMER_READ_WRITE
COUNT_READ_ONLY
SUM_TIMER_READ_ONLY
MIN_TIMER_READ_ONLY
AVG_TIMER_READ_ONLY
MAX_TIMER_READ_ONLY
*
USER
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ_WRITE
SUM_TIMER_READ_WRITE
MIN_TIMER_READ_WRITE
AVG_TIMER_READ_WRITE
MAX_TIMER_READ_WRITE
COUNT_READ_ONLY
SUM_TIMER_READ_ONLY
MIN_TIMER_READ_ONLY
AVG_TIMER_READ_ONLY
MAX_TIMER_READ_ONLY
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ_WRITE
SUM_TIMER_READ_WRITE
MIN_TIMER_READ_WRITE
AVG_TIMER_READ_WRITE
MAX_TIMER_READ_WRITE
COUNT_READ_ONLY
SUM_TIMER_READ_ONLY
MIN_TIMER_READ_ONLY
AVG_TIMER_READ_ONLY
MAX_TIMER_READ_ONLY
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
SPINS
OBJECT_SCHEMA
OBJECT_NAME
INDEX_NAME
OBJECT_TYPE
OBJECT_INSTANCE_BEGIN
NESTING_EVENT_ID
NESTING_EVENT_TYPE
OPERATION
NUMBER_OF_BYTES
FLAGS
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
SPINS
OBJECT_SCHEMA
OBJECT_NAME
INDEX_NAME
OBJECT_TYPE
OBJECT_INSTANCE_BEGIN
NESTING_EVENT_ID
NESTING_EVENT_TYPE
OPERATION
NUMBER_OF_BYTES
FLAGS
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
SPINS
OBJECT_SCHEMA
OBJECT_NAME
INDEX_NAME
OBJECT_TYPE
OBJECT_INSTANCE_BEGIN
NESTING_EVENT_ID
NESTING_EVENT_TYPE
OPERATION
NUMBER_OF_BYTES
FLAGS
*
USER
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
HOST
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
EVENT_NAME
OBJECT_INSTANCE_BEGIN
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
THREAD_ID
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
USER
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
FILE_NAME
EVENT_NAME
OPEN_COUNT
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
SUM_NUMBER_OF_BYTES_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
SUM_NUMBER_OF_BYTES_WRITE
COUNT_MISC
SUM_TIMER_MISC
MIN_TIMER_MISC
AVG_TIMER_MISC
MAX_TIMER_MISC
*
FILE_NAME
EVENT_NAME
OBJECT_INSTANCE_BEGIN
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
SUM_NUMBER_OF_BYTES_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
SUM_NUMBER_OF_BYTES_WRITE
COUNT_MISC
SUM_TIMER_MISC
MIN_TIMER_MISC
AVG_TIMER_MISC
MAX_TIMER_MISC
*
VARIABLE_NAME
VARIABLE_VALUE
*
VARIABLE_NAME
VARIABLE_VALUE
*
IP
HOST
HOST_VALIDATED
SUM_CONNECT_ERRORS
COUNT_HOST_BLOCKED_ERRORS
COUNT_NAMEINFO_TRANSIENT_ERRORS
COUNT_NAMEINFO_PERMANENT_ERRORS
COUNT_FORMAT_ERRORS
COUNT_ADDRINFO_TRANSIENT_ERRORS
COUNT_ADDRINFO_PERMANENT_ERRORS
COUNT_FCRDNS_ERRORS
COUNT_HOST_ACL_ERRORS
COUNT_NO_AUTH_PLUGIN_ERRORS
COUNT_AUTH_PLUGIN_ERRORS
COUNT_HANDSHAKE_ERRORS
COUNT_PROXY_USER_ERRORS
COUNT_PROXY_USER_ACL_ERRORS
COUNT_AUTHENTICATION_ERRORS
COUNT_SSL_ERRORS
COUNT_MAX_USER_CONNECTIONS_ERRORS
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS
COUNT_DEFAULT_DATABASE_ERRORS
COUNT_INIT_CONNECT_ERRORS
COUNT_LOCAL_ERRORS
COUNT_UNKNOWN_ERRORS
FIRST_SEEN
LAST_SEEN
FIRST_ERROR_SEEN
LAST_ERROR_SEEN
*
HOST
CURRENT_CONNECTIONS
TOTAL_CONNECTIONS
*
KEY_ID
KEY_OWNER
BACKEND_KEY_ID
*
SERVER_UUID
LOCAL
REPLICATION
STORAGE_ENGINES
*
USER
HOST
EVENT_NAME
COUNT_ALLOC
COUNT_FREE
SUM_NUMBER_OF_BYTES_ALLOC
SUM_NUMBER_OF_BYTES_FREE
LOW_COUNT_USED
CURRENT_COUNT_USED
HIGH_COUNT_USED
LOW_NUMBER_OF_BYTES_USED
CURRENT_NUMBER_OF_BYTES_USED
HIGH_NUMBER_OF_BYTES_USED
*
HOST
EVENT_NAME
COUNT_ALLOC
COUNT_FREE
SUM_NUMBER_OF_BYTES_ALLOC
SUM_NUMBER_OF_BYTES_FREE
LOW_COUNT_USED
CURRENT_COUNT_USED
HIGH_COUNT_USED
LOW_NUMBER_OF_BYTES_USED
CURRENT_NUMBER_OF_BYTES_USED
HIGH_NUMBER_OF_BYTES_USED
*
THREAD_ID
EVENT_NAME
COUNT_ALLOC
COUNT_FREE
SUM_NUMBER_OF_BYTES_ALLOC
SUM_NUMBER_OF_BYTES_FREE
LOW_COUNT_USED
CURRENT_COUNT_USED
HIGH_COUNT_USED
LOW_NUMBER_OF_BYTES_USED
CURRENT_NUMBER_OF_BYTES_USED
HIGH_NUMBER_OF_BYTES_USED
*
USER
EVENT_NAME
COUNT_ALLOC
COUNT_FREE
SUM_NUMBER_OF_BYTES_ALLOC
SUM_NUMBER_OF_BYTES_FREE
LOW_COUNT_USED
CURRENT_COUNT_USED
HIGH_COUNT_USED
LOW_NUMBER_OF_BYTES_USED
CURRENT_NUMBER_OF_BYTES_USED
HIGH_NUMBER_OF_BYTES_USED
*
EVENT_NAME
COUNT_ALLOC
COUNT_FREE
SUM_NUMBER_OF_BYTES_ALLOC
SUM_NUMBER_OF_BYTES_FREE
LOW_COUNT_USED
CURRENT_COUNT_USED
HIGH_COUNT_USED
LOW_NUMBER_OF_BYTES_USED
CURRENT_NUMBER_OF_BYTES_USED
HIGH_NUMBER_OF_BYTES_USED
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
COLUMN_NAME
OBJECT_INSTANCE_BEGIN
LOCK_TYPE
LOCK_DURATION
LOCK_STATUS
SOURCE
OWNER_THREAD_ID
OWNER_EVENT_ID
*
NAME
OBJECT_INSTANCE_BEGIN
LOCKED_BY_THREAD_ID
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
*
TIMER_NAME
TIMER_FREQUENCY
TIMER_RESOLUTION
TIMER_OVERHEAD
*
VARIABLE_NAME
VARIABLE_VALUE
*
OBJECT_INSTANCE_BEGIN
STATEMENT_ID
STATEMENT_NAME
SQL_TEXT
OWNER_THREAD_ID
OWNER_EVENT_ID
OWNER_OBJECT_TYPE
OWNER_OBJECT_SCHEMA
OWNER_OBJECT_NAME
TIMER_PREPARE
COUNT_REPREPARE
COUNT_EXECUTE
SUM_TIMER_EXECUTE
MIN_TIMER_EXECUTE
AVG_TIMER_EXECUTE
MAX_TIMER_EXECUTE
SUM_LOCK_TIME
SUM_ERRORS
SUM_WARNINGS
SUM_ROWS_AFFECTED
SUM_ROWS_SENT
SUM_ROWS_EXAMINED
SUM_CREATED_TMP_DISK_TABLES
SUM_CREATED_TMP_TABLES
SUM_SELECT_FULL_JOIN
SUM_SELECT_FULL_RANGE_JOIN
SUM_SELECT_RANGE
SUM_SELECT_RANGE_CHECK
SUM_SELECT_SCAN
SUM_SORT_MERGE_PASSES
SUM_SORT_RANGE
SUM_SORT_ROWS
SUM_SORT_SCAN
SUM_NO_INDEX_USED
SUM_NO_GOOD_INDEX_USED
*
CHANNEL_NAME
DESIRED_DELAY
PRIVILEGE_CHECKS_USER
*
CHANNEL_NAME
FILTER_NAME
FILTER_RULE
CONFIGURED_BY
ACTIVE_SINCE
COUNTER
*
FILTER_NAME
FILTER_RULE
CONFIGURED_BY
ACTIVE_SINCE
*
CHANNEL_NAME
SERVICE_STATE
REMAINING_DELAY
COUNT_TRANSACTIONS_RETRIES
*
CHANNEL_NAME
THREAD_ID
SERVICE_STATE
LAST_ERROR_NUMBER
LAST_ERROR_MESSAGE
LAST_ERROR_TIMESTAMP
LAST_PROCESSED_TRANSACTION
LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP
LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP
LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP
PROCESSING_TRANSACTION
PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP
PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP
*
CHANNEL_NAME
WORKER_ID
THREAD_ID
SERVICE_STATE
LAST_ERROR_NUMBER
LAST_ERROR_MESSAGE
LAST_ERROR_TIMESTAMP
LAST_APPLIED_TRANSACTION
LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP
LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP
LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP
APPLYING_TRANSACTION
APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP
APPLYING_TRANSACTION_START_APPLY_TIMESTAMP
LAST_APPLIED_TRANSACTION_RETRIES_COUNT
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP
APPLYING_TRANSACTION_RETRIES_COUNT
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP
*
CHANNEL_NAME
HOST
PORT
USER
NETWORK_INTERFACE
AUTO_POSITION
SSL_ALLOWED
SSL_CA_FILE
SSL_CA_PATH
SSL_CERTIFICATE
SSL_CIPHER
SSL_KEY
SSL_VERIFY_SERVER_CERTIFICATE
SSL_CRL_FILE
SSL_CRL_PATH
CONNECTION_RETRY_INTERVAL
CONNECTION_RETRY_COUNT
HEARTBEAT_INTERVAL
TLS_VERSION
PUBLIC_KEY_PATH
GET_PUBLIC_KEY
NETWORK_NAMESPACE
COMPRESSION_ALGORITHM
ZSTD_COMPRESSION_LEVEL
*
CHANNEL_NAME
GROUP_NAME
SOURCE_UUID
THREAD_ID
SERVICE_STATE
COUNT_RECEIVED_HEARTBEATS
LAST_HEARTBEAT_TIMESTAMP
RECEIVED_TRANSACTION_SET
LAST_ERROR_NUMBER
LAST_ERROR_MESSAGE
LAST_ERROR_TIMESTAMP
LAST_QUEUED_TRANSACTION
LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP
LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP
LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP
QUEUEING_TRANSACTION
QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP
QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP
QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP
*
CHANNEL_NAME
VIEW_ID
MEMBER_ID
COUNT_TRANSACTIONS_IN_QUEUE
COUNT_TRANSACTIONS_CHECKED
COUNT_CONFLICTS_DETECTED
COUNT_TRANSACTIONS_ROWS_VALIDATING
TRANSACTIONS_COMMITTED_ALL_MEMBERS
LAST_CONFLICT_FREE_TRANSACTION
COUNT_TRANSACTIONS_REMOTE_IN_APPLIER_QUEUE
COUNT_TRANSACTIONS_REMOTE_APPLIED
COUNT_TRANSACTIONS_LOCAL_PROPOSED
COUNT_TRANSACTIONS_LOCAL_ROLLBACK
*
CHANNEL_NAME
MEMBER_ID
MEMBER_HOST
MEMBER_PORT
MEMBER_STATE
MEMBER_ROLE
MEMBER_VERSION
*
NAME
OBJECT_INSTANCE_BEGIN
WRITE_LOCKED_BY_THREAD_ID
READ_LOCKED_BY_COUNT
*
PROCESSLIST_ID
ATTR_NAME
ATTR_VALUE
ORDINAL_POSITION
*
PROCESSLIST_ID
ATTR_NAME
ATTR_VALUE
ORDINAL_POSITION
*
VARIABLE_NAME
VARIABLE_VALUE
*
VARIABLE_NAME
VARIABLE_VALUE
*
HOST
USER
ROLE
ENABLED
HISTORY
*
NAME
ENABLED
*
NAME
ENABLED
TIMED
PROPERTIES
VOLATILITY
DOCUMENTATION
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
ENABLED
TIMED
*
NAME
ENABLED
HISTORY
PROPERTIES
VOLATILITY
DOCUMENTATION
*
EVENT_NAME
OBJECT_INSTANCE_BEGIN
THREAD_ID
SOCKET_ID
IP
PORT
STATE
*
EVENT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
SUM_NUMBER_OF_BYTES_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
SUM_NUMBER_OF_BYTES_WRITE
COUNT_MISC
SUM_TIMER_MISC
MIN_TIMER_MISC
AVG_TIMER_MISC
MAX_TIMER_MISC
*
EVENT_NAME
OBJECT_INSTANCE_BEGIN
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
SUM_NUMBER_OF_BYTES_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
SUM_NUMBER_OF_BYTES_WRITE
COUNT_MISC
SUM_TIMER_MISC
MIN_TIMER_MISC
AVG_TIMER_MISC
MAX_TIMER_MISC
*
USER
HOST
VARIABLE_NAME
VARIABLE_VALUE
*
HOST
VARIABLE_NAME
VARIABLE_VALUE
*
THREAD_ID
VARIABLE_NAME
VARIABLE_VALUE
*
USER
VARIABLE_NAME
VARIABLE_VALUE
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_INSTANCE_BEGIN
OWNER_THREAD_ID
OWNER_EVENT_ID
INTERNAL_LOCK
EXTERNAL_LOCK
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
INDEX_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
COUNT_FETCH
SUM_TIMER_FETCH
MIN_TIMER_FETCH
AVG_TIMER_FETCH
MAX_TIMER_FETCH
COUNT_INSERT
SUM_TIMER_INSERT
MIN_TIMER_INSERT
AVG_TIMER_INSERT
MAX_TIMER_INSERT
COUNT_UPDATE
SUM_TIMER_UPDATE
MIN_TIMER_UPDATE
AVG_TIMER_UPDATE
MAX_TIMER_UPDATE
COUNT_DELETE
SUM_TIMER_DELETE
MIN_TIMER_DELETE
AVG_TIMER_DELETE
MAX_TIMER_DELETE
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
COUNT_FETCH
SUM_TIMER_FETCH
MIN_TIMER_FETCH
AVG_TIMER_FETCH
MAX_TIMER_FETCH
COUNT_INSERT
SUM_TIMER_INSERT
MIN_TIMER_INSERT
AVG_TIMER_INSERT
MAX_TIMER_INSERT
COUNT_UPDATE
SUM_TIMER_UPDATE
MIN_TIMER_UPDATE
AVG_TIMER_UPDATE
MAX_TIMER_UPDATE
COUNT_DELETE
SUM_TIMER_DELETE
MIN_TIMER_DELETE
AVG_TIMER_DELETE
MAX_TIMER_DELETE
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
COUNT_STAR
SUM_TIMER_WAIT
MIN_TIMER_WAIT
AVG_TIMER_WAIT
MAX_TIMER_WAIT
COUNT_READ
SUM_TIMER_READ
MIN_TIMER_READ
AVG_TIMER_READ
MAX_TIMER_READ
COUNT_WRITE
SUM_TIMER_WRITE
MIN_TIMER_WRITE
AVG_TIMER_WRITE
MAX_TIMER_WRITE
COUNT_READ_NORMAL
SUM_TIMER_READ_NORMAL
MIN_TIMER_READ_NORMAL
AVG_TIMER_READ_NORMAL
MAX_TIMER_READ_NORMAL
COUNT_READ_WITH_SHARED_LOCKS
SUM_TIMER_READ_WITH_SHARED_LOCKS
MIN_TIMER_READ_WITH_SHARED_LOCKS
AVG_TIMER_READ_WITH_SHARED_LOCKS
MAX_TIMER_READ_WITH_SHARED_LOCKS
COUNT_READ_HIGH_PRIORITY
SUM_TIMER_READ_HIGH_PRIORITY
MIN_TIMER_READ_HIGH_PRIORITY
AVG_TIMER_READ_HIGH_PRIORITY
MAX_TIMER_READ_HIGH_PRIORITY
COUNT_READ_NO_INSERT
SUM_TIMER_READ_NO_INSERT
MIN_TIMER_READ_NO_INSERT
AVG_TIMER_READ_NO_INSERT
MAX_TIMER_READ_NO_INSERT
COUNT_READ_EXTERNAL
SUM_TIMER_READ_EXTERNAL
MIN_TIMER_READ_EXTERNAL
AVG_TIMER_READ_EXTERNAL
MAX_TIMER_READ_EXTERNAL
COUNT_WRITE_ALLOW_WRITE
SUM_TIMER_WRITE_ALLOW_WRITE
MIN_TIMER_WRITE_ALLOW_WRITE
AVG_TIMER_WRITE_ALLOW_WRITE
MAX_TIMER_WRITE_ALLOW_WRITE
COUNT_WRITE_CONCURRENT_INSERT
SUM_TIMER_WRITE_CONCURRENT_INSERT
MIN_TIMER_WRITE_CONCURRENT_INSERT
AVG_TIMER_WRITE_CONCURRENT_INSERT
MAX_TIMER_WRITE_CONCURRENT_INSERT
COUNT_WRITE_LOW_PRIORITY
SUM_TIMER_WRITE_LOW_PRIORITY
MIN_TIMER_WRITE_LOW_PRIORITY
AVG_TIMER_WRITE_LOW_PRIORITY
MAX_TIMER_WRITE_LOW_PRIORITY
COUNT_WRITE_NORMAL
SUM_TIMER_WRITE_NORMAL
MIN_TIMER_WRITE_NORMAL
AVG_TIMER_WRITE_NORMAL
MAX_TIMER_WRITE_NORMAL
COUNT_WRITE_EXTERNAL
SUM_TIMER_WRITE_EXTERNAL
MIN_TIMER_WRITE_EXTERNAL
AVG_TIMER_WRITE_EXTERNAL
MAX_TIMER_WRITE_EXTERNAL
*
THREAD_ID
NAME
TYPE
PROCESSLIST_ID
PROCESSLIST_USER
PROCESSLIST_HOST
PROCESSLIST_DB
PROCESSLIST_COMMAND
PROCESSLIST_TIME
PROCESSLIST_STATE
PROCESSLIST_INFO
PARENT_THREAD_ID
ROLE
INSTRUMENTED
HISTORY
CONNECTION_TYPE
THREAD_OS_ID
RESOURCE_GROUP
*
UDF_NAME
UDF_RETURN_TYPE
UDF_TYPE
UDF_LIBRARY
UDF_USAGE_COUNT
*
THREAD_ID
VARIABLE_NAME
VARIABLE_VALUE
*
USER
CURRENT_CONNECTIONS
TOTAL_CONNECTIONS
*
THREAD_ID
VARIABLE_NAME
VARIABLE_VALUE
*
VARIABLE_NAME
VARIABLE_SOURCE
VARIABLE_PATH
MIN_VALUE
MAX_VALUE
SET_TIME
SET_USER
SET_HOST
選擇資料表
accounts
cond_instances
data_lock_waits
data_locks
events_errors_summary_by_account_by_error
events_errors_summary_by_host_by_error
events_errors_summary_by_thread_by_error
events_errors_summary_by_user_by_error
events_errors_summary_global_by_error
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_histogram_by_digest
events_statements_histogram_global
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_program
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_transactions_current
events_transactions_history
events_transactions_history_long
events_transactions_summary_by_account_by_event_name
events_transactions_summary_by_host_by_event_name
events_transactions_summary_by_thread_by_event_name
events_transactions_summary_by_user_by_event_name
events_transactions_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
global_status
global_variables
host_cache
hosts
keyring_keys
log_status
memory_summary_by_account_by_event_name
memory_summary_by_host_by_event_name
memory_summary_by_thread_by_event_name
memory_summary_by_user_by_event_name
memory_summary_global_by_event_name
metadata_locks
mutex_instances
objects_summary_global_by_type
performance_timers
persisted_variables
prepared_statements_instances
replication_applier_configuration
replication_applier_filters
replication_applier_global_filters
replication_applier_status
replication_applier_status_by_coordinator
replication_applier_status_by_worker
replication_connection_configuration
replication_connection_status
replication_group_member_stats
replication_group_members
rwlock_instances
session_account_connect_attrs
session_connect_attrs
session_status
session_variables
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_threads
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
status_by_account
status_by_host
status_by_thread
status_by_user
table_handles
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
user_defined_functions
user_variables_by_thread
users
variables_by_thread
variables_info
.
選擇欄位
顯示
準則
排序
遞增
遞減
加入為
AND
OR
Column
選擇欄位
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一個欄位
選擇資料表
accounts
cond_instances
data_lock_waits
data_locks
events_errors_summary_by_account_by_error
events_errors_summary_by_host_by_error
events_errors_summary_by_thread_by_error
events_errors_summary_by_user_by_error
events_errors_summary_global_by_error
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_histogram_by_digest
events_statements_histogram_global
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_program
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_transactions_current
events_transactions_history
events_transactions_history_long
events_transactions_summary_by_account_by_event_name
events_transactions_summary_by_host_by_event_name
events_transactions_summary_by_thread_by_event_name
events_transactions_summary_by_user_by_event_name
events_transactions_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
global_status
global_variables
host_cache
hosts
keyring_keys
log_status
memory_summary_by_account_by_event_name
memory_summary_by_host_by_event_name
memory_summary_by_thread_by_event_name
memory_summary_by_user_by_event_name
memory_summary_global_by_event_name
metadata_locks
mutex_instances
objects_summary_global_by_type
performance_timers
persisted_variables
prepared_statements_instances
replication_applier_configuration
replication_applier_filters
replication_applier_global_filters
replication_applier_status
replication_applier_status_by_coordinator
replication_applier_status_by_worker
replication_connection_configuration
replication_connection_status
replication_group_member_stats
replication_group_members
rwlock_instances
session_account_connect_attrs
session_connect_attrs
session_status
session_variables
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_threads
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
status_by_account
status_by_host
status_by_thread
status_by_user
table_handles
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
user_defined_functions
user_variables_by_thread
users
variables_by_thread
variables_info
.
選擇欄位
選擇資料表
accounts
cond_instances
data_lock_waits
data_locks
events_errors_summary_by_account_by_error
events_errors_summary_by_host_by_error
events_errors_summary_by_thread_by_error
events_errors_summary_by_user_by_error
events_errors_summary_global_by_error
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_histogram_by_digest
events_statements_histogram_global
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_program
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_transactions_current
events_transactions_history
events_transactions_history_long
events_transactions_summary_by_account_by_event_name
events_transactions_summary_by_host_by_event_name
events_transactions_summary_by_thread_by_event_name
events_transactions_summary_by_user_by_event_name
events_transactions_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
global_status
global_variables
host_cache
hosts
keyring_keys
log_status
memory_summary_by_account_by_event_name
memory_summary_by_host_by_event_name
memory_summary_by_thread_by_event_name
memory_summary_by_user_by_event_name
memory_summary_global_by_event_name
metadata_locks
mutex_instances
objects_summary_global_by_type
performance_timers
persisted_variables
prepared_statements_instances
replication_applier_configuration
replication_applier_filters
replication_applier_global_filters
replication_applier_status
replication_applier_status_by_coordinator
replication_applier_status_by_worker
replication_connection_configuration
replication_connection_status
replication_group_member_stats
replication_group_members
rwlock_instances
session_account_connect_attrs
session_connect_attrs
session_status
session_variables
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_threads
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
status_by_account
status_by_host
status_by_thread
status_by_user
table_handles
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
user_defined_functions
user_variables_by_thread
users
variables_by_thread
variables_info
.
選擇欄位
顯示
準則
排序
遞增
遞減
加入為
AND
OR
Column
選擇欄位
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一個欄位
選擇資料表
accounts
cond_instances
data_lock_waits
data_locks
events_errors_summary_by_account_by_error
events_errors_summary_by_host_by_error
events_errors_summary_by_thread_by_error
events_errors_summary_by_user_by_error
events_errors_summary_global_by_error
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_histogram_by_digest
events_statements_histogram_global
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_program
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_transactions_current
events_transactions_history
events_transactions_history_long
events_transactions_summary_by_account_by_event_name
events_transactions_summary_by_host_by_event_name
events_transactions_summary_by_thread_by_event_name
events_transactions_summary_by_user_by_event_name
events_transactions_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
global_status
global_variables
host_cache
hosts
keyring_keys
log_status
memory_summary_by_account_by_event_name
memory_summary_by_host_by_event_name
memory_summary_by_thread_by_event_name
memory_summary_by_user_by_event_name
memory_summary_global_by_event_name
metadata_locks
mutex_instances
objects_summary_global_by_type
performance_timers
persisted_variables
prepared_statements_instances
replication_applier_configuration
replication_applier_filters
replication_applier_global_filters
replication_applier_status
replication_applier_status_by_coordinator
replication_applier_status_by_worker
replication_connection_configuration
replication_connection_status
replication_group_member_stats
replication_group_members
rwlock_instances
session_account_connect_attrs
session_connect_attrs
session_status
session_variables
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_threads
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
status_by_account
status_by_host
status_by_thread
status_by_user
table_handles
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
user_defined_functions
user_variables_by_thread
users
variables_by_thread
variables_info
.
選擇欄位
選擇資料表
accounts
cond_instances
data_lock_waits
data_locks
events_errors_summary_by_account_by_error
events_errors_summary_by_host_by_error
events_errors_summary_by_thread_by_error
events_errors_summary_by_user_by_error
events_errors_summary_global_by_error
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_histogram_by_digest
events_statements_histogram_global
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_program
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_transactions_current
events_transactions_history
events_transactions_history_long
events_transactions_summary_by_account_by_event_name
events_transactions_summary_by_host_by_event_name
events_transactions_summary_by_thread_by_event_name
events_transactions_summary_by_user_by_event_name
events_transactions_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
global_status
global_variables
host_cache
hosts
keyring_keys
log_status
memory_summary_by_account_by_event_name
memory_summary_by_host_by_event_name
memory_summary_by_thread_by_event_name
memory_summary_by_user_by_event_name
memory_summary_global_by_event_name
metadata_locks
mutex_instances
objects_summary_global_by_type
performance_timers
persisted_variables
prepared_statements_instances
replication_applier_configuration
replication_applier_filters
replication_applier_global_filters
replication_applier_status
replication_applier_status_by_coordinator
replication_applier_status_by_worker
replication_connection_configuration
replication_connection_status
replication_group_member_stats
replication_group_members
rwlock_instances
session_account_connect_attrs
session_connect_attrs
session_status
session_variables
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_threads
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
status_by_account
status_by_host
status_by_thread
status_by_user
table_handles
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
user_defined_functions
user_variables_by_thread
users
variables_by_thread
variables_info
.
選擇欄位
顯示
準則
排序
遞增
遞減
加入為
AND
OR
Column
選擇欄位
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一個欄位
選擇資料表
accounts
cond_instances
data_lock_waits
data_locks
events_errors_summary_by_account_by_error
events_errors_summary_by_host_by_error
events_errors_summary_by_thread_by_error
events_errors_summary_by_user_by_error
events_errors_summary_global_by_error
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_histogram_by_digest
events_statements_histogram_global
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_program
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_transactions_current
events_transactions_history
events_transactions_history_long
events_transactions_summary_by_account_by_event_name
events_transactions_summary_by_host_by_event_name
events_transactions_summary_by_thread_by_event_name
events_transactions_summary_by_user_by_event_name
events_transactions_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
global_status
global_variables
host_cache
hosts
keyring_keys
log_status
memory_summary_by_account_by_event_name
memory_summary_by_host_by_event_name
memory_summary_by_thread_by_event_name
memory_summary_by_user_by_event_name
memory_summary_global_by_event_name
metadata_locks
mutex_instances
objects_summary_global_by_type
performance_timers
persisted_variables
prepared_statements_instances
replication_applier_configuration
replication_applier_filters
replication_applier_global_filters
replication_applier_status
replication_applier_status_by_coordinator
replication_applier_status_by_worker
replication_connection_configuration
replication_connection_status
replication_group_member_stats
replication_group_members
rwlock_instances
session_account_connect_attrs
session_connect_attrs
session_status
session_variables
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_threads
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
status_by_account
status_by_host
status_by_thread
status_by_user
table_handles
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
user_defined_functions
user_variables_by_thread
users
variables_by_thread
variables_info
.
選擇欄位
選擇資料表
accounts
cond_instances
data_lock_waits
data_locks
events_errors_summary_by_account_by_error
events_errors_summary_by_host_by_error
events_errors_summary_by_thread_by_error
events_errors_summary_by_user_by_error
events_errors_summary_global_by_error
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_histogram_by_digest
events_statements_histogram_global
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_program
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_transactions_current
events_transactions_history
events_transactions_history_long
events_transactions_summary_by_account_by_event_name
events_transactions_summary_by_host_by_event_name
events_transactions_summary_by_thread_by_event_name
events_transactions_summary_by_user_by_event_name
events_transactions_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
global_status
global_variables
host_cache
hosts
keyring_keys
log_status
memory_summary_by_account_by_event_name
memory_summary_by_host_by_event_name
memory_summary_by_thread_by_event_name
memory_summary_by_user_by_event_name
memory_summary_global_by_event_name
metadata_locks
mutex_instances
objects_summary_global_by_type
performance_timers
persisted_variables
prepared_statements_instances
replication_applier_configuration
replication_applier_filters
replication_applier_global_filters
replication_applier_status
replication_applier_status_by_coordinator
replication_applier_status_by_worker
replication_connection_configuration
replication_connection_status
replication_group_member_stats
replication_group_members
rwlock_instances
session_account_connect_attrs
session_connect_attrs
session_status
session_variables
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_threads
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
status_by_account
status_by_host
status_by_thread
status_by_user
table_handles
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
user_defined_functions
user_variables_by_thread
users
variables_by_thread
variables_info
.
選擇欄位
顯示
準則
排序
遞增
遞減
加入為
AND
OR
Column
選擇欄位
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一個欄位
選擇資料表
accounts
cond_instances
data_lock_waits
data_locks
events_errors_summary_by_account_by_error
events_errors_summary_by_host_by_error
events_errors_summary_by_thread_by_error
events_errors_summary_by_user_by_error
events_errors_summary_global_by_error
events_stages_current
events_stages_history
events_stages_history_long
events_stages_summary_by_account_by_event_name
events_stages_summary_by_host_by_event_name
events_stages_summary_by_thread_by_event_name
events_stages_summary_by_user_by_event_name
events_stages_summary_global_by_event_name
events_statements_current
events_statements_histogram_by_digest
events_statements_histogram_global
events_statements_history
events_statements_history_long
events_statements_summary_by_account_by_event_name
events_statements_summary_by_digest
events_statements_summary_by_host_by_event_name
events_statements_summary_by_program
events_statements_summary_by_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_summary_global_by_event_name
events_transactions_current
events_transactions_history
events_transactions_history_long
events_transactions_summary_by_account_by_event_name
events_transactions_summary_by_host_by_event_name
events_transactions_summary_by_thread_by_event_name
events_transactions_summary_by_user_by_event_name
events_transactions_summary_global_by_event_name
events_waits_current
events_waits_history
events_waits_history_long
events_waits_summary_by_account_by_event_name
events_waits_summary_by_host_by_event_name
events_waits_summary_by_instance
events_waits_summary_by_thread_by_event_name
events_waits_summary_by_user_by_event_name
events_waits_summary_global_by_event_name
file_instances
file_summary_by_event_name
file_summary_by_instance
global_status
global_variables
host_cache
hosts
keyring_keys
log_status
memory_summary_by_account_by_event_name
memory_summary_by_host_by_event_name
memory_summary_by_thread_by_event_name
memory_summary_by_user_by_event_name
memory_summary_global_by_event_name
metadata_locks
mutex_instances
objects_summary_global_by_type
performance_timers
persisted_variables
prepared_statements_instances
replication_applier_configuration
replication_applier_filters
replication_applier_global_filters
replication_applier_status
replication_applier_status_by_coordinator
replication_applier_status_by_worker
replication_connection_configuration
replication_connection_status
replication_group_member_stats
replication_group_members
rwlock_instances
session_account_connect_attrs
session_connect_attrs
session_status
session_variables
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_threads
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
status_by_account
status_by_host
status_by_thread
status_by_user
table_handles
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
user_defined_functions
user_variables_by_thread
users
variables_by_thread
variables_info
.
選擇欄位
phpMyAdmin 演示伺服器:
目前正在運行 Git
master
的分支版本
RELEASE_5_2_1-4907-g5b04607256
。