Difference between revisions of "Performance schema"

From SPGC Document Wiki

Jump to: navigation, search

Revision as of 11:04, 9 August 2016

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	varchar	64	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	64	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

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