pfs_column_types.h File Reference

Data types for columns used in the performance schema tables (declarations) More...

#include <stddef.h>

Go to the source code of this file.

Macros
#define	COL_OBJECT_SCHEMA_CHAR_SIZE   64
	Size of the OBJECT_SCHEMA columns, in characters. More...
#define	COL_OBJECT_SCHEMA_SIZE   (COL_OBJECT_SCHEMA_CHAR_SIZE * 1)
	Size of the OBJECT_SCHEMA columns, in bytes. More...
#define	COL_OBJECT_NAME_EXTENDED_CHAR_SIZE   512
	Size of the extended OBJECT_NAME columns, in characters. More...
#define	COL_OBJECT_NAME_EXTENDED_SIZE   (COL_OBJECT_NAME_EXTENDED_CHAR_SIZE * 1)
	Size of the extended OBJECT_NAME columns, in bytes. More...
#define	COL_OBJECT_NAME_CHAR_SIZE   64
	Size of the OBJECT_NAME columns, in characters. More...
#define	COL_OBJECT_NAME_SIZE   (COL_OBJECT_NAME_CHAR_SIZE * 1)
	Size of the OBJECT_NAME columns, in bytes. More...
#define	COL_INDEX_NAME_CHAR_SIZE   64
	Size of the INDEX_NAME columns, in characters. More...
#define	COL_INDEX_NAME_SIZE   (COL_INDEX_NAME_CHAR_SIZE * 1)
	Size of the INDEX_NAME columns, in bytes. More...
#define	COL_INFO_CHAR_SIZE   1024
	Size of INFO columns, in characters. More...
#define	COL_INFO_SIZE   (COL_INFO_CHAR_SIZE * 1)
	Size of INFO columns, in bytes. More...
#define	COL_SOURCE_CHAR_SIZE   64
	Size of the SOURCE columns, in characters. More...
#define	COL_SOURCE_SIZE   (COL_SOURCE_CHAR_SIZE * 1)
	Size of the SOURCE columns, in bytes. More...
#define	FIRST_TIMER_NAME   (static_cast<int>(TIMER_NAME_CYCLE))
	Integer, first value of. More...
#define	LAST_TIMER_NAME   (static_cast<int>(TIMER_NAME_THREAD_CPU))
	Integer, last value of. More...
#define	COUNT_TIMER_NAME   (LAST_TIMER_NAME - FIRST_TIMER_NAME + 1)
	Integer, number of values of. More...
#define	FIRST_OPERATION_TYPE   (static_cast<int>(OPERATION_TYPE_LOCK))
	Integer, first value of. More...
#define	LAST_OPERATION_TYPE   (static_cast<int>(OPERATION_TYPE_METADATA))
	Integer, last value of. More...
#define	COUNT_OPERATION_TYPE   (LAST_OPERATION_TYPE - FIRST_OPERATION_TYPE + 1)
	Integer, number of values of. More...
#define	FIRST_OBJECT_TYPE   (static_cast<int>(OBJECT_TYPE_EVENT))
	Integer, first value of. More...
#define	LAST_OBJECT_TYPE   (static_cast<int>(OBJECT_TYPE_CHECK_CONSTRAINT))
	Integer, last value of. More...
#define	COUNT_OBJECT_TYPE   (LAST_OBJECT_TYPE - FIRST_OBJECT_TYPE + 1)
	Integer, number of values of. More...
#define	FIRST_EVENT_TYPE   (static_cast<int>(EVENT_TYPE_TRANSACTION))
	Integer, first value of. More...
#define	LAST_EVENT_TYPE   (static_cast<int>(EVENT_TYPE_WAIT))
	Integer, last value of. More...
#define	COUNT_EVENT_TYPE   (LAST_EVENT_TYPE - FIRST_EVENT_TYPE + 1)
	Integer, number of values of. More...
#define	FIRST_TRANS_STATE   (static_cast<int>(TRANS_STATE_ACTIVE))
	Integer, first value of. More...
#define	LAST_TRANS_STATE   (static_cast<int>(TRANS_STATE_ROLLED_BACK))
	Integer, last value of. More...
#define	COUNT_TRANS_STATE   (LAST_TRANS_STATE - FIRST_TRANS_STATE + 1)
	Integer, number of values of. More...
#define	FIRST_TRANS_STATE_XA   (static_cast<int>(TRANS_STATE_XA_NOTR))
	Integer, first value of. More...
#define	LAST_TRANS_STATE_XA   (static_cast<int>(TRANS_STATE_XA_COMMITTED))
	Integer, last value of. More...
#define	COUNT_TRANS_STATE_XA   (LAST_TRANS_STATE_XA - FIRST_TRANS_STATE_XA + 1)
	Integer, number of values of. More...
#define	FIRST_TRANS_LEVEL   (static_cast<int>(TRANS_LEVEL_READ_UNCOMMITTED))
	Integer, first value of. More...
#define	LAST_TRANS_LEVEL   (static_cast<int>(TRANS_LEVEL_SERIALIZABLE))
	Integer, last value of. More...
#define	COUNT_TRANS_LEVEL   (LAST_TRANS_LEVEL - FIRST_TRANS_LEVEL + 1)
	Integer, number of values of. More...
#define	FIRST_TRANS_MODE   (static_cast<int>(TRANS_MODE_READ_WRITE))
	Integer, first value of. More...
#define	LAST_TRANS_MODE   (static_cast<int>(TRANS_MODE_READ_ONLY))
	Integer, last value of. More...
#define	COUNT_TRANS_MODE   (LAST_TRANS_MODE - FIRST_TRANS_MODE + 1)
	Integer, number of values of. More...
#define	INSTR_PROPERTIES_SET_SINGLETON   (1 << 0)
#define	INSTR_PROPERTIES_SET_PROGRESS   (1 << 1)
#define	INSTR_PROPERTIES_SET_USER   (1 << 2)
#define	INSTR_PROPERTIES_SET_GLOBAL_STAT   (1 << 3)
#define	INSTR_PROPERTIES_SET_MUTABLE   (1 << 4)
#define	INSTR_PROPERTIES_SET_QUOTA_BY_DEFAULT   (1 << 5)
#define	INSTR_FLAGS_SET_CONTROLLED   (1 << 0)
#define	INSTR_FLAGS_MASK   (1)
#define	THREAD_PROPERTIES_SET_SINGLETON   (1 << 0)
#define	THREAD_PROPERTIES_SET_USER   (1 << 1)

Enumerations
enum	enum_timer_name {   TIMER_NAME_CYCLE = 1 , TIMER_NAME_NANOSEC = 2 , TIMER_NAME_MICROSEC = 3 , TIMER_NAME_MILLISEC = 4 ,   TIMER_NAME_THREAD_CPU = 5 }
	Enum values for the TIMER_NAME columns. More...
enum	enum_yes_no { ENUM_YES = 1 , ENUM_NO = 2 }
	Enum values for the various YES/NO columns. More...
enum	enum_executed_on_engine { ENUM_PRIMARY = 1 , ENUM_SECONDARY = 2 }
	Enum values for the various EXECUTION_ENGINE columns. More...
enum	enum_operation_type {   OPERATION_TYPE_LOCK = 1 , OPERATION_TYPE_TRYLOCK = 2 , OPERATION_TYPE_READLOCK = 3 , OPERATION_TYPE_WRITELOCK = 4 ,   OPERATION_TYPE_TRYREADLOCK = 5 , OPERATION_TYPE_TRYWRITELOCK = 6 , OPERATION_TYPE_UNLOCK = 7 , OPERATION_TYPE_SHAREDLOCK = 8 ,   OPERATION_TYPE_SHAREDEXCLUSIVELOCK = 9 , OPERATION_TYPE_EXCLUSIVELOCK = 10 , OPERATION_TYPE_TRYSHAREDLOCK = 11 , OPERATION_TYPE_TRYSHAREDEXCLUSIVELOCK = 12 ,   OPERATION_TYPE_TRYEXCLUSIVELOCK = 13 , OPERATION_TYPE_SHAREDUNLOCK = 14 , OPERATION_TYPE_SHAREDEXCLUSIVEUNLOCK = 15 , OPERATION_TYPE_EXCLUSIVEUNLOCK = 16 ,   OPERATION_TYPE_WAIT = 17 , OPERATION_TYPE_TIMEDWAIT = 18 , OPERATION_TYPE_FILECREATE = 19 , OPERATION_TYPE_FILECREATETMP = 20 ,   OPERATION_TYPE_FILEOPEN = 21 , OPERATION_TYPE_FILESTREAMOPEN = 22 , OPERATION_TYPE_FILECLOSE = 23 , OPERATION_TYPE_FILESTREAMCLOSE = 24 ,   OPERATION_TYPE_FILEREAD = 25 , OPERATION_TYPE_FILEWRITE = 26 , OPERATION_TYPE_FILESEEK = 27 , OPERATION_TYPE_FILETELL = 28 ,   OPERATION_TYPE_FILEFLUSH = 29 , OPERATION_TYPE_FILESTAT = 30 , OPERATION_TYPE_FILEFSTAT = 31 , OPERATION_TYPE_FILECHSIZE = 32 ,   OPERATION_TYPE_FILEDELETE = 33 , OPERATION_TYPE_FILERENAME = 34 , OPERATION_TYPE_FILESYNC = 35 , OPERATION_TYPE_TABLE_FETCH = 36 ,   OPERATION_TYPE_TABLE_WRITE_ROW = 37 , OPERATION_TYPE_TABLE_UPDATE_ROW = 38 , OPERATION_TYPE_TABLE_DELETE_ROW = 39 , OPERATION_TYPE_TL_READ_NORMAL = 40 ,   OPERATION_TYPE_TL_READ_WITH_SHARED_LOCKS = 41 , OPERATION_TYPE_TL_READ_HIGH_PRIORITY = 42 , OPERATION_TYPE_TL_READ_NO_INSERTS = 43 , OPERATION_TYPE_TL_WRITE_ALLOW_WRITE = 44 ,   OPERATION_TYPE_TL_WRITE_CONCURRENT_INSERT = 45 , OPERATION_TYPE_TL_WRITE_LOW_PRIORITY = 46 , OPERATION_TYPE_TL_WRITE_NORMAL = 47 , OPERATION_TYPE_TL_READ_EXTERNAL = 48 ,   OPERATION_TYPE_TL_WRITE_EXTERNAL = 49 , OPERATION_TYPE_SOCKETCREATE = 50 , OPERATION_TYPE_SOCKETCONNECT = 51 , OPERATION_TYPE_SOCKETBIND = 52 ,   OPERATION_TYPE_SOCKETCLOSE = 53 , OPERATION_TYPE_SOCKETSEND = 54 , OPERATION_TYPE_SOCKETRECV = 55 , OPERATION_TYPE_SOCKETSENDTO = 56 ,   OPERATION_TYPE_SOCKETRECVFROM = 57 , OPERATION_TYPE_SOCKETSENDMSG = 58 , OPERATION_TYPE_SOCKETRECVMSG = 59 , OPERATION_TYPE_SOCKETSEEK = 60 ,   OPERATION_TYPE_SOCKETOPT = 61 , OPERATION_TYPE_SOCKETSTAT = 62 , OPERATION_TYPE_SOCKETSHUTDOWN = 63 , OPERATION_TYPE_SOCKETSELECT = 64 ,   OPERATION_TYPE_IDLE = 65 , OPERATION_TYPE_METADATA = 66 }
	Enum values for the various OPERATION columns. More...
enum	enum_object_type : char {   NO_OBJECT_TYPE = 0 , OBJECT_TYPE_EVENT = 1 , OBJECT_TYPE_FUNCTION = 2 , OBJECT_TYPE_PROCEDURE = 3 ,   OBJECT_TYPE_TABLE = 4 , OBJECT_TYPE_TRIGGER = 5 , OBJECT_TYPE_TEMPORARY_TABLE = 6 , OBJECT_TYPE_GLOBAL = 7 ,   OBJECT_TYPE_SCHEMA = 8 , OBJECT_TYPE_COMMIT = 9 , OBJECT_TYPE_USER_LEVEL_LOCK = 10 , OBJECT_TYPE_TABLESPACE = 11 ,   OBJECT_TYPE_LOCKING_SERVICE = 12 , OBJECT_TYPE_SRID = 13 , OBJECT_TYPE_ACL_CACHE = 14 , OBJECT_TYPE_COLUMN_STATISTICS = 15 ,   OBJECT_TYPE_BACKUP_LOCK = 16 , OBJECT_TYPE_RESOURCE_GROUPS = 17 , OBJECT_TYPE_FOREIGN_KEY = 18 , OBJECT_TYPE_CHECK_CONSTRAINT = 19 }
	Enum values for the various OBJECT_TYPE columns. More...
enum	enum_event_type { EVENT_TYPE_TRANSACTION = 1 , EVENT_TYPE_STATEMENT = 2 , EVENT_TYPE_STAGE = 3 , EVENT_TYPE_WAIT = 4 }
	Enum values for the NESTING_EVENT_TYPE columns. More...
enum	enum_transaction_state { TRANS_STATE_ACTIVE = 1 , TRANS_STATE_COMMITTED = 2 , TRANS_STATE_ROLLED_BACK = 3 }
	Enum values for transaction state columns. More...
enum	enum_xa_transaction_state {   TRANS_STATE_XA_NOTR , TRANS_STATE_XA_ACTIVE , TRANS_STATE_XA_IDLE , TRANS_STATE_XA_PREPARED ,   TRANS_STATE_XA_ROLLBACK_ONLY , TRANS_STATE_XA_COMMITTED }
	Enum values for XA transaction state columns. More...
enum	enum_isolation_level { TRANS_LEVEL_READ_UNCOMMITTED , TRANS_LEVEL_READ_COMMITTED , TRANS_LEVEL_REPEATABLE_READ , TRANS_LEVEL_SERIALIZABLE }
	Enum values for transaction isolation level columns. More...
enum	enum_transaction_mode { TRANS_MODE_READ_ONLY = 1 , TRANS_MODE_READ_WRITE = 2 }
	Enum values for transaction access mode columns. More...

Functions
void	object_type_to_string (enum_object_type object_type, const char **string, size_t *length)
void	string_to_object_type (const char *string, size_t length, enum_object_type *object_type)

Detailed Description

Data types for columns used in the performance schema tables (declarations)

Macro Definition Documentation

COL_INDEX_NAME_CHAR_SIZE

#define COL_INDEX_NAME_CHAR_SIZE   64

Size of the INDEX_NAME columns, in characters.

COL_INDEX_NAME_SIZE

#define COL_INDEX_NAME_SIZE   (COL_INDEX_NAME_CHAR_SIZE * 1)

Size of the INDEX_NAME columns, in bytes.

COL_INFO_CHAR_SIZE

#define COL_INFO_CHAR_SIZE   1024

Size of INFO columns, in characters.

Size of:

• performance_schema.events_statement_current (INFO)
• performance_schema.events_statement_history (INFO)
• performance_schema.events_statement_history_long (INFO)

COL_INFO_SIZE

#define COL_INFO_SIZE   (COL_INFO_CHAR_SIZE * 1)

Size of INFO columns, in bytes.

COL_OBJECT_NAME_CHAR_SIZE

#define COL_OBJECT_NAME_CHAR_SIZE   64

Size of the OBJECT_NAME columns, in characters.

COL_OBJECT_NAME_EXTENDED_CHAR_SIZE

#define COL_OBJECT_NAME_EXTENDED_CHAR_SIZE   512

Size of the extended OBJECT_NAME columns, in characters.

'Extended' columns are used when the object name also represents the name of a non SQL object, such as a file name. Size in bytes of:

• performance_schema.events_waits_current (OBJECT_NAME)
• performance_schema.events_waits_history (OBJECT_NAME)
• performance_schema.events_waits_history_long (OBJECT_NAME)

COL_OBJECT_NAME_EXTENDED_SIZE

#define COL_OBJECT_NAME_EXTENDED_SIZE   (COL_OBJECT_NAME_EXTENDED_CHAR_SIZE * 1)

Size of the extended OBJECT_NAME columns, in bytes.

COL_OBJECT_NAME_SIZE

#define COL_OBJECT_NAME_SIZE   (COL_OBJECT_NAME_CHAR_SIZE * 1)

Size of the OBJECT_NAME columns, in bytes.

COL_OBJECT_SCHEMA_CHAR_SIZE

#define COL_OBJECT_SCHEMA_CHAR_SIZE   64

Size of the OBJECT_SCHEMA columns, in characters.

COL_OBJECT_SCHEMA_SIZE

#define COL_OBJECT_SCHEMA_SIZE   (COL_OBJECT_SCHEMA_CHAR_SIZE * 1)

Size of the OBJECT_SCHEMA columns, in bytes.

COL_SOURCE_CHAR_SIZE

#define COL_SOURCE_CHAR_SIZE   64

Size of the SOURCE columns, in characters.

COL_SOURCE_SIZE

#define COL_SOURCE_SIZE   (COL_SOURCE_CHAR_SIZE * 1)

Size of the SOURCE columns, in bytes.

COUNT_EVENT_TYPE

#define COUNT_EVENT_TYPE   (LAST_EVENT_TYPE - FIRST_EVENT_TYPE + 1)

Integer, number of values of.

See also

enum_event_type.

COUNT_OBJECT_TYPE

#define COUNT_OBJECT_TYPE   (LAST_OBJECT_TYPE - FIRST_OBJECT_TYPE + 1)

Integer, number of values of.

See also

enum_object_type.

COUNT_OPERATION_TYPE

#define COUNT_OPERATION_TYPE   (LAST_OPERATION_TYPE - FIRST_OPERATION_TYPE + 1)

Integer, number of values of.

See also

enum_operation_type.

COUNT_TIMER_NAME

#define COUNT_TIMER_NAME   (LAST_TIMER_NAME - FIRST_TIMER_NAME + 1)

Integer, number of values of.

See also

enum_timer_name.

COUNT_TRANS_LEVEL

#define COUNT_TRANS_LEVEL   (LAST_TRANS_LEVEL - FIRST_TRANS_LEVEL + 1)

Integer, number of values of.

See also

enum_isolation_level.

COUNT_TRANS_MODE

#define COUNT_TRANS_MODE   (LAST_TRANS_MODE - FIRST_TRANS_MODE + 1)

Integer, number of values of.

See also

enum_transaction_mode.

COUNT_TRANS_STATE

#define COUNT_TRANS_STATE   (LAST_TRANS_STATE - FIRST_TRANS_STATE + 1)

Integer, number of values of.

See also

enum_transaction_state.

COUNT_TRANS_STATE_XA

#define COUNT_TRANS_STATE_XA   (LAST_TRANS_STATE_XA - FIRST_TRANS_STATE_XA + 1)

Integer, number of values of.

See also

enum_xa_transaction_state.

FIRST_EVENT_TYPE

#define FIRST_EVENT_TYPE   (static_cast<int>(EVENT_TYPE_TRANSACTION))

Integer, first value of.

See also

enum_event_type.

FIRST_OBJECT_TYPE

#define FIRST_OBJECT_TYPE   (static_cast<int>(OBJECT_TYPE_EVENT))

Integer, first value of.

See also

enum_object_type.

FIRST_OPERATION_TYPE

#define FIRST_OPERATION_TYPE   (static_cast<int>(OPERATION_TYPE_LOCK))

Integer, first value of.

See also

enum_operation_type.

FIRST_TIMER_NAME

#define FIRST_TIMER_NAME   (static_cast<int>(TIMER_NAME_CYCLE))

Integer, first value of.

See also

enum_timer_name.

FIRST_TRANS_LEVEL

#define FIRST_TRANS_LEVEL   (static_cast<int>(TRANS_LEVEL_READ_UNCOMMITTED))

Integer, first value of.

See also

enum_isolation_level.

FIRST_TRANS_MODE

#define FIRST_TRANS_MODE   (static_cast<int>(TRANS_MODE_READ_WRITE))

Integer, first value of.

See also

enum_transaction_mode.

FIRST_TRANS_STATE

#define FIRST_TRANS_STATE   (static_cast<int>(TRANS_STATE_ACTIVE))

Integer, first value of.

See also

enum_transaction_state.

FIRST_TRANS_STATE_XA

#define FIRST_TRANS_STATE_XA   (static_cast<int>(TRANS_STATE_XA_NOTR))

Integer, first value of.

See also

enum_xa_transaction_state.

INSTR_FLAGS_MASK

#define INSTR_FLAGS_MASK   (1)

INSTR_FLAGS_SET_CONTROLLED

#define INSTR_FLAGS_SET_CONTROLLED   (1 << 0)

INSTR_PROPERTIES_SET_GLOBAL_STAT

#define INSTR_PROPERTIES_SET_GLOBAL_STAT   (1 << 3)

INSTR_PROPERTIES_SET_MUTABLE

#define INSTR_PROPERTIES_SET_MUTABLE   (1 << 4)

INSTR_PROPERTIES_SET_PROGRESS

#define INSTR_PROPERTIES_SET_PROGRESS   (1 << 1)

INSTR_PROPERTIES_SET_QUOTA_BY_DEFAULT

#define INSTR_PROPERTIES_SET_QUOTA_BY_DEFAULT   (1 << 5)

INSTR_PROPERTIES_SET_SINGLETON

#define INSTR_PROPERTIES_SET_SINGLETON   (1 << 0)

INSTR_PROPERTIES_SET_USER

#define INSTR_PROPERTIES_SET_USER   (1 << 2)

LAST_EVENT_TYPE

#define LAST_EVENT_TYPE   (static_cast<int>(EVENT_TYPE_WAIT))

Integer, last value of.

See also

enum_event_type.

LAST_OBJECT_TYPE

#define LAST_OBJECT_TYPE   (static_cast<int>(OBJECT_TYPE_CHECK_CONSTRAINT))

Integer, last value of.

See also

enum_object_type.

LAST_OPERATION_TYPE

#define LAST_OPERATION_TYPE   (static_cast<int>(OPERATION_TYPE_METADATA))

Integer, last value of.

See also

enum_operation_type.

LAST_TIMER_NAME

#define LAST_TIMER_NAME   (static_cast<int>(TIMER_NAME_THREAD_CPU))

Integer, last value of.

See also

enum_timer_name.

LAST_TRANS_LEVEL

#define LAST_TRANS_LEVEL   (static_cast<int>(TRANS_LEVEL_SERIALIZABLE))

Integer, last value of.

See also

enum_isolation_level.

LAST_TRANS_MODE

#define LAST_TRANS_MODE   (static_cast<int>(TRANS_MODE_READ_ONLY))

Integer, last value of.

See also

enum_transaction_mode.

LAST_TRANS_STATE

#define LAST_TRANS_STATE   (static_cast<int>(TRANS_STATE_ROLLED_BACK))

Integer, last value of.

See also

enum_transaction_state.

LAST_TRANS_STATE_XA

#define LAST_TRANS_STATE_XA   (static_cast<int>(TRANS_STATE_XA_COMMITTED))

Integer, last value of.

See also

enum_xa_transaction_state.

THREAD_PROPERTIES_SET_SINGLETON

#define THREAD_PROPERTIES_SET_SINGLETON   (1 << 0)

THREAD_PROPERTIES_SET_USER

#define THREAD_PROPERTIES_SET_USER   (1 << 1)

Enumeration Type Documentation

enum_event_type

enum enum_event_type

Enum values for the NESTING_EVENT_TYPE columns.

This enum is found in the following tables:

• performance_schema.events_waits_current (NESTING_EVENT_TYPE)
• performance_schema.events_stages_current (NESTING_EVENT_TYPE)
• performance_schema.events_statements_current (NESTING_EVENT_TYPE)

Enumerator
EVENT_TYPE_TRANSACTION
EVENT_TYPE_STATEMENT
EVENT_TYPE_STAGE
EVENT_TYPE_WAIT

enum_executed_on_engine

enum enum_executed_on_engine

Enum values for the various EXECUTION_ENGINE columns.

This enum is found in the following tables:

• performance_schema.threads
• performance_schema.processlist
• performance_schema.events_statements_current
• performance_schema.events_statements_history
• performance_schema.events_statements_history_long

Enumerator
ENUM_PRIMARY
ENUM_SECONDARY

enum_isolation_level

enum enum_isolation_level

Enum values for transaction isolation level columns.

See enum_tx_isolation in handler.h.

Enumerator
TRANS_LEVEL_READ_UNCOMMITTED
TRANS_LEVEL_READ_COMMITTED
TRANS_LEVEL_REPEATABLE_READ
TRANS_LEVEL_SERIALIZABLE

enum_object_type

enum enum_object_type : char

Enum values for the various OBJECT_TYPE columns.

Enumerator
NO_OBJECT_TYPE
OBJECT_TYPE_EVENT
OBJECT_TYPE_FUNCTION
OBJECT_TYPE_PROCEDURE
OBJECT_TYPE_TABLE
OBJECT_TYPE_TRIGGER
OBJECT_TYPE_TEMPORARY_TABLE
OBJECT_TYPE_GLOBAL
OBJECT_TYPE_SCHEMA
OBJECT_TYPE_COMMIT
OBJECT_TYPE_USER_LEVEL_LOCK
OBJECT_TYPE_TABLESPACE
OBJECT_TYPE_LOCKING_SERVICE
OBJECT_TYPE_SRID
OBJECT_TYPE_ACL_CACHE
OBJECT_TYPE_COLUMN_STATISTICS
OBJECT_TYPE_BACKUP_LOCK
OBJECT_TYPE_RESOURCE_GROUPS
OBJECT_TYPE_FOREIGN_KEY
OBJECT_TYPE_CHECK_CONSTRAINT

enum_operation_type

enum enum_operation_type

Enum values for the various OPERATION columns.

This enum is found in the following tables:

• performance_schema.events_waits_current (OPERATION)
• performance_schema.events_waits_history (OPERATION)
• performance_schema.events_waits_history_long (OPERATION)

Enumerator
OPERATION_TYPE_LOCK
OPERATION_TYPE_TRYLOCK
OPERATION_TYPE_READLOCK
OPERATION_TYPE_WRITELOCK
OPERATION_TYPE_TRYREADLOCK
OPERATION_TYPE_TRYWRITELOCK
OPERATION_TYPE_UNLOCK
OPERATION_TYPE_SHAREDLOCK
OPERATION_TYPE_SHAREDEXCLUSIVELOCK
OPERATION_TYPE_EXCLUSIVELOCK
OPERATION_TYPE_TRYSHAREDLOCK
OPERATION_TYPE_TRYSHAREDEXCLUSIVELOCK
OPERATION_TYPE_TRYEXCLUSIVELOCK
OPERATION_TYPE_SHAREDUNLOCK
OPERATION_TYPE_SHAREDEXCLUSIVEUNLOCK
OPERATION_TYPE_EXCLUSIVEUNLOCK
OPERATION_TYPE_WAIT
OPERATION_TYPE_TIMEDWAIT
OPERATION_TYPE_FILECREATE
OPERATION_TYPE_FILECREATETMP
OPERATION_TYPE_FILEOPEN
OPERATION_TYPE_FILESTREAMOPEN
OPERATION_TYPE_FILECLOSE
OPERATION_TYPE_FILESTREAMCLOSE
OPERATION_TYPE_FILEREAD
OPERATION_TYPE_FILEWRITE
OPERATION_TYPE_FILESEEK
OPERATION_TYPE_FILETELL
OPERATION_TYPE_FILEFLUSH
OPERATION_TYPE_FILESTAT
OPERATION_TYPE_FILEFSTAT
OPERATION_TYPE_FILECHSIZE
OPERATION_TYPE_FILEDELETE
OPERATION_TYPE_FILERENAME
OPERATION_TYPE_FILESYNC
OPERATION_TYPE_TABLE_FETCH
OPERATION_TYPE_TABLE_WRITE_ROW
OPERATION_TYPE_TABLE_UPDATE_ROW
OPERATION_TYPE_TABLE_DELETE_ROW
OPERATION_TYPE_TL_READ_NORMAL
OPERATION_TYPE_TL_READ_WITH_SHARED_LOCKS
OPERATION_TYPE_TL_READ_HIGH_PRIORITY
OPERATION_TYPE_TL_READ_NO_INSERTS
OPERATION_TYPE_TL_WRITE_ALLOW_WRITE
OPERATION_TYPE_TL_WRITE_CONCURRENT_INSERT
OPERATION_TYPE_TL_WRITE_LOW_PRIORITY
OPERATION_TYPE_TL_WRITE_NORMAL
OPERATION_TYPE_TL_READ_EXTERNAL
OPERATION_TYPE_TL_WRITE_EXTERNAL
OPERATION_TYPE_SOCKETCREATE
OPERATION_TYPE_SOCKETCONNECT
OPERATION_TYPE_SOCKETBIND
OPERATION_TYPE_SOCKETCLOSE
OPERATION_TYPE_SOCKETSEND
OPERATION_TYPE_SOCKETRECV
OPERATION_TYPE_SOCKETSENDTO
OPERATION_TYPE_SOCKETRECVFROM
OPERATION_TYPE_SOCKETSENDMSG
OPERATION_TYPE_SOCKETRECVMSG
OPERATION_TYPE_SOCKETSEEK
OPERATION_TYPE_SOCKETOPT
OPERATION_TYPE_SOCKETSTAT
OPERATION_TYPE_SOCKETSHUTDOWN
OPERATION_TYPE_SOCKETSELECT
OPERATION_TYPE_IDLE
OPERATION_TYPE_METADATA

enum_timer_name

enum enum_timer_name

Enum values for the TIMER_NAME columns.

This enum is found in the following tables:

• performance_schema.performance_timer (TIMER_NAME)

Enumerator
TIMER_NAME_CYCLE
TIMER_NAME_NANOSEC
TIMER_NAME_MICROSEC
TIMER_NAME_MILLISEC
TIMER_NAME_THREAD_CPU

enum_transaction_mode

enum enum_transaction_mode

Enum values for transaction access mode columns.

Enumerator
TRANS_MODE_READ_ONLY
TRANS_MODE_READ_WRITE

enum_transaction_state

enum enum_transaction_state

Enum values for transaction state columns.

Enumerator
TRANS_STATE_ACTIVE
TRANS_STATE_COMMITTED
TRANS_STATE_ROLLED_BACK

enum_xa_transaction_state

enum enum_xa_transaction_state

Enum values for XA transaction state columns.

Enums 1-5 match those used by the server. See XID_STATE::enum xa_states in xa.h.

Enumerator
TRANS_STATE_XA_NOTR
TRANS_STATE_XA_ACTIVE
TRANS_STATE_XA_IDLE
TRANS_STATE_XA_PREPARED
TRANS_STATE_XA_ROLLBACK_ONLY
TRANS_STATE_XA_COMMITTED

enum_yes_no

enum enum_yes_no

Enum values for the various YES/NO columns.

This enum is found in the following tables:

• performance_schema.setup_instruments (ENABLED)
• performance_schema.setup_instruments (TIMED)
• performance_schema.setup_consumers (ENABLED)

Enumerator
ENUM_YES
ENUM_NO

Function Documentation

object_type_to_string()

void object_type_to_string	(	enum_object_type	object_type,
		const char **	string,
		size_t *	length
	)

string_to_object_type()

void string_to_object_type	(	const char *	string,
		size_t	length,
		enum_object_type *	object_type
	)