common_schema

innodb_simple_locks

NAME

innodb_simple_locks: Listing of locks, simplifying INFORMATION_SCHEMA.INNODB_LOCKS

TYPE

View

DESCRIPTION

innodb_simple_locks is a simplification of INFORMATION_SCHEMA.INNODB_LOCKS. It merely provides with "the good parts" in the form of selected columns. No rows are filtered by this view.

STRUCTURE

mysql> DESC common_schema.innodb_simple_locks;
+-------------+---------------+------+-----+---------+-------+
| Field       | Type          | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| lock_id     | varchar(81)   | NO   |     |         |       |
| lock_trx_id | varchar(18)   | NO   |     |         |       |
| lock_type   | varchar(32)   | NO   |     |         |       |
| lock_table  | varchar(1024) | NO   |     |         |       |
| lock_index  | varchar(1024) | YES  |     | NULL    |       |
| lock_data   | varchar(8192) | YES  |     | NULL    |       |
+-------------+---------------+------+-----+---------+-------+

SYNOPSIS

Columns of this view map directly to those of INFORMATION_SCHEMA.INNODB_LOCKS table

EXAMPLES

Show current locks:

mysql> SELECT * FROM common_schema.innodb_simple_locks;
+----------------+-------------+-----------+--------------------------+------------+-----------+
| lock_id        | lock_trx_id | lock_type | lock_table               | lock_index | lock_data |
+----------------+-------------+-----------+--------------------------+------------+-----------+
| 313C57443:1027 | 313C57443   | TABLE     | `deps_db`.`pending_deps` | NULL       | NULL      |
| 313C57442:1027 | 313C57442   | TABLE     | `deps_db`.`pending_deps` | NULL       | NULL      |
+----------------+-------------+-----------+--------------------------+------------+-----------+

ENVIRONMENT

MySQL 5.1 with InnoDB Plugin installed (with InnoDB INFORMATION_SCHEMA plugins enabled), or MySQL >= 5.5

SEE ALSO

innodb_locked_transactions, innodb_transactions, innodb_transactions_summary

AUTHOR

Shlomi Noach

common_schema documentation