SELECT SUM(AVG_ROW_LENGTH*TABLE_ROWS) FROM information_schema.tables WHERE TABLE_NAME='yourTableName';
Comment