ACollecting information requires large numbers of locks on various INFORMATION_SCHEMA tables
BAggregating details from various storage engine caches for the final output is time consuming
CCollecting information requires various disk-level operations and is time consuming
DCounting and summarizing all table pages in the InnoDB shared tablespace is time consuming