Querying InnoDB Lock Waits

project_id

Yes

String

Explanation:

Project ID of a tenant in a region

To obtain this value, see Obtaining a Project ID.

Constraints:

N/A

Values:

The value can contain 32 characters. Only letters and digits are allowed.

Default value:

N/A

instance_id

Yes

String

Explanation:

Unique ID of an instance

Constraints:

N/A

Values:

The value can contain 32 characters. Only letters and digits are allowed.

Default value:

N/A

db_user_id

Yes

String

Explanation:

Database user ID, that is, ID of a connection established between the database account and the database. A database user ID is created by calling the API in Registering a Database User.

Constraints:

N/A

Values:

The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed.

Default value:

N/A

innodb_trx

Array of InnodbTrx objects

Explanation:

Information about the current transaction that holds or waits for a lock

Values:

N/A

innodb_lock_waits

Array of InnodbLockWaits objects

Explanation:

Mapping between the lock requested by each transaction and the lock that blocks the request

Values:

N/A

count

Integer

Explanation:

Number of transactions that currently hold or wait for locks

Values:

[0, 2^31-1]. The actual value depends on the query result.

trx_id

String

Explanation:

Transaction ID

Values:

N/A

trx_state

String

Explanation:

Transaction status

Values:

N/A

trx_started

String

Explanation:

Time when a transaction was started

Values:

N/A

trx_wait_started

String

Explanation:

Transaction ID

Values:

N/A

trx_mysql_thread_id

String

Explanation:

Session ID, same as the ID returned by the ListProcesses API

Values:

N/A

trx_query

String

Explanation:

SQL statement executed by a transaction

Values:

N/A

trx_tables_locked

String

Explanation:

Number of tables with row locks

Values:

N/A

trx_rows_locked

String

Explanation:

Number of locked rows (approximate value)

Values:

N/A

trx_rows_modified

String

Explanation:

Number of rows inserted or modified by a transaction

Values:

N/A

trx_isolation_level

String

Explanation:

Isolation level

Values:

N/A

innodb_wait_locks

Array of InnodbLock objects

Explanation:

Information about lock waits

Values:

N/A

innodb_hold_locks

Array of InnodbLock objects

Explanation:

Information about held locks

Values:

N/A

lock_id

String

Explanation:

Lock ID

Values:

N/A

lock_trx_id

String

Explanation:

Transaction ID

Values:

N/A

lock_mode

String

Explanation:

Lock mode

Values:

• S[,GAP]
• X[,GAP]
• IS[,GAP]
• IX[,GAP]
• AUTO_INC
• UNKNOWN

lock_type

String

Explanation:

Lock type

Values:

• RECORD: row lock
• TABLE: table lock

lock_table

String

Explanation:

Locked table

Values:

N/A

lock_index

String

Explanation:

Index that has been locked if lock_type is RECORD. If lock_type is Table, null is returned.

Values:

N/A

lock_space

String

Explanation:

Index that has been locked if lock_type is RECORD. If lock_type is Table, null is returned.

Values:

N/A

lock_page

String

Explanation:

Page number of the locked record if lock_type is RECORD. If lock_type is Table, null is returned.

Values:

N/A

lock_rec

String

Explanation:

Heap number of the locked record if lock_type is RECORD. If lock_type is Table, null is returned.

Values:

N/A

lock_data

String

Explanation:

Primary key locked by a transaction. If lock_type is Table, null is returned.

Values:

N/A

requesting_trx_id

String

Explanation:

ID of a transaction that requests the lock

Values:

N/A

requested_lock_id

String

Explanation:

ID of a requested lock

Values:

N/A

blocking_trx_id

String

Explanation:

ID of a blocked transaction

Values:

N/A

blocking_lock_id

String

Explanation:

ID of a blocked lock

Values:

N/A

200

Successful request

400

Bad request

500

Internal server error