MySQL config file my-small.cnf parsing, Chinese translation, configuration

# Example MySQL config file for small systems.

#数据库最小系统配置文件样例

# This was for a system with little memory (<= 64M) where MySQL was only used# by time to time and it's important that The mysqld daemon# doesn ' t use much resources.

#这个配置时为内存比较小的系统且数据库不连续使用的系统设置的,

#最重要的时它的后台服务几乎不会使用太多资源

# 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 the This file, you can use the all long options, the supports.# If you want the know which options a program support S, run the program# with the "--help" option.

#在这个文件中, you can use all the long options supported by the program.

#如果你想只知道程序支持哪个选项, run the program to find help

# The following options would be passed to all MySQL clients

#下列选项应用到数据库的客户端

[Client] #password = Your_password #密码port = 3306 #端口 socket=/tmp/mysql.sock #socket位置

# here follows entries for some specific programs

#接下来的条目是为一些特别程序准备的

# the mysql server   [mysqld]port= 3306                  #端口socket = /tmp/mysql.sock   # Socket location skip-external-locking          #跳过扩展锁key_buffer_size   = 16k          #键缓存是  16Kmax_allowed_packet =  1m        #允许最大信息包  1Mtable_open_cache = 4            #打开表缓存  4sort_buffer_size = 64K          #排序缓存  64Kread_buffer_size = 256K         #读缓存区  256Kread_rnd_buffer_size = 256K    #net_buffer_length  =  2K         #网络缓存长度2Kthread_stack  = 128K             #线程堆  128k 

# Don ' t listen on a TCP/IP port at all. This can is a security enhancement,# if all processes then need to connect to mysqld run in the same host.# all Interactio N with Mysqld must is made via Unix sockets or named pipes.# Note that using the this option without enabling named Pipes on W indows# (using the "enable-named-pipe" option) would render mysqld useless!# #skip-networkingserver-id= 1

#不要一直监听一个tcp/IP Port. This is a security enhancement if all processes need to be connected to the same host database background.

#和数据库后台的所有交互必须经过Unix code or Named pipes.

#注意如果windows没有激活相应选项 (enable-named-pipe), this option is not valid.

# Uncomment the following if you want to log updates #日志更新 #log-bin=mysql-bin

# Binary Logging format-mixed recommended#binlog_format=mixed

# binary Mixed-format logging

# causes updates to Non-transactional engines using statement format to be# written directly to binary log. Before using this option make sure that# there is no dependencies between transactional and non-transactional# tables suc H as in the statement INSERT into T_myisam SELECT * from# t_innodb; Otherwise, slaves may diverge from the master. #binlog_direct_non_transactional_updates =true

#更新到非事务引擎使用说明格式写到二进制日志中,

#使用这个选项之前确保依赖在事务和非事务表

#例如: Insert Data. Otherwise, the standby machine and the host run counter.

# uncomment the following if you are  using innodb tables   #是否使用Innodb表 #innodb_data_home_dir = /usr/local/mysql/data# innodb_data_file_path = ibdata1:10m:autoextend#innodb_log_group_home_dir = /usr/local/ MYSQL/DATA# YOU CAN SET&NBSP, .... _buffer_pool_size up to 50 - 80 %# of ram but beware of  setting memory usage too high#innodb_buffer_pool_size = 16m#innodb_ ADDITIONAL_MEM_POOL_SIZE = 2M# SET&NBSP, .... _log_file_size to 25 % of buffer pool size#innodb_log_file_size =  5m#innodb_log_buffer_size = 8m#innodb_flush_log_at_trx_commit = 1#innodb_lock_wait_ Timeout = 50 

[mysqldump] #备份quickmax_allowed_packet = 16M

[MySQL] #no-auto-rehash

#命令不自动补全 http://blog.51yip.com/mysql/1056.html

Auto-rehash

#修改为自动补全 can only prompt for table names and field names inside the table

# Remove The next comment character if you is not a familiar with SQL #安全更新 #safe-updates

[Myisamchk]

#获得有关你的数据库表的统计信息或检查, repair and optimize their http://blog.csdn.net/wyzxg/article/details/7303486

Key_buffer_size = 8M

Sort_buffer_size = 8M

[Mysqlhotcopy]

#热备 https://www.centos.bz/2011/11/backup-mysql-database-with-mysqlhotcopy/

Interactive-timeout

This article is from the "11282743" blog, please be sure to keep this source http://11292743.blog.51cto.com/11282743/1910327

MySQL config file my-small.cnf parsing, Chinese translation, configuration