mysql my-innodb-heavy-4g.cnf_mysql my-innodb-heavy-4G.cnf 配置y详细解读

#DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy queries

#描述：4GB 内存、只有 InnoDB、ACID、很少连接数、繁重的查询

#TYPE: SYSTEM

#END CONFIG INFO

#

# This is a MySQL example config file for systems with 4GB of memory

# running mostly MySQL using InnoDB only tables and performing complex

# queries with few connections.

# 这是一个针对 4G 内存系统(主要运行只有 InnoDB 表的 MySQL 并使用几个连接数执行复杂的查询)的 MySQL 配置文件例子。

# MySQL programs look for option files in a set of

# locations which depend on the deployment platform.

# You can copy this option file to one of those

# locations. For information about these locations, see:

# http://dev.mysql.com/doc/mysql/en/option-files.html

#

# In this file, you can use all long options that a program supports.

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

# with the "--help" option.

#

# More detailed information about the individual options can also be

# found in the manual.

#

#

# 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.

# 下面的选项将被 MySQL 客户端应用程序所读取。

# 注意，只有 MySQL 标准的客户端应用程序是被保证能读取到该章节的。

# 如果你希望你自己的 MySQL 客户端程序能够承兑这些值，你需要在 MySQL 客户端库初始化中作为一个选项来指定它。

[client]

#password = [your_password]

port = 3306

socket = /usr/local/mysql/tmp/mysql.sock

# *** Application-specific options follow here ***

# *** 应用程序特定的选项在下面 ***

#

# The MySQL server

#

[mysqld]

# generic configuration options

# 通用配置选项

port = 3306

socket = /usr/local/mysql/tmp/mysql.sock

# back_log is the number of connections the operating system can keep in

# the listen queue, before the MySQL connection manager thread has

# processed them. If you have a very high connection rate and experience

# "connection refused" errors, you might need to increase this value.

# Check your OS documentation for the maximum value of this parameter.

# Attempting to set back_log higher than your operating system limit

# will have no effect.

# back_log 是指保持在操作系统监听队列中的连接数量，即在 MySQL 连接管理器线程处理它们之前的连接数量。

# 如果你有一个非常高的连接率并见到过“拒绝连接”的错误，你可能需要提高该值。

# 检查你的操作系统文档中该参数 的最大值。

# 试图将 back_log 设置得高于你操作系统的限制将不会起到任何作用。

back_log = 50

# Don't listen on a TCP/IP port at all. This can be a security

# enhancement, if all processes that need to connect to mysqld run

# on the same host. All interaction with mysqld must be made via Unix

# sockets or named pipes.

# Note that using this option without enabling named pipes on Windows

# (via the "enable-named-pipe" option) will render mysqld useless!

# 根本不用监听一个 TCP/IP 端口。

# 如果运行在相同主机上的所有进程都需要连接到 mysqld，这可能是一个安全增强。

# 所有与 mysqld 的互动都必须通过 Unix sockets(套接字)或命名管道进行。

# 注意，在 Windows 上使用该选项但却不启用命名管道(通过“enable-named-pipe”选项)将使得 mysqld 变得无用。

#skip-networking

# The maximum amount of concurrent sessions the MySQL server will

# allow. One of these connections will be reserved for a user with

# SUPER privileges to allow the administrator to login even if the

# connection limit has been reached.

# MySQL 允许的并发会话的最大数量。

# 其中的一个连接将被保留给拥有 SUPER 特权的用户，即使已经到达了连接限制，仍可以允许管理者登录。

max_connections = 100

# Maximum amount of errors allowed per host. If this limit is reached,

# the host will be blocked from connecting to the MySQL server until

# "FLUSH HOSTS" has been run or the server was restarted. Invalid

# passwords and other errors during the connect phase result in

# increasing this value. See the "Aborted_connects" status variable for

# global counter.

# 每个主机允许的最大错误数量。

# 如果已到达该限制，主机将阻止对 MySQL 服务器的连接，直到运行“FLUSH HOSTS”或者服务器被重启。

# 在连接阶段的无效密码和其它错误将导致该值被提高。