按 Ctrl+Enter 键执行查询按 Enter 执行查询
崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: information_schema 查询时间: 在当前会话期间
SELECT * FROM `INNODB_LOCK_WAITS`崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: information_schema 查询时间: 在当前会话期间
SELECT * FROM `INNODB_LOCK_WAITS`插件 | 说明 | 版本 | 作者 | 授权 |
---|---|---|---|---|
mysql_native_password | Native MySQL authentication | 2.0 | R.J.Silk, Sergei Golubchik | GPL |
mysql_old_password | Old MySQL-4.0 authentication | 2.0 | R.J.Silk, Sergei Golubchik | GPL |
插件 | 说明 | 版本 | 作者 | 授权 |
---|---|---|---|---|
CHANGED_PAGE_BITMAPS | XtraDB dummy changed_page_bitmaps table | 100121.0 | MariaDB Corporation | GPL |
CLIENT_STATISTICS | Client Statistics | 100121.0 | Percona and Sergei Golubchik | GPL |
FEEDBACK 已禁用 | MariaDB User Feedback Plugin | 100121.0 | Sergei Golubchik | GPL |
INDEX_STATISTICS | Index Statistics | 100121.0 | Percona and Sergei Golubchik | GPL |
INNODB_BUFFER_PAGE | InnoDB Buffer Page Information | 100121.0 | Oracle Corporation | GPL |
INNODB_BUFFER_PAGE_LRU | InnoDB Buffer Page in LRU | 100121.0 | Oracle Corporation | GPL |
INNODB_BUFFER_POOL_STATS | InnoDB Buffer Pool Statistics Information | 100121.0 | Oracle Corporation | GPL |
INNODB_CHANGED_PAGES | InnoDB CHANGED_PAGES table | 100121.0 | Percona | GPL |
INNODB_CMP | Statistics for the InnoDB compression | 100121.0 | Oracle Corporation | GPL |
INNODB_CMPMEM | Statistics for the InnoDB compressed buffer pool | 100121.0 | Oracle Corporation | GPL |
INNODB_CMPMEM_RESET | Statistics for the InnoDB compressed buffer pool; reset cumulated counts | 100121.0 | Oracle Corporation | GPL |
INNODB_CMP_PER_INDEX | Statistics for the InnoDB compression (per index) | 100121.0 | Oracle Corporation | GPL |
INNODB_CMP_PER_INDEX_RESET | Statistics for the InnoDB compression (per index); reset cumulated counts | 100121.0 | Oracle Corporation | GPL |
INNODB_CMP_RESET | Statistics for the InnoDB compression; reset cumulated counts | 100121.0 | Oracle Corporation | GPL |
INNODB_FT_BEING_DELETED | INNODB AUXILIARY FTS BEING DELETED TABLE | 100121.0 | Oracle Corporation | GPL |
INNODB_FT_CONFIG | INNODB AUXILIARY FTS CONFIG TABLE | 100121.0 | Oracle Corporation | GPL |
INNODB_FT_DEFAULT_STOPWORD | Default stopword list for InnoDB Full Text Search | 100121.0 | Oracle Corporation | GPL |
INNODB_FT_DELETED | INNODB AUXILIARY FTS DELETED TABLE | 100121.0 | Oracle Corporation | GPL |
INNODB_FT_INDEX_CACHE | INNODB AUXILIARY FTS INDEX CACHED | 100121.0 | Oracle Corporation | GPL |
INNODB_FT_INDEX_TABLE | INNODB AUXILIARY FTS INDEX TABLE | 100121.0 | Oracle Corporation | GPL |
INNODB_LOCKS | InnoDB conflicting locks | 100121.0 | Oracle Corporation | GPL |
INNODB_LOCK_WAITS | InnoDB which lock is blocking which | 100121.0 | Oracle Corporation | GPL |
INNODB_METRICS | InnoDB Metrics Info | 100121.0 | Oracle Corporation | GPL |
INNODB_MUTEXES | InnoDB SYS_DATAFILES | 100121.0 | Oracle Corporation | GPL |
INNODB_SYS_COLUMNS | InnoDB SYS_COLUMNS | 100121.0 | Oracle Corporation | GPL |
INNODB_SYS_DATAFILES | InnoDB SYS_DATAFILES | 100121.0 | Oracle Corporation | GPL |
INNODB_SYS_FIELDS | InnoDB SYS_FIELDS | 100121.0 | Oracle Corporation | GPL |
INNODB_SYS_FOREIGN | InnoDB SYS_FOREIGN | 100121.0 | Oracle Corporation | GPL |
INNODB_SYS_FOREIGN_COLS | InnoDB SYS_FOREIGN_COLS | 100121.0 | Oracle Corporation | GPL |
INNODB_SYS_INDEXES | InnoDB SYS_INDEXES | 100121.0 | Oracle Corporation | GPL |
INNODB_SYS_SEMAPHORE_WAITS | InnoDB SYS_SEMAPHORE_WAITS | 100121.0 | MariaDB Corporation | GPL |
INNODB_SYS_TABLES | InnoDB SYS_TABLES | 100121.0 | Oracle Corporation | GPL |
INNODB_SYS_TABLESPACES | InnoDB SYS_TABLESPACES | 100121.0 | Oracle Corporation | GPL |
INNODB_SYS_TABLESTATS | InnoDB SYS_TABLESTATS | 100121.0 | Oracle Corporation | GPL |
INNODB_TABLESPACES_ENCRYPTION | InnoDB TABLESPACES_ENCRYPTION | 100121.0 | Google Inc | BSD |
INNODB_TABLESPACES_SCRUBBING | InnoDB TABLESPACES_SCRUBBING | 100121.0 | Google Inc | BSD |
INNODB_TRX | InnoDB transactions | 100121.0 | Oracle Corporation | GPL |
TABLE_STATISTICS | Table Statistics | 100121.0 | Percona and Sergei Golubchik | GPL |
USER_STATISTICS | User Statistics | 100121.0 | Percona and Sergei Golubchik | GPL |
XTRADB_INTERNAL_HASH_TABLES | InnoDB internal hash tables information | 100121.0 | Percona Inc. | GPL |
XTRADB_READ_VIEW | InnoDB Read View information | 100121.0 | Percona Inc. | GPL |
XTRADB_RSEG | InnoDB rollback segment information | 100121.0 | Percona Inc. | GPL |
插件 | 说明 | 版本 | 作者 | 授权 |
---|---|---|---|---|
ARCHIVE | Archive storage engine | 100121.0 | Brian Aker, MySQL AB | GPL |
Aria | Crash-safe tables with MyISAM heritage | 100121.0 | Monty Program Ab | GPL |
binlog | This is a pseudo storage engine to represent the binlog in a transaction | 100121.0 | MySQL AB | GPL |
BLACKHOLE | /dev/null storage engine (anything you write to it disappears) | 100121.0 | MySQL AB | GPL |
CSV | CSV storage engine | 100121.0 | Brian Aker, MySQL AB | GPL |
InnoDB | Percona-XtraDB, Supports transactions, row-level locking, foreign keys and encryption for tables | 100121.0 | Oracle Corporation | GPL |
MEMORY | Hash based, stored in memory, useful for temporary tables | 100121.0 | MySQL AB | GPL |
MRG_MyISAM | Collection of identical MyISAM tables | 100121.0 | MySQL AB | GPL |
MyISAM | MyISAM storage engine | 100121.0 | MySQL AB | GPL |
partition | Partition Storage Engine Helper | 100121.0 | Mikael Ronstrom, MySQL AB | GPL |
PERFORMANCE_SCHEMA | Performance Schema | 100121.0 | Marc Alff, Oracle | GPL |
SEQUENCE | Generated tables filled with sequential values | 100121.0 | Sergei Golubchik | GPL |
wsrep | A pseudo storage engine to represent transactions in multi-master synchornous replication | 100121.0 | Codership Oy | GPL |