[Tools]
Datenbank:
`information_schema`
Tabelle: `INNODB_TRX`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`INNODB_TRX`
Datensätze 1 - 1 von insgesamt 1 << < > >>
| Ansicht: kompakt Die Abfrage enthält 22 Spalten | |||||||||||||||||||||||
| # |  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_is_read_only | trx_autocommit_non_locking | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
  | 1. | 18446744072165004 | RUNNING | 2026-06-24 01:26:45 | NULL | NULL | 0 | 89344 | SELECT TIMESTAMP,DEVICE,'',READING,VALUE FROM history WHERE TIMESTAMP < DATE_SUB(CURDATE(),INTERVAL 1 DAY) AND TIMESTAMP >= DATE_SUB(CURDATE(),INTERVAL 7 DAY) ORDER BY TIMESTAMP ASC | fetching rows | 1 | 0 | 0 | 1080 | 0 | 0 | 0 | REPEATABLE READ | 1 | 1 | NULL | 1 | 1 |
Datensätze 1 - 1 von insgesamt 1 << < > >>