MySQL Variables
Processes Processes State Variables
The script tries since 2 sec. to kill the process 2741818268 .
| ID | User | Host | DB | Command | Time | State | Info | RT: 3 sec |
|---|---|---|---|---|---|---|---|---|
| 2742725140 | filmtheater | localhost | information_schema | Sleep | 6 | kill | ||
| 2742725565 | filmtheater | localhost | information_schema | Sleep | 3 | kill | ||
| 2742725956 | filmtheater | localhost | information_schema | Query | 0 | Optimizing | SELECT * FROM `PARTITIONS` WHERE `TABLE_CATALOG`="def" AND `TABLE_SCHEMA`="information_schema" AND `TABLE_NAME`="INNODB_SYS_INDEXES" AND `PARTITION_NAME`="" AND `SUBPARTITION_NAME`="" AND `PARTITION_ORDINAL_POSITION`="" AND `SUBPARTITION_ORDINAL_POSITION`="" AND `PARTITION_METHOD`="" AND `SUBPARTITION_METHOD`="" AND `PARTITION_EXPRESSION`="" AND `SUBPARTITION_EXPRESSION`="" AND `PARTITION_DESCRIPTION`="" AND `TABLE_ROWS`="0" AND `AVG_ROW_LENGTH`="230" AND `DATA_LENGTH`="0" AND `MAX_DATA_LENGTH`="33265130" AND `INDEX_LENGTH`="0" AND `DATA_FREE`="0" AND `CREATE_TIME`="2024-10-07 20:35:25" AND `UPDATE_TIME`="" AND `CHECK_TIME`="" AND `CHECKSUM`="" AND `PARTITION_COMMENT`="" AND `NODEGROUP`="" AND `TABLESPACE_NAME`="" | kill |
| 2742725957 | filmtheater | localhost | Query | 0 | starting | SHOW FULL PROCESSLIST | kill |