查询mysql数据库中数据内存大小以及数据索引内存语句

查看单表的数据大小与索引大小

SELECT CONCAT( ROUND( (INDEX_LENGTH + DATA_LENGTH) / 1024 / 1024, 2 ), 'MB') AS 'total_size',
                CONCAT(ROUND(DATA_LENGTH / 1024 / 1024, 2),'MB') AS 'data_size',
                CONCAT(ROUND(INDEX_LENGTH / 1024 / 1024, 2),'MB') AS 'index_size'
                FROM INFORMATION_SCHEMA. TABLES
                WHERE TABLE_SCHEMA = '对应的数据库' AND TABLE_NAME = '对应的表名'

PHP查看当前数据库的总大小（数据+索引

$sql = 'SHOW TABLE STATUS';
$command = $connection->createCommand($sql)->queryAll(); //查询
$dbsize += $table['Data_length'] + $table['Index_length']; //循环累加