MySQL 5 Server Configuration

Mysqld-nt.exe-install

Net start MySQL
1
Detailed Configuration
2
Server machine (server type, MySQL occupies a lot of resources) ","
2
Transactional database only (server type, focusing on transaction processing, General )",
Next
3
Set manual setting to 1000

 

Quick installation of mysql5

Do not use non-English paths during installation. After installation, enter the installation configuration.
1. Configuration Mode
Detailed configuration of the detailed configuration (★)
2. What type does MySQL apply?
Developer Machine Development Server, which uses as little memory as possible
Server machine common Web server, which uses a medium amount of memory (★)
Dedicated MySQL server machine only runs the MySQL database and occupies all the memory.
3. Select database usage
Multifunctional database multi-function usage, will optimize the database into a good InnoDB Storage type and efficient MyISAM storage type (preferred)
Transactional database is only used for transaction processing. It is best to optimize InnoDB, but also supports MyISAM (★)
Non-transactional database only is a non-transaction processing type and is suitable for simple applications. Only MyISAM types that do not support transactions are supported.
4. Select the data storage location of innoddb. The default value is generally
5. Select the maximum number of connections allowed by MySQL
Demo-support (DSS)/OLAP up to 20 concurrent connections
Online Transaction Processing (oldp) has a maximum of 500 concurrent connections.
Manual setting custom (★Set to 1000 concurrent threads)
6. Select the port for database listening. The default value is (★)
7. Set the default MySQL encoding. The default encoding is Latin1.
Standard character set is encoded as Latin1
Best support for multilingualism is set to utf8
Manual selected *** ult Character Set/collation custom encoding, simplified Chinese: gb2132 or GBK (★)
8. Set MYSQL as a Windows Service (★)
9. Set the MySQL Super User Password. This super user is very important and has all permissions for MySQL (★)
Check enable root access from remote machine to allow the remote machine to connect to the MySQL server with the root user (★)
10. After confirmation, the system starts automatic configuration. (★)