The Database Usage dialog allows 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
.
Multifunctional Database: This
option enables both the InnoDB
and
MyISAM
storage engines and divides
resources evenly between the two. This option is recommended
for users who use both storage engines on a regular basis.
Transactional Database Only: This
option enables both the InnoDB
and
MyISAM
storage engines, but dedicates
most server resources to the InnoDB
storage engine. This option is recommended for users who use
InnoDB
almost exclusively and make only
minimal use of MyISAM
.
Non-Transactional Database Only:
This option disables the InnoDB
storage
engine completely and dedicates all server resources to the
MyISAM
storage engine. This option is
recommended for users who do not use
InnoDB
.
The Config Wizard uses a template to generate the server configuration file. The Database Usage 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
.
User Comments
Add your own comment.