performance_schema

accounts

Column Type Null Default Comments
USER char(16) Yes NULL
HOST char(60) Yes NULL
CURRENT_CONNECTIONS bigint(20) No
TOTAL_CONNECTIONS bigint(20) No

cond_instances

Column Type Null Default Comments
NAME varchar(128) No
OBJECT_INSTANCE_BEGIN bigint(20) No

events_stages_current

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Yes NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Yes NULL
TIMER_START bigint(20) Yes NULL
TIMER_END bigint(20) Yes NULL
TIMER_WAIT bigint(20) Yes NULL
NESTING_EVENT_ID bigint(20) Yes NULL
NESTING_EVENT_TYPE enum('STATEMENT', 'STAGE', 'WAIT') Yes NULL

events_stages_history

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Yes NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Yes NULL
TIMER_START bigint(20) Yes NULL
TIMER_END bigint(20) Yes NULL
TIMER_WAIT bigint(20) Yes NULL
NESTING_EVENT_ID bigint(20) Yes NULL
NESTING_EVENT_TYPE enum('STATEMENT', 'STAGE', 'WAIT') Yes NULL

events_stages_history_long

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Yes NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Yes NULL
TIMER_START bigint(20) Yes NULL
TIMER_END bigint(20) Yes NULL
TIMER_WAIT bigint(20) Yes NULL
NESTING_EVENT_ID bigint(20) Yes NULL
NESTING_EVENT_TYPE enum('STATEMENT', 'STAGE', 'WAIT') Yes NULL

events_stages_summary_by_account_by_event_name

Column Type Null Default Comments
USER char(16) Yes NULL
HOST char(60) Yes NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_stages_summary_by_host_by_event_name

Column Type Null Default Comments
HOST char(60) Yes NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_stages_summary_by_thread_by_event_name

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_stages_summary_by_user_by_event_name

Column Type Null Default Comments
USER char(16) Yes NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_stages_summary_global_by_event_name

Column Type Null Default Comments
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_statements_current

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Yes NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Yes NULL
TIMER_START bigint(20) Yes NULL
TIMER_END bigint(20) Yes NULL
TIMER_WAIT bigint(20) Yes NULL
LOCK_TIME bigint(20) No
SQL_TEXT longtext Yes NULL
DIGEST varchar(32) Yes NULL
DIGEST_TEXT longtext Yes NULL
CURRENT_SCHEMA varchar(64) Yes NULL
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(64) Yes NULL
OBJECT_INSTANCE_BEGIN bigint(20) Yes NULL
MYSQL_ERRNO int(11) Yes NULL
RETURNED_SQLSTATE varchar(5) Yes NULL
MESSAGE_TEXT varchar(128) Yes NULL
ERRORS bigint(20) No
WARNINGS bigint(20) No
ROWS_AFFECTED bigint(20) No
ROWS_SENT bigint(20) No
ROWS_EXAMINED bigint(20) No
CREATED_TMP_DISK_TABLES bigint(20) No
CREATED_TMP_TABLES bigint(20) No
SELECT_FULL_JOIN bigint(20) No
SELECT_FULL_RANGE_JOIN bigint(20) No
SELECT_RANGE bigint(20) No
SELECT_RANGE_CHECK bigint(20) No
SELECT_SCAN bigint(20) No
SORT_MERGE_PASSES bigint(20) No
SORT_RANGE bigint(20) No
SORT_ROWS bigint(20) No
SORT_SCAN bigint(20) No
NO_INDEX_USED bigint(20) No
NO_GOOD_INDEX_USED bigint(20) No
NESTING_EVENT_ID bigint(20) Yes NULL
NESTING_EVENT_TYPE enum('STATEMENT', 'STAGE', 'WAIT') Yes NULL

events_statements_history

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Yes NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Yes NULL
TIMER_START bigint(20) Yes NULL
TIMER_END bigint(20) Yes NULL
TIMER_WAIT bigint(20) Yes NULL
LOCK_TIME bigint(20) No
SQL_TEXT longtext Yes NULL
DIGEST varchar(32) Yes NULL
DIGEST_TEXT longtext Yes NULL
CURRENT_SCHEMA varchar(64) Yes NULL
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(64) Yes NULL
OBJECT_INSTANCE_BEGIN bigint(20) Yes NULL
MYSQL_ERRNO int(11) Yes NULL
RETURNED_SQLSTATE varchar(5) Yes NULL
MESSAGE_TEXT varchar(128) Yes NULL
ERRORS bigint(20) No
WARNINGS bigint(20) No
ROWS_AFFECTED bigint(20) No
ROWS_SENT bigint(20) No
ROWS_EXAMINED bigint(20) No
CREATED_TMP_DISK_TABLES bigint(20) No
CREATED_TMP_TABLES bigint(20) No
SELECT_FULL_JOIN bigint(20) No
SELECT_FULL_RANGE_JOIN bigint(20) No
SELECT_RANGE bigint(20) No
SELECT_RANGE_CHECK bigint(20) No
SELECT_SCAN bigint(20) No
SORT_MERGE_PASSES bigint(20) No
SORT_RANGE bigint(20) No
SORT_ROWS bigint(20) No
SORT_SCAN bigint(20) No
NO_INDEX_USED bigint(20) No
NO_GOOD_INDEX_USED bigint(20) No
NESTING_EVENT_ID bigint(20) Yes NULL
NESTING_EVENT_TYPE enum('STATEMENT', 'STAGE', 'WAIT') Yes NULL

events_statements_history_long

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Yes NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Yes NULL
TIMER_START bigint(20) Yes NULL
TIMER_END bigint(20) Yes NULL
TIMER_WAIT bigint(20) Yes NULL
LOCK_TIME bigint(20) No
SQL_TEXT longtext Yes NULL
DIGEST varchar(32) Yes NULL
DIGEST_TEXT longtext Yes NULL
CURRENT_SCHEMA varchar(64) Yes NULL
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(64) Yes NULL
OBJECT_INSTANCE_BEGIN bigint(20) Yes NULL
MYSQL_ERRNO int(11) Yes NULL
RETURNED_SQLSTATE varchar(5) Yes NULL
MESSAGE_TEXT varchar(128) Yes NULL
ERRORS bigint(20) No
WARNINGS bigint(20) No
ROWS_AFFECTED bigint(20) No
ROWS_SENT bigint(20) No
ROWS_EXAMINED bigint(20) No
CREATED_TMP_DISK_TABLES bigint(20) No
CREATED_TMP_TABLES bigint(20) No
SELECT_FULL_JOIN bigint(20) No
SELECT_FULL_RANGE_JOIN bigint(20) No
SELECT_RANGE bigint(20) No
SELECT_RANGE_CHECK bigint(20) No
SELECT_SCAN bigint(20) No
SORT_MERGE_PASSES bigint(20) No
SORT_RANGE bigint(20) No
SORT_ROWS bigint(20) No
SORT_SCAN bigint(20) No
NO_INDEX_USED bigint(20) No
NO_GOOD_INDEX_USED bigint(20) No
NESTING_EVENT_ID bigint(20) Yes NULL
NESTING_EVENT_TYPE enum('STATEMENT', 'STAGE', 'WAIT') Yes NULL

events_statements_summary_by_account_by_event_name

Column Type Null Default Comments
USER char(16) Yes NULL
HOST char(60) Yes NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

events_statements_summary_by_digest

Column Type Null Default Comments
SCHEMA_NAME varchar(64) Yes NULL
DIGEST varchar(32) Yes NULL
DIGEST_TEXT longtext Yes NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No
FIRST_SEEN timestamp No 0000-00-00 00:00:00
LAST_SEEN timestamp No 0000-00-00 00:00:00

events_statements_summary_by_host_by_event_name

Column Type Null Default Comments
HOST char(60) Yes NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

events_statements_summary_by_thread_by_event_name

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

events_statements_summary_by_user_by_event_name

Column Type Null Default Comments
USER char(16) Yes NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

events_statements_summary_global_by_event_name

Column Type Null Default Comments
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
SUM_LOCK_TIME bigint(20) No
SUM_ERRORS bigint(20) No
SUM_WARNINGS bigint(20) No
SUM_ROWS_AFFECTED bigint(20) No
SUM_ROWS_SENT bigint(20) No
SUM_ROWS_EXAMINED bigint(20) No
SUM_CREATED_TMP_DISK_TABLES bigint(20) No
SUM_CREATED_TMP_TABLES bigint(20) No
SUM_SELECT_FULL_JOIN bigint(20) No
SUM_SELECT_FULL_RANGE_JOIN bigint(20) No
SUM_SELECT_RANGE bigint(20) No
SUM_SELECT_RANGE_CHECK bigint(20) No
SUM_SELECT_SCAN bigint(20) No
SUM_SORT_MERGE_PASSES bigint(20) No
SUM_SORT_RANGE bigint(20) No
SUM_SORT_ROWS bigint(20) No
SUM_SORT_SCAN bigint(20) No
SUM_NO_INDEX_USED bigint(20) No
SUM_NO_GOOD_INDEX_USED bigint(20) No

events_waits_current

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Yes NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Yes NULL
TIMER_START bigint(20) Yes NULL
TIMER_END bigint(20) Yes NULL
TIMER_WAIT bigint(20) Yes NULL
SPINS int(10) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(512) Yes NULL
INDEX_NAME varchar(64) Yes NULL
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
NESTING_EVENT_ID bigint(20) Yes NULL
NESTING_EVENT_TYPE enum('STATEMENT', 'STAGE', 'WAIT') Yes NULL
OPERATION varchar(32) No
NUMBER_OF_BYTES bigint(20) Yes NULL
FLAGS int(10) Yes NULL

events_waits_history

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Yes NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Yes NULL
TIMER_START bigint(20) Yes NULL
TIMER_END bigint(20) Yes NULL
TIMER_WAIT bigint(20) Yes NULL
SPINS int(10) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(512) Yes NULL
INDEX_NAME varchar(64) Yes NULL
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
NESTING_EVENT_ID bigint(20) Yes NULL
NESTING_EVENT_TYPE enum('STATEMENT', 'STAGE', 'WAIT') Yes NULL
OPERATION varchar(32) No
NUMBER_OF_BYTES bigint(20) Yes NULL
FLAGS int(10) Yes NULL

events_waits_history_long

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_ID bigint(20) No
END_EVENT_ID bigint(20) Yes NULL
EVENT_NAME varchar(128) No
SOURCE varchar(64) Yes NULL
TIMER_START bigint(20) Yes NULL
TIMER_END bigint(20) Yes NULL
TIMER_WAIT bigint(20) Yes NULL
SPINS int(10) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(512) Yes NULL
INDEX_NAME varchar(64) Yes NULL
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
NESTING_EVENT_ID bigint(20) Yes NULL
NESTING_EVENT_TYPE enum('STATEMENT', 'STAGE', 'WAIT') Yes NULL
OPERATION varchar(32) No
NUMBER_OF_BYTES bigint(20) Yes NULL
FLAGS int(10) Yes NULL

events_waits_summary_by_account_by_event_name

Column Type Null Default Comments
USER char(16) Yes NULL
HOST char(60) Yes NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_waits_summary_by_host_by_event_name

Column Type Null Default Comments
HOST char(60) Yes NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_waits_summary_by_instance

Column Type Null Default Comments
EVENT_NAME varchar(128) No
OBJECT_INSTANCE_BEGIN bigint(20) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_waits_summary_by_thread_by_event_name

Column Type Null Default Comments
THREAD_ID bigint(20) No
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_waits_summary_by_user_by_event_name

Column Type Null Default Comments
USER char(16) Yes NULL
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

events_waits_summary_global_by_event_name

Column Type Null Default Comments
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

file_instances

Column Type Null Default Comments
FILE_NAME varchar(512) No
EVENT_NAME varchar(128) No
OPEN_COUNT int(10) No

file_summary_by_event_name

Column Type Null Default Comments
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No
COUNT_MISC bigint(20) No
SUM_TIMER_MISC bigint(20) No
MIN_TIMER_MISC bigint(20) No
AVG_TIMER_MISC bigint(20) No
MAX_TIMER_MISC bigint(20) No

file_summary_by_instance

Column Type Null Default Comments
FILE_NAME varchar(512) No
EVENT_NAME varchar(128) No
OBJECT_INSTANCE_BEGIN bigint(20) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No
COUNT_MISC bigint(20) No
SUM_TIMER_MISC bigint(20) No
MIN_TIMER_MISC bigint(20) No
AVG_TIMER_MISC bigint(20) No
MAX_TIMER_MISC bigint(20) No

hosts

Column Type Null Default Comments
HOST char(60) Yes NULL
CURRENT_CONNECTIONS bigint(20) No
TOTAL_CONNECTIONS bigint(20) No

host_cache

Column Type Null Default Comments
IP varchar(64) No
HOST varchar(255) Yes NULL
HOST_VALIDATED enum('YES', 'NO') No
SUM_CONNECT_ERRORS bigint(20) No
COUNT_HOST_BLOCKED_ERRORS bigint(20) No
COUNT_NAMEINFO_TRANSIENT_ERRORS bigint(20) No
COUNT_NAMEINFO_PERMANENT_ERRORS bigint(20) No
COUNT_FORMAT_ERRORS bigint(20) No
COUNT_ADDRINFO_TRANSIENT_ERRORS bigint(20) No
COUNT_ADDRINFO_PERMANENT_ERRORS bigint(20) No
COUNT_FCRDNS_ERRORS bigint(20) No
COUNT_HOST_ACL_ERRORS bigint(20) No
COUNT_NO_AUTH_PLUGIN_ERRORS bigint(20) No
COUNT_AUTH_PLUGIN_ERRORS bigint(20) No
COUNT_HANDSHAKE_ERRORS bigint(20) No
COUNT_PROXY_USER_ERRORS bigint(20) No
COUNT_PROXY_USER_ACL_ERRORS bigint(20) No
COUNT_AUTHENTICATION_ERRORS bigint(20) No
COUNT_SSL_ERRORS bigint(20) No
COUNT_MAX_USER_CONNECTIONS_ERRORS bigint(20) No
COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS bigint(20) No
COUNT_DEFAULT_DATABASE_ERRORS bigint(20) No
COUNT_INIT_CONNECT_ERRORS bigint(20) No
COUNT_LOCAL_ERRORS bigint(20) No
COUNT_UNKNOWN_ERRORS bigint(20) No
FIRST_SEEN timestamp No 0000-00-00 00:00:00
LAST_SEEN timestamp No 0000-00-00 00:00:00
FIRST_ERROR_SEEN timestamp Yes 0000-00-00 00:00:00
LAST_ERROR_SEEN timestamp Yes 0000-00-00 00:00:00

mutex_instances

Column Type Null Default Comments
NAME varchar(128) No
OBJECT_INSTANCE_BEGIN bigint(20) No
LOCKED_BY_THREAD_ID bigint(20) Yes NULL

objects_summary_global_by_type

Column Type Null Default Comments
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(64) Yes NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No

performance_timers

Column Type Null Default Comments
TIMER_NAME enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK') No
TIMER_FREQUENCY bigint(20) Yes NULL
TIMER_RESOLUTION bigint(20) Yes NULL
TIMER_OVERHEAD bigint(20) Yes NULL

rwlock_instances

Column Type Null Default Comments
NAME varchar(128) No
OBJECT_INSTANCE_BEGIN bigint(20) No
WRITE_LOCKED_BY_THREAD_ID bigint(20) Yes NULL
READ_LOCKED_BY_COUNT int(10) No

session_account_connect_attrs

Column Type Null Default Comments
PROCESSLIST_ID int(11) No
ATTR_NAME varchar(32) No
ATTR_VALUE varchar(1024) Yes NULL
ORDINAL_POSITION int(11) Yes NULL

session_connect_attrs

Column Type Null Default Comments
PROCESSLIST_ID int(11) No
ATTR_NAME varchar(32) No
ATTR_VALUE varchar(1024) Yes NULL
ORDINAL_POSITION int(11) Yes NULL

setup_actors

Column Type Null Default Comments
HOST char(60) No %
USER char(16) No %
ROLE char(16) No %

setup_consumers

Column Type Null Default Comments
NAME varchar(64) No
ENABLED enum('YES', 'NO') No

setup_instruments

Column Type Null Default Comments
NAME varchar(128) No
ENABLED enum('YES', 'NO') No
TIMED enum('YES', 'NO') No

setup_objects

Column Type Null Default Comments
OBJECT_TYPE enum('TABLE') No TABLE
OBJECT_SCHEMA varchar(64) Yes %
OBJECT_NAME varchar(64) No %
ENABLED enum('YES', 'NO') No YES
TIMED enum('YES', 'NO') No YES

setup_timers

Column Type Null Default Comments
NAME varchar(64) No
TIMER_NAME enum('CYCLE', 'NANOSECOND', 'MICROSECOND', 'MILLISECOND', 'TICK') No

socket_instances

Column Type Null Default Comments
EVENT_NAME varchar(128) No
OBJECT_INSTANCE_BEGIN bigint(20) No
THREAD_ID bigint(20) Yes NULL
SOCKET_ID int(11) No
IP varchar(64) No
PORT int(11) No
STATE enum('IDLE', 'ACTIVE') No

socket_summary_by_event_name

Column Type Null Default Comments
EVENT_NAME varchar(128) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No
COUNT_MISC bigint(20) No
SUM_TIMER_MISC bigint(20) No
MIN_TIMER_MISC bigint(20) No
AVG_TIMER_MISC bigint(20) No
MAX_TIMER_MISC bigint(20) No

socket_summary_by_instance

Column Type Null Default Comments
EVENT_NAME varchar(128) No
OBJECT_INSTANCE_BEGIN bigint(20) No
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No
COUNT_MISC bigint(20) No
SUM_TIMER_MISC bigint(20) No
MIN_TIMER_MISC bigint(20) No
AVG_TIMER_MISC bigint(20) No
MAX_TIMER_MISC bigint(20) No

table_io_waits_summary_by_index_usage

Column Type Null Default Comments
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(64) Yes NULL
INDEX_NAME varchar(64) Yes NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
COUNT_FETCH bigint(20) No
SUM_TIMER_FETCH bigint(20) No
MIN_TIMER_FETCH bigint(20) No
AVG_TIMER_FETCH bigint(20) No
MAX_TIMER_FETCH bigint(20) No
COUNT_INSERT bigint(20) No
SUM_TIMER_INSERT bigint(20) No
MIN_TIMER_INSERT bigint(20) No
AVG_TIMER_INSERT bigint(20) No
MAX_TIMER_INSERT bigint(20) No
COUNT_UPDATE bigint(20) No
SUM_TIMER_UPDATE bigint(20) No
MIN_TIMER_UPDATE bigint(20) No
AVG_TIMER_UPDATE bigint(20) No
MAX_TIMER_UPDATE bigint(20) No
COUNT_DELETE bigint(20) No
SUM_TIMER_DELETE bigint(20) No
MIN_TIMER_DELETE bigint(20) No
AVG_TIMER_DELETE bigint(20) No
MAX_TIMER_DELETE bigint(20) No

table_io_waits_summary_by_table

Column Type Null Default Comments
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(64) Yes NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
COUNT_FETCH bigint(20) No
SUM_TIMER_FETCH bigint(20) No
MIN_TIMER_FETCH bigint(20) No
AVG_TIMER_FETCH bigint(20) No
MAX_TIMER_FETCH bigint(20) No
COUNT_INSERT bigint(20) No
SUM_TIMER_INSERT bigint(20) No
MIN_TIMER_INSERT bigint(20) No
AVG_TIMER_INSERT bigint(20) No
MAX_TIMER_INSERT bigint(20) No
COUNT_UPDATE bigint(20) No
SUM_TIMER_UPDATE bigint(20) No
MIN_TIMER_UPDATE bigint(20) No
AVG_TIMER_UPDATE bigint(20) No
MAX_TIMER_UPDATE bigint(20) No
COUNT_DELETE bigint(20) No
SUM_TIMER_DELETE bigint(20) No
MIN_TIMER_DELETE bigint(20) No
AVG_TIMER_DELETE bigint(20) No
MAX_TIMER_DELETE bigint(20) No

table_lock_waits_summary_by_table

Column Type Null Default Comments
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_SCHEMA varchar(64) Yes NULL
OBJECT_NAME varchar(64) Yes NULL
COUNT_STAR bigint(20) No
SUM_TIMER_WAIT bigint(20) No
MIN_TIMER_WAIT bigint(20) No
AVG_TIMER_WAIT bigint(20) No
MAX_TIMER_WAIT bigint(20) No
COUNT_READ bigint(20) No
SUM_TIMER_READ bigint(20) No
MIN_TIMER_READ bigint(20) No
AVG_TIMER_READ bigint(20) No
MAX_TIMER_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_TIMER_WRITE bigint(20) No
MIN_TIMER_WRITE bigint(20) No
AVG_TIMER_WRITE bigint(20) No
MAX_TIMER_WRITE bigint(20) No
COUNT_READ_NORMAL bigint(20) No
SUM_TIMER_READ_NORMAL bigint(20) No
MIN_TIMER_READ_NORMAL bigint(20) No
AVG_TIMER_READ_NORMAL bigint(20) No
MAX_TIMER_READ_NORMAL bigint(20) No
COUNT_READ_WITH_SHARED_LOCKS bigint(20) No
SUM_TIMER_READ_WITH_SHARED_LOCKS bigint(20) No
MIN_TIMER_READ_WITH_SHARED_LOCKS bigint(20) No
AVG_TIMER_READ_WITH_SHARED_LOCKS bigint(20) No
MAX_TIMER_READ_WITH_SHARED_LOCKS bigint(20) No
COUNT_READ_HIGH_PRIORITY bigint(20) No
SUM_TIMER_READ_HIGH_PRIORITY bigint(20) No
MIN_TIMER_READ_HIGH_PRIORITY bigint(20) No
AVG_TIMER_READ_HIGH_PRIORITY bigint(20) No
MAX_TIMER_READ_HIGH_PRIORITY bigint(20) No
COUNT_READ_NO_INSERT bigint(20) No
SUM_TIMER_READ_NO_INSERT bigint(20) No
MIN_TIMER_READ_NO_INSERT bigint(20) No
AVG_TIMER_READ_NO_INSERT bigint(20) No
MAX_TIMER_READ_NO_INSERT bigint(20) No
COUNT_READ_EXTERNAL bigint(20) No
SUM_TIMER_READ_EXTERNAL bigint(20) No
MIN_TIMER_READ_EXTERNAL bigint(20) No
AVG_TIMER_READ_EXTERNAL bigint(20) No
MAX_TIMER_READ_EXTERNAL bigint(20) No
COUNT_WRITE_ALLOW_WRITE bigint(20) No
SUM_TIMER_WRITE_ALLOW_WRITE bigint(20) No
MIN_TIMER_WRITE_ALLOW_WRITE bigint(20) No
AVG_TIMER_WRITE_ALLOW_WRITE bigint(20) No
MAX_TIMER_WRITE_ALLOW_WRITE bigint(20) No
COUNT_WRITE_CONCURRENT_INSERT bigint(20) No
SUM_TIMER_WRITE_CONCURRENT_INSERT bigint(20) No
MIN_TIMER_WRITE_CONCURRENT_INSERT bigint(20) No
AVG_TIMER_WRITE_CONCURRENT_INSERT bigint(20) No
MAX_TIMER_WRITE_CONCURRENT_INSERT bigint(20) No
COUNT_WRITE_DELAYED bigint(20) No
SUM_TIMER_WRITE_DELAYED bigint(20) No
MIN_TIMER_WRITE_DELAYED bigint(20) No
AVG_TIMER_WRITE_DELAYED bigint(20) No
MAX_TIMER_WRITE_DELAYED bigint(20) No
COUNT_WRITE_LOW_PRIORITY bigint(20) No
SUM_TIMER_WRITE_LOW_PRIORITY bigint(20) No
MIN_TIMER_WRITE_LOW_PRIORITY bigint(20) No
AVG_TIMER_WRITE_LOW_PRIORITY bigint(20) No
MAX_TIMER_WRITE_LOW_PRIORITY bigint(20) No
COUNT_WRITE_NORMAL bigint(20) No
SUM_TIMER_WRITE_NORMAL bigint(20) No
MIN_TIMER_WRITE_NORMAL bigint(20) No
AVG_TIMER_WRITE_NORMAL bigint(20) No
MAX_TIMER_WRITE_NORMAL bigint(20) No
COUNT_WRITE_EXTERNAL bigint(20) No
SUM_TIMER_WRITE_EXTERNAL bigint(20) No
MIN_TIMER_WRITE_EXTERNAL bigint(20) No
AVG_TIMER_WRITE_EXTERNAL bigint(20) No
MAX_TIMER_WRITE_EXTERNAL bigint(20) No

threads

Column Type Null Default Comments
THREAD_ID bigint(20) No
NAME varchar(128) No
TYPE varchar(10) No
PROCESSLIST_ID bigint(20) Yes NULL
PROCESSLIST_USER varchar(16) Yes NULL
PROCESSLIST_HOST varchar(60) Yes NULL
PROCESSLIST_DB varchar(64) Yes NULL
PROCESSLIST_COMMAND varchar(16) Yes NULL
PROCESSLIST_TIME bigint(20) Yes NULL
PROCESSLIST_STATE varchar(64) Yes NULL
PROCESSLIST_INFO longtext Yes NULL
PARENT_THREAD_ID bigint(20) Yes NULL
ROLE varchar(64) Yes NULL
INSTRUMENTED enum('YES', 'NO') No

users

Column Type Null Default Comments
USER char(16) Yes NULL
CURRENT_CONNECTIONS bigint(20) No
TOTAL_CONNECTIONS bigint(20) No