查看表空间大小
    USE information_schema;
    SELECT data_length,index_length FROM TABLES WHERE table_schema=’xinshen’
    AND table_name = ‘xs_tb_operation_log’;
    查看表空间大小
    USE information_schema;
    SELECT table_name,CONCAT(ROUND(SUM(data_length/1024/1024),2),’MB’) AS data_length_MB,
    CONCAT(ROUND(SUM(index_length/1024/1024),2),’MB’) AS index_length_MB
    FROM TABLES WHERE table_schema=’xinshen’
    — and table_name = ‘xs_tb_operation_log’;
    GROUP BY table_name;