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

Source: Internet
Author: User
Tags rehash

# 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#&NBSP;YOU&NBSP;CAN&NBSP;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&NBSP;=&NBSP;2M#&NBSP;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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.