#include "univ.i"
#include "trx0types.h"
#include "dict0types.h"
#include "ut0ut.h"

Include dependency graph for trx0i_s.h:

Data Structures
struct	i_s_hash_chain_t
struct	i_s_locks_row_t
struct	i_s_trx_row_t
struct	i_s_lock_waits_row_t

Macros
#define	TRX_I_S_MEM_LIMIT 16777216 /* 16 MiB */
#define	TRX_I_S_LOCK_DATA_MAX_LEN 8192
#define	TRX_I_S_TRX_QUERY_MAX_LEN 1024
#define	TRX_I_S_TRX_OP_STATE_MAX_LEN 64
#define	TRX_I_S_TRX_FK_ERROR_MAX_LEN 256
#define	TRX_I_S_TRX_ISOLATION_LEVEL_MAX_LEN 16
#define	TRX_I_S_STRING_COPY(data, field, constraint, tcache)
#define	TRX_I_S_LOCK_ID_MAX_LEN (TRX_ID_MAX_LEN + 63)

Enumerations
enum	i_s_table { I_S_INNODB_TRX, I_S_INNODB_LOCKS, I_S_INNODB_LOCK_WAITS }

Functions
UNIV_INTERN void	trx_i_s_cache_init (trx_i_s_cache_t *cache)
UNIV_INTERN void	trx_i_s_cache_free (trx_i_s_cache_t *cache)
UNIV_INTERN void	trx_i_s_cache_start_read (trx_i_s_cache_t *cache)
UNIV_INTERN void	trx_i_s_cache_end_read (trx_i_s_cache_t *cache)
UNIV_INTERN void	trx_i_s_cache_start_write (trx_i_s_cache_t *cache)
UNIV_INTERN void	trx_i_s_cache_end_write (trx_i_s_cache_t *cache)
UNIV_INTERN ulint	trx_i_s_cache_get_rows_used (trx_i_s_cache_t *cache, enum i_s_table table)
UNIV_INTERN void *	trx_i_s_cache_get_nth_row (trx_i_s_cache_t *cache, enum i_s_table table, ulint n)
UNIV_INTERN int	trx_i_s_possibly_fetch_data_into_cache (trx_i_s_cache_t *cache)
UNIV_INTERN ibool	trx_i_s_cache_is_truncated (trx_i_s_cache_t *cache)
UNIV_INTERN char *	trx_i_s_create_lock_id (const i_s_locks_row_t row, char lock_id, ulint lock_id_size)

Variables
trx_i_s_cache_t *	trx_i_s_cache

Detailed Description

INFORMATION SCHEMA innodb_trx, innodb_locks and innodb_lock_waits tables cache structures and public functions.

Created July 17, 2007 Vasil Dimov

Macro Definition Documentation

#define TRX_I_S_LOCK_DATA_MAX_LEN 8192

The maximum length of a string that can be stored in

i_s_locks_row_t::lock_data

#define TRX_I_S_LOCK_ID_MAX_LEN (TRX_ID_MAX_LEN + 63)

The maximum length of a resulting lock_id_size in

trx_i_s_create_lock_id(), not including the terminating NUL. ":%lu:%lu:%lu" -> 63 chars

#define TRX_I_S_MEM_LIMIT 16777216 /* 16 MiB */

The maximum amount of memory that can be consumed by innodb_trx,

innodb_locks and innodb_lock_waits information schema tables.

#define TRX_I_S_STRING_COPY	(	data,
		field,
		constraint,
		tcache
	)

Value:

do {                                                            \
        if (strlen(data) > constraint) {                        \
                char    buff[constraint + 1];                   \
                strncpy(buff, data, constraint);                \
                buff[constraint] = '\0';                        \
                                                                \
                field = static_cast<const char*>(               \
                        ha_storage_put_memlim(                  \
                        (tcache)->storage, buff, constraint + 1,\
                        MAX_ALLOWED_FOR_STORAGE(tcache)));      \
        } else {                                                \
                field = static_cast<const char*>(               \
                        ha_storage_put_str_memlim(              \
                        (tcache)->storage, data,                \
                        MAX_ALLOWED_FOR_STORAGE(tcache)));      \
        }                                                       \
} while (0)

Safely copy strings in to the INNODB_TRX table's

string based columns

#define TRX_I_S_TRX_FK_ERROR_MAX_LEN 256

The maximum length of a string that can be stored in

i_s_trx_row_t::trx_foreign_key_error

#define TRX_I_S_TRX_ISOLATION_LEVEL_MAX_LEN 16

The maximum length of a string that can be stored in

i_s_trx_row_t::trx_isolation_level

#define TRX_I_S_TRX_OP_STATE_MAX_LEN 64

The maximum length of a string that can be stored in

i_s_trx_row_t::trx_operation_state

#define TRX_I_S_TRX_QUERY_MAX_LEN 1024

The maximum length of a string that can be stored in

i_s_trx_row_t::trx_query

Enumeration Type Documentation

enum i_s_table

Auxiliary enum used by functions that need to select one of the

INFORMATION_SCHEMA tables

Enumerator:

I_S_INNODB_TRX	INFORMATION_SCHEMA.innodb_trx
I_S_INNODB_LOCKS	INFORMATION_SCHEMA.innodb_locks
I_S_INNODB_LOCK_WAITS	INFORMATION_SCHEMA.innodb_lock_waits

Function Documentation

UNIV_INTERN void trx_i_s_cache_end_read ( trx_i_s_cache_t * cache )

Release a shared/read lock on the tables cache. in: cache

UNIV_INTERN void trx_i_s_cache_end_write ( trx_i_s_cache_t * cache )

Release an exclusive/write lock on the tables cache. in: cache

UNIV_INTERN void trx_i_s_cache_free ( trx_i_s_cache_t * cache )

Free the INFORMATION SCHEMA trx related cache. in/out: cache to free

UNIV_INTERN void* trx_i_s_cache_get_nth_row	(	trx_i_s_cache_t *	cache,
		enum i_s_table	table,
		ulint	n
	)

Retrieves the nth row in the cache for a given INFORMATION SCHEMA table.

Returns: row in: row number

Parameters

cache	in: cache
table	in: which table

UNIV_INTERN ulint trx_i_s_cache_get_rows_used	(	trx_i_s_cache_t *	cache,
		enum i_s_table	table
	)

Retrieves the number of used rows in the cache for a given INFORMATION SCHEMA table.

Returns: number of rows in: which table

Parameters

cache in: cache

UNIV_INTERN void trx_i_s_cache_init ( trx_i_s_cache_t * cache )

Initialize INFORMATION SCHEMA trx related cache. out: cache to init

UNIV_INTERN ibool trx_i_s_cache_is_truncated ( trx_i_s_cache_t * cache )

Returns TRUE if the data in the cache is truncated due to the memory limit posed by TRX_I_S_MEM_LIMIT.

Returns: TRUE if truncated in: cache

UNIV_INTERN void trx_i_s_cache_start_read ( trx_i_s_cache_t * cache )

Issue a shared/read lock on the tables cache. in: cache

UNIV_INTERN void trx_i_s_cache_start_write ( trx_i_s_cache_t * cache )

Issue an exclusive/write lock on the tables cache. in: cache

UNIV_INTERN char* trx_i_s_create_lock_id	(	const i_s_locks_row_t *	row,
		char *	lock_id,
		ulint	lock_id_size
	)

Crafts a lock id string from a i_s_locks_row_t object. Returns its second argument. This function aborts if there is not enough space in lock_id. Be sure to provide at least TRX_I_S_LOCK_ID_MAX_LEN + 1 if you want to be 100% sure that it will not abort.

Returns: resulting lock id in: size of the lock id buffer

Parameters

row	in: innodb_locks row
lock_id	out: resulting lock_id

UNIV_INTERN int trx_i_s_possibly_fetch_data_into_cache ( trx_i_s_cache_t * cache )

Update the transactions cache if it has not been read for some time.

Returns: 0 - fetched, 1 - not in/out: cache

Variable Documentation

trx_i_s_cache_t* trx_i_s_cache

This is the intermediate buffer where data needed to fill the

INFORMATION SCHEMA tables is fetched and later retrieved by the C++ code in handler/i_s.cc.

Data Structures

Macros

Enumerations

Functions

Variables

Detailed Description

Macro Definition Documentation

Enumeration Type Documentation

Function Documentation

Variable Documentation