mysql配置文件

#ExampleMySQLconfigfileformediumsystems.

#

#Thisisforasystemwithlittlememory(32M-64M)whereMySQLplays

#animportantpart,orsystemsupto128MwhereMySQLisusedtogetherwith

#otherprograms(suchasawebserver)

#

#MySQLprogramslookforoptionfilesinasetof

#locationswhichdependonthedeploymentplatform.

#Youcancopythisoptionfiletooneofthose

#locations.Forinformationabouttheselocations,see:

#http://dev.mysql.com/doc/mysql/en/option-files.html

#

#Inthisfile,youcanusealllongoptionsthataprogramsupports.

#Ifyouwanttoknowwhichoptionsaprogramsupports,runtheprogram

#withthe"--help"option.

#ThefollowingoptionswillbepassedtoallMySQLclients

[client]

#password=your_password

port=3306

socket=/var/lib/mysql/mysql.sock

#default-character-set=utf8

#Herefollowsentriesforsomespecificprograms

#TheMySQLserver

[mysqld]

port=3306

socket=/var/lib/mysql/mysql.sock

skip-external-locking

key_buffer_size=16M

max_allowed_packet=1M

table_open_cache=64

sort_buffer_size=512K

net_buffer_length=8K

read_buffer_size=256K

read_rnd_buffer_size=512K

myisam_sort_buffer_size=8M

max_connections=1000

lower_case_table_names=1

character-set-server=utf8

#Don'tlistenonaTCP/IPportatall.Thiscanbeasecurityenhancement,

#ifallprocessesthatneedtoconnecttomysqldrunonthesamehost.

#AllinteractionwithmysqldmustbemadeviaUnixsocketsornamedpipes.

#NotethatusingthisoptionwithoutenablingnamedpipesonWindows

#(viathe"enable-named-pipe"option)willrendermysqlduseless!

#

#skip-networking

#ReplicationMasterServer(default)

#binaryloggingisrequiredforreplication

log-bin=mysql-bin

#binaryloggingformat-mixedrecommended

binlog_format=mixed

#requireduniqueidbetween1and2^32-1

#defaultsto1ifmaster-hostisnotset

#butwillnotfunctionasamasterifomitted

server-id=1

#ReplicationSlave(commentoutmastersectiontousethis)

#

#Toconfigurethishostasareplicationslave,youcanchoosebetween

#twomethods:

#

#1)UsetheCHANGEMASTERTOcommand(fullydescribedinourmanual)-

#thesyntaxis:

#

#CHANGEMASTERTOMASTER_HOST=<host>,MASTER_PORT=<port>,

#MASTER_USER=<user>,MASTER_PASSWORD=<password>;

#

#whereyoureplace<host>,<user>,<password>byquotedstringsand

#<port>bythemaster'sportnumber(3306bydefault).

#

#Example:

#

#CHANGEMASTERTOMASTER_HOST='125.564.12.1',MASTER_PORT=3306,

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

#

#OR

#

#2)Setthevariablesbelow.However,incaseyouchoosethismethod,then

#startreplicationforthefirsttime(evenunsuccessfully,forexample

#ifyoumistypedthepasswordinmaster-passwordandtheslavefailsto

#connect),theslavewillcreateamaster.infofile,andanylater

#changeinthisfiletothevariables'valuesbelowwillbeignoredand

#overriddenbythecontentofthemaster.infofile,unlessyoushutdown

#theslaveserver,deletemaster.infoandrestarttheslaverserver.

#Forthatreason,youmaywanttoleavethelinesbelowuntouched

#(commented)andinsteaduseCHANGEMASTERTO(seeabove)

#

#requireduniqueidbetween2and2^32-1

#(anddifferentfromthemaster)

#defaultsto2ifmaster-hostisset

#butwillnotfunctionasaslaveifomitted

#server-id=2

#

#Thereplicationmasterforthisslave-required

#master-host=<hostname>

#

#Theusernametheslavewilluseforauthenticationwhenconnecting

#tothemaster-required

#master-user=<username>

#

#Thepasswordtheslavewillauthenticatewithwhenconnectingto

#themaster-required

#master-password=<password>

#

#Theportthemasterislisteningon.

#optional-defaultsto3306

#master-port=<port>

#

#binarylogging-notrequiredforslaves,butrecommended

#log-bin=mysql-bin

#UncommentthefollowingifyouareusingInnoDBtables

#innodb_data_home_dir=/var/lib/mysql

#innodb_data_file_path=ibdata1:10M:autoextend

#innodb_log_group_home_dir=/var/lib/mysql

#Youcanset.._buffer_pool_sizeupto50-80%

#ofRAMbutbewareofsettingmemoryusagetoohigh

#innodb_buffer_pool_size=16M

#innodb_additional_mem_pool_size=2M

#Set.._log_file_sizeto25%ofbufferpoolsize

#innodb_log_file_size=5M

#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

#RemovethenextcommentcharacterifyouarenotfamiliarwithSQL

#safe-updates

[myisamchk]

key_buffer_size=20M

sort_buffer_size=20M

read_buffer=2M

write_buffer=2M

[mysqlhotcopy]

interactive-timeout