MySQL breakdown of table size between data and index

table-size.sql

SELECT 
    ROUND(SUM(DAT) /1024/1024/1024, 2),
    ROUND(SUM(NDX) /1024/1024/1024, 2),
    TBL
FROM
(
    SELECT TBLN, DAT,NDX,TBL,IF(px>4,4,px) pw1,IF(py>4,4,py) pw2,IF(pz>4,4,pz) pw3
    FROM 
    (
        SELECT table_name TBLN, data_length DAT,index_length NDX,data_length+index_length TBL,
        FLOOR(LOG(IF(data_length=0,1,data_length))/LOG(1024)) px,
        FLOOR(LOG(IF(index_length=0,1,index_length))/LOG(1024)) py,
        FLOOR(LOG(data_length+index_length)/LOG(1024)) pz
        FROM information_schema.tables
        WHERE table_schema='mydb'
        GROUP BY table_name
    ) AA
) A,(SELECT 'B KBMBGBTB' units) B;