mysql设置超时锁定_Mysql 5.16 配置（避免并发锁定超时）

# Other default tuning values

# MySQL Server Instance Configuration File

#

----------------------------------------------------------------------

# Generated by the MySQL Server Instance Configuration Wizard

#

#

# Installation Instructions

#

----------------------------------------------------------------------

#

# On Linux you can copy this file to /etc/my.cnf to set global

options,

# mysql-data-dir/my.cnf to set server-specific options

# (@localstatedir@ for this installation) or to

# ~/.my.cnf to set user-specific options.

#

# On Windows you should keep this file in the installation

directory

# of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y).

To

# make sure the server reads the config file use the startup

option

# "--defaults-file".

#

# To run run the server from the command line, execute this in

a

# command line shell, e.g.

# mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server

X.Y\my.ini"

#

# To install the server as a Windows service manually, execute this

in a

# command line shell, e.g.

# mysqld --install MySQLXY --defaults-file="C:\Program

Files\MySQL\MySQL Server X.Y\my.ini"

#

# And then execute this in a command line shell to start the

server, e.g.

# net start MySQLXY

#

#

# Guildlines for editing this file

#

----------------------------------------------------------------------

#

# In this file, you can use all long options that the program

supports.

# If you want to know the options a program supports, start the

program

# with the "--help" option.

#

# More detailed information about the individual options can also

be

# found in the manual.

#

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

#

#

# CLIENT SECTION

#

----------------------------------------------------------------------

#

# The following options will be read by MySQL client

applications.

# Note that only client applications shipped by MySQL are

guaranteed

# to read this section. If you want your own MySQL client program

to

# honor these values, you need to specify it as an option during

the

# MySQL client library initialization.

#

[client]

no-beep

# pipe

# socket=mysql

port=3333

character-set-client=utf8

[mysql]

default-character-set=utf8

# SERVER SECTION

#

----------------------------------------------------------------------

#

# The following options will be read by the MySQL Server. Make sure

that

# you have installed the server correctly (see above) so it reads

this

# file.

#

# server_type=3

[mysqld]

# The next three options are mutually exclusive to SERVER_PORT

below.

# skip-networking

# enable-named-pipe

# The Pipe the MyS