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 Configuration 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.