SELECT * FROM `INNODB_TRX`
Filter rows: |
trx_id | trx_state | trx_started | trx_requested_lock_id | trx_wait_started | trx_weight | trx_mysql_thread_id | trx_query | trx_operation_state | trx_tables_in_use | trx_tables_locked | trx_lock_structs | trx_lock_memory_bytes | trx_rows_locked | trx_rows_modified | trx_concurrency_tickets | trx_isolation_level | trx_unique_checks | trx_foreign_key_checks | trx_last_foreign_key_error | trx_adaptive_hash_latched | trx_adaptive_hash_timeout | trx_is_read_only | trx_autocommit_non_locking | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
20085154 | LOCK WAIT | 2024-09-24 11:59:09 | 20085154:5775:3:14 | 2024-09-24 11:59:09 | 10 | 47608 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | inserting | 1 | 1 | 10 | 992 | 1 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085153 | LOCK WAIT | 2024-09-24 11:59:09 | 20085153:5775:3:14 | 2024-09-24 11:59:09 | 10 | 47611 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | inserting | 1 | 1 | 10 | 992 | 1 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085152 | LOCK WAIT | 2024-09-24 11:59:09 | 20085152:5775:3:14 | 2024-09-24 11:59:09 | 10 | 47605 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | inserting | 1 | 1 | 10 | 992 | 1 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085137 | LOCK WAIT | 2024-09-24 11:59:09 | 20085137:5775:3:14 | 2024-09-24 11:59:09 | 14 | 47599 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | inserting | 1 | 1 | 14 | 2408 | 1 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085125 | LOCK WAIT | 2024-09-24 11:59:09 | 20085125:5775:3:14 | 2024-09-24 11:59:09 | 16 | 47602 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | inserting | 1 | 1 | 16 | 2408 | 1 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085107 | LOCK WAIT | 2024-09-24 11:59:08 | 20085107:5775:3:14 | 2024-09-24 11:59:08 | 18 | 47586 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | inserting | 1 | 1 | 18 | 2408 | 1 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085088 | LOCK WAIT | 2024-09-24 11:59:08 | 20085088:5775:3:14 | 2024-09-24 11:59:08 | 22 | 47581 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | inserting | 1 | 1 | 22 | 2408 | 1 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085083 | LOCK WAIT | 2024-09-24 11:59:08 | 20085083:5775:3:14 | 2024-09-24 11:59:08 | 22 | 47551 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | inserting | 1 | 1 | 22 | 2408 | 1 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085081 | LOCK WAIT | 2024-09-24 11:59:08 | 20085081:5775:3:14 | 2024-09-24 11:59:08 | 22 | 47593 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | inserting | 1 | 1 | 22 | 2408 | 1 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085080 | RUNNING | 2024-09-24 11:59:08 | NULL | NULL | 21 | 47596 | REPLACE INTO `phpmyadmin`.`pma__recent` (`username... | preparing | 1 | 1 | 20 | 2408 | 1 | 1 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 0 | 0 | |
20085156 | RUNNING | 2024-09-24 11:59:09 | NULL | NULL | 0 | 47613 | SELECT COUNT(*) FROM `gpsbeta`.`file_movement` | fetching rows | 0 | 0 | 0 | 312 | 0 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 0 | 10000 | 1 | 1 |
Filter rows: |