MySQL Installation Details graphic version (V5.5ForWindows)

MySQL has been used for the past few years, and it is a combination of Windows +. Net + MySQL. The MyISAM engine supports increasing data of more than 10 million yuan per day for a single table, and the TB-level data MySQL can be used easily.

MySQL has been used for the past few years, and it is a combination of Windows +. Net + MySQL. The MyISAM engine supports increasing data of more than 10 million yuan per day for a single table, and the TB-level data MySQL can be used easily.

Recently, I am working on a large concurrent project and tried InnoDB's Installation File of MySQL5.5 and less than 30 m, which is no inferior to the huge Oracle or MSSqlServer. We believe that MySQL is widely used in Windows because it is open-source and not superstitious about Linux. I have compiled a previous article and hope to help the author.

Installation environment: Windows Server 2003 [32bit NTFS]
Version: MySQL 5.5.15 [:]
References:

Step 1: select the installation type
There are three types of installation: Typical (Typical installation), Complete (full installation), and Custom (Custom installation ).
Typical (Typical installation) Only installs MySQL server, mysql command line client, and command line utility. The command line client and utility include mysqldump, myisamchk, and several other tools to help you manage your MySQL server.
Complete installation installs all components included in the package. Components included in the fully-installed software package include the Embedded Server library, benchmarking suite, supporting scripts, and documentation.
Custom (Custom installation) Installation allows you to have full control over the packages and installation paths you want to install.

Step 2: Customize the installation dialog box
All available components are included in the Tree View on the left of the custom installation dialog box. Uninstalled components are represented by the red X icon; installed components have the gray icon. To change a widget, click the widget icon and select a new one from the drop-down list.
You can click Change... on the right of the installation path to Change the default installation path.
After selecting the installation component and installation path, click Next to enter the confirmation dialog box.

Step 3:

Step 4: select the server type
You can select three server types, which of the following will affect MySQL Configuration Wizard's decision on memory, hard disk, and process or usage.
· Developer Machine: This option represents a typical personal desktop workstation. Assume that multiple desktop applications are running on the machine. Configure the MySQL server 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 servers. 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. It is assumed that no other application is running. The MySQL server is configured to use all available system resources.

Step 5: Select storage engine
You can specify the table processor used to create a MySQL table. With this option, you can choose whether to 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 at the same time, and resources are evenly allocated between the two engines. 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 assigns most server resources 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.
Here is a brief introduction. InnoDB and MyISAM are the two most commonly used table types in MySQL. their respective advantages and disadvantages depend on the specific application. The basic difference is that the MyISAM type does not support advanced processing such as transaction processing, while the InnoDB type does. MyISAM tables emphasize performance, and the execution speed is faster than that of InnoDB, but transactions are not supported. InnoDB provides advanced database functions such as transaction support and Foreign keys.

Step 6: select the InnoDB data file storage directory

Step 7: Set concurrent connections
It is important to limit the number of concurrent connections between the created MySQL server to prevent the server from consuming resources.
· Demo-support (Decision Support) (DSS)/OLAP: This option can be selected if the server does not require a large number of parallel connections. Assume that the average number of concurrent connections is 20.
· Online Transaction Processing (Online Transaction Processing) (OLTP): select this option if your server requires a large number of parallel connections. Set the maximum number of connections to 500.
· Manual Setting: select this option to manually set the maximum number of parallel connections on the server. Select the number of parallel connections from the previous drop-down box. If the expected number is not in the list, enter the maximum number of connections in the drop-down box.

Step 8: networking options
In the Networking Options (network Options) dialog box, you can enable or disable the TCP/IP network and configure the port number used to connect to the MySQL server. The TCP/IP network is enabled by default. To disable the TCP/IP network, deselect the check box next to the Enable TCP/IP Networking option.
Port 3306 is used by default. To access the port used by MySQL, select a new port number from the drop-down list or directly enter a new port number in the drop-down list. If the selected port number is already in use, a prompt is displayed to confirm the selected port number.

Step 9: select a Character Set
The MySQL Server supports multiple character sets and can set the default server character set for all tables, columns, and databases. Use the Character Set (Character Set dialog box) to change the default Character Set of the MySQL server.
· Standard Character Set: If you want to use Latin1 as the default server Character Set, select this option. Latin1 is used in English and many western European languages.
· Best Support For Multilingualism (multiple languages supported): select this option if you want to use UTF8 as the default server character set. UTF8 can store characters in different languages as a single character set.
· Manual Selected Default Character Set/Collation (Default Character Set/Collation manually Selected): select this option if you want to manually select the Default Character Set of the server. Select the expected character set from the drop-down list.

Step 10: Set the service
On a Windows NT-based platform, you can install a MySQL server as a service. After the service is installed, the MySQL server can be automatically started when the system starts, or even automatically started with Windows when a service failure occurs.
By default, the MySQL Configuration Wizard installs the MySQL server as a service named MySQL. If you do not want to Install the Service, cancel the selection box next to the Install As Windows Service option. You can select a new service name from the drop-down list or enter a new service name in the drop-down list to change the service name.
To install the MySQL Server as a service but not Automatically start it, do not select the check box next to the Launch the MySQL Server Automatically option.

Step 11: Security Options
We strongly recommend that you set a root password for your MySQL server. By default, MySQL Configuration Wizard requires you to set a root password. If you do not want to set the root password, do not select the selection box next to the Modify Security Settings (Modify Security Settings) option.
To set the root password, enter the expected password in the New root password (enter the New password) and Confirm (OK) boxes. If you reconfigure an existing server, you also need to enter the existing root password in the Current root password box.
To prevent network logon, do not select the box next to Enable root access from remote machines (remote connection not allowed. This improves security.
To Create An Anonymous user Account, select the box next to the Create An Anonymous Account option. Creating an anonymous account will reduce server security and cause logon and license difficulties. Therefore, it is not recommended.

OK.