accounts

ColumnTypeNullDefault Links to Comments MIME
USERchar(16)YesNULL
HOSTchar(60)YesNULL
CURRENT_CONNECTIONSbigint(20)No
TOTAL_CONNECTIONSbigint(20)No

cond_instances

ColumnTypeNullDefault Links to Comments MIME
NAMEvarchar(128)No
OBJECT_INSTANCE_BEGINbigint(20)No

events_stages_current

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_IDbigint(20)No
END_EVENT_IDbigint(20)YesNULL
EVENT_NAMEvarchar(128)No
SOURCEvarchar(64)YesNULL
TIMER_STARTbigint(20)YesNULL
TIMER_ENDbigint(20)YesNULL
TIMER_WAITbigint(20)YesNULL
NESTING_EVENT_IDbigint(20)YesNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')YesNULL

events_stages_history

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_IDbigint(20)No
END_EVENT_IDbigint(20)YesNULL
EVENT_NAMEvarchar(128)No
SOURCEvarchar(64)YesNULL
TIMER_STARTbigint(20)YesNULL
TIMER_ENDbigint(20)YesNULL
TIMER_WAITbigint(20)YesNULL
NESTING_EVENT_IDbigint(20)YesNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')YesNULL

events_stages_history_long

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_IDbigint(20)No
END_EVENT_IDbigint(20)YesNULL
EVENT_NAMEvarchar(128)No
SOURCEvarchar(64)YesNULL
TIMER_STARTbigint(20)YesNULL
TIMER_ENDbigint(20)YesNULL
TIMER_WAITbigint(20)YesNULL
NESTING_EVENT_IDbigint(20)YesNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')YesNULL

events_stages_summary_by_account_by_event_name

ColumnTypeNullDefault Links to Comments MIME
USERchar(16)YesNULL
HOSTchar(60)YesNULL
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_stages_summary_by_host_by_event_name

ColumnTypeNullDefault Links to Comments MIME
HOSTchar(60)YesNULL
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_stages_summary_by_thread_by_event_name

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_stages_summary_by_user_by_event_name

ColumnTypeNullDefault Links to Comments MIME
USERchar(16)YesNULL
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_stages_summary_global_by_event_name

ColumnTypeNullDefault Links to Comments MIME
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_statements_current

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_IDbigint(20)No
END_EVENT_IDbigint(20)YesNULL
EVENT_NAMEvarchar(128)No
SOURCEvarchar(64)YesNULL
TIMER_STARTbigint(20)YesNULL
TIMER_ENDbigint(20)YesNULL
TIMER_WAITbigint(20)YesNULL
LOCK_TIMEbigint(20)No
SQL_TEXTlongtextYesNULL
DIGESTvarchar(32)YesNULL
DIGEST_TEXTlongtextYesNULL
CURRENT_SCHEMAvarchar(64)YesNULL
OBJECT_TYPEvarchar(64)YesNULL
OBJECT_SCHEMAvarchar(64)YesNULL
OBJECT_NAMEvarchar(64)YesNULL
OBJECT_INSTANCE_BEGINbigint(20)YesNULL
MYSQL_ERRNOint(11)YesNULL
RETURNED_SQLSTATEvarchar(5)YesNULL
MESSAGE_TEXTvarchar(128)YesNULL
ERRORSbigint(20)No
WARNINGSbigint(20)No
ROWS_AFFECTEDbigint(20)No
ROWS_SENTbigint(20)No
ROWS_EXAMINEDbigint(20)No
CREATED_TMP_DISK_TABLESbigint(20)No
CREATED_TMP_TABLESbigint(20)No
SELECT_FULL_JOINbigint(20)No
SELECT_FULL_RANGE_JOINbigint(20)No
SELECT_RANGEbigint(20)No
SELECT_RANGE_CHECKbigint(20)No
SELECT_SCANbigint(20)No
SORT_MERGE_PASSESbigint(20)No
SORT_RANGEbigint(20)No
SORT_ROWSbigint(20)No
SORT_SCANbigint(20)No
NO_INDEX_USEDbigint(20)No
NO_GOOD_INDEX_USEDbigint(20)No
NESTING_EVENT_IDbigint(20)YesNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')YesNULL

events_statements_history

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_IDbigint(20)No
END_EVENT_IDbigint(20)YesNULL
EVENT_NAMEvarchar(128)No
SOURCEvarchar(64)YesNULL
TIMER_STARTbigint(20)YesNULL
TIMER_ENDbigint(20)YesNULL
TIMER_WAITbigint(20)YesNULL
LOCK_TIMEbigint(20)No
SQL_TEXTlongtextYesNULL
DIGESTvarchar(32)YesNULL
DIGEST_TEXTlongtextYesNULL
CURRENT_SCHEMAvarchar(64)YesNULL
OBJECT_TYPEvarchar(64)YesNULL
OBJECT_SCHEMAvarchar(64)YesNULL
OBJECT_NAMEvarchar(64)YesNULL
OBJECT_INSTANCE_BEGINbigint(20)YesNULL
MYSQL_ERRNOint(11)YesNULL
RETURNED_SQLSTATEvarchar(5)YesNULL
MESSAGE_TEXTvarchar(128)YesNULL
ERRORSbigint(20)No
WARNINGSbigint(20)No
ROWS_AFFECTEDbigint(20)No
ROWS_SENTbigint(20)No
ROWS_EXAMINEDbigint(20)No
CREATED_TMP_DISK_TABLESbigint(20)No
CREATED_TMP_TABLESbigint(20)No
SELECT_FULL_JOINbigint(20)No
SELECT_FULL_RANGE_JOINbigint(20)No
SELECT_RANGEbigint(20)No
SELECT_RANGE_CHECKbigint(20)No
SELECT_SCANbigint(20)No
SORT_MERGE_PASSESbigint(20)No
SORT_RANGEbigint(20)No
SORT_ROWSbigint(20)No
SORT_SCANbigint(20)No
NO_INDEX_USEDbigint(20)No
NO_GOOD_INDEX_USEDbigint(20)No
NESTING_EVENT_IDbigint(20)YesNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')YesNULL

events_statements_history_long

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_IDbigint(20)No
END_EVENT_IDbigint(20)YesNULL
EVENT_NAMEvarchar(128)No
SOURCEvarchar(64)YesNULL
TIMER_STARTbigint(20)YesNULL
TIMER_ENDbigint(20)YesNULL
TIMER_WAITbigint(20)YesNULL
LOCK_TIMEbigint(20)No
SQL_TEXTlongtextYesNULL
DIGESTvarchar(32)YesNULL
DIGEST_TEXTlongtextYesNULL
CURRENT_SCHEMAvarchar(64)YesNULL
OBJECT_TYPEvarchar(64)YesNULL
OBJECT_SCHEMAvarchar(64)YesNULL
OBJECT_NAMEvarchar(64)YesNULL
OBJECT_INSTANCE_BEGINbigint(20)YesNULL
MYSQL_ERRNOint(11)YesNULL
RETURNED_SQLSTATEvarchar(5)YesNULL
MESSAGE_TEXTvarchar(128)YesNULL
ERRORSbigint(20)No
WARNINGSbigint(20)No
ROWS_AFFECTEDbigint(20)No
ROWS_SENTbigint(20)No
ROWS_EXAMINEDbigint(20)No
CREATED_TMP_DISK_TABLESbigint(20)No
CREATED_TMP_TABLESbigint(20)No
SELECT_FULL_JOINbigint(20)No
SELECT_FULL_RANGE_JOINbigint(20)No
SELECT_RANGEbigint(20)No
SELECT_RANGE_CHECKbigint(20)No
SELECT_SCANbigint(20)No
SORT_MERGE_PASSESbigint(20)No
SORT_RANGEbigint(20)No
SORT_ROWSbigint(20)No
SORT_SCANbigint(20)No
NO_INDEX_USEDbigint(20)No
NO_GOOD_INDEX_USEDbigint(20)No
NESTING_EVENT_IDbigint(20)YesNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')YesNULL

events_statements_summary_by_account_by_event_name

ColumnTypeNullDefault Links to Comments MIME
USERchar(16)YesNULL
HOSTchar(60)YesNULL
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
SUM_LOCK_TIMEbigint(20)No
SUM_ERRORSbigint(20)No
SUM_WARNINGSbigint(20)No
SUM_ROWS_AFFECTEDbigint(20)No
SUM_ROWS_SENTbigint(20)No
SUM_ROWS_EXAMINEDbigint(20)No
SUM_CREATED_TMP_DISK_TABLESbigint(20)No
SUM_CREATED_TMP_TABLESbigint(20)No
SUM_SELECT_FULL_JOINbigint(20)No
SUM_SELECT_FULL_RANGE_JOINbigint(20)No
SUM_SELECT_RANGEbigint(20)No
SUM_SELECT_RANGE_CHECKbigint(20)No
SUM_SELECT_SCANbigint(20)No
SUM_SORT_MERGE_PASSESbigint(20)No
SUM_SORT_RANGEbigint(20)No
SUM_SORT_ROWSbigint(20)No
SUM_SORT_SCANbigint(20)No
SUM_NO_INDEX_USEDbigint(20)No
SUM_NO_GOOD_INDEX_USEDbigint(20)No

events_statements_summary_by_digest

ColumnTypeNullDefault Links to Comments MIME
SCHEMA_NAMEvarchar(64)YesNULL
DIGESTvarchar(32)YesNULL
DIGEST_TEXTlongtextYesNULL
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
SUM_LOCK_TIMEbigint(20)No
SUM_ERRORSbigint(20)No
SUM_WARNINGSbigint(20)No
SUM_ROWS_AFFECTEDbigint(20)No
SUM_ROWS_SENTbigint(20)No
SUM_ROWS_EXAMINEDbigint(20)No
SUM_CREATED_TMP_DISK_TABLESbigint(20)No
SUM_CREATED_TMP_TABLESbigint(20)No
SUM_SELECT_FULL_JOINbigint(20)No
SUM_SELECT_FULL_RANGE_JOINbigint(20)No
SUM_SELECT_RANGEbigint(20)No
SUM_SELECT_RANGE_CHECKbigint(20)No
SUM_SELECT_SCANbigint(20)No
SUM_SORT_MERGE_PASSESbigint(20)No
SUM_SORT_RANGEbigint(20)No
SUM_SORT_ROWSbigint(20)No
SUM_SORT_SCANbigint(20)No
SUM_NO_INDEX_USEDbigint(20)No
SUM_NO_GOOD_INDEX_USEDbigint(20)No
FIRST_SEENtimestampNo0000-00-00 00:00:00
LAST_SEENtimestampNo0000-00-00 00:00:00

events_statements_summary_by_host_by_event_name

ColumnTypeNullDefault Links to Comments MIME
HOSTchar(60)YesNULL
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
SUM_LOCK_TIMEbigint(20)No
SUM_ERRORSbigint(20)No
SUM_WARNINGSbigint(20)No
SUM_ROWS_AFFECTEDbigint(20)No
SUM_ROWS_SENTbigint(20)No
SUM_ROWS_EXAMINEDbigint(20)No
SUM_CREATED_TMP_DISK_TABLESbigint(20)No
SUM_CREATED_TMP_TABLESbigint(20)No
SUM_SELECT_FULL_JOINbigint(20)No
SUM_SELECT_FULL_RANGE_JOINbigint(20)No
SUM_SELECT_RANGEbigint(20)No
SUM_SELECT_RANGE_CHECKbigint(20)No
SUM_SELECT_SCANbigint(20)No
SUM_SORT_MERGE_PASSESbigint(20)No
SUM_SORT_RANGEbigint(20)No
SUM_SORT_ROWSbigint(20)No
SUM_SORT_SCANbigint(20)No
SUM_NO_INDEX_USEDbigint(20)No
SUM_NO_GOOD_INDEX_USEDbigint(20)No

events_statements_summary_by_thread_by_event_name

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
SUM_LOCK_TIMEbigint(20)No
SUM_ERRORSbigint(20)No
SUM_WARNINGSbigint(20)No
SUM_ROWS_AFFECTEDbigint(20)No
SUM_ROWS_SENTbigint(20)No
SUM_ROWS_EXAMINEDbigint(20)No
SUM_CREATED_TMP_DISK_TABLESbigint(20)No
SUM_CREATED_TMP_TABLESbigint(20)No
SUM_SELECT_FULL_JOINbigint(20)No
SUM_SELECT_FULL_RANGE_JOINbigint(20)No
SUM_SELECT_RANGEbigint(20)No
SUM_SELECT_RANGE_CHECKbigint(20)No
SUM_SELECT_SCANbigint(20)No
SUM_SORT_MERGE_PASSESbigint(20)No
SUM_SORT_RANGEbigint(20)No
SUM_SORT_ROWSbigint(20)No
SUM_SORT_SCANbigint(20)No
SUM_NO_INDEX_USEDbigint(20)No
SUM_NO_GOOD_INDEX_USEDbigint(20)No

events_statements_summary_by_user_by_event_name

ColumnTypeNullDefault Links to Comments MIME
USERchar(16)YesNULL
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
SUM_LOCK_TIMEbigint(20)No
SUM_ERRORSbigint(20)No
SUM_WARNINGSbigint(20)No
SUM_ROWS_AFFECTEDbigint(20)No
SUM_ROWS_SENTbigint(20)No
SUM_ROWS_EXAMINEDbigint(20)No
SUM_CREATED_TMP_DISK_TABLESbigint(20)No
SUM_CREATED_TMP_TABLESbigint(20)No
SUM_SELECT_FULL_JOINbigint(20)No
SUM_SELECT_FULL_RANGE_JOINbigint(20)No
SUM_SELECT_RANGEbigint(20)No
SUM_SELECT_RANGE_CHECKbigint(20)No
SUM_SELECT_SCANbigint(20)No
SUM_SORT_MERGE_PASSESbigint(20)No
SUM_SORT_RANGEbigint(20)No
SUM_SORT_ROWSbigint(20)No
SUM_SORT_SCANbigint(20)No
SUM_NO_INDEX_USEDbigint(20)No
SUM_NO_GOOD_INDEX_USEDbigint(20)No

events_statements_summary_global_by_event_name

ColumnTypeNullDefault Links to Comments MIME
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
SUM_LOCK_TIMEbigint(20)No
SUM_ERRORSbigint(20)No
SUM_WARNINGSbigint(20)No
SUM_ROWS_AFFECTEDbigint(20)No
SUM_ROWS_SENTbigint(20)No
SUM_ROWS_EXAMINEDbigint(20)No
SUM_CREATED_TMP_DISK_TABLESbigint(20)No
SUM_CREATED_TMP_TABLESbigint(20)No
SUM_SELECT_FULL_JOINbigint(20)No
SUM_SELECT_FULL_RANGE_JOINbigint(20)No
SUM_SELECT_RANGEbigint(20)No
SUM_SELECT_RANGE_CHECKbigint(20)No
SUM_SELECT_SCANbigint(20)No
SUM_SORT_MERGE_PASSESbigint(20)No
SUM_SORT_RANGEbigint(20)No
SUM_SORT_ROWSbigint(20)No
SUM_SORT_SCANbigint(20)No
SUM_NO_INDEX_USEDbigint(20)No
SUM_NO_GOOD_INDEX_USEDbigint(20)No

events_waits_current

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_IDbigint(20)No
END_EVENT_IDbigint(20)YesNULL
EVENT_NAMEvarchar(128)No
SOURCEvarchar(64)YesNULL
TIMER_STARTbigint(20)YesNULL
TIMER_ENDbigint(20)YesNULL
TIMER_WAITbigint(20)YesNULL
SPINSint(10)YesNULL
OBJECT_SCHEMAvarchar(64)YesNULL
OBJECT_NAMEvarchar(512)YesNULL
INDEX_NAMEvarchar(64)YesNULL
OBJECT_TYPEvarchar(64)YesNULL
OBJECT_INSTANCE_BEGINbigint(20)No
NESTING_EVENT_IDbigint(20)YesNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')YesNULL
OPERATIONvarchar(32)No
NUMBER_OF_BYTESbigint(20)YesNULL
FLAGSint(10)YesNULL

events_waits_history

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_IDbigint(20)No
END_EVENT_IDbigint(20)YesNULL
EVENT_NAMEvarchar(128)No
SOURCEvarchar(64)YesNULL
TIMER_STARTbigint(20)YesNULL
TIMER_ENDbigint(20)YesNULL
TIMER_WAITbigint(20)YesNULL
SPINSint(10)YesNULL
OBJECT_SCHEMAvarchar(64)YesNULL
OBJECT_NAMEvarchar(512)YesNULL
INDEX_NAMEvarchar(64)YesNULL
OBJECT_TYPEvarchar(64)YesNULL
OBJECT_INSTANCE_BEGINbigint(20)No
NESTING_EVENT_IDbigint(20)YesNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')YesNULL
OPERATIONvarchar(32)No
NUMBER_OF_BYTESbigint(20)YesNULL
FLAGSint(10)YesNULL

events_waits_history_long

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_IDbigint(20)No
END_EVENT_IDbigint(20)YesNULL
EVENT_NAMEvarchar(128)No
SOURCEvarchar(64)YesNULL
TIMER_STARTbigint(20)YesNULL
TIMER_ENDbigint(20)YesNULL
TIMER_WAITbigint(20)YesNULL
SPINSint(10)YesNULL
OBJECT_SCHEMAvarchar(64)YesNULL
OBJECT_NAMEvarchar(512)YesNULL
INDEX_NAMEvarchar(64)YesNULL
OBJECT_TYPEvarchar(64)YesNULL
OBJECT_INSTANCE_BEGINbigint(20)No
NESTING_EVENT_IDbigint(20)YesNULL
NESTING_EVENT_TYPEenum('STATEMENT', 'STAGE', 'WAIT')YesNULL
OPERATIONvarchar(32)No
NUMBER_OF_BYTESbigint(20)YesNULL
FLAGSint(10)YesNULL

events_waits_summary_by_account_by_event_name

ColumnTypeNullDefault Links to Comments MIME
USERchar(16)YesNULL
HOSTchar(60)YesNULL
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_waits_summary_by_host_by_event_name

ColumnTypeNullDefault Links to Comments MIME
HOSTchar(60)YesNULL
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_waits_summary_by_instance

ColumnTypeNullDefault Links to Comments MIME
EVENT_NAMEvarchar(128)No
OBJECT_INSTANCE_BEGINbigint(20)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_waits_summary_by_thread_by_event_name

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_waits_summary_by_user_by_event_name

ColumnTypeNullDefault Links to Comments MIME
USERchar(16)YesNULL
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

events_waits_summary_global_by_event_name

ColumnTypeNullDefault Links to Comments MIME
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

file_instances

ColumnTypeNullDefault Links to Comments MIME
FILE_NAMEvarchar(512)No
EVENT_NAMEvarchar(128)No
OPEN_COUNTint(10)No

file_summary_by_event_name

ColumnTypeNullDefault Links to Comments MIME
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
COUNT_READbigint(20)No
SUM_TIMER_READbigint(20)No
MIN_TIMER_READbigint(20)No
AVG_TIMER_READbigint(20)No
MAX_TIMER_READbigint(20)No
SUM_NUMBER_OF_BYTES_READbigint(20)No
COUNT_WRITEbigint(20)No
SUM_TIMER_WRITEbigint(20)No
MIN_TIMER_WRITEbigint(20)No
AVG_TIMER_WRITEbigint(20)No
MAX_TIMER_WRITEbigint(20)No
SUM_NUMBER_OF_BYTES_WRITEbigint(20)No
COUNT_MISCbigint(20)No
SUM_TIMER_MISCbigint(20)No
MIN_TIMER_MISCbigint(20)No
AVG_TIMER_MISCbigint(20)No
MAX_TIMER_MISCbigint(20)No

file_summary_by_instance

ColumnTypeNullDefault Links to Comments MIME
FILE_NAMEvarchar(512)No
EVENT_NAMEvarchar(128)No
OBJECT_INSTANCE_BEGINbigint(20)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
COUNT_READbigint(20)No
SUM_TIMER_READbigint(20)No
MIN_TIMER_READbigint(20)No
AVG_TIMER_READbigint(20)No
MAX_TIMER_READbigint(20)No
SUM_NUMBER_OF_BYTES_READbigint(20)No
COUNT_WRITEbigint(20)No
SUM_TIMER_WRITEbigint(20)No
MIN_TIMER_WRITEbigint(20)No
AVG_TIMER_WRITEbigint(20)No
MAX_TIMER_WRITEbigint(20)No
SUM_NUMBER_OF_BYTES_WRITEbigint(20)No
COUNT_MISCbigint(20)No
SUM_TIMER_MISCbigint(20)No
MIN_TIMER_MISCbigint(20)No
AVG_TIMER_MISCbigint(20)No
MAX_TIMER_MISCbigint(20)No

host_cache

ColumnTypeNullDefault Links to Comments MIME
IPvarchar(64)No
HOSTvarchar(255)YesNULL
HOST_VALIDATEDenum('YES', 'NO')No
SUM_CONNECT_ERRORSbigint(20)No
COUNT_HOST_BLOCKED_ERRORSbigint(20)No
COUNT_NAMEINFO_TRANSIENT_ERRORSbigint(20)No
COUNT_NAMEINFO_PERMANENT_ERRORSbigint(20)No
COUNT_FORMAT_ERRORSbigint(20)No
COUNT_ADDRINFO_TRANSIENT_ERRORSbigint(20)No
COUNT_ADDRINFO_PERMANENT_ERRORSbigint(20)No
COUNT_FCRDNS_ERRORSbigint(20)No
COUNT_HOST_ACL_ERRORSbigint(20)No
COUNT_NO_AUTH_PLUGIN_ERRORSbigint(20)No
COUNT_AUTH_PLUGIN_ERRORSbigint(20)No
COUNT_HANDSHAKE_ERRORSbigint(20)No
COUNT_PROXY_USER_ERRORSbigint(20)No
COUNT_PROXY_USER_ACL_ERRORSbigint(20)No
COUNT_AUTHENTICATION_ERRORSbigint(20)No
COUNT_SSL_ERRORSbigint(20)No
COUNT_MAX_USER_CONNECTIONS_ERRORSbigint(20)No
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORSbigint(20)No
COUNT_DEFAULT_DATABASE_ERRORSbigint(20)No
COUNT_INIT_CONNECT_ERRORSbigint(20)No
COUNT_LOCAL_ERRORSbigint(20)No
COUNT_UNKNOWN_ERRORSbigint(20)No
FIRST_SEENtimestampNo0000-00-00 00:00:00
LAST_SEENtimestampNo0000-00-00 00:00:00
FIRST_ERROR_SEENtimestampYes0000-00-00 00:00:00
LAST_ERROR_SEENtimestampYes0000-00-00 00:00:00

hosts

ColumnTypeNullDefault Links to Comments MIME
HOSTchar(60)YesNULL
CURRENT_CONNECTIONSbigint(20)No
TOTAL_CONNECTIONSbigint(20)No

mutex_instances

ColumnTypeNullDefault Links to Comments MIME
NAMEvarchar(128)No
OBJECT_INSTANCE_BEGINbigint(20)No
LOCKED_BY_THREAD_IDbigint(20)YesNULL

objects_summary_global_by_type

ColumnTypeNullDefault Links to Comments MIME
OBJECT_TYPEvarchar(64)YesNULL
OBJECT_SCHEMAvarchar(64)YesNULL
OBJECT_NAMEvarchar(64)YesNULL
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No

performance_timers

ColumnTypeNullDefault Links to Comments MIME
TIMER_NAMEenum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')No
TIMER_FREQUENCYbigint(20)YesNULL
TIMER_RESOLUTIONbigint(20)YesNULL
TIMER_OVERHEADbigint(20)YesNULL

rwlock_instances

ColumnTypeNullDefault Links to Comments MIME
NAMEvarchar(128)No
OBJECT_INSTANCE_BEGINbigint(20)No
WRITE_LOCKED_BY_THREAD_IDbigint(20)YesNULL
READ_LOCKED_BY_COUNTint(10)No

session_account_connect_attrs

ColumnTypeNullDefault Links to Comments MIME
PROCESSLIST_IDint(11)No
ATTR_NAMEvarchar(32)No
ATTR_VALUEvarchar(1024)YesNULL
ORDINAL_POSITIONint(11)YesNULL

session_connect_attrs

ColumnTypeNullDefault Links to Comments MIME
PROCESSLIST_IDint(11)No
ATTR_NAMEvarchar(32)No
ATTR_VALUEvarchar(1024)YesNULL
ORDINAL_POSITIONint(11)YesNULL

setup_actors

ColumnTypeNullDefault Links to Comments MIME
HOSTchar(60)No%
USERchar(16)No%
ROLEchar(16)No%

setup_consumers

ColumnTypeNullDefault Links to Comments MIME
NAMEvarchar(64)No
ENABLEDenum('YES', 'NO')No

setup_instruments

ColumnTypeNullDefault Links to Comments MIME
NAMEvarchar(128)No
ENABLEDenum('YES', 'NO')No
TIMEDenum('YES', 'NO')No

setup_objects

ColumnTypeNullDefault Links to Comments MIME
OBJECT_TYPEenum('TABLE')NoTABLE
OBJECT_SCHEMAvarchar(64)Yes%
OBJECT_NAMEvarchar(64)No%
ENABLEDenum('YES', 'NO')NoYES
TIMEDenum('YES', 'NO')NoYES

setup_timers

ColumnTypeNullDefault Links to Comments MIME
NAMEvarchar(64)No
TIMER_NAMEenum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK')No

socket_instances

ColumnTypeNullDefault Links to Comments MIME
EVENT_NAMEvarchar(128)No
OBJECT_INSTANCE_BEGINbigint(20)No
THREAD_IDbigint(20)YesNULL
SOCKET_IDint(11)No
IPvarchar(64)No
PORTint(11)No
STATEenum('IDLE', 'ACTIVE')No

socket_summary_by_event_name

ColumnTypeNullDefault Links to Comments MIME
EVENT_NAMEvarchar(128)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
COUNT_READbigint(20)No
SUM_TIMER_READbigint(20)No
MIN_TIMER_READbigint(20)No
AVG_TIMER_READbigint(20)No
MAX_TIMER_READbigint(20)No
SUM_NUMBER_OF_BYTES_READbigint(20)No
COUNT_WRITEbigint(20)No
SUM_TIMER_WRITEbigint(20)No
MIN_TIMER_WRITEbigint(20)No
AVG_TIMER_WRITEbigint(20)No
MAX_TIMER_WRITEbigint(20)No
SUM_NUMBER_OF_BYTES_WRITEbigint(20)No
COUNT_MISCbigint(20)No
SUM_TIMER_MISCbigint(20)No
MIN_TIMER_MISCbigint(20)No
AVG_TIMER_MISCbigint(20)No
MAX_TIMER_MISCbigint(20)No

socket_summary_by_instance

ColumnTypeNullDefault Links to Comments MIME
EVENT_NAMEvarchar(128)No
OBJECT_INSTANCE_BEGINbigint(20)No
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
COUNT_READbigint(20)No
SUM_TIMER_READbigint(20)No
MIN_TIMER_READbigint(20)No
AVG_TIMER_READbigint(20)No
MAX_TIMER_READbigint(20)No
SUM_NUMBER_OF_BYTES_READbigint(20)No
COUNT_WRITEbigint(20)No
SUM_TIMER_WRITEbigint(20)No
MIN_TIMER_WRITEbigint(20)No
AVG_TIMER_WRITEbigint(20)No
MAX_TIMER_WRITEbigint(20)No
SUM_NUMBER_OF_BYTES_WRITEbigint(20)No
COUNT_MISCbigint(20)No
SUM_TIMER_MISCbigint(20)No
MIN_TIMER_MISCbigint(20)No
AVG_TIMER_MISCbigint(20)No
MAX_TIMER_MISCbigint(20)No

table_io_waits_summary_by_index_usage

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

table_io_waits_summary_by_table

ColumnTypeNullDefault Links to Comments MIME
OBJECT_TYPEvarchar(64)YesNULL
OBJECT_SCHEMAvarchar(64)YesNULL
OBJECT_NAMEvarchar(64)YesNULL
COUNT_STARbigint(20)No
SUM_TIMER_WAITbigint(20)No
MIN_TIMER_WAITbigint(20)No
AVG_TIMER_WAITbigint(20)No
MAX_TIMER_WAITbigint(20)No
COUNT_READbigint(20)No
SUM_TIMER_READbigint(20)No
MIN_TIMER_READbigint(20)No
AVG_TIMER_READbigint(20)No
MAX_TIMER_READbigint(20)No
COUNT_WRITEbigint(20)No
SUM_TIMER_WRITEbigint(20)No
MIN_TIMER_WRITEbigint(20)No
AVG_TIMER_WRITEbigint(20)No
MAX_TIMER_WRITEbigint(20)No
COUNT_FETCHbigint(20)No
SUM_TIMER_FETCHbigint(20)No
MIN_TIMER_FETCHbigint(20)No
AVG_TIMER_FETCHbigint(20)No
MAX_TIMER_FETCHbigint(20)No
COUNT_INSERTbigint(20)No
SUM_TIMER_INSERTbigint(20)No
MIN_TIMER_INSERTbigint(20)No
AVG_TIMER_INSERTbigint(20)No
MAX_TIMER_INSERTbigint(20)No
COUNT_UPDATEbigint(20)No
SUM_TIMER_UPDATEbigint(20)No
MIN_TIMER_UPDATEbigint(20)No
AVG_TIMER_UPDATEbigint(20)No
MAX_TIMER_UPDATEbigint(20)No
COUNT_DELETEbigint(20)No
SUM_TIMER_DELETEbigint(20)No
MIN_TIMER_DELETEbigint(20)No
AVG_TIMER_DELETEbigint(20)No
MAX_TIMER_DELETEbigint(20)No

table_lock_waits_summary_by_table

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

threads

ColumnTypeNullDefault Links to Comments MIME
THREAD_IDbigint(20)No
NAMEvarchar(128)No
TYPEvarchar(10)No
PROCESSLIST_IDbigint(20)YesNULL
PROCESSLIST_USERvarchar(16)YesNULL
PROCESSLIST_HOSTvarchar(60)YesNULL
PROCESSLIST_DBvarchar(64)YesNULL
PROCESSLIST_COMMANDvarchar(16)YesNULL
PROCESSLIST_TIMEbigint(20)YesNULL
PROCESSLIST_STATEvarchar(64)YesNULL
PROCESSLIST_INFOlongtextYesNULL
PARENT_THREAD_IDbigint(20)YesNULL
ROLEvarchar(64)YesNULL
INSTRUMENTEDenum('YES', 'NO')No

users

ColumnTypeNullDefault Links to Comments MIME
USERchar(16)YesNULL
CURRENT_CONNECTIONSbigint(20)No
TOTAL_CONNECTIONSbigint(20)No
Notice in ./templates/database/designer/js_fields.phtml#5
Undefined index: token

Backtrace

./libraries/Template.class.php#80: include(./templates/database/designer/js_fields.phtml)
./libraries/db_designer.lib.php#152: PMA\Template->render(array)
./db_designer.php#148: PMA_getHtmlForJSFields(
array,
array,
array,
integer -1,
)