mysql 查看库表数量,库空间大小

select 
　　count(TABLE_NAME), 

　　concat(truncate(data_length/1024/1024,2),' MB') as data_size,

　　concat(truncate(index_length/1024/1024,2),' MB') as index_size

from information_schema.tables where TABLE_SCHEMA = 'TestDB'