如何查询MySQL已使用内存

一、查询所有数据库占用空间大小

SELECT
    TABLE_SCHEMA AS "数据库",
    sum( table_rows ) AS "记录数",
    concat( ROUND ( sum( data_length ) / 1024 / 1024, 2 ), ' MB' )  AS "数据容量（MB）",
        concat( ROUND ( sum( data_length ) / 1024 / 1024/ 1024, 2 ), ' GB' )  AS "数据容量（GB）",
    concat( ROUND ( sum( index_length ) / 1024 / 1024, 2 )/ 1024, 'GB' )  AS "索引容量（GB）" 

FROM
    information_schema.TABLES
group by TABLE_SCHEMA
;