本篇文章主要介绍了"my-innodb-heavy-4G参数内容介绍",主要涉及到require,队列,索引,表空间,文件描述符方面的内容,对于其他数据库感兴趣的同学可以参考一下:
#BEGIN CONFIG INFO#DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy que...
#BEGIN CONFIG INFO
#DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy queries
#系统需要4GB内存
#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.
#
# 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.
# 客户端配置,用来指定端口号和socket
[client]
#password= [your_password]
port= 3306
socket= /tmp/mysql.sock
# *** Application-specific options follow here ***
#
# The MySQL server
# 服务端配置
[mysqld]
# generic configuration options //默认配置选项的端口号和socket
port= 3306
socket= /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