mysql配置优化（MySQL configuration optimization）.docVIP

mysql配置优化（MySQL configuration optimization） MySQL configuration optimization 2008-03-10 14:55 Site traffic is more and more big, MySQL naturally become the bottleneck, so recently I have been studying the optimization of MySQL, the first step is natural that the optimization of MySQL system parameters, as a large amount of web access (more than 200 thousand times) of the database system, can not expect the default system parameter MySQL can make MySQL run very smoothly. The search on the network information and their own attempt, I think the following parameters are key: (1), back_log: MySQL can have the number of connections. When the main MySQL thread gets very many connection requests in a very short period of time, this role, then the main thread takes some time (although very short) to check the connection and start a new thread. Back_log pointed out that temporarily stop in MySQL short time to answer new requests before the number of requests can be exist in the stack. Only if you expect in a short period of time there are many connections, you need to increase it, in other words, the value on the arrival of the TCP/IP connection interception queue size. Your operating system has its own limit on the size of this queue. Try to set the back_log operating system is higher than your limit will be invalid. When you look at your host process list, found to be connected | unauthenticated user | process a large number of 264084 xxx.xxx.xxx.xxx NULL Connect NULL | | | | | login NULL, it is necessary to increase the value of back_log. The default value is 50, I changed it to 500. (2), interactive_timeout: The server in a few seconds before it closed in an interactive connection for action. An interactive customer is defined as (mysql_real_connect) use the CLIENT_INTERACTIVE option to customers. The default value is 28800, I changed it to 7200. (3), key_buffer_size: The index blocks is buffer and shared by all threads. Key_buffer_size is used for index block buffer size