Performance schema

From SPGC Document Wiki

Revision as of 11:27, 9 August 2016 by Ojt2 (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

Contents

1 cond_instances
2 events_waits_current
3 events_waits_history
4 events_waits_history_long
5 events_waits_summary_by_thread
6 events_waits_summary_by_global
7 file_instances
8 file_summary_by_event_by_name
9 file_summary_by_instance
10 mutex_instances
11 performance_timers
12 rwlock_instances

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

performance_timers
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

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Performance_schema&oldid=2770"