accounts

SpalteTypNullStandard Verweise Kommentare MIME
USERchar(16)JaNULL
HOSTchar(60)JaNULL
CURRENT_CONNECTIONSbigint(20)Nein
TOTAL_CONNECTIONSbigint(20)Nein

cond_instances

SpalteTypNullStandard Verweise Kommentare MIME
NAMEvarchar(128)Nein
OBJECT_INSTANCE_BEGINbigint(20)Nein

events_stages_current

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_IDbigint(20)Nein
END_EVENT_IDbigint(20)JaNULL
EVENT_NAMEvarchar(128)Nein
SOURCEvarchar(64)JaNULL
TIMER_STARTbigint(20)JaNULL
TIMER_ENDbigint(20)JaNULL
TIMER_WAITbigint(20)JaNULL
NESTING_EVENT_IDbigint(20)JaNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')JaNULL

events_stages_history

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_IDbigint(20)Nein
END_EVENT_IDbigint(20)JaNULL
EVENT_NAMEvarchar(128)Nein
SOURCEvarchar(64)JaNULL
TIMER_STARTbigint(20)JaNULL
TIMER_ENDbigint(20)JaNULL
TIMER_WAITbigint(20)JaNULL
NESTING_EVENT_IDbigint(20)JaNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')JaNULL

events_stages_history_long

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_IDbigint(20)Nein
END_EVENT_IDbigint(20)JaNULL
EVENT_NAMEvarchar(128)Nein
SOURCEvarchar(64)JaNULL
TIMER_STARTbigint(20)JaNULL
TIMER_ENDbigint(20)JaNULL
TIMER_WAITbigint(20)JaNULL
NESTING_EVENT_IDbigint(20)JaNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')JaNULL

events_stages_summary_by_account_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
USERchar(16)JaNULL
HOSTchar(60)JaNULL
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_stages_summary_by_host_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
HOSTchar(60)JaNULL
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_stages_summary_by_thread_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_stages_summary_by_user_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
USERchar(16)JaNULL
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_stages_summary_global_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_statements_current

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_IDbigint(20)Nein
END_EVENT_IDbigint(20)JaNULL
EVENT_NAMEvarchar(128)Nein
SOURCEvarchar(64)JaNULL
TIMER_STARTbigint(20)JaNULL
TIMER_ENDbigint(20)JaNULL
TIMER_WAITbigint(20)JaNULL
LOCK_TIMEbigint(20)Nein
SQL_TEXTlongtextJaNULL
DIGESTvarchar(32)JaNULL
DIGEST_TEXTlongtextJaNULL
CURRENT_SCHEMAvarchar(64)JaNULL
OBJECT_TYPEvarchar(64)JaNULL
OBJECT_SCHEMAvarchar(64)JaNULL
OBJECT_NAMEvarchar(64)JaNULL
OBJECT_INSTANCE_BEGINbigint(20)JaNULL
MYSQL_ERRNOint(11)JaNULL
RETURNED_SQLSTATEvarchar(5)JaNULL
MESSAGE_TEXTvarchar(128)JaNULL
ERRORSbigint(20)Nein
WARNINGSbigint(20)Nein
ROWS_AFFECTEDbigint(20)Nein
ROWS_SENTbigint(20)Nein
ROWS_EXAMINEDbigint(20)Nein
CREATED_TMP_DISK_TABLESbigint(20)Nein
CREATED_TMP_TABLESbigint(20)Nein
SELECT_FULL_JOINbigint(20)Nein
SELECT_FULL_RANGE_JOINbigint(20)Nein
SELECT_RANGEbigint(20)Nein
SELECT_RANGE_CHECKbigint(20)Nein
SELECT_SCANbigint(20)Nein
SORT_MERGE_PASSESbigint(20)Nein
SORT_RANGEbigint(20)Nein
SORT_ROWSbigint(20)Nein
SORT_SCANbigint(20)Nein
NO_INDEX_USEDbigint(20)Nein
NO_GOOD_INDEX_USEDbigint(20)Nein
NESTING_EVENT_IDbigint(20)JaNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')JaNULL

events_statements_history

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_IDbigint(20)Nein
END_EVENT_IDbigint(20)JaNULL
EVENT_NAMEvarchar(128)Nein
SOURCEvarchar(64)JaNULL
TIMER_STARTbigint(20)JaNULL
TIMER_ENDbigint(20)JaNULL
TIMER_WAITbigint(20)JaNULL
LOCK_TIMEbigint(20)Nein
SQL_TEXTlongtextJaNULL
DIGESTvarchar(32)JaNULL
DIGEST_TEXTlongtextJaNULL
CURRENT_SCHEMAvarchar(64)JaNULL
OBJECT_TYPEvarchar(64)JaNULL
OBJECT_SCHEMAvarchar(64)JaNULL
OBJECT_NAMEvarchar(64)JaNULL
OBJECT_INSTANCE_BEGINbigint(20)JaNULL
MYSQL_ERRNOint(11)JaNULL
RETURNED_SQLSTATEvarchar(5)JaNULL
MESSAGE_TEXTvarchar(128)JaNULL
ERRORSbigint(20)Nein
WARNINGSbigint(20)Nein
ROWS_AFFECTEDbigint(20)Nein
ROWS_SENTbigint(20)Nein
ROWS_EXAMINEDbigint(20)Nein
CREATED_TMP_DISK_TABLESbigint(20)Nein
CREATED_TMP_TABLESbigint(20)Nein
SELECT_FULL_JOINbigint(20)Nein
SELECT_FULL_RANGE_JOINbigint(20)Nein
SELECT_RANGEbigint(20)Nein
SELECT_RANGE_CHECKbigint(20)Nein
SELECT_SCANbigint(20)Nein
SORT_MERGE_PASSESbigint(20)Nein
SORT_RANGEbigint(20)Nein
SORT_ROWSbigint(20)Nein
SORT_SCANbigint(20)Nein
NO_INDEX_USEDbigint(20)Nein
NO_GOOD_INDEX_USEDbigint(20)Nein
NESTING_EVENT_IDbigint(20)JaNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')JaNULL

events_statements_history_long

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_IDbigint(20)Nein
END_EVENT_IDbigint(20)JaNULL
EVENT_NAMEvarchar(128)Nein
SOURCEvarchar(64)JaNULL
TIMER_STARTbigint(20)JaNULL
TIMER_ENDbigint(20)JaNULL
TIMER_WAITbigint(20)JaNULL
LOCK_TIMEbigint(20)Nein
SQL_TEXTlongtextJaNULL
DIGESTvarchar(32)JaNULL
DIGEST_TEXTlongtextJaNULL
CURRENT_SCHEMAvarchar(64)JaNULL
OBJECT_TYPEvarchar(64)JaNULL
OBJECT_SCHEMAvarchar(64)JaNULL
OBJECT_NAMEvarchar(64)JaNULL
OBJECT_INSTANCE_BEGINbigint(20)JaNULL
MYSQL_ERRNOint(11)JaNULL
RETURNED_SQLSTATEvarchar(5)JaNULL
MESSAGE_TEXTvarchar(128)JaNULL
ERRORSbigint(20)Nein
WARNINGSbigint(20)Nein
ROWS_AFFECTEDbigint(20)Nein
ROWS_SENTbigint(20)Nein
ROWS_EXAMINEDbigint(20)Nein
CREATED_TMP_DISK_TABLESbigint(20)Nein
CREATED_TMP_TABLESbigint(20)Nein
SELECT_FULL_JOINbigint(20)Nein
SELECT_FULL_RANGE_JOINbigint(20)Nein
SELECT_RANGEbigint(20)Nein
SELECT_RANGE_CHECKbigint(20)Nein
SELECT_SCANbigint(20)Nein
SORT_MERGE_PASSESbigint(20)Nein
SORT_RANGEbigint(20)Nein
SORT_ROWSbigint(20)Nein
SORT_SCANbigint(20)Nein
NO_INDEX_USEDbigint(20)Nein
NO_GOOD_INDEX_USEDbigint(20)Nein
NESTING_EVENT_IDbigint(20)JaNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')JaNULL

events_statements_summary_by_account_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
USERchar(16)JaNULL
HOSTchar(60)JaNULL
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
SUM_LOCK_TIMEbigint(20)Nein
SUM_ERRORSbigint(20)Nein
SUM_WARNINGSbigint(20)Nein
SUM_ROWS_AFFECTEDbigint(20)Nein
SUM_ROWS_SENTbigint(20)Nein
SUM_ROWS_EXAMINEDbigint(20)Nein
SUM_CREATED_TMP_DISK_TABLESbigint(20)Nein
SUM_CREATED_TMP_TABLESbigint(20)Nein
SUM_SELECT_FULL_JOINbigint(20)Nein
SUM_SELECT_FULL_RANGE_JOINbigint(20)Nein
SUM_SELECT_RANGEbigint(20)Nein
SUM_SELECT_RANGE_CHECKbigint(20)Nein
SUM_SELECT_SCANbigint(20)Nein
SUM_SORT_MERGE_PASSESbigint(20)Nein
SUM_SORT_RANGEbigint(20)Nein
SUM_SORT_ROWSbigint(20)Nein
SUM_SORT_SCANbigint(20)Nein
SUM_NO_INDEX_USEDbigint(20)Nein
SUM_NO_GOOD_INDEX_USEDbigint(20)Nein

events_statements_summary_by_digest

SpalteTypNullStandard Verweise Kommentare MIME
SCHEMA_NAMEvarchar(64)JaNULL
DIGESTvarchar(32)JaNULL
DIGEST_TEXTlongtextJaNULL
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
SUM_LOCK_TIMEbigint(20)Nein
SUM_ERRORSbigint(20)Nein
SUM_WARNINGSbigint(20)Nein
SUM_ROWS_AFFECTEDbigint(20)Nein
SUM_ROWS_SENTbigint(20)Nein
SUM_ROWS_EXAMINEDbigint(20)Nein
SUM_CREATED_TMP_DISK_TABLESbigint(20)Nein
SUM_CREATED_TMP_TABLESbigint(20)Nein
SUM_SELECT_FULL_JOINbigint(20)Nein
SUM_SELECT_FULL_RANGE_JOINbigint(20)Nein
SUM_SELECT_RANGEbigint(20)Nein
SUM_SELECT_RANGE_CHECKbigint(20)Nein
SUM_SELECT_SCANbigint(20)Nein
SUM_SORT_MERGE_PASSESbigint(20)Nein
SUM_SORT_RANGEbigint(20)Nein
SUM_SORT_ROWSbigint(20)Nein
SUM_SORT_SCANbigint(20)Nein
SUM_NO_INDEX_USEDbigint(20)Nein
SUM_NO_GOOD_INDEX_USEDbigint(20)Nein
FIRST_SEENtimestampNein0000-00-00 00:00:00
LAST_SEENtimestampNein0000-00-00 00:00:00

events_statements_summary_by_host_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
HOSTchar(60)JaNULL
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
SUM_LOCK_TIMEbigint(20)Nein
SUM_ERRORSbigint(20)Nein
SUM_WARNINGSbigint(20)Nein
SUM_ROWS_AFFECTEDbigint(20)Nein
SUM_ROWS_SENTbigint(20)Nein
SUM_ROWS_EXAMINEDbigint(20)Nein
SUM_CREATED_TMP_DISK_TABLESbigint(20)Nein
SUM_CREATED_TMP_TABLESbigint(20)Nein
SUM_SELECT_FULL_JOINbigint(20)Nein
SUM_SELECT_FULL_RANGE_JOINbigint(20)Nein
SUM_SELECT_RANGEbigint(20)Nein
SUM_SELECT_RANGE_CHECKbigint(20)Nein
SUM_SELECT_SCANbigint(20)Nein
SUM_SORT_MERGE_PASSESbigint(20)Nein
SUM_SORT_RANGEbigint(20)Nein
SUM_SORT_ROWSbigint(20)Nein
SUM_SORT_SCANbigint(20)Nein
SUM_NO_INDEX_USEDbigint(20)Nein
SUM_NO_GOOD_INDEX_USEDbigint(20)Nein

events_statements_summary_by_thread_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
SUM_LOCK_TIMEbigint(20)Nein
SUM_ERRORSbigint(20)Nein
SUM_WARNINGSbigint(20)Nein
SUM_ROWS_AFFECTEDbigint(20)Nein
SUM_ROWS_SENTbigint(20)Nein
SUM_ROWS_EXAMINEDbigint(20)Nein
SUM_CREATED_TMP_DISK_TABLESbigint(20)Nein
SUM_CREATED_TMP_TABLESbigint(20)Nein
SUM_SELECT_FULL_JOINbigint(20)Nein
SUM_SELECT_FULL_RANGE_JOINbigint(20)Nein
SUM_SELECT_RANGEbigint(20)Nein
SUM_SELECT_RANGE_CHECKbigint(20)Nein
SUM_SELECT_SCANbigint(20)Nein
SUM_SORT_MERGE_PASSESbigint(20)Nein
SUM_SORT_RANGEbigint(20)Nein
SUM_SORT_ROWSbigint(20)Nein
SUM_SORT_SCANbigint(20)Nein
SUM_NO_INDEX_USEDbigint(20)Nein
SUM_NO_GOOD_INDEX_USEDbigint(20)Nein

events_statements_summary_by_user_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
USERchar(16)JaNULL
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
SUM_LOCK_TIMEbigint(20)Nein
SUM_ERRORSbigint(20)Nein
SUM_WARNINGSbigint(20)Nein
SUM_ROWS_AFFECTEDbigint(20)Nein
SUM_ROWS_SENTbigint(20)Nein
SUM_ROWS_EXAMINEDbigint(20)Nein
SUM_CREATED_TMP_DISK_TABLESbigint(20)Nein
SUM_CREATED_TMP_TABLESbigint(20)Nein
SUM_SELECT_FULL_JOINbigint(20)Nein
SUM_SELECT_FULL_RANGE_JOINbigint(20)Nein
SUM_SELECT_RANGEbigint(20)Nein
SUM_SELECT_RANGE_CHECKbigint(20)Nein
SUM_SELECT_SCANbigint(20)Nein
SUM_SORT_MERGE_PASSESbigint(20)Nein
SUM_SORT_RANGEbigint(20)Nein
SUM_SORT_ROWSbigint(20)Nein
SUM_SORT_SCANbigint(20)Nein
SUM_NO_INDEX_USEDbigint(20)Nein
SUM_NO_GOOD_INDEX_USEDbigint(20)Nein

events_statements_summary_global_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
SUM_LOCK_TIMEbigint(20)Nein
SUM_ERRORSbigint(20)Nein
SUM_WARNINGSbigint(20)Nein
SUM_ROWS_AFFECTEDbigint(20)Nein
SUM_ROWS_SENTbigint(20)Nein
SUM_ROWS_EXAMINEDbigint(20)Nein
SUM_CREATED_TMP_DISK_TABLESbigint(20)Nein
SUM_CREATED_TMP_TABLESbigint(20)Nein
SUM_SELECT_FULL_JOINbigint(20)Nein
SUM_SELECT_FULL_RANGE_JOINbigint(20)Nein
SUM_SELECT_RANGEbigint(20)Nein
SUM_SELECT_RANGE_CHECKbigint(20)Nein
SUM_SELECT_SCANbigint(20)Nein
SUM_SORT_MERGE_PASSESbigint(20)Nein
SUM_SORT_RANGEbigint(20)Nein
SUM_SORT_ROWSbigint(20)Nein
SUM_SORT_SCANbigint(20)Nein
SUM_NO_INDEX_USEDbigint(20)Nein
SUM_NO_GOOD_INDEX_USEDbigint(20)Nein

events_waits_current

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_IDbigint(20)Nein
END_EVENT_IDbigint(20)JaNULL
EVENT_NAMEvarchar(128)Nein
SOURCEvarchar(64)JaNULL
TIMER_STARTbigint(20)JaNULL
TIMER_ENDbigint(20)JaNULL
TIMER_WAITbigint(20)JaNULL
SPINSint(10)JaNULL
OBJECT_SCHEMAvarchar(64)JaNULL
OBJECT_NAMEvarchar(512)JaNULL
INDEX_NAMEvarchar(64)JaNULL
OBJECT_TYPEvarchar(64)JaNULL
OBJECT_INSTANCE_BEGINbigint(20)Nein
NESTING_EVENT_IDbigint(20)JaNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')JaNULL
OPERATIONvarchar(32)Nein
NUMBER_OF_BYTESbigint(20)JaNULL
FLAGSint(10)JaNULL

events_waits_history

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_IDbigint(20)Nein
END_EVENT_IDbigint(20)JaNULL
EVENT_NAMEvarchar(128)Nein
SOURCEvarchar(64)JaNULL
TIMER_STARTbigint(20)JaNULL
TIMER_ENDbigint(20)JaNULL
TIMER_WAITbigint(20)JaNULL
SPINSint(10)JaNULL
OBJECT_SCHEMAvarchar(64)JaNULL
OBJECT_NAMEvarchar(512)JaNULL
INDEX_NAMEvarchar(64)JaNULL
OBJECT_TYPEvarchar(64)JaNULL
OBJECT_INSTANCE_BEGINbigint(20)Nein
NESTING_EVENT_IDbigint(20)JaNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')JaNULL
OPERATIONvarchar(32)Nein
NUMBER_OF_BYTESbigint(20)JaNULL
FLAGSint(10)JaNULL

events_waits_history_long

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_IDbigint(20)Nein
END_EVENT_IDbigint(20)JaNULL
EVENT_NAMEvarchar(128)Nein
SOURCEvarchar(64)JaNULL
TIMER_STARTbigint(20)JaNULL
TIMER_ENDbigint(20)JaNULL
TIMER_WAITbigint(20)JaNULL
SPINSint(10)JaNULL
OBJECT_SCHEMAvarchar(64)JaNULL
OBJECT_NAMEvarchar(512)JaNULL
INDEX_NAMEvarchar(64)JaNULL
OBJECT_TYPEvarchar(64)JaNULL
OBJECT_INSTANCE_BEGINbigint(20)Nein
NESTING_EVENT_IDbigint(20)JaNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')JaNULL
OPERATIONvarchar(32)Nein
NUMBER_OF_BYTESbigint(20)JaNULL
FLAGSint(10)JaNULL

events_waits_summary_by_account_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
USERchar(16)JaNULL
HOSTchar(60)JaNULL
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_waits_summary_by_host_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
HOSTchar(60)JaNULL
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_waits_summary_by_instance

SpalteTypNullStandard Verweise Kommentare MIME
EVENT_NAMEvarchar(128)Nein
OBJECT_INSTANCE_BEGINbigint(20)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_waits_summary_by_thread_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_waits_summary_by_user_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
USERchar(16)JaNULL
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

events_waits_summary_global_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

file_instances

SpalteTypNullStandard Verweise Kommentare MIME
FILE_NAMEvarchar(512)Nein
EVENT_NAMEvarchar(128)Nein
OPEN_COUNTint(10)Nein

file_summary_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
COUNT_READbigint(20)Nein
SUM_TIMER_READbigint(20)Nein
MIN_TIMER_READbigint(20)Nein
AVG_TIMER_READbigint(20)Nein
MAX_TIMER_READbigint(20)Nein
SUM_NUMBER_OF_BYTES_READbigint(20)Nein
COUNT_WRITEbigint(20)Nein
SUM_TIMER_WRITEbigint(20)Nein
MIN_TIMER_WRITEbigint(20)Nein
AVG_TIMER_WRITEbigint(20)Nein
MAX_TIMER_WRITEbigint(20)Nein
SUM_NUMBER_OF_BYTES_WRITEbigint(20)Nein
COUNT_MISCbigint(20)Nein
SUM_TIMER_MISCbigint(20)Nein
MIN_TIMER_MISCbigint(20)Nein
AVG_TIMER_MISCbigint(20)Nein
MAX_TIMER_MISCbigint(20)Nein

file_summary_by_instance

SpalteTypNullStandard Verweise Kommentare MIME
FILE_NAMEvarchar(512)Nein
EVENT_NAMEvarchar(128)Nein
OBJECT_INSTANCE_BEGINbigint(20)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
COUNT_READbigint(20)Nein
SUM_TIMER_READbigint(20)Nein
MIN_TIMER_READbigint(20)Nein
AVG_TIMER_READbigint(20)Nein
MAX_TIMER_READbigint(20)Nein
SUM_NUMBER_OF_BYTES_READbigint(20)Nein
COUNT_WRITEbigint(20)Nein
SUM_TIMER_WRITEbigint(20)Nein
MIN_TIMER_WRITEbigint(20)Nein
AVG_TIMER_WRITEbigint(20)Nein
MAX_TIMER_WRITEbigint(20)Nein
SUM_NUMBER_OF_BYTES_WRITEbigint(20)Nein
COUNT_MISCbigint(20)Nein
SUM_TIMER_MISCbigint(20)Nein
MIN_TIMER_MISCbigint(20)Nein
AVG_TIMER_MISCbigint(20)Nein
MAX_TIMER_MISCbigint(20)Nein

hosts

SpalteTypNullStandard Verweise Kommentare MIME
HOSTchar(60)JaNULL
CURRENT_CONNECTIONSbigint(20)Nein
TOTAL_CONNECTIONSbigint(20)Nein

host_cache

SpalteTypNullStandard Verweise Kommentare MIME
IPvarchar(64)Nein
HOSTvarchar(255)JaNULL
HOST_VALIDATEDenum('YES', 'NO')Nein
SUM_CONNECT_ERRORSbigint(20)Nein
COUNT_HOST_BLOCKED_ERRORSbigint(20)Nein
COUNT_NAMEINFO_TRANSIENT_ERRORSbigint(20)Nein
COUNT_NAMEINFO_PERMANENT_ERRORSbigint(20)Nein
COUNT_FORMAT_ERRORSbigint(20)Nein
COUNT_ADDRINFO_TRANSIENT_ERRORSbigint(20)Nein
COUNT_ADDRINFO_PERMANENT_ERRORSbigint(20)Nein
COUNT_FCRDNS_ERRORSbigint(20)Nein
COUNT_HOST_ACL_ERRORSbigint(20)Nein
COUNT_NO_AUTH_PLUGIN_ERRORSbigint(20)Nein
COUNT_AUTH_PLUGIN_ERRORSbigint(20)Nein
COUNT_HANDSHAKE_ERRORSbigint(20)Nein
COUNT_PROXY_USER_ERRORSbigint(20)Nein
COUNT_PROXY_USER_ACL_ERRORSbigint(20)Nein
COUNT_AUTHENTICATION_ERRORSbigint(20)Nein
COUNT_SSL_ERRORSbigint(20)Nein
COUNT_MAX_USER_CONNECTIONS_ERRORSbigint(20)Nein
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORSbigint(20)Nein
COUNT_DEFAULT_DATABASE_ERRORSbigint(20)Nein
COUNT_INIT_CONNECT_ERRORSbigint(20)Nein
COUNT_LOCAL_ERRORSbigint(20)Nein
COUNT_UNKNOWN_ERRORSbigint(20)Nein
FIRST_SEENtimestampNein0000-00-00 00:00:00
LAST_SEENtimestampNein0000-00-00 00:00:00
FIRST_ERROR_SEENtimestampJa0000-00-00 00:00:00
LAST_ERROR_SEENtimestampJa0000-00-00 00:00:00

mutex_instances

SpalteTypNullStandard Verweise Kommentare MIME
NAMEvarchar(128)Nein
OBJECT_INSTANCE_BEGINbigint(20)Nein
LOCKED_BY_THREAD_IDbigint(20)JaNULL

objects_summary_global_by_type

SpalteTypNullStandard Verweise Kommentare MIME
OBJECT_TYPEvarchar(64)JaNULL
OBJECT_SCHEMAvarchar(64)JaNULL
OBJECT_NAMEvarchar(64)JaNULL
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein

performance_timers

SpalteTypNullStandard Verweise Kommentare MIME
TIMER_NAMEenum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')Nein
TIMER_FREQUENCYbigint(20)JaNULL
TIMER_RESOLUTIONbigint(20)JaNULL
TIMER_OVERHEADbigint(20)JaNULL

rwlock_instances

SpalteTypNullStandard Verweise Kommentare MIME
NAMEvarchar(128)Nein
OBJECT_INSTANCE_BEGINbigint(20)Nein
WRITE_LOCKED_BY_THREAD_IDbigint(20)JaNULL
READ_LOCKED_BY_COUNTint(10)Nein

session_account_connect_attrs

SpalteTypNullStandard Verweise Kommentare MIME
PROCESSLIST_IDint(11)Nein
ATTR_NAMEvarchar(32)Nein
ATTR_VALUEvarchar(1024)JaNULL
ORDINAL_POSITIONint(11)JaNULL

session_connect_attrs

SpalteTypNullStandard Verweise Kommentare MIME
PROCESSLIST_IDint(11)Nein
ATTR_NAMEvarchar(32)Nein
ATTR_VALUEvarchar(1024)JaNULL
ORDINAL_POSITIONint(11)JaNULL

setup_actors

SpalteTypNullStandard Verweise Kommentare MIME
HOSTchar(60)Nein%
USERchar(16)Nein%
ROLEchar(16)Nein%

setup_consumers

SpalteTypNullStandard Verweise Kommentare MIME
NAMEvarchar(64)Nein
ENABLEDenum('YES', 'NO')Nein

setup_instruments

SpalteTypNullStandard Verweise Kommentare MIME
NAMEvarchar(128)Nein
ENABLEDenum('YES', 'NO')Nein
TIMEDenum('YES', 'NO')Nein

setup_objects

SpalteTypNullStandard Verweise Kommentare MIME
OBJECT_TYPEenum('TABLE')NeinTABLE
OBJECT_SCHEMAvarchar(64)Ja%
OBJECT_NAMEvarchar(64)Nein%
ENABLEDenum('YES', 'NO')NeinYES
TIMEDenum('YES', 'NO')NeinYES

setup_timers

SpalteTypNullStandard Verweise Kommentare MIME
NAMEvarchar(64)Nein
TIMER_NAMEenum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')Nein

socket_instances

SpalteTypNullStandard Verweise Kommentare MIME
EVENT_NAMEvarchar(128)Nein
OBJECT_INSTANCE_BEGINbigint(20)Nein
THREAD_IDbigint(20)JaNULL
SOCKET_IDint(11)Nein
IPvarchar(64)Nein
PORTint(11)Nein
STATEenum('IDLE', 'ACTIVE')Nein

socket_summary_by_event_name

SpalteTypNullStandard Verweise Kommentare MIME
EVENT_NAMEvarchar(128)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
COUNT_READbigint(20)Nein
SUM_TIMER_READbigint(20)Nein
MIN_TIMER_READbigint(20)Nein
AVG_TIMER_READbigint(20)Nein
MAX_TIMER_READbigint(20)Nein
SUM_NUMBER_OF_BYTES_READbigint(20)Nein
COUNT_WRITEbigint(20)Nein
SUM_TIMER_WRITEbigint(20)Nein
MIN_TIMER_WRITEbigint(20)Nein
AVG_TIMER_WRITEbigint(20)Nein
MAX_TIMER_WRITEbigint(20)Nein
SUM_NUMBER_OF_BYTES_WRITEbigint(20)Nein
COUNT_MISCbigint(20)Nein
SUM_TIMER_MISCbigint(20)Nein
MIN_TIMER_MISCbigint(20)Nein
AVG_TIMER_MISCbigint(20)Nein
MAX_TIMER_MISCbigint(20)Nein

socket_summary_by_instance

SpalteTypNullStandard Verweise Kommentare MIME
EVENT_NAMEvarchar(128)Nein
OBJECT_INSTANCE_BEGINbigint(20)Nein
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
COUNT_READbigint(20)Nein
SUM_TIMER_READbigint(20)Nein
MIN_TIMER_READbigint(20)Nein
AVG_TIMER_READbigint(20)Nein
MAX_TIMER_READbigint(20)Nein
SUM_NUMBER_OF_BYTES_READbigint(20)Nein
COUNT_WRITEbigint(20)Nein
SUM_TIMER_WRITEbigint(20)Nein
MIN_TIMER_WRITEbigint(20)Nein
AVG_TIMER_WRITEbigint(20)Nein
MAX_TIMER_WRITEbigint(20)Nein
SUM_NUMBER_OF_BYTES_WRITEbigint(20)Nein
COUNT_MISCbigint(20)Nein
SUM_TIMER_MISCbigint(20)Nein
MIN_TIMER_MISCbigint(20)Nein
AVG_TIMER_MISCbigint(20)Nein
MAX_TIMER_MISCbigint(20)Nein

table_io_waits_summary_by_index_usage

SpalteTypNullStandard Verweise Kommentare MIME
OBJECT_TYPEvarchar(64)JaNULL
OBJECT_SCHEMAvarchar(64)JaNULL
OBJECT_NAMEvarchar(64)JaNULL
INDEX_NAMEvarchar(64)JaNULL
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
COUNT_READbigint(20)Nein
SUM_TIMER_READbigint(20)Nein
MIN_TIMER_READbigint(20)Nein
AVG_TIMER_READbigint(20)Nein
MAX_TIMER_READbigint(20)Nein
COUNT_WRITEbigint(20)Nein
SUM_TIMER_WRITEbigint(20)Nein
MIN_TIMER_WRITEbigint(20)Nein
AVG_TIMER_WRITEbigint(20)Nein
MAX_TIMER_WRITEbigint(20)Nein
COUNT_FETCHbigint(20)Nein
SUM_TIMER_FETCHbigint(20)Nein
MIN_TIMER_FETCHbigint(20)Nein
AVG_TIMER_FETCHbigint(20)Nein
MAX_TIMER_FETCHbigint(20)Nein
COUNT_INSERTbigint(20)Nein
SUM_TIMER_INSERTbigint(20)Nein
MIN_TIMER_INSERTbigint(20)Nein
AVG_TIMER_INSERTbigint(20)Nein
MAX_TIMER_INSERTbigint(20)Nein
COUNT_UPDATEbigint(20)Nein
SUM_TIMER_UPDATEbigint(20)Nein
MIN_TIMER_UPDATEbigint(20)Nein
AVG_TIMER_UPDATEbigint(20)Nein
MAX_TIMER_UPDATEbigint(20)Nein
COUNT_DELETEbigint(20)Nein
SUM_TIMER_DELETEbigint(20)Nein
MIN_TIMER_DELETEbigint(20)Nein
AVG_TIMER_DELETEbigint(20)Nein
MAX_TIMER_DELETEbigint(20)Nein

table_io_waits_summary_by_table

SpalteTypNullStandard Verweise Kommentare MIME
OBJECT_TYPEvarchar(64)JaNULL
OBJECT_SCHEMAvarchar(64)JaNULL
OBJECT_NAMEvarchar(64)JaNULL
COUNT_STARbigint(20)Nein
SUM_TIMER_WAITbigint(20)Nein
MIN_TIMER_WAITbigint(20)Nein
AVG_TIMER_WAITbigint(20)Nein
MAX_TIMER_WAITbigint(20)Nein
COUNT_READbigint(20)Nein
SUM_TIMER_READbigint(20)Nein
MIN_TIMER_READbigint(20)Nein
AVG_TIMER_READbigint(20)Nein
MAX_TIMER_READbigint(20)Nein
COUNT_WRITEbigint(20)Nein
SUM_TIMER_WRITEbigint(20)Nein
MIN_TIMER_WRITEbigint(20)Nein
AVG_TIMER_WRITEbigint(20)Nein
MAX_TIMER_WRITEbigint(20)Nein
COUNT_FETCHbigint(20)Nein
SUM_TIMER_FETCHbigint(20)Nein
MIN_TIMER_FETCHbigint(20)Nein
AVG_TIMER_FETCHbigint(20)Nein
MAX_TIMER_FETCHbigint(20)Nein
COUNT_INSERTbigint(20)Nein
SUM_TIMER_INSERTbigint(20)Nein
MIN_TIMER_INSERTbigint(20)Nein
AVG_TIMER_INSERTbigint(20)Nein
MAX_TIMER_INSERTbigint(20)Nein
COUNT_UPDATEbigint(20)Nein
SUM_TIMER_UPDATEbigint(20)Nein
MIN_TIMER_UPDATEbigint(20)Nein
AVG_TIMER_UPDATEbigint(20)Nein
MAX_TIMER_UPDATEbigint(20)Nein
COUNT_DELETEbigint(20)Nein
SUM_TIMER_DELETEbigint(20)Nein
MIN_TIMER_DELETEbigint(20)Nein
AVG_TIMER_DELETEbigint(20)Nein
MAX_TIMER_DELETEbigint(20)Nein

table_lock_waits_summary_by_table

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

threads

SpalteTypNullStandard Verweise Kommentare MIME
THREAD_IDbigint(20)Nein
NAMEvarchar(128)Nein
TYPEvarchar(10)Nein
PROCESSLIST_IDbigint(20)JaNULL
PROCESSLIST_USERvarchar(16)JaNULL
PROCESSLIST_HOSTvarchar(60)JaNULL
PROCESSLIST_DBvarchar(64)JaNULL
PROCESSLIST_COMMANDvarchar(16)JaNULL
PROCESSLIST_TIMEbigint(20)JaNULL
PROCESSLIST_STATEvarchar(64)JaNULL
PROCESSLIST_INFOlongtextJaNULL
PARENT_THREAD_IDbigint(20)JaNULL
ROLEvarchar(64)JaNULL
INSTRUMENTEDenum('YES', 'NO')Nein

users

SpalteTypNullStandard Verweise Kommentare MIME
USERchar(16)JaNULL
CURRENT_CONNECTIONSbigint(20)Nein
TOTAL_CONNECTIONSbigint(20)Nein