MySQL memory parameters and adjustments

1. Slow Query log:

Slow_launch_time=2 the value of a query greater than a certain time (unit: s)

Slow_query_log=on/off Turn off slow query log

Slow_query_log_file=/opt/data/host-slow.log Slow Query Log location

2. Number of connections:

Max_connections MySQL Maximum number of connections

Back_log when the number of connections is full, set a value that allows the number of connections to enter the wait stack

Max_connect_errors account number of errors allowed to connect to the server

Connect_timeout maximum time for a connection message (in s)

Skip-name-resolve join MY.CNF, MySQL will receive the connection request, according to the request package

The IP that is obtained in the reverse trace of the requestor's host name. And then again based on the return

Host name again to get the IP. If the IP is the same two times, then the connection is successfully established.

Add a second parameter , you can save this step

NOTES:

Query the current number of connections: Show global status like ' connections ';