Всем привет!
Смотрю mysqldumpslow -t 10 -s l mysql-slow.log
В ТОПе запросы
Count: 435316 Time=0.00s (83s) Lock=0.00s (153s) Rows=0.0 (0), main[main]@2hosts
SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'S' AND FILE_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IN (SELECT DISTINCT LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'S' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA='S' AND TABLE_NAME IN ('S'))) GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE ORDER BY LOGFILE_GROUP_NAME
Count: 435316 Time=0.00s (64s) Lock=0.00s (101s) Rows=0.0 (0), main[main]@2hosts
SELECT DISTINCT TABLESPACE_NAME, FILE_NAME, LOGFILE_GROUP_NAME, EXTENT_SIZE, INITIAL_SIZE, ENGINE FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'S' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA='S' AND TABLE_NAME IN ('S')) ORDER BY TABLESPACE_NAME, LOGFILE_GROUP_NAME
Что приводит к генерации таких запросов?
Все таблицы на InnoDB.
Спасибо!