MySQL-Variablen
Prozesse Prozesse Status Variablen
Es wird seit 2 Sekunde(n) versucht, Prozess 75502 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 | ||||
| 69041 | burkhard | localhost | fhem | Query | 0 | Updating | UPDATE current SET TIMESTAMP='2026-09-28 11:24:18', TYPE='LUFTDATENINFO', EVENT='state: active', VALUE='active', UNIT=NULL WHERE (DEVICE='HNTM') AND (READING='state') | kill |
| 76540 | burkhard | localhost:41136 | fhem | Query | 438 | Creating sort index | SELECT * FROM `history` ORDER BY `UNIT` DESC LIMIT 3882432, 30 | kill |
| 76542 | burkhard | localhost:41194 | fhem | Query | 431 | Creating sort index | SELECT * FROM `history` ORDER BY `UNIT` DESC LIMIT 3882432, 30 | kill |
| 76551 | burkhard | localhost:41310 | fhem | Query | 405 | Creating sort index | SELECT * FROM `history` ORDER BY `UNIT` DESC LIMIT 3882432, 30 | kill |
| 76555 | burkhard | localhost:41398 | fhem | Query | 391 | Creating sort index | SELECT * FROM `history` ORDER BY `UNIT` DESC LIMIT 3882432, 30 | kill |
| 76569 | burkhard | localhost:41502 | fhem | Query | 293 | Creating sort index | SELECT * FROM `history` ORDER BY `UNIT` DESC LIMIT 3882432, 30 | kill |
| 76570 | burkhard | localhost:41590 | fhem | Query | 293 | Creating sort index | SELECT * FROM `history` ORDER BY `UNIT` DESC LIMIT 3882432, 30 | kill |
| 76572 | burkhard | localhost:41670 | fhem | Query | 290 | Creating sort index | SELECT * FROM `history` ORDER BY `UNIT` DESC LIMIT 3882432, 30 | kill |
| 76668 | burkhard | localhost:43178 | information_schema | Query | 0 | Converting HEAP to Aria | SELECT * FROM `INNODB_BUFFER_PAGE_LRU` ORDER BY `POOL_ID` ASC LIMIT 970, 30 | kill |
| 76670 | burkhard | localhost:43200 | information_schema | Query | 7 | Filling schema table | SELECT count(*) as anzahl FROM (select * from `innodb_buffer_page`) as query | kill |
| 76671 | burkhard | localhost:43204 | information_schema | Query | 8 | Removing tmp table | SELECT count(*) as anzahl FROM (select * from `partitions`) as query | kill |
| 76674 | burkhard | localhost:43250 | mysql | Sleep | 0 | kill | ||
| 76675 | burkhard | localhost:43254 | information_schema | Sleep | 0 | kill | ||
| 76676 | burkhard | localhost:43258 | information_schema | Query | 0 | Converting HEAP to Aria | SELECT count(*) as anzahl FROM (select * from `innodb_buffer_page_lru`) as query | kill |
| 76677 | burkhard | localhost:43268 | Query | 0 | Init | SHOW FULL PROCESSLIST | kill |