近期访问
`smartschool111`.`general_calls`
`smartschool111`.`exam_schedules`
`smartschool111`.`fee_session_groups`
`performance_schema`.`events_statements_history_long`
`smartschool111`.`front_cms_program_photos`
`smartschool111`.`item_store`
`smartschool111`.`events`
`smartschool111`.`books`
`smartschool111`.`classes`
`smartschool111`.`enquiry`
表收藏夹
`smartschool222`.`feemasters`
`smartschool222`.`front_cms_media_gallery`
`smartschool222`.`front_cms_page_contents`
`smartschool222`.`front_cms_program_photos`
新建
cm9vdA==.YWJj
cm9vdA==.YWJj
0
abc
cm9vdA==.YWJjc2Nob29sMg==
cm9vdA==.YWJjc2Nob29sMg==
0
abcschool2
cm9vdA==.YWJjc2Nob29sMzM=
cm9vdA==.YWJjc2Nob29sMzM=
0
abcschool33
cm9vdA==.YWJjc2Nob29sMzMz
cm9vdA==.YWJjc2Nob29sMzMz
0
abcschool333
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==
cm9vdA==.cGhwbXlhZG1pbg==
0
phpmyadmin
cm9vdA==.c21hcnRzY2hvb2w=
cm9vdA==.c21hcnRzY2hvb2w=
0
smartschool
cm9vdA==.c21hcnRzY2hvb2wx
cm9vdA==.c21hcnRzY2hvb2wx
0
smartschool1
cm9vdA==.c21hcnRzY2hvb2wz
cm9vdA==.c21hcnRzY2hvb2wz
0
smartschool3
cm9vdA==.c21hcnRzY2hvb2wxMTE=
cm9vdA==.c21hcnRzY2hvb2wxMTE=
0
smartschool111
cm9vdA==.c21hcnRzY2hvb2wyMjI=
cm9vdA==.c21hcnRzY2hvb2wyMjI=
0
smartschool222
cm9vdA==.dGVzdA==
cm9vdA==.dGVzdA==
0
test
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
该处必须启用 Javascript!
服务器: 127.0.0.1
»
数据库: performance_schema
结构
SQL
搜索
查询
导出
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
多表查询
通过示例查询
*
USER
HOST
CURRENT_CONNECTIONS
TOTAL_CONNECTIONS
*
NAME
OBJECT_INSTANCE_BEGIN
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
NESTING_EVENT_ID
NESTING_EVENT_TYPE
*
THREAD_ID
EVENT_ID
END_EVENT_ID
EVENT_NAME
SOURCE
TIMER_START
TIMER_END
TIMER_WAIT
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
*
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
*
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
*
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
*
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
*
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
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
*
HOST
CURRENT_CONNECTIONS
TOTAL_CONNECTIONS
*
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
*
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
*
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
*
HOST
USER
ROLE
*
NAME
ENABLED
*
NAME
ENABLED
TIMED
*
OBJECT_TYPE
OBJECT_SCHEMA
OBJECT_NAME
ENABLED
TIMED
*
NAME
TIMER_NAME
*
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
*
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_DELAYED
SUM_TIMER_WRITE_DELAYED
MIN_TIMER_WRITE_DELAYED
AVG_TIMER_WRITE_DELAYED
MAX_TIMER_WRITE_DELAYED
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
*
USER
CURRENT_CONNECTIONS
TOTAL_CONNECTIONS
选择表
accounts
cond_instances
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_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_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_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
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
accounts
cond_instances
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_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_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_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
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
选择字段
X
选择表
accounts
cond_instances
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_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_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_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
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
accounts
cond_instances
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_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_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_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
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
选择字段
X
选择表
accounts
cond_instances
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_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_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_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
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
accounts
cond_instances
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_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_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_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
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
选择字段
X
选择表
accounts
cond_instances
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_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_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_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
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
accounts
cond_instances
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_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_thread_by_event_name
events_statements_summary_by_user_by_event_name
events_statements_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
hosts
host_cache
mutex_instances
objects_summary_global_by_type
performance_timers
rwlock_instances
session_account_connect_attrs
session_connect_attrs
setup_actors
setup_consumers
setup_instruments
setup_objects
setup_timers
socket_instances
socket_summary_by_event_name
socket_summary_by_instance
table_io_waits_summary_by_index_usage
table_io_waits_summary_by_table
table_lock_waits_summary_by_table
threads
users
.
选择字段
X