MySQL [2]

my.cnf的一个典型配置

Thursday, May 22, 2014 11:05 AM [mysql] default-character-set=latin1 no-auto-rehash port=3307 socket=/data2/mysqldata/mysql.sock [mysqld] #绑定ip(默认为0.0.0.0) bind

May 22, 2014 1 topics

MySQL [2]

my.cnf的一个典型配置 Thursday, May 22, 2014 11:05 AM [mysql]

default-character-set=latin1

no-auto-rehash

port=3307

socket=/data2/mysqldata/mysql.sock

[mysqld] #绑定ip(默认为0.0.0.0)

bind-address=10.166.6.171

character-set-server=latin1

datadir=/data2/mysqldata/data

default-storage-engine=MyISAM

key_buffer_size=512M

log-error=/data/mysqllog/mysql_3307.err

max_allowed_packet=1M

max_binlog_size=1073741824

max_connect_errors=1000

max_connections=100

max_heap_table_size=4096M

myisam_max_sort_file_size=128M

myisam_sort_buffer_size=128M

port=3307

read_rnd_buffer=2M

skip-innodb

skip-name-resolv

socket=/data2/mysqldata/mysql.sock

sort_buffer=8M

table_cache=30010

thread_cache=8

thread_concurrency=4

tmp_table_size=4096M

tmpdir=/data2/mysqldata/tmp

init_connect=’SET AUTOCOMMIT=1’

[client]

port=3307

socket=/data2/mysqldata/mysql.sock

[mysqldump]

max_allowed_packet=16M

quick

已使用 Microsoft OneNote 2016 创建。