设为首页 加入收藏

TOP

源码编译安装MySQL5.6.10最佳实践(四)
2014-11-24 03:28:50 来源: 作者: 【 】 浏览:14
Tags:源码 编译 安装 MySQL5.6.10 最佳 实践
u replace ,, by quoted strings and

# by the master's port number(3306 by default).

#

# Example:

#

# CHANGE MASTER TOMASTER_HOST='125.564.12.1', MASTER_PORT=3306,

# MASTER_USER='joe',MASTER_PASSWORD='secret';

#

# OR

#

# 2) Set the variablesbelow. However, in case you choose this method, then

# start replication for the first time (evenunsuccessfully, for example

# if you mistyped the password inmaster-password and the slave fails to

# connect), the slave will create a master.infofile, and any later

# change in this file to the variables'values below will be ignored and

# overridden by the content of themaster.info file, unless you shutdown

# the slave server, delete master.info andrestart the slaver server.

# For that reason, you may want to leave thelines below untouched

# (commented) and instead use CHANGE MASTERTO (see above)

#

# required unique idbetween 2 and 2^32 - 1

# (and different fromthe master)

# defaults to 2 ifmaster-host is set

# but will notfunction as a slave if omitted

#server-id = 2

#

# The replicationmaster for this slave - required

#master-host =

#

# The username theslave will use for authentication when connecting

# to the master -required

#master-user =

#

# The password theslave will authenticate with when connecting to

# the master -required

#master-password=

#

# The port the masteris listening on.

# optional - defaultsto 3306

#master-port =

#

# binary logging - notrequired for slaves, but recommended

#log-bin=mysql-bin

# Uncomment thefollowing if you are using InnoDB tables

#innodb_data_home_dir= /var/lib/mysql

#innodb_data_file_path= ibdata1:10M:autoextend

#innodb_log_group_home_dir= /var/lib/mysql

# You can set.._buffer_pool_size up to 50 - 80 %

# of RAM but bewareof setting memory usage too high

#innodb_buffer_pool_size= 256M

#innodb_additional_mem_pool_size= 20M

# Set.._log_file_size to 25 % of buffer pool size

#innodb_log_file_size= 64M

#innodb_log_buffer_size= 8M

#innodb_flush_log_at_trx_commit= 1

#innodb_lock_wait_timeout= 50

[mysqldump]

quick

max_allowed_packet =16M

[mysql]

no-auto-rehash

# Remove the nextcomment character if you are not familiar with SQL

#safe-updates

[myisamchk]

key_buffer_size =128M

sort_buffer_size =128M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

文章原来放在这儿:http://wenku.baidu.com/view/95063fe3b8f67c1cfad6b8fd fr=prin,今天看有很多浏览量了,之前忙没空整理,今天移到csdn,希望能与更多的人分享!

首页 上一页 1 2 3 4 下一页 尾页 4/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇mysql中查询数据库下所有的表 下一篇MySQL优化器可选开关详解

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·数据库:推荐几款 Re (2025-12-25 12:17:11)
·如何最简单、通俗地 (2025-12-25 12:17:09)
·什么是Redis?为什么 (2025-12-25 12:17:06)
·对于一个想入坑Linux (2025-12-25 11:49:07)
·Linux 怎么读? (2025-12-25 11:49:04)