accounts

字段类型默认 链接到 注释 MIME
USERchar(16)NULL
HOSTchar(60)NULL
CURRENT_CONNECTIONSbigint(20)
TOTAL_CONNECTIONSbigint(20)

cond_instances

字段类型默认 链接到 注释 MIME
NAMEvarchar(128)
OBJECT_INSTANCE_BEGINbigint(20)

events_stages_current

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_IDbigint(20)
END_EVENT_IDbigint(20)NULL
EVENT_NAMEvarchar(128)
SOURCEvarchar(64)NULL
TIMER_STARTbigint(20)NULL
TIMER_ENDbigint(20)NULL
TIMER_WAITbigint(20)NULL
NESTING_EVENT_IDbigint(20)NULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')NULL

events_stages_history

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_IDbigint(20)
END_EVENT_IDbigint(20)NULL
EVENT_NAMEvarchar(128)
SOURCEvarchar(64)NULL
TIMER_STARTbigint(20)NULL
TIMER_ENDbigint(20)NULL
TIMER_WAITbigint(20)NULL
NESTING_EVENT_IDbigint(20)NULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')NULL

events_stages_history_long

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_IDbigint(20)
END_EVENT_IDbigint(20)NULL
EVENT_NAMEvarchar(128)
SOURCEvarchar(64)NULL
TIMER_STARTbigint(20)NULL
TIMER_ENDbigint(20)NULL
TIMER_WAITbigint(20)NULL
NESTING_EVENT_IDbigint(20)NULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')NULL

events_stages_summary_by_account_by_event_name

字段类型默认 链接到 注释 MIME
USERchar(16)NULL
HOSTchar(60)NULL
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_stages_summary_by_host_by_event_name

字段类型默认 链接到 注释 MIME
HOSTchar(60)NULL
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_stages_summary_by_thread_by_event_name

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_stages_summary_by_user_by_event_name

字段类型默认 链接到 注释 MIME
USERchar(16)NULL
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_stages_summary_global_by_event_name

字段类型默认 链接到 注释 MIME
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_statements_current

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_IDbigint(20)
END_EVENT_IDbigint(20)NULL
EVENT_NAMEvarchar(128)
SOURCEvarchar(64)NULL
TIMER_STARTbigint(20)NULL
TIMER_ENDbigint(20)NULL
TIMER_WAITbigint(20)NULL
LOCK_TIMEbigint(20)
SQL_TEXTlongtextNULL
DIGESTvarchar(32)NULL
DIGEST_TEXTlongtextNULL
CURRENT_SCHEMAvarchar(64)NULL
OBJECT_TYPEvarchar(64)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(64)NULL
OBJECT_INSTANCE_BEGINbigint(20)NULL
MYSQL_ERRNOint(11)NULL
RETURNED_SQLSTATEvarchar(5)NULL
MESSAGE_TEXTvarchar(128)NULL
ERRORSbigint(20)
WARNINGSbigint(20)
ROWS_AFFECTEDbigint(20)
ROWS_SENTbigint(20)
ROWS_EXAMINEDbigint(20)
CREATED_TMP_DISK_TABLESbigint(20)
CREATED_TMP_TABLESbigint(20)
SELECT_FULL_JOINbigint(20)
SELECT_FULL_RANGE_JOINbigint(20)
SELECT_RANGEbigint(20)
SELECT_RANGE_CHECKbigint(20)
SELECT_SCANbigint(20)
SORT_MERGE_PASSESbigint(20)
SORT_RANGEbigint(20)
SORT_ROWSbigint(20)
SORT_SCANbigint(20)
NO_INDEX_USEDbigint(20)
NO_GOOD_INDEX_USEDbigint(20)
NESTING_EVENT_IDbigint(20)NULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')NULL

events_statements_history

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_IDbigint(20)
END_EVENT_IDbigint(20)NULL
EVENT_NAMEvarchar(128)
SOURCEvarchar(64)NULL
TIMER_STARTbigint(20)NULL
TIMER_ENDbigint(20)NULL
TIMER_WAITbigint(20)NULL
LOCK_TIMEbigint(20)
SQL_TEXTlongtextNULL
DIGESTvarchar(32)NULL
DIGEST_TEXTlongtextNULL
CURRENT_SCHEMAvarchar(64)NULL
OBJECT_TYPEvarchar(64)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(64)NULL
OBJECT_INSTANCE_BEGINbigint(20)NULL
MYSQL_ERRNOint(11)NULL
RETURNED_SQLSTATEvarchar(5)NULL
MESSAGE_TEXTvarchar(128)NULL
ERRORSbigint(20)
WARNINGSbigint(20)
ROWS_AFFECTEDbigint(20)
ROWS_SENTbigint(20)
ROWS_EXAMINEDbigint(20)
CREATED_TMP_DISK_TABLESbigint(20)
CREATED_TMP_TABLESbigint(20)
SELECT_FULL_JOINbigint(20)
SELECT_FULL_RANGE_JOINbigint(20)
SELECT_RANGEbigint(20)
SELECT_RANGE_CHECKbigint(20)
SELECT_SCANbigint(20)
SORT_MERGE_PASSESbigint(20)
SORT_RANGEbigint(20)
SORT_ROWSbigint(20)
SORT_SCANbigint(20)
NO_INDEX_USEDbigint(20)
NO_GOOD_INDEX_USEDbigint(20)
NESTING_EVENT_IDbigint(20)NULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')NULL

events_statements_history_long

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_IDbigint(20)
END_EVENT_IDbigint(20)NULL
EVENT_NAMEvarchar(128)
SOURCEvarchar(64)NULL
TIMER_STARTbigint(20)NULL
TIMER_ENDbigint(20)NULL
TIMER_WAITbigint(20)NULL
LOCK_TIMEbigint(20)
SQL_TEXTlongtextNULL
DIGESTvarchar(32)NULL
DIGEST_TEXTlongtextNULL
CURRENT_SCHEMAvarchar(64)NULL
OBJECT_TYPEvarchar(64)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(64)NULL
OBJECT_INSTANCE_BEGINbigint(20)NULL
MYSQL_ERRNOint(11)NULL
RETURNED_SQLSTATEvarchar(5)NULL
MESSAGE_TEXTvarchar(128)NULL
ERRORSbigint(20)
WARNINGSbigint(20)
ROWS_AFFECTEDbigint(20)
ROWS_SENTbigint(20)
ROWS_EXAMINEDbigint(20)
CREATED_TMP_DISK_TABLESbigint(20)
CREATED_TMP_TABLESbigint(20)
SELECT_FULL_JOINbigint(20)
SELECT_FULL_RANGE_JOINbigint(20)
SELECT_RANGEbigint(20)
SELECT_RANGE_CHECKbigint(20)
SELECT_SCANbigint(20)
SORT_MERGE_PASSESbigint(20)
SORT_RANGEbigint(20)
SORT_ROWSbigint(20)
SORT_SCANbigint(20)
NO_INDEX_USEDbigint(20)
NO_GOOD_INDEX_USEDbigint(20)
NESTING_EVENT_IDbigint(20)NULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')NULL

events_statements_summary_by_account_by_event_name

字段类型默认 链接到 注释 MIME
USERchar(16)NULL
HOSTchar(60)NULL
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
SUM_LOCK_TIMEbigint(20)
SUM_ERRORSbigint(20)
SUM_WARNINGSbigint(20)
SUM_ROWS_AFFECTEDbigint(20)
SUM_ROWS_SENTbigint(20)
SUM_ROWS_EXAMINEDbigint(20)
SUM_CREATED_TMP_DISK_TABLESbigint(20)
SUM_CREATED_TMP_TABLESbigint(20)
SUM_SELECT_FULL_JOINbigint(20)
SUM_SELECT_FULL_RANGE_JOINbigint(20)
SUM_SELECT_RANGEbigint(20)
SUM_SELECT_RANGE_CHECKbigint(20)
SUM_SELECT_SCANbigint(20)
SUM_SORT_MERGE_PASSESbigint(20)
SUM_SORT_RANGEbigint(20)
SUM_SORT_ROWSbigint(20)
SUM_SORT_SCANbigint(20)
SUM_NO_INDEX_USEDbigint(20)
SUM_NO_GOOD_INDEX_USEDbigint(20)

events_statements_summary_by_digest

字段类型默认 链接到 注释 MIME
SCHEMA_NAMEvarchar(64)NULL
DIGESTvarchar(32)NULL
DIGEST_TEXTlongtextNULL
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
SUM_LOCK_TIMEbigint(20)
SUM_ERRORSbigint(20)
SUM_WARNINGSbigint(20)
SUM_ROWS_AFFECTEDbigint(20)
SUM_ROWS_SENTbigint(20)
SUM_ROWS_EXAMINEDbigint(20)
SUM_CREATED_TMP_DISK_TABLESbigint(20)
SUM_CREATED_TMP_TABLESbigint(20)
SUM_SELECT_FULL_JOINbigint(20)
SUM_SELECT_FULL_RANGE_JOINbigint(20)
SUM_SELECT_RANGEbigint(20)
SUM_SELECT_RANGE_CHECKbigint(20)
SUM_SELECT_SCANbigint(20)
SUM_SORT_MERGE_PASSESbigint(20)
SUM_SORT_RANGEbigint(20)
SUM_SORT_ROWSbigint(20)
SUM_SORT_SCANbigint(20)
SUM_NO_INDEX_USEDbigint(20)
SUM_NO_GOOD_INDEX_USEDbigint(20)
FIRST_SEENtimestamp0000-00-00 00:00:00
LAST_SEENtimestamp0000-00-00 00:00:00

events_statements_summary_by_host_by_event_name

字段类型默认 链接到 注释 MIME
HOSTchar(60)NULL
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
SUM_LOCK_TIMEbigint(20)
SUM_ERRORSbigint(20)
SUM_WARNINGSbigint(20)
SUM_ROWS_AFFECTEDbigint(20)
SUM_ROWS_SENTbigint(20)
SUM_ROWS_EXAMINEDbigint(20)
SUM_CREATED_TMP_DISK_TABLESbigint(20)
SUM_CREATED_TMP_TABLESbigint(20)
SUM_SELECT_FULL_JOINbigint(20)
SUM_SELECT_FULL_RANGE_JOINbigint(20)
SUM_SELECT_RANGEbigint(20)
SUM_SELECT_RANGE_CHECKbigint(20)
SUM_SELECT_SCANbigint(20)
SUM_SORT_MERGE_PASSESbigint(20)
SUM_SORT_RANGEbigint(20)
SUM_SORT_ROWSbigint(20)
SUM_SORT_SCANbigint(20)
SUM_NO_INDEX_USEDbigint(20)
SUM_NO_GOOD_INDEX_USEDbigint(20)

events_statements_summary_by_thread_by_event_name

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
SUM_LOCK_TIMEbigint(20)
SUM_ERRORSbigint(20)
SUM_WARNINGSbigint(20)
SUM_ROWS_AFFECTEDbigint(20)
SUM_ROWS_SENTbigint(20)
SUM_ROWS_EXAMINEDbigint(20)
SUM_CREATED_TMP_DISK_TABLESbigint(20)
SUM_CREATED_TMP_TABLESbigint(20)
SUM_SELECT_FULL_JOINbigint(20)
SUM_SELECT_FULL_RANGE_JOINbigint(20)
SUM_SELECT_RANGEbigint(20)
SUM_SELECT_RANGE_CHECKbigint(20)
SUM_SELECT_SCANbigint(20)
SUM_SORT_MERGE_PASSESbigint(20)
SUM_SORT_RANGEbigint(20)
SUM_SORT_ROWSbigint(20)
SUM_SORT_SCANbigint(20)
SUM_NO_INDEX_USEDbigint(20)
SUM_NO_GOOD_INDEX_USEDbigint(20)

events_statements_summary_by_user_by_event_name

字段类型默认 链接到 注释 MIME
USERchar(16)NULL
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
SUM_LOCK_TIMEbigint(20)
SUM_ERRORSbigint(20)
SUM_WARNINGSbigint(20)
SUM_ROWS_AFFECTEDbigint(20)
SUM_ROWS_SENTbigint(20)
SUM_ROWS_EXAMINEDbigint(20)
SUM_CREATED_TMP_DISK_TABLESbigint(20)
SUM_CREATED_TMP_TABLESbigint(20)
SUM_SELECT_FULL_JOINbigint(20)
SUM_SELECT_FULL_RANGE_JOINbigint(20)
SUM_SELECT_RANGEbigint(20)
SUM_SELECT_RANGE_CHECKbigint(20)
SUM_SELECT_SCANbigint(20)
SUM_SORT_MERGE_PASSESbigint(20)
SUM_SORT_RANGEbigint(20)
SUM_SORT_ROWSbigint(20)
SUM_SORT_SCANbigint(20)
SUM_NO_INDEX_USEDbigint(20)
SUM_NO_GOOD_INDEX_USEDbigint(20)

events_statements_summary_global_by_event_name

字段类型默认 链接到 注释 MIME
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
SUM_LOCK_TIMEbigint(20)
SUM_ERRORSbigint(20)
SUM_WARNINGSbigint(20)
SUM_ROWS_AFFECTEDbigint(20)
SUM_ROWS_SENTbigint(20)
SUM_ROWS_EXAMINEDbigint(20)
SUM_CREATED_TMP_DISK_TABLESbigint(20)
SUM_CREATED_TMP_TABLESbigint(20)
SUM_SELECT_FULL_JOINbigint(20)
SUM_SELECT_FULL_RANGE_JOINbigint(20)
SUM_SELECT_RANGEbigint(20)
SUM_SELECT_RANGE_CHECKbigint(20)
SUM_SELECT_SCANbigint(20)
SUM_SORT_MERGE_PASSESbigint(20)
SUM_SORT_RANGEbigint(20)
SUM_SORT_ROWSbigint(20)
SUM_SORT_SCANbigint(20)
SUM_NO_INDEX_USEDbigint(20)
SUM_NO_GOOD_INDEX_USEDbigint(20)

events_waits_current

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_IDbigint(20)
END_EVENT_IDbigint(20)NULL
EVENT_NAMEvarchar(128)
SOURCEvarchar(64)NULL
TIMER_STARTbigint(20)NULL
TIMER_ENDbigint(20)NULL
TIMER_WAITbigint(20)NULL
SPINSint(10)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(512)NULL
INDEX_NAMEvarchar(64)NULL
OBJECT_TYPEvarchar(64)NULL
OBJECT_INSTANCE_BEGINbigint(20)
NESTING_EVENT_IDbigint(20)NULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')NULL
OPERATIONvarchar(32)
NUMBER_OF_BYTESbigint(20)NULL
FLAGSint(10)NULL

events_waits_history

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_IDbigint(20)
END_EVENT_IDbigint(20)NULL
EVENT_NAMEvarchar(128)
SOURCEvarchar(64)NULL
TIMER_STARTbigint(20)NULL
TIMER_ENDbigint(20)NULL
TIMER_WAITbigint(20)NULL
SPINSint(10)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(512)NULL
INDEX_NAMEvarchar(64)NULL
OBJECT_TYPEvarchar(64)NULL
OBJECT_INSTANCE_BEGINbigint(20)
NESTING_EVENT_IDbigint(20)NULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')NULL
OPERATIONvarchar(32)
NUMBER_OF_BYTESbigint(20)NULL
FLAGSint(10)NULL

events_waits_history_long

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_IDbigint(20)
END_EVENT_IDbigint(20)NULL
EVENT_NAMEvarchar(128)
SOURCEvarchar(64)NULL
TIMER_STARTbigint(20)NULL
TIMER_ENDbigint(20)NULL
TIMER_WAITbigint(20)NULL
SPINSint(10)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(512)NULL
INDEX_NAMEvarchar(64)NULL
OBJECT_TYPEvarchar(64)NULL
OBJECT_INSTANCE_BEGINbigint(20)
NESTING_EVENT_IDbigint(20)NULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')NULL
OPERATIONvarchar(32)
NUMBER_OF_BYTESbigint(20)NULL
FLAGSint(10)NULL

events_waits_summary_by_account_by_event_name

字段类型默认 链接到 注释 MIME
USERchar(16)NULL
HOSTchar(60)NULL
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_waits_summary_by_host_by_event_name

字段类型默认 链接到 注释 MIME
HOSTchar(60)NULL
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_waits_summary_by_instance

字段类型默认 链接到 注释 MIME
EVENT_NAMEvarchar(128)
OBJECT_INSTANCE_BEGINbigint(20)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_waits_summary_by_thread_by_event_name

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_waits_summary_by_user_by_event_name

字段类型默认 链接到 注释 MIME
USERchar(16)NULL
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

events_waits_summary_global_by_event_name

字段类型默认 链接到 注释 MIME
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

file_instances

字段类型默认 链接到 注释 MIME
FILE_NAMEvarchar(512)
EVENT_NAMEvarchar(128)
OPEN_COUNTint(10)

file_summary_by_event_name

字段类型默认 链接到 注释 MIME
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
COUNT_READbigint(20)
SUM_TIMER_READbigint(20)
MIN_TIMER_READbigint(20)
AVG_TIMER_READbigint(20)
MAX_TIMER_READbigint(20)
SUM_NUMBER_OF_BYTES_READbigint(20)
COUNT_WRITEbigint(20)
SUM_TIMER_WRITEbigint(20)
MIN_TIMER_WRITEbigint(20)
AVG_TIMER_WRITEbigint(20)
MAX_TIMER_WRITEbigint(20)
SUM_NUMBER_OF_BYTES_WRITEbigint(20)
COUNT_MISCbigint(20)
SUM_TIMER_MISCbigint(20)
MIN_TIMER_MISCbigint(20)
AVG_TIMER_MISCbigint(20)
MAX_TIMER_MISCbigint(20)

file_summary_by_instance

字段类型默认 链接到 注释 MIME
FILE_NAMEvarchar(512)
EVENT_NAMEvarchar(128)
OBJECT_INSTANCE_BEGINbigint(20)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
COUNT_READbigint(20)
SUM_TIMER_READbigint(20)
MIN_TIMER_READbigint(20)
AVG_TIMER_READbigint(20)
MAX_TIMER_READbigint(20)
SUM_NUMBER_OF_BYTES_READbigint(20)
COUNT_WRITEbigint(20)
SUM_TIMER_WRITEbigint(20)
MIN_TIMER_WRITEbigint(20)
AVG_TIMER_WRITEbigint(20)
MAX_TIMER_WRITEbigint(20)
SUM_NUMBER_OF_BYTES_WRITEbigint(20)
COUNT_MISCbigint(20)
SUM_TIMER_MISCbigint(20)
MIN_TIMER_MISCbigint(20)
AVG_TIMER_MISCbigint(20)
MAX_TIMER_MISCbigint(20)

host_cache

字段类型默认 链接到 注释 MIME
IPvarchar(64)
HOSTvarchar(255)NULL
HOST_VALIDATEDenum('YES', 'NO')
SUM_CONNECT_ERRORSbigint(20)
COUNT_HOST_BLOCKED_ERRORSbigint(20)
COUNT_NAMEINFO_TRANSIENT_ERRORSbigint(20)
COUNT_NAMEINFO_PERMANENT_ERRORSbigint(20)
COUNT_FORMAT_ERRORSbigint(20)
COUNT_ADDRINFO_TRANSIENT_ERRORSbigint(20)
COUNT_ADDRINFO_PERMANENT_ERRORSbigint(20)
COUNT_FCRDNS_ERRORSbigint(20)
COUNT_HOST_ACL_ERRORSbigint(20)
COUNT_NO_AUTH_PLUGIN_ERRORSbigint(20)
COUNT_AUTH_PLUGIN_ERRORSbigint(20)
COUNT_HANDSHAKE_ERRORSbigint(20)
COUNT_PROXY_USER_ERRORSbigint(20)
COUNT_PROXY_USER_ACL_ERRORSbigint(20)
COUNT_AUTHENTICATION_ERRORSbigint(20)
COUNT_SSL_ERRORSbigint(20)
COUNT_MAX_USER_CONNECTIONS_ERRORSbigint(20)
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORSbigint(20)
COUNT_DEFAULT_DATABASE_ERRORSbigint(20)
COUNT_INIT_CONNECT_ERRORSbigint(20)
COUNT_LOCAL_ERRORSbigint(20)
COUNT_UNKNOWN_ERRORSbigint(20)
FIRST_SEENtimestamp0000-00-00 00:00:00
LAST_SEENtimestamp0000-00-00 00:00:00
FIRST_ERROR_SEENtimestamp0000-00-00 00:00:00
LAST_ERROR_SEENtimestamp0000-00-00 00:00:00

hosts

字段类型默认 链接到 注释 MIME
HOSTchar(60)NULL
CURRENT_CONNECTIONSbigint(20)
TOTAL_CONNECTIONSbigint(20)

mutex_instances

字段类型默认 链接到 注释 MIME
NAMEvarchar(128)
OBJECT_INSTANCE_BEGINbigint(20)
LOCKED_BY_THREAD_IDbigint(20)NULL

objects_summary_global_by_type

字段类型默认 链接到 注释 MIME
OBJECT_TYPEvarchar(64)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(64)NULL
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)

performance_timers

字段类型默认 链接到 注释 MIME
TIMER_NAMEenum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')
TIMER_FREQUENCYbigint(20)NULL
TIMER_RESOLUTIONbigint(20)NULL
TIMER_OVERHEADbigint(20)NULL

rwlock_instances

字段类型默认 链接到 注释 MIME
NAMEvarchar(128)
OBJECT_INSTANCE_BEGINbigint(20)
WRITE_LOCKED_BY_THREAD_IDbigint(20)NULL
READ_LOCKED_BY_COUNTint(10)

session_account_connect_attrs

字段类型默认 链接到 注释 MIME
PROCESSLIST_IDint(11)
ATTR_NAMEvarchar(32)
ATTR_VALUEvarchar(1024)NULL
ORDINAL_POSITIONint(11)NULL

session_connect_attrs

字段类型默认 链接到 注释 MIME
PROCESSLIST_IDint(11)
ATTR_NAMEvarchar(32)
ATTR_VALUEvarchar(1024)NULL
ORDINAL_POSITIONint(11)NULL

setup_actors

字段类型默认 链接到 注释 MIME
HOSTchar(60)%
USERchar(16)%
ROLEchar(16)%

setup_consumers

字段类型默认 链接到 注释 MIME
NAMEvarchar(64)
ENABLEDenum('YES', 'NO')

setup_instruments

字段类型默认 链接到 注释 MIME
NAMEvarchar(128)
ENABLEDenum('YES', 'NO')
TIMEDenum('YES', 'NO')

setup_objects

字段类型默认 链接到 注释 MIME
OBJECT_TYPEenum('TABLE')TABLE
OBJECT_SCHEMAvarchar(64)%
OBJECT_NAMEvarchar(64)%
ENABLEDenum('YES', 'NO')YES
TIMEDenum('YES', 'NO')YES

setup_timers

字段类型默认 链接到 注释 MIME
NAMEvarchar(64)
TIMER_NAMEenum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')

socket_instances

字段类型默认 链接到 注释 MIME
EVENT_NAMEvarchar(128)
OBJECT_INSTANCE_BEGINbigint(20)
THREAD_IDbigint(20)NULL
SOCKET_IDint(11)
IPvarchar(64)
PORTint(11)
STATEenum('IDLE', 'ACTIVE')

socket_summary_by_event_name

字段类型默认 链接到 注释 MIME
EVENT_NAMEvarchar(128)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
COUNT_READbigint(20)
SUM_TIMER_READbigint(20)
MIN_TIMER_READbigint(20)
AVG_TIMER_READbigint(20)
MAX_TIMER_READbigint(20)
SUM_NUMBER_OF_BYTES_READbigint(20)
COUNT_WRITEbigint(20)
SUM_TIMER_WRITEbigint(20)
MIN_TIMER_WRITEbigint(20)
AVG_TIMER_WRITEbigint(20)
MAX_TIMER_WRITEbigint(20)
SUM_NUMBER_OF_BYTES_WRITEbigint(20)
COUNT_MISCbigint(20)
SUM_TIMER_MISCbigint(20)
MIN_TIMER_MISCbigint(20)
AVG_TIMER_MISCbigint(20)
MAX_TIMER_MISCbigint(20)

socket_summary_by_instance

字段类型默认 链接到 注释 MIME
EVENT_NAMEvarchar(128)
OBJECT_INSTANCE_BEGINbigint(20)
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
COUNT_READbigint(20)
SUM_TIMER_READbigint(20)
MIN_TIMER_READbigint(20)
AVG_TIMER_READbigint(20)
MAX_TIMER_READbigint(20)
SUM_NUMBER_OF_BYTES_READbigint(20)
COUNT_WRITEbigint(20)
SUM_TIMER_WRITEbigint(20)
MIN_TIMER_WRITEbigint(20)
AVG_TIMER_WRITEbigint(20)
MAX_TIMER_WRITEbigint(20)
SUM_NUMBER_OF_BYTES_WRITEbigint(20)
COUNT_MISCbigint(20)
SUM_TIMER_MISCbigint(20)
MIN_TIMER_MISCbigint(20)
AVG_TIMER_MISCbigint(20)
MAX_TIMER_MISCbigint(20)

table_io_waits_summary_by_index_usage

字段类型默认 链接到 注释 MIME
OBJECT_TYPEvarchar(64)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(64)NULL
INDEX_NAMEvarchar(64)NULL
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
COUNT_READbigint(20)
SUM_TIMER_READbigint(20)
MIN_TIMER_READbigint(20)
AVG_TIMER_READbigint(20)
MAX_TIMER_READbigint(20)
COUNT_WRITEbigint(20)
SUM_TIMER_WRITEbigint(20)
MIN_TIMER_WRITEbigint(20)
AVG_TIMER_WRITEbigint(20)
MAX_TIMER_WRITEbigint(20)
COUNT_FETCHbigint(20)
SUM_TIMER_FETCHbigint(20)
MIN_TIMER_FETCHbigint(20)
AVG_TIMER_FETCHbigint(20)
MAX_TIMER_FETCHbigint(20)
COUNT_INSERTbigint(20)
SUM_TIMER_INSERTbigint(20)
MIN_TIMER_INSERTbigint(20)
AVG_TIMER_INSERTbigint(20)
MAX_TIMER_INSERTbigint(20)
COUNT_UPDATEbigint(20)
SUM_TIMER_UPDATEbigint(20)
MIN_TIMER_UPDATEbigint(20)
AVG_TIMER_UPDATEbigint(20)
MAX_TIMER_UPDATEbigint(20)
COUNT_DELETEbigint(20)
SUM_TIMER_DELETEbigint(20)
MIN_TIMER_DELETEbigint(20)
AVG_TIMER_DELETEbigint(20)
MAX_TIMER_DELETEbigint(20)

table_io_waits_summary_by_table

字段类型默认 链接到 注释 MIME
OBJECT_TYPEvarchar(64)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(64)NULL
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
COUNT_READbigint(20)
SUM_TIMER_READbigint(20)
MIN_TIMER_READbigint(20)
AVG_TIMER_READbigint(20)
MAX_TIMER_READbigint(20)
COUNT_WRITEbigint(20)
SUM_TIMER_WRITEbigint(20)
MIN_TIMER_WRITEbigint(20)
AVG_TIMER_WRITEbigint(20)
MAX_TIMER_WRITEbigint(20)
COUNT_FETCHbigint(20)
SUM_TIMER_FETCHbigint(20)
MIN_TIMER_FETCHbigint(20)
AVG_TIMER_FETCHbigint(20)
MAX_TIMER_FETCHbigint(20)
COUNT_INSERTbigint(20)
SUM_TIMER_INSERTbigint(20)
MIN_TIMER_INSERTbigint(20)
AVG_TIMER_INSERTbigint(20)
MAX_TIMER_INSERTbigint(20)
COUNT_UPDATEbigint(20)
SUM_TIMER_UPDATEbigint(20)
MIN_TIMER_UPDATEbigint(20)
AVG_TIMER_UPDATEbigint(20)
MAX_TIMER_UPDATEbigint(20)
COUNT_DELETEbigint(20)
SUM_TIMER_DELETEbigint(20)
MIN_TIMER_DELETEbigint(20)
AVG_TIMER_DELETEbigint(20)
MAX_TIMER_DELETEbigint(20)

table_lock_waits_summary_by_table

字段类型默认 链接到 注释 MIME
OBJECT_TYPEvarchar(64)NULL
OBJECT_SCHEMAvarchar(64)NULL
OBJECT_NAMEvarchar(64)NULL
COUNT_STARbigint(20)
SUM_TIMER_WAITbigint(20)
MIN_TIMER_WAITbigint(20)
AVG_TIMER_WAITbigint(20)
MAX_TIMER_WAITbigint(20)
COUNT_READbigint(20)
SUM_TIMER_READbigint(20)
MIN_TIMER_READbigint(20)
AVG_TIMER_READbigint(20)
MAX_TIMER_READbigint(20)
COUNT_WRITEbigint(20)
SUM_TIMER_WRITEbigint(20)
MIN_TIMER_WRITEbigint(20)
AVG_TIMER_WRITEbigint(20)
MAX_TIMER_WRITEbigint(20)
COUNT_READ_NORMALbigint(20)
SUM_TIMER_READ_NORMALbigint(20)
MIN_TIMER_READ_NORMALbigint(20)
AVG_TIMER_READ_NORMALbigint(20)
MAX_TIMER_READ_NORMALbigint(20)
COUNT_READ_WITH_SHARED_LOCKSbigint(20)
SUM_TIMER_READ_WITH_SHARED_LOCKSbigint(20)
MIN_TIMER_READ_WITH_SHARED_LOCKSbigint(20)
AVG_TIMER_READ_WITH_SHARED_LOCKSbigint(20)
MAX_TIMER_READ_WITH_SHARED_LOCKSbigint(20)
COUNT_READ_HIGH_PRIORITYbigint(20)
SUM_TIMER_READ_HIGH_PRIORITYbigint(20)
MIN_TIMER_READ_HIGH_PRIORITYbigint(20)
AVG_TIMER_READ_HIGH_PRIORITYbigint(20)
MAX_TIMER_READ_HIGH_PRIORITYbigint(20)
COUNT_READ_NO_INSERTbigint(20)
SUM_TIMER_READ_NO_INSERTbigint(20)
MIN_TIMER_READ_NO_INSERTbigint(20)
AVG_TIMER_READ_NO_INSERTbigint(20)
MAX_TIMER_READ_NO_INSERTbigint(20)
COUNT_READ_EXTERNALbigint(20)
SUM_TIMER_READ_EXTERNALbigint(20)
MIN_TIMER_READ_EXTERNALbigint(20)
AVG_TIMER_READ_EXTERNALbigint(20)
MAX_TIMER_READ_EXTERNALbigint(20)
COUNT_WRITE_ALLOW_WRITEbigint(20)
SUM_TIMER_WRITE_ALLOW_WRITEbigint(20)
MIN_TIMER_WRITE_ALLOW_WRITEbigint(20)
AVG_TIMER_WRITE_ALLOW_WRITEbigint(20)
MAX_TIMER_WRITE_ALLOW_WRITEbigint(20)
COUNT_WRITE_CONCURRENT_INSERTbigint(20)
SUM_TIMER_WRITE_CONCURRENT_INSERTbigint(20)
MIN_TIMER_WRITE_CONCURRENT_INSERTbigint(20)
AVG_TIMER_WRITE_CONCURRENT_INSERTbigint(20)
MAX_TIMER_WRITE_CONCURRENT_INSERTbigint(20)
COUNT_WRITE_DELAYEDbigint(20)
SUM_TIMER_WRITE_DELAYEDbigint(20)
MIN_TIMER_WRITE_DELAYEDbigint(20)
AVG_TIMER_WRITE_DELAYEDbigint(20)
MAX_TIMER_WRITE_DELAYEDbigint(20)
COUNT_WRITE_LOW_PRIORITYbigint(20)
SUM_TIMER_WRITE_LOW_PRIORITYbigint(20)
MIN_TIMER_WRITE_LOW_PRIORITYbigint(20)
AVG_TIMER_WRITE_LOW_PRIORITYbigint(20)
MAX_TIMER_WRITE_LOW_PRIORITYbigint(20)
COUNT_WRITE_NORMALbigint(20)
SUM_TIMER_WRITE_NORMALbigint(20)
MIN_TIMER_WRITE_NORMALbigint(20)
AVG_TIMER_WRITE_NORMALbigint(20)
MAX_TIMER_WRITE_NORMALbigint(20)
COUNT_WRITE_EXTERNALbigint(20)
SUM_TIMER_WRITE_EXTERNALbigint(20)
MIN_TIMER_WRITE_EXTERNALbigint(20)
AVG_TIMER_WRITE_EXTERNALbigint(20)
MAX_TIMER_WRITE_EXTERNALbigint(20)

threads

字段类型默认 链接到 注释 MIME
THREAD_IDbigint(20)
NAMEvarchar(128)
TYPEvarchar(10)
PROCESSLIST_IDbigint(20)NULL
PROCESSLIST_USERvarchar(16)NULL
PROCESSLIST_HOSTvarchar(60)NULL
PROCESSLIST_DBvarchar(64)NULL
PROCESSLIST_COMMANDvarchar(16)NULL
PROCESSLIST_TIMEbigint(20)NULL
PROCESSLIST_STATEvarchar(64)NULL
PROCESSLIST_INFOlongtextNULL
PARENT_THREAD_IDbigint(20)NULL
ROLEvarchar(64)NULL
INSTRUMENTEDenum('YES', 'NO')

users

字段类型默认 链接到 注释 MIME
USERchar(16)NULL
CURRENT_CONNECTIONSbigint(20)
TOTAL_CONNECTIONSbigint(20)