The dialog enables you to
indicate the storage engines that you expect to use when
creating MySQL tables. The option you choose determines whether
the InnoDB storage engine is available and
what percentage of the server resources are available to
InnoDB.
: This option enables both the
InnoDBandMyISAMstorage engines and divides resources evenly between the two. This option is recommended for users who use both storage engines on a regular basis.: This option enables both the
InnoDBandMyISAMstorage engines, but dedicates most server resources to theInnoDBstorage engine. This option is recommended for users who useInnoDBalmost exclusively and make only minimal use ofMyISAM.: This option disables the
InnoDBstorage engine completely and dedicates all server resources to theMyISAMstorage engine. This option is recommended for users who do not useInnoDB.
The Configuration Wizard uses a template to generate the server configuration file. The dialog sets one of the following option strings:
Multifunctional Database: MIXED Transactional Database Only: INNODB Non-Transactional Database Only: MYISAM
When these options are processed through the default template (my-template.ini) the result is:
Multifunctional Database: default-storage-engine=InnoDB _myisam_pct=50 Transactional Database Only: default-storage-engine=InnoDB _myisam_pct=5 Non-Transactional Database Only: default-storage-engine=MyISAM _myisam_pct=100 skip-innodb
The _myisam_pct value is used to calculate
the percentage of resources dedicated to
MyISAM. The remaining resources are allocated
to InnoDB.