- 2.3.4 Using the Configuration Wizard
- 2.3.4.1 Introduction to the Configuration Wizard
- 2.3.4.2 Starting the MySQL Configuration Wizard
- 2.3.4.3 Choosing a Maintenance Option
- 2.3.4.4 Choosing a Configuration Type
- 2.3.4.5 The Server Type Dialog
- 2.3.4.6 The Database Usage Dialog
- 2.3.4.7 The InnoDB Tablespace Dialog
- 2.3.4.8 The Concurrent Connections Dialog
- 2.3.4.9 The Networking and Strict Mode Options Dialog
- 2.3.4.10 The Character Set Dialog
- 2.3.4.11 The Service Options Dialog
- 2.3.4.12 The Security Options Dialog
- 2.3.4.13 The Confirmation Dialog
- 2.3.4.14 The Location of the my.ini File
- 2.3.4.15 Editing the my.ini File
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
InnoDBandMyISAMstorage engines, and divides resources evenly between the two. This option is recommended for users who use both table handlers on a regular basis.Transactional Database Only: 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.Non-Transactional Database Only: 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.
User Comments
Add your own comment.