MySQL-Variablen
Prozesse Prozesse Status Variablen
Es wird seit 2 Sekunde(n) versucht, Prozess 9321 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 | Query | 0 | Update | INSERT INTO history (TIMESTAMP, DEVICE, TYPE, EVENT, READING, VALUE, UNIT) VALUES ('2026-10-03 08:02:49','MQTT2_ebusd','MQTT2_DEVICE','betrdFeuer1_aussentemp_value','state','betrdFeuer1_aussentemp_value',NULL) | kill |
| 7863 | burkhard | localhost | fhem | Sleep | 24284 | kill | ||
| 9972 | burkhard | localhost:33892 | fhem | Query | 1443 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 9975 | burkhard | localhost:33926 | fhem | Query | 1433 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30 | kill |
| 9981 | burkhard | localhost:34016 | fhem | Query | 1423 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 9982 | burkhard | localhost:34060 | fhem | Query | 1422 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30 | kill |
| 9989 | burkhard | localhost:34146 | fhem | Query | 1422 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 9990 | burkhard | localhost:34150 | fhem | Query | 1422 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30 | kill |
| 9991 | burkhard | localhost:34206 | fhem | Query | 1422 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 9992 | burkhard | localhost:34210 | fhem | Query | 1422 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30 | kill |
| 9997 | burkhard | localhost:34244 | fhem | Query | 1422 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 9998 | burkhard | localhost:34268 | fhem | Query | 1422 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30 | kill |
| 10001 | burkhard | localhost:34386 | fhem | Query | 1410 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30 | kill |
| 10003 | burkhard | localhost:34394 | fhem | Query | 1410 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30 | kill |
| 10011 | burkhard | localhost:34480 | fhem | Query | 1374 | Creating sort index | SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30 | kill |
| 10073 | burkhard | localhost:35964 | fhem | Query | 961 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30 | kill |
| 10079 | burkhard | localhost:36072 | fhem | Query | 962 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30 | kill |
| 10080 | burkhard | localhost:36166 | fhem | Query | 961 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30 | kill |
| 10086 | burkhard | localhost:36280 | fhem | Query | 971 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30 | kill |
| 10089 | burkhard | localhost:36380 | fhem | Query | 961 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30 | kill |
| 10095 | burkhard | localhost:36490 | fhem | Query | 875 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30 | kill |
| 10097 | burkhard | localhost:36532 | fhem | Query | 875 | Creating sort index | SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30 | kill |
| 10100 | burkhard | localhost:36600 | fhem | Query | 688 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30 | kill |
| 10111 | burkhard | localhost:36720 | fhem | Query | 688 | Creating sort index | SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30 | kill |
| 10123 | burkhard | localhost:36996 | fhem | Query | 689 | Creating sort index | SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30 | kill |
| 10124 | burkhard | localhost:37044 | fhem | Query | 709 | Creating sort index | SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30 | kill |
| 10127 | burkhard | localhost:37122 | fhem | Query | 709 | Creating sort index | SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30 | kill |
| 10129 | burkhard | localhost:37216 | fhem | Query | 768 | Creating sort index | SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30 | kill |
| 10136 | burkhard | localhost:37388 | fhem | Query | 756 | Creating sort index | SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30 | kill |
| 10247 | burkhard | localhost:40124 | fhem | Query | 194 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10248 | burkhard | localhost:40134 | fhem | Query | 193 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10253 | burkhard | localhost:40216 | fhem | Query | 177 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10259 | burkhard | localhost:40334 | fhem | Query | 155 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10261 | burkhard | localhost:40366 | fhem | Query | 148 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10262 | burkhard | localhost:40384 | fhem | Query | 145 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10263 | burkhard | localhost:40454 | fhem | Query | 129 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10264 | burkhard | localhost:40484 | fhem | Query | 120 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10266 | burkhard | localhost:40548 | fhem | Query | 105 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10268 | burkhard | localhost:40612 | fhem | Query | 92 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10269 | burkhard | localhost:40618 | fhem | Query | 92 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10273 | burkhard | localhost:40724 | fhem | Query | 70 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10276 | burkhard | localhost:40776 | fhem | Query | 62 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10277 | burkhard | localhost:40842 | fhem | Query | 48 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10278 | burkhard | localhost:40892 | fhem | Query | 38 | Sending data | SELECT count(*) as anzahl FROM (select * from `history`) as query | kill |
| 10279 | burkhard | localhost:41056 | information_schema | Query | 0 | Checking permissions | SELECT count(*) as anzahl FROM (select * from `columns`) as query | kill |
| 10280 | burkhard | localhost:41060 | information_schema | Query | 0 | Filling schema table | SELECT count(*) as anzahl FROM (select * from `innodb_buffer_page_lru`) as query | kill |
| 10281 | burkhard | localhost:41064 | Query | 0 | Init | SHOW FULL PROCESSLIST | kill |