Difference between revisions of "Performance schema"

From SPGC Document Wiki
Jump to: navigation, search
Line 724: Line 724:
 
==performance_timers==
 
==performance_timers==
 
{| class="wikitable" \
 
{| class="wikitable" \
−
!colspan="7" | mutex_instances
+
!colspan="7" | performance_timers
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name
Line 760: Line 760:
 
|No
 
|No
 
|No
 
|No
 +
|}
 +
 +
==rwlock_instances==
 +
{| class="wikitable" \
 +
!colspan="7" | performance_timers
 +
|-
 +
! style="text-align:left;" | 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
 
|}
 
|}

Revision as of 11:27, 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 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"