MySQL Forums
Forum List  »  German

Leistungseinbruch bei Aufrufen DB über PhpMyAdmin
Posted by: Maurizio Nicosia
Date: June 13, 2022 10:00AM

Beim Aufrufen einer Datenbank über PhpMyAdmin geht die CPU in die Knie.
Ich habe einen meinen Server neu aufbaut und die Datenbank per mysqldump zurückgesichert. Im Dump waren allerdings nur ganz bestimmte Datenbanken ohne mysql, performance_schema oder information_schema.

Ich habe mich auf die Lauer gelegt mit "slow-log"...

Hier das Resultat:
Es kommt eindeutig davon, wenn ich über PhpMyAdmin auf eine meiner Datenbanken klicke... Dann dauert es ewig und es loggt dann diesen query

# Query_time: 21.351066 Lock_time: 0.003935 Rows_sent: 239 Rows_examined: 33858
use db_mustermann;
SET timestamp=1655134989;
SELECT *,
`TABLE_SCHEMA` AS `Db`,
`TABLE_NAME` AS `Name`,
`TABLE_TYPE` AS `TABLE_TYPE`,
`ENGINE` AS `Engine`,
`ENGINE` AS `Type`,
`VERSION` AS `Version`,
`ROW_FORMAT` AS `Row_format`,
`TABLE_ROWS` AS `Rows`,
`AVG_ROW_LENGTH` AS `Avg_row_length`,
`DATA_LENGTH` AS `Data_length`,
`MAX_DATA_LENGTH` AS `Max_data_length`,
`INDEX_LENGTH` AS `Index_length`,
`DATA_FREE` AS `Data_free`,
`AUTO_INCREMENT` AS `Auto_increment`,
`CREATE_TIME` AS `Create_time`,
`UPDATE_TIME` AS `Update_time`,
`CHECK_TIME` AS `Check_time`,
`TABLE_COLLATION` AS `Collation`,
`CHECKSUM` AS `Checksum`,
`CREATE_OPTIONS` AS `Create_options`,
`TABLE_COMMENT` AS `Comment`
FROM `information_schema`.`TABLES` t
WHERE `TABLE_SCHEMA` COLLATE utf8_bin
IN ('db_mustermann')
ORDER BY Name ASC LIMIT 250 OFFSET 0;

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.