cond_instances

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

events_waits_current

Column Type Null Default Comments
THREAD_ID int(11) No
EVENT_ID bigint(20) No
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
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
NESTING_EVENT_ID bigint(20) Yes NULL
OPERATION varchar(16) No
NUMBER_OF_BYTES bigint(20) Yes NULL
FLAGS int(10) Yes NULL

events_waits_history

Column Type Null Default Comments
THREAD_ID int(11) No
EVENT_ID bigint(20) No
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
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
NESTING_EVENT_ID bigint(20) Yes NULL
OPERATION varchar(16) No
NUMBER_OF_BYTES bigint(20) Yes NULL
FLAGS int(10) Yes NULL

events_waits_history_long

Column Type Null Default Comments
THREAD_ID int(11) No
EVENT_ID bigint(20) No
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
OBJECT_TYPE varchar(64) Yes NULL
OBJECT_INSTANCE_BEGIN bigint(20) No
NESTING_EVENT_ID bigint(20) Yes NULL
OPERATION varchar(16) No
NUMBER_OF_BYTES bigint(20) Yes NULL
FLAGS int(10) Yes NULL

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 int(11) 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_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_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No

file_summary_by_instance

Column Type Null Default Comments
FILE_NAME varchar(512) No
EVENT_NAME varchar(128) No
COUNT_READ bigint(20) No
COUNT_WRITE bigint(20) No
SUM_NUMBER_OF_BYTES_READ bigint(20) No
SUM_NUMBER_OF_BYTES_WRITE bigint(20) No

mutex_instances

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

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 int(11) Yes NULL
READ_LOCKED_BY_COUNT int(10) 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_timers

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

threads

Column Type Null Default Comments
THREAD_ID int(11) No
PROCESSLIST_ID int(11) Yes NULL
NAME varchar(128) No