The backup process has not been completed for a long time. I checked and found that there is a slow SQL query. How can we adjust it?
# User@Host: webuser[webuser] @ localhost [] Id: 352018
Query_time: 70501.609143 Lock_time: 0.001609 Rows_sent: 71748 Rows_examined: 430506
SET timestamp=1779530407;
SELECT T2.PATH, T2.NAME, T1.SPACE_TYPE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES T1 JOIN INFORMATION_SCHEMA.INNODB_TABLESPACES_BRIEF T2 USING (SPACE) WHERE T1.SPACE_TYPE = ‘Single’ && T1.ROW_FORMAT != 'Undo’UNION SELECT T2.PATH, SUBSTRING_INDEX(SUBSTRING_INDEX(T2.PATH, ‘/’, -1), ‘.’, 1) NAME, T1.SPACE_TYPE FROM INFORMATION_SCHEMA .INNODB_TABLESPACES T1 JOIN INFORMATION_SCHEMA .INNODB_TABLESPACES_BRIEF T2 USING (SPACE) WHERE T1.SPACE_TYPE = ‘General’ && T1.ROW_FORMAT != ‘Undo’;