20937708        ./var/lib/mysql/databasename/tablename.ibd

MYSQL_USER=root
MYSQL_PASS=rootpass
MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
DB=databasename
TB=tablename
SQL="SELECT data_length+index_length FROM information_schema.tables"
SQL="${SQL} WHERE table_schema='${DB}' AND table_name='${TB}'"
TBLSIZE_OPER=`ls -l /var/lib/mysql/${DB}/${TB}.ibd`
TBLSIZE_INFO=`mysql ${MYSQL_CONN} -ANe"${SQL}"`
(( TBLSIZE_FRAG = TBLSIZE_OPER - TBLSIZE_INFO ))
(( TBLSIZE_FRAG_GB = TBLSIZE_FRAG / 1073741824 ))
echo ${TBLSIZE_FRAG} ${TBLSIZE_FRAG_GB}

USE databasename
ALTER TABLE tablename ENGINE=InnoDB;

USE databasename
ALTER TABLE tablename ENGINE=InnoDB;

OPTIMIZE TABLE `databasename`.`tablename`;