Startseite

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

MySQL-Variablen

Prozesse    Prozesse   Status   Variablen   

 

Es wird seit 2 Sekunde(n) versucht, Prozess 120891 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
208	burkhard	localhost	fhem	Query	331	Creating sort index	SELECT TIMESTAMP,DEVICE,'',READING,VALUE FROM history WHERE TIMESTAMP < DATE_SUB(CURDATE(),INTERVAL 1 DAY) AND TIMESTAMP >= DATE_SUB(CURDATE(),INTERVAL 7 DAY) ORDER BY TIMESTAMP ASC	kill
477	burkhard	localhost:37414	fhem	Query	1977	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3786432, 30	kill
492	burkhard	localhost:37566	fhem	Query	1966	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3786432, 30	kill
496	burkhard	localhost:37668	fhem	Query	1948	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3786432, 30	kill
506	burkhard	localhost:37750	fhem	Query	1881	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3786432, 30	kill
512	burkhard	localhost:37870	fhem	Query	1881	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3786432, 30	kill
521	burkhard	localhost:37954	fhem	Query	1872	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3786432, 30	kill
535	burkhard	localhost:38084	fhem	Query	1856	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3786432, 30	kill
536	burkhard	localhost:38110	fhem	Query	1844	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 3786432, 30	kill
1039	burkhard	localhost:43740	fhem	Query	857	Sending data	SELECT * FROM `history` LIMIT 3895925, 30	kill
1057	burkhard	localhost:43878	fhem	Query	836	Sending data	SELECT * FROM `history` LIMIT 3895925, 30	kill
1063	burkhard	localhost:43980	fhem	Query	812	Sending data	SELECT * FROM `history` LIMIT 3895925, 30	kill
1082	burkhard	localhost:44124	fhem	Query	796	Sending data	SELECT * FROM `history` LIMIT 3895925, 30	kill
1089	burkhard	localhost:44228	fhem	Query	775	Sending data	SELECT * FROM `history` LIMIT 3895925, 30	kill
1095	burkhard	localhost:44338	fhem	Query	754	Sending data	SELECT * FROM `history` LIMIT 3895925, 30	kill
1103	burkhard	localhost:44438	fhem	Query	734	Sending data	SELECT * FROM `history` LIMIT 3895925, 30	kill
1113	burkhard	localhost:44556	fhem	Query	712	Sending data	SELECT * FROM `history` LIMIT 3895925, 30	kill
1182	burkhard	localhost:45278	fhem	Query	593	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 30, 30	kill
1190	burkhard	localhost:45394	fhem	Query	570	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 30, 30	kill
1194	burkhard	localhost:45484	fhem	Query	552	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 30, 30	kill
1205	burkhard	localhost:45606	fhem	Query	535	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 30, 30	kill
1209	burkhard	localhost:45724	fhem	Query	507	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 30, 30	kill
1220	burkhard	localhost:45814	fhem	Query	493	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 30, 30	kill
1230	burkhard	localhost:45938	fhem	Query	473	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 30, 30	kill
1240	burkhard	localhost:46034	fhem	Query	452	Creating sort index	SELECT * FROM `history` ORDER BY `READING` ASC LIMIT 30, 30	kill
1284	burkhard	localhost:47026	fhem	Query	238	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1291	burkhard	localhost:47108	fhem	Query	222	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1294	burkhard	localhost:47188	fhem	Query	207	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1301	burkhard	localhost:47238	fhem	Query	202	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1311	burkhard	localhost:47320	fhem	Query	187	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1316	burkhard	localhost:47382	fhem	Query	177	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1322	burkhard	localhost:47436	fhem	Query	162	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1324	burkhard	localhost:47444	fhem	Query	162	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1325	burkhard	localhost:47504	fhem	Query	147	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1326	burkhard	localhost:47552	fhem	Query	134	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1327	burkhard	localhost:47586	fhem	Query	127	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1330	burkhard	localhost:47630	fhem	Query	118	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1337	burkhard	localhost:47688	fhem	Query	107	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1339	burkhard	localhost:47724	fhem	Query	98	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1341	burkhard	localhost:47772	fhem	Query	86	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1344	burkhard	localhost:47862	fhem	Query	60	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1358	burkhard	localhost:48056	fhem	Query	20	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1364	burkhard	localhost:48138	fhem	Query	4	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
1370	burkhard	localhost:48182		Query	0	Init	SHOW FULL PROCESSLIST	kill