Startseite

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

MySQL-Variablen

Prozesse    Prozesse   Status   Variablen   

 

Es wird seit 2 Sekunde(n) versucht, Prozess 30579 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	17	Init	COMMIT	kill
1982	burkhard	localhost:46922	fhem	Query	71	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
2000	burkhard	localhost:47150	fhem	Query	40	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
2013	burkhard	localhost:47268	fhem	Query	15	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
2019	burkhard	localhost:47358	fhem	Query	11	Creating sort index	SELECT * FROM `history` ORDER BY `VALUE` ASC LIMIT 3815060, 30	kill
2020	burkhard	localhost:47386	information_schema	Query	7	Removing tmp table	SHOW FULL FIELDS FROM `information_schema`.`CHARACTER_SETS`	kill
2021	burkhard	localhost:47396	information_schema	Query	7	Opening tables	SHOW FULL FIELDS FROM `information_schema`.`INNODB_BUFFER_POOL_STATS`	kill
2022	burkhard	localhost:47394	information_schema	Query	7	Opening tables	SHOW FIELDS FROM `COLLATIONS`	kill
2023	burkhard	localhost:47402	information_schema	Query	7	Opening tables	SHOW TABLE STATUS FROM `information_schema`	kill
2024	burkhard	localhost:47430	fhem	Query	1	Sending data	SELECT count(*) as anzahl FROM (select * from `history`) as query	kill
2026	burkhard	localhost:47448		Query	0	Init	SHOW FULL PROCESSLIST	kill