Performance schema

cond_instances

cond_instances
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
NAME	varchar	128	No	Yes	No
OBJECT_INSTANCE_BEGIN	bigint	20	No	Yes	No

events_waits_current

events_waits_current
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
THREAD_ID	int	11	No	Yes	No
EVENT_ID	bigint	20	No	Yes	Yes
EVENT_NAME	varchar	128	No	Yes	No
SOURCE	varchar	64	No	No	No
TIMER_START	bigint	20	No	No	Yes
TIMER_END	bigint	20	No	No	Yes
TIMER_WAIT	bigint	20	No	No	Yes
SPINS	int	10	No	No	Yes
OBJECT_SCHEMA	varchar	64	No	No	No
OBJECT_NAME	varchar	512	No	No	No
OBJECT_TYPE	varchar	128	No	No	No
OBJECT_INSTANCE_BEGIN	bigint	20	No	Yes	No
NESTING_EVENT_ID	bigint	20	No	No	Yes
OPERATION	varchar	16	No	Yes	No
NUMBER_OF_BYTES	bigint	20	No	No	Yes
FLAGS	int	10	No	No	Yes

events_waits_history

events_waits_current
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
THREAD_ID	int	11	No	Yes	No
EVENT_ID	bigint	20	No	Yes	Yes
EVENT_NAME	varchar	128	No	Yes	No
SOURCE	varchar	64	No	No	No
TIMER_START	bigint	20	No	No	Yes
TIMER_END	bigint	20	No	No	Yes
TIMER_WAIT	bigint	20	No	No	Yes
SPINS	int	10	No	No	Yes
OBJECT_SCHEMA	varchar	64	No	No	No
OBJECT_NAME	varchar	512	No	No	No
OBJECT_TYPE	varchar	128	No	No	No
OBJECT_INSTANCE_BEGIN	bigint	20	No	Yes	No
NESTING_EVENT_ID	bigint	20	No	No	Yes
OPERATION	varchar	16	No	Yes	No
NUMBER_OF_BYTES	bigint	20	No	No	Yes
FLAGS	int	10	No	No	Yes

events_waits_history_long

events_waits_history_long
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
THREAD_ID	int	11	No	Yes	No
EVENT_ID	bigint	20	No	Yes	Yes
EVENT_NAME	varchar	128	No	Yes	No
SOURCE	varchar	64	No	No	No
TIMER_START	bigint	20	No	No	Yes
TIMER_END	bigint	20	No	No	Yes
TIMER_WAIT	bigint	20	No	No	Yes
SPINS	int	10	No	No	Yes
OBJECT_SCHEMA	varchar	64	No	No	No
OBJECT_NAME	varchar	512	No	No	No
OBJECT_TYPE	varchar	128	No	No	No
OBJECT_INSTANCE_BEGIN	bigint	20	No	Yes	No
NESTING_EVENT_ID	bigint	20	No	No	Yes
OPERATION	varchar	16	No	Yes	No
NUMBER_OF_BYTES	bigint	20	No	No	Yes
FLAGS	int	10	No	No	Yes

events_waits_summary_by_thread

events_waits_summary_by_thread
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
THREAD_ID	int	11	No	Yes	No
EVENT_NAME	varchar	128	No	Yes	No
COUNT_STAR	bigint	20	No	Yes	Yes
SUM_TIMER_WAIT	bigint	20	No	Yes	Yes
MIN_TIMER_WAIT	bigint	20	No	Yes	Yes
AVG_TIMER_WAIT	bigint	20	No	Yes	Yes
MAX_TIMER_WAIT	bigint	20	No	Yes	Yes
MIN_TIMER_WAIT	bigint	20	No	Yes	Yes
AVG_TIMER_WAIT	bigint	20	No	Yes	Yes
MAX_TIMER_WAIT	bigint	20	No	Yes	Yes

events_waits_summary_by_global

events_waits_summary_by_global
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
EVENT_NAME	varchar	128	No	Yes	No
COUNT_STAR	bigint	20	No	Yes	Yes
SUM_TIMER_WAIT	bigint	20	No	Yes	Yes
MIN_TIMER_WAIT	bigint	20	No	Yes	Yes
AVG_TIMER_WAIT	bigint	20	No	Yes	Yes
MAX_TIMER_WAIT	bigint	20	No	Yes	Yes
MIN_TIMER_WAIT	bigint	20	No	Yes	Yes
AVG_TIMER_WAIT	bigint	20	No	Yes	Yes
MAX_TIMER_WAIT	bigint	20	No	Yes	Yes

file_instances

file_instances
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FILE_NAME	varchar	512	No	Yes	No
EVENT_NAME	varchar	128	No	Yes	No
OPEN_COUNT	int	10	No	Yes	Yes

file_summary_by_event_by_name

file_summary_by_event_by_name
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
EVENT_NAME	varchar	128	No	Yes	No
COUNT_READ	bigint	20	No	Yes	Yes
COUNT_WRITE	bigint	20	No	Yes	Yes
SUM_NUMBER_OF_BYTES_READ	bigint	20	No	Yes	Yes
SUM_NUMBER_OF_BYTES_WRITE	bigint	20	No	Yes	Yes

file_summary_by_instance

file_summary_by_instance
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
FILE_NAME	varchar	512	No	Yes	No
EVENT_NAME	varchar	128	No	Yes	No
COUNT_READ	bigint	20	No	Yes	Yes
COUNT_WRITE	bigint	20	No	Yes	Yes
SUM_NUMBER_OF_BYTES_READ	bigint	20	No	Yes	Yes
SUM_NUMBER_OF_BYTES_WRITE	bigint	20	No	Yes	Yes

mutex_instances

mutex_instances
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
NAME	varchar	128	No	Yes	No
OBJECT_INSTANCE_BEGIN	bigint	20	No	Yes	No
LOCKED_BY_THREAD_ID	int	11	No	No	No

performance_timers

performance_timers
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
TIMER_NAME	enum	0	No	Yes	No
TIMER_FREQUENCY	bigint	20	No	Yes	No
TIMER_RESOLUTION	bigint	20	No	No	No
TIMER_OVERHEAD	bigint	20	No	No	No

rwlock_instances

rwlock_instances
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
NAME	varchar	128	No	Yes	No
OBJECT_INSTANCE_BEGIN	bigint	20	No	Yes	No
WRITE_LOCKED_BY_THREAD_ID	int	11	No	No	No
READ_LOCKED_BY_COUNT	int	10	No	Yes	Yes

setup_consumer

setup_consumer
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
NAME	varchar	64	No	Yes	No
ENABLED	enum	Y,N	No	Yes	No

setup_instruments

setup_instruments
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
NAME	varchar	128	No	Yes	No
ENABLED	enum	Y,N	No	Yes	No
TIMED	enum	Y,N	No	Yes	No