Recently, I was working on a large concurrent project, and I tried InnoDB's MySQL 5.5, which has an installation file of less than 30M, and the performance is not inferior to the huge Oracle or MSSqlServer. Open source, not superstitious about Linux, I believe that MySQL will be more and more widely used in Windows. I have compiled a previous article, hoping to be helpful to beginners.
Installation Environment: Windows Server 2003 [32bit NTFS]
Version information: MySQL 5.5.15 [Download address: http://dev.mysql.com/downloads/
References: http://dev.mysql.com/doc/refman/5.1/zh/installing.html
Step 1: Select the installation type
There are 3 mounting types: Typical (typical installation), Complete (complete installation) and Custom (custom installation).
The Typical installation installs only the MySQL server, mysql command-line client, and command-line utilities. Command-line clients and utilities include mysqldump, myisamchk, and several other tools to help you manage your MySQL server.
The Complete installation installs all the components contained within the package. The components included in the fully installed package include embedded server libraries, benchmark kits, support scripts, and documentation.
Custom installation allows you to have full control over the packages you want to install and the installation path.
Step 2: Customize the installation dialog
All available components are listed in the tree view on the left side of the custom installation dialog. Uninstalled components are indicated by a red X icon; Components that are already installed have gray icons. To change a component, tap the component's icon and select a new option from the drop-down list.
You can click Change on the right side of the installation path... button to change the default installation path.
After selecting the installation components and installation path, click the Next button to enter the confirmation dialog box.
Step 3:Select the configuration type
You can choose between two configuration types: Detailed Configuration and Standard Configuration. The Standard Configuration option is suitable for new users who want to get MySQL up quickly without having to think about server configuration. The detailed configuration options are suitable for advanced users who want more granular control over server configuration.
If you are new to MySQL and need to configure a server as a single-user development machine, the Standard Configuration should suit your needs. If you select the Standard Configuration option, the MySQL Configuration Wizard automatically sets all configuration options, excluding service options and security options.
The Standard Configuration setting option may not be compatible with the system on which MySQL is installed. If you already have MySQL installed on your system and the installation you want to configure, it is recommended to select the detailed configuration.
Step 4: Select the server type
There are 3 server types to choose from, and which server you choose will influence the MySQL Configuration Wizard's decisions about memory, hard disks, and processes or usage.
· Developer Machine: This option represents a typical personal desktop workstation. Suppose there are multiple desktop applications running on the machine. Configure the MySQL server to use minimal system resources.
· Server Machine: This option represents a server, and a MySQL server can run alongside other applications, such as FTP, email, and web servers. The MySQL server is configured to use the appropriate proportion of system resources.
· Dedicated MySQL Server Machine: This option represents a server that only runs MySQL services. Assume that no other applications are running. The MySQL server is configured to use all available system resources.
Step 5: Select the storage engine
You can indicate the table processor used when creating the MySQL table. This option allows you to choose whether to use the InnoDB storage engine and what percentage of server resources InnoDB occupies.
· Multifunctional Database: Select this option to use both InnoDB and MyISAM storage engines and distribute resources evenly between the two engines. This option is recommended for users who frequently use both storage engines.
· Transactional Database Only: This option uses both the InnoDB and MyISAM storage engines, but assigns most server resources to the InnoDB storage engine. This option is recommended for users who primarily use InnoDB and only occasionally use MyISAM.
· Non-Transactional Database Only: This option completely disables the InnoDB storage engine and assigns all server resources to the MyISAM storage engine. This option is recommended for users who do not use InnoDB.
Here is a brief introduction, InnoDB and MyISAM are the two most commonly used table types for using MySQL, each with its own advantages and disadvantages, depending 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. Tables of type MyISAM emphasize performance, and they perform several times faster than types of InnoDB, but do not provide transaction support, while InnoDB provides advanced database features such as transaction support and foreign keys.
Step 6: Select the InnoDB data file storage directory
Step 7: Set the number of concurrent connections setting
It is important to limit the number of parallel connections created to and from the MySQL server in order to prevent the server from running out of resources.
· Decision Support (DSS)/OLAP: This option can be selected if the server does not require a lot of parallel connections. Assuming an average number of parallel connections is 20.
· Online Transaction Processing (OLTP): Select this option if your server requires a lot of parallel connections. The maximum number of connections is set to 500.
· Manual Setting: Select this option to manually set the maximum number of server parallel connections. Select the number of parallel connections from the previous drop-down box, or enter the maximum number of connections in the drop-down box if the number you expect is not listed.
Step 8: Networking options
In the Networking Options dialog, you can enable or disable TCP/IP networking and configure the port number used to connect to the MySQL server. TCP/IP networks are enabled by default. To disable TCP/IP networking, deselect the check box next to the Enable TCP/IP Networking option.
Port 3306 is used by default. To get more access to the ports used by MySQL, select a new port number from the drop-down box or enter a new port number directly into the drop-down box. If your selected port number is already occupied, you will be prompted to confirm the selected port number.
Step 9: Select the character set
MySQL Server supports a variety of character sets, and you can set a default server character set for all tables, columns, and databases. Use the Character Set dialog to change the default character set for the MySQL server.
· Standard Character Set: Select this option if you want to use Latin1 as the default server character set. Latin1 is used in English and many Western European languages.
· Best Support For Multilingualism: Select this option if you want to use UTF8 as the default server character set. UTF8 can store characters from different languages as a single character set.
· Manual Selected Default Character Set/Collation: Select this option if you want to manually select the server's default character set. Select the desired character set from the drop-down list.
Step 10: Set up the service
On Windows NT-based platforms, you can install MySQL Server as a service. When installed as a service, the MySQL server can be automatically started when the system starts, and even automatically starts with Windows when the service fails.
By default, the MySQL Configuration Wizard installs the MySQL server as a service named MySQL. If you don't want to install the service, uncheck the box next to the Install As Windows Service option. You can change the service name by selecting a new service name from the drop-down box or entering a new service name in the drop-down box.
To install MySQL Server as a service, but not automatically, do not check the box next to the Launch the MySQL Server Automatically option.
Step 11: Security Options
It is highly recommended to set a root password for your MySQL server, and the MySQL Configuration Wizard requires you to set a root password by default. If you don't want to set a root password, don't check the box next to the Modify Security Settings option.
To set a root password, enter the desired password in the New root password and Confirm boxes. If you want to reconfigure an existing server, you will also need to enter the existing root password in the Current root password box.
To prevent login over the network, uncheck the box next to the Enable root access from remote machines option. This improves safety.
To create an anonymous user account, check the box next to the Create An Anonymous Account option. Creating anonymous accounts can reduce server security and make login and permission difficult. Therefore, it is not recommended.
OK, finally.
|
Posted on 2/3/2015 1:58:45 PM
|
|
|
|
