Startseite

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

MySQL-Variablen

Prozesse    Prozesse   Status   Variablen   

 

Es wird seit 2 Sekunde(n) versucht, Prozess 1044 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	65	Waiting for table metadata lock	INSERT INTO history (TIMESTAMP, DEVICE, TYPE, EVENT, READING, VALUE, UNIT) VALUES ('2026-10-02 02:59:46','SolarSpeicher','MODBUSATTR','Abregelung: 0','Abregelung','0',NULL)	kill
2405	burkhard	localhost:53670	fhem	Query	1399	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
2409	burkhard	localhost:53766	fhem	Query	1400	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
2412	burkhard	localhost:53854	fhem	Query	1400	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
2418	burkhard	localhost:53966	fhem	Query	1400	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
2424	burkhard	localhost:54060	fhem	Query	1400	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
2426	burkhard	localhost:54166	fhem	Query	1399	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
2429	burkhard	localhost:54246	fhem	Query	1400	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
2435	burkhard	localhost:54380	fhem	Query	1394	Creating sort index	SELECT * FROM `history` ORDER BY `DEVICE` ASC LIMIT 3819041, 30	kill
2808	burkhard	localhost	fhem	Query	73	Waiting for table metadata lock	OPTIMIZE TABLE `history`	kill
2822	burkhard	localhost:33752		Query	0	Init	SHOW FULL PROCESSLIST	kill