mysql5.6.20二进制安装部署文档

port = 3307

socket = /tmp/mysql3307.sock

[mysqld]

port = 3307

socket = /tmp/mysql3307.sock

datadir = /data1/mysql5.6/data

skip-external-locking

key_buffer_size = 32M

max_allowed_packet = 50M

table_open_cache = 1024

sort_buffer_size = 4M

net_buffer_length = 8K

read_buffer_size = 4M

read_rnd_buffer_size = 512K

myisam_sort_buffer_size = 64M

thread_cache_size = 128

#query_cache_size = 128M

tmp_table_size = 64M

max_join_size=3G

#skip-networking

skip-name-resolve

max_connections = 500

max_connect_errors = 1000

open_files_limit = 65535

#log-bin=mysql-bin

#binlog_format=row

server-id = 1

#expire_logs_days = 1

#default_storage_engine = InnoDB 

innodb_data_home_dir = /data1/mysql5.6/var

innodb_data_file_path = ibdata1:300M:autoextend

innodb_log_group_home_dir = /data1/mysql5.6/var

innodb_buffer_pool_size = 1024M

innodb_additional_mem_pool_size = 2M

innodb_log_file_size = 256M

innodb_log_buffer_size = 8M

innodb_flush_log_at_trx_commit = 0

innodb_lock_wait_timeout = 50

#innodb_force_recovery = 2

[mysqldump]

quick

max_allowed_packet = 256M

[mysql]

no-auto-rehash

[myisamchk]

key_buffer_size = 16M

sort_buffer_size = 4M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout

到此单台服务器上开启另外一个实例mysql5.6.20成功完成。而且不会对线上mysql5.5.48的业务产生任何影响的

本文出自 “10931853” 博客，请务必保留此出处http://wujianwei.blog.51cto.com/10931853/1959711

mysql5.6.20二进制安装部署文档

标签：mysql   二进制   安装部署