MySQL-Variablen
Prozesse Prozesse Status Variablen
Es wird seit 2 Sekunde(n) versucht, Prozess 10101 zu beenden.
| ID | User | Host | DB | Command | Time | State | Info | RT: 3 sec |
|---|---|---|---|---|---|---|---|---|
| 2 | system user | Daemon | InnoDB purge coordinator | kill | ||||
| 1 | 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 | ||||
| 183 | burkhard | localhost | fhem | Sleep | 23 | kill | ||
| 10992 | burkhard | localhost:59720 | fhem | Query | 1019 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30 | kill |
| 10997 | burkhard | localhost:59874 | fhem | Query | 986 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30 | kill |
| 10999 | burkhard | localhost:59924 | fhem | Query | 977 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30 | kill |
| 11001 | burkhard | localhost:60000 | fhem | Query | 942 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30 | kill |
| 11002 | burkhard | localhost:60052 | fhem | Query | 919 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30 | kill |
| 11005 | burkhard | localhost:60134 | fhem | Query | 929 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30 | kill |
| 11010 | burkhard | localhost:60236 | fhem | Query | 908 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30 | kill |
| 11011 | burkhard | localhost:60284 | fhem | Query | 888 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30 | kill |
| 11089 | burkhard | localhost:34132 | fhem | Query | 388 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 11099 | burkhard | localhost:34260 | fhem | Query | 367 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 11100 | burkhard | localhost:34354 | fhem | Query | 347 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 11102 | burkhard | localhost:34422 | fhem | Query | 320 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 11103 | burkhard | localhost:34486 | fhem | Query | 307 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 11107 | burkhard | localhost:34584 | fhem | Query | 281 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 11110 | burkhard | localhost:34662 | fhem | Query | 262 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 11113 | burkhard | localhost:34752 | fhem | Query | 242 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 11145 | burkhard | localhost:35792 | Query | 0 | Init | SHOW FULL PROCESSLIST | kill |