CA Spectrum 10.3 mysql InnoDB is consuming more space than the old MyISAM db

Document ID : KB000122472
Last Modified Date : 06/12/2018
Show Technical Document Details
Introduction:
The CA Spectrum 10.3 release provides support for moving the mysql myisam db to the innodb engine.  The innodb allows for performance improvements with Spectrum's mysql however it has been noticed that after converting the mysql db from myisam to innodb the mysql db grew 40% in disk space.
Instructions:
This is expected behaviour due to changes with the InnoDB engine.  The post installation steps for CA Spectrum 10.3 note the increase in disk size when using InnoDB:

https://docops.ca.com/ca-spectrum/10-3-0/en/installing-and-upgrading/upgrading#Upgrading-PostUpgradeTasks 

After conversion, the InnoDB tables occupy more space (approxamity 30%-40%) compare to the MyISAM tables. As per MYSQL recommendation, the InnoDB is considered as the most efficent engine to work on large scale tables. The InnoDB supports row level locking and auto crash recovery features, which are not supported in MyISAM.
Additional Information:
Additional information in regards to the size increase is documented here:
 
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html#innodb-convert-storage-requirements

And a reference:

https://stackoverflow.com/questions/2914492/why-is-innodb-table-size-much-larger-than-expected