Startseite

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

MySQL-Variablen

Prozesse    Prozesse   Status   Variablen   

 

Es wird seit 2 Sekunde(n) versucht, Prozess 57791 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
57844	burkhard	localhost:58074	fhem	Query	1702	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
57849	burkhard	localhost:58194	fhem	Query	1702	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
57864	burkhard	localhost:58332	fhem	Query	1702	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
57868	burkhard	localhost:58436	fhem	Query	1702	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
57872	burkhard	localhost:58524	fhem	Query	1702	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
57880	burkhard	localhost:58644	fhem	Query	1702	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
57881	burkhard	localhost:58760	fhem	Query	1702	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
57882	burkhard	localhost:58860	fhem	Query	1702	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
57984	burkhard	localhost	fhem	Query	0	Init	COMMIT	kill
58095	burkhard	localhost:35400	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 0, 30	kill
58098	burkhard	localhost:35412	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 0, 30	kill
58122	burkhard	localhost:35570	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 0, 30	kill
58125	burkhard	localhost:35716	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 0, 30	kill
58134	burkhard	localhost:35848	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 0, 30	kill
58138	burkhard	localhost:35960	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 0, 30	kill
58145	burkhard	localhost:36090	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 0, 30	kill
58155	burkhard	localhost:36232	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 0, 30	kill
58171	burkhard	localhost:36500	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
58176	burkhard	localhost:36614	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
58182	burkhard	localhost:36742	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
58185	burkhard	localhost:36832	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
58186	burkhard	localhost:36952	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
58191	burkhard	localhost:37040	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
58194	burkhard	localhost:37108	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
58197	burkhard	localhost:37214	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
58307	burkhard	localhost:40178	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `TYPE` ASC LIMIT 3846040, 30	kill
58325	burkhard	localhost:40370	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `TYPE` ASC LIMIT 3846040, 30	kill
58326	burkhard	localhost:40454	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `TYPE` ASC LIMIT 3846040, 30	kill
58335	burkhard	localhost:40596	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `TYPE` ASC LIMIT 3846040, 30	kill
58336	burkhard	localhost:40712	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `TYPE` ASC LIMIT 3846040, 30	kill
58350	burkhard	localhost:40852	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `TYPE` ASC LIMIT 3846040, 30	kill
58356	burkhard	localhost:40980	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `TYPE` ASC LIMIT 3846040, 30	kill
58361	burkhard	localhost:41116	fhem	Query	1166	Creating sort index	SELECT * FROM `history` ORDER BY `TYPE` ASC LIMIT 3846040, 30	kill
58629	burkhard	localhost:49850		Query	0	Writing to net	SHOW FULL PROCESSLIST	kill
58630	burkhard	localhost:49854		Query	0	Init	SHOW FULL PROCESSLIST	kill
58631	burkhard	localhost:49858		Sleep	0			kill
58632	unauthenticated user	localhost:49862		Connect	0	Reading from net		kill