MySQL-Variablen
Prozesse Prozesse Status Variablen
Es wird seit 2 Sekunde(n) versucht, Prozess 28274 zu beenden.
| ID | User | Host | DB | Command | Time | State | Info | RT: 3 sec |
|---|---|---|---|---|---|---|---|---|
| 1 | system user | Daemon | InnoDB purge coordinator | kill | ||||
| 2 | system user | Daemon | InnoDB purge worker | kill | ||||
| 3 | system user | Daemon | InnoDB purge worker | kill | ||||
| 4 | system user | Daemon | InnoDB purge worker | kill | ||||
| 5 | system user | Daemon | InnoDB shutdown handler | kill | ||||
| 30049 | burkhard | localhost:38272 | fhem | Query | 605 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 30062 | burkhard | localhost:38418 | fhem | Query | 584 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 30076 | burkhard | localhost:38550 | fhem | Query | 568 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 30084 | burkhard | localhost:38670 | fhem | Query | 552 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 30097 | burkhard | localhost:38816 | fhem | Query | 478 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 30110 | burkhard | localhost:38930 | fhem | Query | 462 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 30111 | burkhard | localhost:38962 | fhem | Query | 462 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 30114 | burkhard | localhost:39080 | fhem | Query | 446 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 30300 | burkhard | localhost | fhem | Query | 0 | Updating | UPDATE current SET TIMESTAMP='2026-10-02 00:39:13', TYPE='MODBUSATTR', EVENT='battsoc: 3', VALUE='3', UNIT=NULL WHERE (DEVICE='SolarSpeicher') AND (READING='battsoc') | kill |
| 30363 | burkhard | localhost:41722 | information_schema | Query | 10 | Filling schema table | SELECT count(*) as anzahl FROM (select * from `innodb_buffer_page`) as query | kill |
| 30373 | burkhard | localhost:41800 | information_schema | Query | 0 | Optimizing | SELECT count(*) as anzahl FROM (select * from `all_plugins`) as query | kill |
| 30374 | burkhard | localhost:41804 | fhem | Sleep | 0 | kill | ||
| 30375 | burkhard | localhost:41808 | Query | 0 | Init | SHOW FULL PROCESSLIST | kill | |
| 30376 | burkhard | localhost:41812 | information_schema | Query | 0 | Opening tables | SHOW FULL FIELDS FROM `information_schema`.`INNODB_BUFFER_PAGE_LRU` | kill |
| 30377 | burkhard | localhost:41816 | Sleep | 0 | kill | |||
| 30378 | burkhard | localhost:41820 | Sleep | 0 | kill | |||
| 30380 | burkhard | localhost:41828 | Sleep | 0 | kill | |||
| 30381 | unauthenticated user | localhost:41832 | Connect | 0 | Reset for next command | kill |