[Tools]
Datenbank:
`information_schema`
Tabelle: `PROCESSLIST`
Daten-Ansicht
Datensatz einfügen Tabellenstruktur bearbeiten
Tabelle `information_schema`.`PROCESSLIST`
Datensätze 1 - 8 von insgesamt 8 << < > >>
| Ansicht: kompakt Die Abfrage enthält 18 Spalten | |||||||||||||||||||
| # |  ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | STAGE | MAX_STAGE | PROGRESS | MEMORY_USED | MAX_MEMORY_USED | EXAMINED_ROWS | QUERY_ID | INFO_BINARY | TID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
  | 1. | 89349 | burkhard | localhost:41794 | information_schema | Query | 0 | Filling schema table | SELECT * FROM `PROCESSLIST` LIMIT 0, 30 | 0.918 | 0 | 0 | 0.000 | 83216 | 378128 | 0 | 49828420 | SELECT * FROM `PROCESSLIST` LIMIT 0, 30 | 4290 |
|
| 2. | 89344 | burkhard | localhost | fhem | Query | 4 | Creating sort index | 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 | 4367.992 | 0 | 0 | 0.000 | 2167016 | 2167016 | 0 | 49828397 | 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 | 30277 |
|
| 3. | 88903 | burkhard | localhost | fhem | Sleep | 181 | NULL | 181371.306 | 0 | 0 | 0.000 | 69736 | 228392 | 0 | 49826716 | NULL | 29687 | |
|
| 4. | 5 | system user | NULL | Daemon | 0 | InnoDB shutdown handler | NULL | 0.000 | 0 | 0 | 0.000 | 17552 | 17552 | 0 | 0 | NULL | 828 | |
|
| 5. | 4 | system user | NULL | Daemon | 0 | InnoDB purge worker | NULL | 0.000 | 0 | 0 | 0.000 | 17552 | 17552 | 0 | 0 | NULL | 824 | |
|
| 6. | 3 | system user | NULL | Daemon | 0 | InnoDB purge worker | NULL | 0.000 | 0 | 0 | 0.000 | 17552 | 17552 | 0 | 0 | NULL | 823 | |
|
| 7. | 1 | system user | NULL | Daemon | 0 | InnoDB purge coordinator | NULL | 0.000 | 0 | 0 | 0.000 | 17552 | 17552 | 0 | 0 | NULL | 821 | |
|
| 8. | 2 | system user | NULL | Daemon | 0 | InnoDB purge worker | NULL | 0.000 | 0 | 0 | 0.000 | 17552 | 17552 | 0 | 0 | NULL | 822 | |
Datensätze 1 - 8 von insgesamt 8 << < > >>