Introduction to the MySQL Configuration Wizard

1. Select the configuration type. When you start MySQLConfigurationWizard (Configuration Wizard) to reinstall MySQL, or select the Re-configureInstance option for an existing installation, enter

1. Select the Configuration type. When you start MySQL Configuration Wizard (Configuration Wizard) to reinstall MySQL, or select the Re-configure Instance option for an existing installation, enter

1. Select the configuration type

When you start MySQL Configuration Wizard (Configuration Wizard) to reinstall MySQL, or select the Re-configure Instance option for an existing installation, the Configuration type dialog box is displayed.

You can select two Configuration types: Detailed Configuration (Detailed Configuration) and Standard Configuration (Standard Configuration ). Standard Configuration

The (standard configuration) option is suitable for new users who want to quickly start MySQL without considering the server configuration. Detailed configuration options are suitable for advanced users who want to control server configurations in a more fine-grained manner.

2. Server Type dialog box

You can select three server types. Which server will affect the memory, hard disk, and process or usage of MySQL Configuration Wizard?

Decision-making.

· Developer Machine: This option represents a typical personal desktop workstation. Assume that multiple desktop applications are running on the machine. Set MySQL

The server is configured to use the least amount of system resources.

· Server Machine (Server): This option indicates the Server. The MySQL Server can run with other applications, such as FTP, email, and web

Server. Configure the MySQL server to use the appropriate proportion of system resources.

· Dedicated MySQL Server Machine (Dedicated MySQL Server): This option indicates a Server that only runs the MySQL service. Assume that the task is not running.

Other applications. The MySQL server is configured to use all available system resources.

3. database usage dialog box

The Database Usage dialog box shows the table processor used to create a MySQL table. With this option, you can choose whether to enable

Use the InnoDB Storage engine and the proportion of server resources occupied by InnoDB.

· Multifunctional Database (multi-function Database): If this option is selected, the InnoDB and MyISAM storage engines are used simultaneously, and

All resources are allocated. We recommend that you select this option when using two storage engines.

· Transactional Database Only (Only the transaction processing Database): This option uses both the InnoDB and MyISAM storage engines, but most services

To the InnoDB Storage engine. We recommend that you select this option when InnoDB only occasionally uses MyISAM.

· Non-Transactional Database Only (Only Non-transaction processing Database): This option completely disables the InnoDB Storage engine and assigns all server resources

To the MyISAM storage engine. We recommend that you select this option without using InnoDB.