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

book

Article ID: 122472

calendar_today

Updated On:

Products

CA Spectrum

Issue/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.

Environment

Release: Spectrum 10.3.0 and greater
Component: SPCAPP

Resolution

This is expected behavior 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. Pleae reference the "Post Upgrade Tasks" section of the documentation for more information.

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