SELECT ROUND(SUM(data_length+index_length)/1024/1024) AS total_mb,
ROUND(SUM(data_length)/1024/1024) AS data_mb,
ROUND(SUM(index_length)/1024/1024) AS index_mb
FROM information_schema.TABLES WHERE `TABLE_SCHEMA`='voyageone_cms2' -- `TABLE_NAME`='cms_bt_price_log'
ROUND(SUM(data_length)/1024/1024) AS data_mb,
ROUND(SUM(index_length)/1024/1024) AS index_mb
FROM information_schema.TABLES WHERE `TABLE_SCHEMA`='voyageone_cms2' -- `TABLE_NAME`='cms_bt_price_log'