Startseite

• » Statusinformationen
• » Datenbanken
• » MySQL-Variablen
• » MySQL-Befehle

MySQL-Variablen

Prozesse    Prozesse   Status   Variablen   

 

Es wird seit 2 Sekunde(n) versucht, Prozess 9323 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	1	Update	INSERT INTO history (TIMESTAMP, DEVICE, TYPE, EVENT, READING, VALUE, UNIT) VALUES ('2026-10-03 07:56:57','MQTT2_ebusd','MQTT2_DEVICE','betrdFeuer1_kesseltemp_value','state','betrdFeuer1_kesseltemp_value',NULL)	kill
7863	burkhard	localhost	fhem	Sleep	23951			kill
9965	burkhard	localhost:33698	fhem	Query	1233	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30	kill
9968	burkhard	localhost:33826	fhem	Query	1219	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30	kill
9969	burkhard	localhost:33830	fhem	Query	1219	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30	kill
9972	burkhard	localhost:33892	fhem	Query	1110	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30	kill
9975	burkhard	localhost:33926	fhem	Query	1101	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30	kill
9981	burkhard	localhost:34016	fhem	Query	1091	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30	kill
9982	burkhard	localhost:34060	fhem	Query	1090	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30	kill
9989	burkhard	localhost:34146	fhem	Query	1090	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30	kill
9990	burkhard	localhost:34150	fhem	Query	1090	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30	kill
9991	burkhard	localhost:34206	fhem	Query	1090	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30	kill
9992	burkhard	localhost:34210	fhem	Query	1090	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30	kill
9997	burkhard	localhost:34244	fhem	Query	1090	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30	kill
9998	burkhard	localhost:34268	fhem	Query	1090	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30	kill
10001	burkhard	localhost:34386	fhem	Query	1077	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3785898, 30	kill
10003	burkhard	localhost:34394	fhem	Query	1077	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30	kill
10011	burkhard	localhost:34480	fhem	Query	1041	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3865473, 30	kill
10073	burkhard	localhost:35964	fhem	Query	628	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30	kill
10079	burkhard	localhost:36072	fhem	Query	629	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30	kill
10080	burkhard	localhost:36166	fhem	Query	629	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30	kill
10082	burkhard	localhost:36194	fhem	Query	629	Creating sort index	SELECT * FROM `history` ORDER BY `EVENT` ASC LIMIT 3787347, 30	kill
10086	burkhard	localhost:36280	fhem	Query	639	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30	kill
10087	burkhard	localhost:36306	fhem	Query	629	Creating sort index	SELECT * FROM `history` ORDER BY `EVENT` ASC LIMIT 3787347, 30	kill
10089	burkhard	localhost:36380	fhem	Query	629	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30	kill
10092	burkhard	localhost:36414	fhem	Query	629	Creating sort index	SELECT * FROM `history` ORDER BY `EVENT` ASC LIMIT 3787347, 30	kill
10095	burkhard	localhost:36490	fhem	Query	543	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30	kill
10096	burkhard	localhost:36522	fhem	Query	543	Creating sort index	SELECT * FROM `history` ORDER BY `EVENT` ASC LIMIT 3787347, 30	kill
10097	burkhard	localhost:36532	fhem	Query	543	Creating sort index	SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30	kill
10100	burkhard	localhost:36600	fhem	Query	356	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30	kill
10101	burkhard	localhost:36618	fhem	Query	356	Creating sort index	SELECT * FROM `history` ORDER BY `EVENT` ASC LIMIT 3787347, 30	kill
10111	burkhard	localhost:36720	fhem	Query	356	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 60, 30	kill
10113	burkhard	localhost:36752	fhem	Query	356	Creating sort index	SELECT * FROM `history` ORDER BY `EVENT` ASC LIMIT 3787347, 30	kill
10114	burkhard	localhost:36856	fhem	Query	356	Creating sort index	SELECT * FROM `history` ORDER BY `EVENT` ASC LIMIT 3787347, 30	kill
10120	burkhard	localhost:36942	fhem	Query	356	Creating sort index	SELECT * FROM `history` ORDER BY `EVENT` ASC LIMIT 3787347, 30	kill
10123	burkhard	localhost:36996	fhem	Query	356	Creating sort index	SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30	kill
10124	burkhard	localhost:37044	fhem	Query	377	Creating sort index	SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30	kill
10127	burkhard	localhost:37122	fhem	Query	377	Creating sort index	SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30	kill
10129	burkhard	localhost:37216	fhem	Query	436	Creating sort index	SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30	kill
10136	burkhard	localhost:37388	fhem	Query	423	Creating sort index	SELECT * FROM `history` ORDER BY `TIMESTAMP` ASC LIMIT 0, 30	kill
10220	burkhard	localhost:39456		Query	0	Init	SHOW FULL PROCESSLIST	kill