Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Settings for the table structure (list of columns).
Table structure
Documentation Whether the table structure actions should be hidden. Restore default value
Documentation Whether column comments should be shown in table structure view Restore default value
Default transformations
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value

schema_table_lock_waits

# Name Type Collation Attributes Null Default Comments Extra
1 varchar(64) utf8mb3_general_ci Yes NULL Object schema.
2 varchar(64) utf8mb3_general_ci Yes NULL Object name.
3 bigint(20) UNSIGNED No None A unique thread identifier.
4 bigint(20) UNSIGNED Yes NULL The PROCESSLIST.ID value for threads displayed in the INFORMATION_SCHEMA.PROCESSLIST table, or 0 for background threads. Also corresponds with the CONNECTION_ID() return value for the thread.
5 text utf8mb3_general_ci Yes NULL
6 varchar(32) utf8mb3_general_ci No None Lock type. One of BACKUP_FTWRL1, BACKUP_START, BACKUP_TRANS_DML, EXCLUSIVE, INTENTION_EXCLUSIVE, SHARED, SHARED_HIGH_PRIO, SHARED_NO_READ_WRITE, SHARED_NO_WRITE, SHARED_READ, SHARED_UPGRADABLE or SHARED_WRITE.
7 varchar(32) utf8mb3_general_ci No None Lock duration. One of EXPLICIT (locks released by explicit action, for example a global lock acquired with FLUSH TABLES WITH READ LOCK) , STATEMENT (locks implicitly released at statement end) or TRANSACTION (locks implicitly released at transaction end).
8 longtext utf8mb3_general_ci Yes NULL
9 bigint(20) Yes NULL Time in seconds the thread has been in its current state.
10 bigint(20) UNSIGNED Yes NULL Number of rows affected the statement affected.
11 bigint(20) UNSIGNED Yes NULL Number of rows read during the statement's execution.
12 bigint(20) UNSIGNED No None A unique thread identifier.
13 bigint(20) UNSIGNED Yes NULL The PROCESSLIST.ID value for threads displayed in the INFORMATION_SCHEMA.PROCESSLIST table, or 0 for background threads. Also corresponds with the CONNECTION_ID() return value for the thread.
14 text utf8mb3_general_ci Yes NULL
15 varchar(32) utf8mb3_general_ci No None Lock type. One of BACKUP_FTWRL1, BACKUP_START, BACKUP_TRANS_DML, EXCLUSIVE, INTENTION_EXCLUSIVE, SHARED, SHARED_HIGH_PRIO, SHARED_NO_READ_WRITE, SHARED_NO_WRITE, SHARED_READ, SHARED_UPGRADABLE or SHARED_WRITE.
16 varchar(32) utf8mb3_general_ci No None Lock duration. One of EXPLICIT (locks released by explicit action, for example a global lock acquired with FLUSH TABLES WITH READ LOCK) , STATEMENT (locks implicitly released at statement end) or TRANSACTION (locks implicitly released at transaction end).
17 varchar(31) utf8mb3_general_ci Yes NULL
18 varchar(25) utf8mb3_general_ci Yes NULL
With selected: With selected:
Partitions Documentation
Information

Table comments: VIEW

Row statistics
Format
Rows 0
Next autoindex 0
Creation Mar 28, 2026 at 10:52 AM
Last update Mar 28, 2026 at 10:52 AM
Last check Mar 28, 2026 at 10:52 AM