| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mysql >> xiang xi jiang jie MySQL shu ju ku 5.0 de my.cnf pei zhi xuan xiang

xiang xi jiang jie MySQL shu ju ku 5.0 de my.cnf pei zhi xuan xiang

2008-08-14 23:14:22 编辑來源:互联网 评论
 
 
 
本文为【详细讲解MySQL数据库5.0的my.cnf配置选项】的拼音翻译版
  MySQL shu ju ku 5.0 de my.cnf pei zhi xuan xiang gai shu :
  mysqld cheng xu -- mu lu he wen jian
  basedir = path shi yong gei ding mu lu zuo wei gen mu lu ( an zhuang mu lu )。
  character-sets-dir = path gei chu cun fang zhe zi fu ji de mu lu 。
  datadir = path cong gei ding mu lu du qu shu ju ku wen jian 。
  pid-file = filename wei mysqld cheng xu zhi ding yi ge cun fang jin cheng ID de wen jian ( jin shi yong yu UNIX/Linux xi tong ); Init-V jiao ben xu yao shi yong zhe ge wen jian li de jin cheng ID jie shu mysqld jin cheng 。
  socket = filename wei MySQL ke hu cheng xu yu fu wu qi zhi jian de ben di tong xin zhi ding yi ge tao jie zi wen jian ( jin shi yong yu UNIX/Linux xi tong ; mo ren she zhi yi ban shi /var/lib/mysql/mysql.sock wen jian )。
  zai Windows huan jing xia , ru guo MySQL ke hu yu fu wu qi shi tong guo ming ming guan dao jin xing tong xin de ,--sock xuan xiang gei chu de jiang shi gai ming ming guan dao de ming zi ( mo ren she zhi shi MySQL)。
  lower_case_table_name = 1/0 xin mu lu he shu ju biao de ming zi shi fou zhi yuan xu shi yong xiao xie zi mu ; zhe ge xuan xiang zai Windows huan jing xia de mo ren she zhi shi 1( zhi yuan xu shi yong xiao xie zi mu )。
  mysqld cheng xu -- yu yan she zhi
  character-sets-server = name xin shu ju ku huo shu ju biao de mo ren zi fu ji 。 wei le yu MySQL de zao qi ban ben bao chi jian rong , zhe ge zi fu ji ye ke yi yong --default-character-set xuan xiang gei chu ; dan zhe ge xuan xiang yi jing xian de you dian guo shi le 。
  collation-server = name xin shu ju ku huo shu ju biao de mo ren pai xu fang shi 。
  lanuage = name yong zhi ding de yu yan xian shi chu cuo xin xi 。
  mysqld cheng xu -- tong xin 、 wang luo 、 xin xi an quan
  enable-named-pipes yuan xu Windows 2000/XP huan jing xia de ke hu he fu wu qi shi yong ming ming guan dao (named pipe) jin xing tong xin 。 zhe ge ming ming guan dao de mo ren ming zi shi MySQL, dan ke yi yong --socket xuan xiang lai gai bian 。
  local-infile [=0] yuan xu / jin zhi shi yong LOAD DATA LOCAL yu ju lai chu li ben di wen jian 。
  myisam-recover [=opt1, opt2, ...] zai qi dong shi zi dong xiu fu suo you shou sun de MyISAM shu ju biao 。 zhe ge xuan xiang de ke qu zhi you 4 zhong :DEFAULT、BACKUP、QUICK he FORCE; ta men yu myisamchk cheng xu de tong ming xuan xiang zuo yong xiang tong 。
  old-passwords shi yong MySQL 3.23 he 4.0 ban ben zhong de lao suan fa lai jia mi mysql shu ju ku li de mi ma ( mo ren shi yong MySQL 4.1 ban ben kai shi yin ru de xin jia mi suan fa )。
  port = n wei MySQL cheng xu zhi ding yi ge TCP/IP tong xin duan kou ( tong chang shi 3306 duan kou )。
  safe-user-create zhi you zai mysql.user shu ju ku biao shang yong you INSERT quan xian de yong hu cai neng shi yong GRANT ming ling ; zhe shi yi zhong shuang bao xian ji zhi ( ci yong hu huan bi xu ju bei GRANT quan xian cai neng zhi xing GRANT ming ling )。
  shared-memory yuan xu shi yong nei cun (shared memory) jin xing tong xin ( jin shi yong yu Windows)。
  shared-memory-base-name = name gei gong xiang nei cun kuai qi yi ge ming zi ( mo ren de ming zi shi MySQL)。
  skip-grant-tables bu shi yong mysql shu ju ku li de xin xi lai jin xing fang wen kong zhi ( jing gao : zhe jiang yuan xu yong hu ren he yong hu qu xiu gai ren he shu ju ku )。
  skip-host-cache bu shi yong gao su huan cun qu lai cun fang zhu ji ming he IP di zhi de dui ying guan xi 。
  skip-name-resovle bu ba IP di zhi jie xi wei zhu ji ming ; yu fang wen kong zhi (mysql.user shu ju biao ) you guan de jian cha quan bu tong guo IP di zhi xing jin 。
  skip-networking zhi yuan xu tong guo yi ge tao jie zi wen jian (Unix/Linux xi tong ) huo tong guo ming ming guan dao (Windows xi tong ) jin xing ben di lian jie , bu yuan xu ICP/IP lian jie ; zhe ti gao le an quan xing , dan zu duan le lai zi wang luo de wai bu lian jie he suo you de Java ke hu cheng xu (Java ke hu ji shi zai ben di lian jie li ye shi yong TCP/IP)。
  user = name mysqld cheng xu zai qi dong hou jiang zai gei ding UNIX/Linux zhang hu xia zhi xing ; mysqld bi xu cong root zhang hu qi dong cai neng zai qi dong hou qie huan dao ling yi ge zhang hu xia zhi xing ; mysqld_safe jiao ben jiang mo ren shi yong --user=mysql xuan xiang lai qi dong mysqld cheng xu 。
  mysqld cheng xu -- nei cun guan li 、 you hua 、 cha xun huan cun qu
  bulk_insert_buffer_size = n wei yi ci cha ru duo tiao xin ji lu de INSERT ming ling fen pei de huan cun qu chang du ( mo ren she zhi shi 8M)。
  key_buffer_size = n yong lai cun fang suo yin qu kuai de RMA zhi ( mo ren she zhi shi 8M)。
  join_buffer_size = n zai shen jia JOIN cao zuo de shu ju lie mei you suo yin shi wei JOIN cao zuo fen pei de huan cun qu chang du ( mo ren she zhi shi 128K)。
  max_heap_table_size = n HEAP shu ju biao de zui da chang du ( mo ren she zhi shi 16M); chao guo zhe ge chang du de HEAP shu ju biao jiang bei cun ru yi ge lin shi wen jian er bu shi zhu liu zai nei cun li 。
  max_connections = n MySQL fu wu qi tong shi chu li de shu ju ku lian jie de zui da shu liang ( mo ren she zhi shi 100)。
  query_cache_limit = n yuan xu lin shi cun fang zai cha xun huan cun qu li de cha xun jie guo de zui da chang du ( mo ren she zhi shi 1M)。
  query_cache_size = n cha xun huan cun qu de zui da chang du ( mo ren she zhi shi 0, bu kai pi cha xun huan cun qu )。
  query_cache_type = 0/1/2 cha xun huan cun qu de gong zuo mo shi :0, jin yong cha xun huan cun qu ; 1, qi yong cha xun huan cun qu ( mo ren she zhi ); 2," an xu fen pei " mo shi , zhi xiang ying SELECT SQL_CACHE ming ling 。
  read_buffer_size = n wei cong shu ju biao shun xu du qu shu ju de du cao zuo bao liu de huan cun qu de chang du ( mo ren she zhi shi 128KB); zhe ge xuan xiang de she zhi zhi zai bi yao shi ke yi yong SQL ming ling SET SESSION read_buffer_size = n ming ling jia yi gai bian 。
  read_rnd_buffer_size = n lei si yu read_buffer_size xuan xiang , dan zhen dui de shi an mou zhong te ding shun xu ( bi ru shi yong le ORDER BY zi ju de cha xun ) shu chu de cha xun jie guo ( mo ren she zhi shi 256K)。
  sore_buffer = n wei pai xu cao zuo fen pei de huan cun qu de chang du ( mo ren she zhi shi 2M); ru guo zhe ge huan cun qu tai xiao , ze bi xu chuang jian yi ge lin shi wen jian lai jin xing pai xu 。
  table_cache = n tong shi da kai de shu ju biao de shu liang ( mo ren she zhi shi 64)。
  tmp_table_size = n lin shi HEAP shu ju biao de zui da chang du ( mo ren she zhi shi 32M); chao guo zhe ge chang du de lin shi shu ju biao jiang bei zhuan huan wei MyISAM shu ju biao bing cun ru yi ge lin shi wen jian 。
  mysqld cheng xu -- ri zhi
  log [= file] ba suo you de lian jie yi ji suo you de SQL ming ling ji ru ri zhi ( tong yong cha xun ri zhi ); ru guo mei you gei chu file shen shu ,MySQL jiang zai shu ju ku mu lu li chuang jian yi ge hostname.log wen jian zuo wei zhe zhong ri zhi wen jian (hostname shi fu wu qi de zhu ji ming )。
  log-slow-queries [= file] ba zhi xing yong shi chao guo long_query_time bian liang zhi de cha xun ming ling ji ru ri zhi ( man cha xun ri zhi ); ru guo mei you gei chu file shen shu ,MySQL jiang zai shu ju ku mu lu li chuang jian yi ge hostname-slow.log wen jian zuo wei zhe zhong ri zhi wen jian (hostname shi fu wu qi zhu ji ming )。
  long_query_time = n man cha xun de zhi xing yong shi shang xian ( mo ren she zhi shi 10s)。
  long_queries_not_using_indexs ba man cha xun yi ji zhi xing shi mei you shi yong suo yin de cha xun ming ling quan dou ji ru ri zhi ( qi yu tong --log-slow-queries xuan xiang )。
  log-bin [= filename] ba dui shu ju jin xing xiu gai de suo you SQL ming ling ( ye jiu shi INSERT、UPDATE he DELETE ming ling ) yi er jin zhi ge shi ji ru ri zhi ( er jin zhi bian geng ri zhi ,binary update log)。 zhe zhong ri zhi de wen jian ming shi filename.n huo mo ren de hostname.n, qi zhong n shi yi ge 6 wei shu zi de zheng shu ( ri zhi wen jian an shun xu bian hao )。
  log-bin-index = filename er jin zhi ri zhi gong neng de suo yin wen jian ming 。 zai mo ren qing kuang xia , zhe ge suo yin wen jian yu er jin zhi ri zhi wen jian de ming zi xiang tong , dan hou zhui ming shi .index er bu shi .nnnnnn。
  max_binlog_size = n er jin zhi ri zhi wen jian de zui da chang du ( mo ren she zhi shi 1GB)。 zai qian yi ge er jin zhi ri zhi wen jian li de xin xi liang chao guo zhe ge zui da chang du zhi qian ,MySQL fu wu qi hui zi dong ti gong yi ge xin de er jin zhi ri zhi wen jian jie xu shang 。
  binlog-do-db = dbname zhi ba gei ding shu ju ku li de bian hua qing kuang ji ru er jin zhi ri zhi wen jian , qi ta shu ju ku li de bian hua qing kuang bu ji zai 。 ru guo xu yao ji zai duo ge shu ju ku li de bian hua qing kuang , jiu bi xu zai pei zhi wen jian shi yong duo ge ben xuan xiang lai she zhi , mei ge shu ju ku yi xing 。
  binlog-ignore-db = dbname bu ba gei ding shu ju ku li de bian hua qing kuang ji ru er jin zhi ri zhi wen jian 。
  sync_binlog = n mei jing guo n ci ri zhi xie cao zuo jiu ba ri zhi wen jian xie ru ying pan yi ci ( dui ri zhi xin xi jin xing yi ci tong bu )。n=1 shi zui an quan de zuo fa , dan xiao lv zui di 。 mo ren she zhi shi n=0, yi si shi you cao zuo xi tong lai fu ze er jin zhi ri zhi wen jian de tong bu gong zuo 。
  log-update [= file] ji zai chu cuo qing kuang de ri zhi wen jian ming ( chu cuo ri zhi )。 zhe zhong ri zhi gong neng wu fa jin yong 。 ru guo mei you gei chu file shen shu ,MySQL hui shi yong hostname.err zuo wei zhong ri zhi wen jian de ming zi 。
  mysqld cheng xu -- jing xiang ( zhu kong jing xiang fu wu qi )
  server-id = n gei fu wu qi fen pei yi ge du yi wu er de ID bian hao ; n de qu zhi fan wei shi 1~2 de 32 ci fang qi yong er jin zhi ri zhi gong neng 。
  log-bin = name qi yong er jin zhi ri zhi gong neng 。 zhe zhong ri zhi de wen jian ming shi filename.n huo mo ren de hostname.n, qi zhong de n shi yi ge 6 wei shu zi de zheng shu ( ri zhi wen jian shun xu bian hao )。
  binlog-do/ignore-db = dbname zhi ba gei ding shu ju ku li de bian hua qing kuang ji ru er jin zhi ri zhi wen jian / bu ba gei ding de shu ju ku li de bian hua ji ru er jin zhi ri zhi wen jian 。
  mysqld cheng xu -- jing xiang ( cong shu jing xiang fu wu qi )
  server-id = n gei fu wu qi fen pei yi ge wei yi de ID bian hao
  log-slave-updates qi yong cong shu fu wu qi shang de ri zhi gong neng , shi zhe tai ji suan ji ke yi yong lai gou cheng yi ge jing xiang lian (A->B->C)。
  master-host = hostname zhu kong fu wu qi de zhu ji ming huo IP di zhi 。 ru guo cong shu fu wu qi shang cun zai mater.info wen jian ( jing xiang guan xi ding yi wen jian ), ta jiang hu lue ci xuan xiang 。
  master-user = replicusername cong shu fu wu qi yong lai lian jie zhu kong fu wu qi de yong hu ming 。 ru guo cong shu fu wu qi shang cun zai mater.info wen jian , ta jiang hu lue ci xuan xiang 。
  master-password = passwd cong shu fu wu qi yong lai lian jie zhu kong fu wu qi de mi ma 。 ru guo cong shu fu wu qi shang cun zai mater.info wen jian , ta jiang hu lue ci xuan xiang 。
  master-port = n cong shu fu wu qi yong lai lian jie zhu kong fu wu qi de TCP/IP duan kou ( mo ren she zhi shi 3306 duan kou )。
  master-connect-retry = n ru guo yu zhu kong fu wu qi de lian jie mei you cheng gong , ze deng dai n miao (s) hou zai jin xing guan li fang shi ( mo ren she zhi shi 60s)。 ru guo cong shu fu wu qi cun zai mater.info wen jian ,
  ta jiang hu lue ci xuan xiang 。
  master-ssl-xxx = xxx dui zhu 、 cong fu wu qi zhi jian de SSL tong xin jin xing pei zhi 。
  read-only = 0/1 0: yuan xu cong shu fu wu qi du li di zhi xing SQL ming ling ( mo ren she zhi ); 1: cong shu fu wu qi zhi neng zhi xing lai zi zhu kong fu wu qi de SQL ming ling 。
  read-log-purge = 0/1 1: ba chu li wan de SQL ming ling li ke cong zhong ji ri zhi wen jian li shan chu ( mo ren she zhi ); 0: bu ba chu li wan de SQL ming ling li ke cong zhong ji ri zhi wen jian li shan chu 。
  replicate-do-table = dbname.tablename yu --replicate-do-table xuan xiang de han yi he yong fa xiang tong , dan shu ju ku he shu ju ku biao ming zi li yuan xu chu xian tong pei fu "%"
  ( li ru : test%.%-- dui ming zi yi "test" kai tou de suo you shu ju ku li de suo yi shu ju ku biao jin xing jing xiang chu li )。
  replicate-do-db = name zhi dui zhe ge shu ju ku jin xing jing xiang chu li 。
  replicate-ignore-table = dbname.tablename bu dui zhe ge shu ju biao jin xing jing xiang chu li 。
  replicate-wild-ignore-table = dbn.tablen bu dui zhe xie shu ju biao jin xing jing xiang chu li 。
  replicate-ignore-db = dbname bu dui zhe ge shu ju ku jin xing jing xiang chu li 。
  replicate-rewrite-db = db1name > db2name ba zhu kong shu ju ku shang de db1name shu ju ku jing xiang chu li wei cong shu fu wu qi shang de db2name shu ju ku 。
  report-host = hostname cong shu fu wu qi de zhu ji ming ; zhe xiang xin xi zhi yu SHOW SLAVE HOSTS ming ling you guan -- zhu kong fu wu qi ke yi yong zhe tiao ming ling sheng cheng yi fen cong shu fu wu qi de ming dan 。
  slave-compressed-protocol = 1 zhu 、 cong fu wu qi shi yong ya suo ge shi jin xing tong xin -- ru guo ta men dou zhi chi zhe me zuo de hua 。
  slave-skip-errors = n1, n2, ... huo all ji shi fa sheng chu cuo dai ma wei n1、n2 deng de cuo wu , jing xiang chu li gong zuo ye ji xu jin xing ( ji bu guan fa sheng shen me cuo wu , jing xiang chu li gong zuo ye ji xu jin xing )。
  ru guo pei zhi de dang , cong shu fu wu qi bu ying gai zai zhi xing SQL ming ling shi fa sheng cuo wu ( zai zhu kong fu wu qi shang zhi xing chu cuo de SQL ming ling bu hui bei fa song dao cong shu fu wu qi shang zuo jing xiang chu li ); ru guo bu shi yong
  slave-skip-errors xuan xiang , cong shu fu wu qi shang de jing xiang gong zuo jiu ke neng guo wei fa sheng cuo wu er zhong duan , zhong duan hou xu yao you ren gong shen yu cai neng ji xu jin xing 。
  mysqld--InnoDB-- ji ben she zhi 、 biao kong jian wen jian
  skip-innodb bu jia zai InnoDB shu ju biao qu dong cheng xu -- ru guo yong bu zhe InnoDB shu ju biao , ke yi yong zhe ge xuan xiang jie sheng yi xie nei cun 。
  innodb-file-per-table wei mei yi ge xin shu ju biao chuang jian yi ge biao kong jian wen jian er bu shi ba shu ju biao dou ji zhong bao cun zai zhong yang biao kong jian li ( hou zhe shi mo ren she zhi )。 gai xuan xiang shi jian yu MySQL 4.1。
  innodb-open-file = n InnoDB shu ju biao qu dong cheng xu zui duo ke yi tong shi da kai de wen jian shu ( mo ren she zhi shi 300)。 ru guo shi yong le innodb-file-per-table xuan xiang bing qie xu yao tong shi da kai hen duo
  shu ju biao de hua , zhe ge shu zi hen ke neng xu yao jia da 。
  innodb_data_home_dir = p InnoDB zhu mu lu , suo you yu InnoDB shu ju biao you guan de mu lu huo wen jian lu jing dou xiang dui yu zhe ge lu jing 。 zai mo ren de qing kuang xia , zhe ge zhu mu lu jiu shi MySQL de shu ju mu lu 。
  innodb_data_file_path = ts yong lai rong na InnoDB wei shu ju biao de biao kong jian : ke neng she ji yi ge yi shang de wen jian ; mei yi ge biao kong jian wen jian de zui da chang du dou bi xu yi zi jie (B)、 zhao zi jie (MB) huo
  qian zhao zi jie (GB) wei dan wei gei chu ; biao kong jian wen jian de ming zi bi xu yi fen hao ge kai ; zui hou yi ge biao kong jian wen jian huan ke yi dai yi ge autoextend shu xing he yi ge zui da chang du (max:n)。
  li ru ,ibdata1:1G; ibdata2:1G:autoextend:max:2G de yi si shi : biao kong jian wen jian ibdata1 de zui da chang du shi 1GB,ibdata2 de zui da chang du ye shi 1G, dan yuan xu ta kuo chong dao 2GB。
  chu wen jian ming wai , huan ke yi yong ying pan fen qu de she zhi ming lai ding yi biao kong jian , ci shi bi xu gei biao kong jian de zui da chu shi chang du zhi jia shang newraw guan jian zi zuo hou zhui , gei biao kong jian de zui da kuo chong chang du zhi jia shang
  raw guan jian zi zuo hou zhui ( li ru /dev/hdb1:20Gnewraw huo /dev/hdb1:20Graw); MySQL 4.0 ji geng gao ban ben de mo ren she zhi shi ibdata1:10M:autoextend。
  innodb_autoextend_increment = n dai you autoextend shu xing de biao kong jian wen jian mei ci jia da duo shao zhao zi jie ( mo ren she zhi shi 8MB)。 zhe ge shu xing bu she ji ju ti de shu ju biao wen jian , na xie wen jian de
  zeng da su du xiang dui shi bi jiao xiao de 。
  innodb_lock_wait_timeout = n ru guo mou ge shi wu zai deng dai n miao (s) hou huan mei you huo de suo xu yao de zi yuan , jiu shi yong ROLLBACK ming ling fang qi zhe ge shi wu 。 zhe xiang she zhi dui yu fa xian he chu li wei neng bei
  InnoDB shu ju biao qu dong cheng xu shi bie chu lai de si suo tiao jian you zhe chong yao de yi yi 。 zhe ge xuan xiang de mo ren she zhi shi 50s。
  innodb_fast_shutdown 0/1 shi fou yi zui kuai de su du guan bi InnoDB, mo ren she zhi shi 1, yi si shi bu ba huan cun zai INSERT huan cun qu de shu ju xie ru shu ju biao , na xie shu ju jiang zai MySQL fu wu qi xia ci
  qi dong shi zai xie ru ( zhe me zuo mei you shen me feng xian , yin wei INSERT huan cun qu shi biao kong jian de yi ge zu cheng bu fen , shu ju bu hui diu shi )。 ba zhe ge xuan xiang she zhi wei 0 fan mian wei xian , yin wei zai ji suan ji guan bi shi ,
  InnoDB qu dong cheng xu hen ke neng mei you zu gou de shi jian wan cheng ta de shu ju tong bu gong zuo , cao zuo xi tong ye xu hui zai ta wan cheng shu ju tong bu gong zuo zhi qian qiang xing jie shu InnoDB, er zhe hui dao zhi shu ju bu wan zheng 。
  mysqld cheng xu --InnoDB-- ri zhi
  innodb_log_group_home_dir = p yong lai cun fang InnoDB ri zhi wen jian de mu lu lu jing ( ru ib_logfile0、ib_logfile1 deng )。 zai mo ren de qing kuang xia ,InnoDB qu dong cheng xu jiang shi yong MySQL shu ju mu
  lu zuo wei zi ji bao cun ri zhi wen jian de wei zhi 。
  innodb_log_files_in_group = n shi yong duo shao ge ri zhi wen jian ( mo ren she zhi shi 2)。InnoDB shu ju biao qu dong cheng xu jiang yi lun zhuan fang shi yi ci tian xie zhe xie wen jian ; dang suo you de ri zhi wen jian dou xie man yi hou ,
  zhi hou de ri zhi xin xi jiang xie ru di yi ge ri zhi wen jian de zui da chang du ( mo ren she zhi shi 5MB)。 zhe ge chang du bi xu yi MB( zhao zi jie ) huo GB( qian zhao zi jie ) wei dan wei jin xing she zhi 。
  innodb_flush_log_at_trx_commit = 0/1/2 zhe ge xuan xiang jue ding zhe shen me shi hou ba ri zhi xin xi xie ru ri zhi wen jian yi ji shen me shi hou ba zhe xie wen jian wu li di xie ( shu yu cheng wei " tong bu ") dao ying pan shang 。
  she zhi zhi 0 de yi si shi mei ge yi miao xie yi ci ri zhi bing jin xing tong bu , zhe ke yi jian shao ying pan xie cao zuo ci shu , dan ke neng zao cheng shu ju diu shi ; she zhi zhi 1( she zhi she zhi ) de yi si shi zai mei zhi xing wan yi tiao COMMIT
  ming ling jiu xie yi ci ri zhi bing jin xing tong bu , zhe ke yi fang zhi shu ju diu shi , dan ying pan xie cao zuo ke neng hui hen pin fan ; she zhi zhi 2 shi yi ban zhe zhong de ban fa , ji mei zhi xing wan yi tiao COMMIT ming ling xie yi ci ri zhi ,
  mei ge yi miao jin xing yi ci tong bu 。
  innodb_flush_method = x InnoDB ri zhi wen jian de tong bu ban fa ( jin shi yong yu UNIX/Linux xi tong )。 zhe ge xuan xiang de ke qu zhi you liang zhong : fdatasync, yong fsync() han shu jin xing tong bu ; O_DSYNC,
  yong O_SYNC() han shu jin xing tong bu 。
  innodb_log_archive = 1 qi yong InnoDB qu dong cheng xu de archive( dang an ) ri zhi gong neng , ba ri zhi xin xi xie ru ib_arch_log_n wen jian 。 qi yong zhe zhong ri zhi gong neng zai InnoDB yu MySQL yi qi shi yong shi mei you
  duo da yi yi ( qi yong MySQL fu wu qi de er jin zhi ri zhi gong neng jiu zu gou yong le )。
  mysqld cheng xu --InnoDB-- huan cun qu de she zhi he you hua
  innodb_log_buffer_pool_size = n wei InnoDB shu ju biao ji qi suo yin er bao liu de RAM nei cun liang ( mo ren she zhi shi 8MB)。 zhe ge shen shu dui su du you zhe xiang dang da de ying xiang , ru guo ji suan ji shang zhi yun xing you
  MySQL/InnoDB shu ju ku fu wu qi , jiu ying gai ba quan bu nei cun de 80% yong yu zhe ge yong tu 。
  innodb_log_buffer_size = n shi wu ri zhi wen jian xie cao zuo huan cun qu de zui da chang du ( mo ren she zhi shi 1MB)。
  innodb_additional_men_pool_size = n wei yong yu nei bu guan li de ge zhong shu ju jie gou fen pei de huan cun qu zui da chang du ( mo ren she zhi shi 1MB)。
  innodb_file_io_threads = n I/O cao zuo ( ying pan xie cao zuo ) de zui da xian cheng ge shu ( mo ren she zhi shi 4)。
  innodb_thread_concurrency = n InnoDB qu dong cheng xu neng gou tong shi shi yong de zui da xian cheng ge shu ( mo ren she zhi shi 8)。
  mysqld cheng xu -- qi ta xuan xiang
  bind-address = ipaddr MySQL fu wu qi de IP di zhi 。 ru guo MySQL fu wu qi suo zai de ji suan ji you duo ge IP di zhi , zhe ge xuan xiang jiang fei chang chong yao 。
  default-storage-engine = type xin shu ju biao de mo ren shu ju biao lei xing ( mo ren she zhi shi MyISAM)。 zhe xiang she zhi huan ke yi tong guo --default-table-type xuan xiang lai she zhi 。
  default-timezone = name wei MySQL fu wu qi she zhi yi ge di li shi qu ( ru guo ta yu ben di ji suan ji de di li shi qu bu yi yang )。
  ft_min_word_len = n quan wen suo yin de zui xiao dan ci chang du gong 。 zhe ge xuan xiang de mo ren she zhi shi 4, yi si shi zai chuang jian quan wen suo yin shi bu kao lv na xie you 3 ge huo geng shao de zi fu gou jian dan ci 。
  Max-allowed-packet = n ke hu yu fu wu qi zhi jian jiao huan de shu ju bao de zui da chang du , zhe ge shu zi zhi shao ying gai da yu ke hu cheng xu jiang yao chu li de zui da BLOB kuai de chang du 。 zhe ge xuan xiang de mo ren she zhi shi 1MB。
  Sql-mode = model1, mode2, ... MySQL jiang yun xing zai na yi zhong SQL mo shi xia 。 zhe ge xuan xiang de zuo yong shi rang MySQL yu qi ta de shu ju ku xi tong bao chi zui da cheng du de jian rong 。 zhe ge xuan xiang de ke qu zhi bao kuo
  ansi、db2、oracle、no_zero_date、pipes_as_concat。
  zhu yi : ru guo zai pei zhi wen jian li gei chu de mou ge xuan xiang shi mysqld wu fa shi bie de ( ru , yin wei fan le yi ge yu chun de da zi cuo wu ),MySQL fu wu qi jiang bu qi dong 。【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
MySQL shu ju ku 5.0 de my.cnf pei zhi xuan xiang gai shu : mysqld cheng xu -- mu lu he wen jian basedir = path shi yong gei ding mu lu zuo wei gen mu lu ( an zhuang mu lu )。 character-sets-dir = path gei chu cun fang zhe zi fu ji de mu lu 。 datadir = path cong gei ding mu lu du qu shu ju ku wen jian 。 pid-file = filename wei mysqld cheng xu zhi ding yi ge cun fang jin cheng ID de wen jian ( jin shi yong yu UNIX/Linux xi tong ); Init-V jiao ben xu yao shi yong zhe ge wen jian li de jin cheng ID jie shu mysqld jin cheng 。 socket = filename wei MySQL ke hu cheng xu yu fu wu qi zhi jian de ben di tong xin zhi ding yi ge tao jie zi wen jian ( jin shi yong yu UNIX/Linux xi tong ; mo ren she zhi yi ban shi /var/lib/mysql/mysql.sock wen jian )。 zai Windows huan jing xia , ru guo MySQL ke hu yu fu wu qi shi tong guo ming ming guan dao jin xing tong xin de ,--sock xuan xiang gei chu de jiang shi gai ming ming guan dao de ming zi ( mo ren she zhi shi MySQL)。 lower_case_table_name = 1/0 xin mu lu he shu ju biao de ming zi shi fou zhi yuan xu shi yong xiao xie zi mu ; zhe ge xuan xiang zai Windows huan jing xia de mo ren she zhi shi 1( zhi yuan xu shi yong xiao xie zi mu )。 mysqld cheng xu -- yu yan she zhi character-sets-server = name xin shu ju ku huo shu ju biao de mo ren zi fu ji 。 wei le yu MySQL de zao qi ban ben bao chi jian rong , zhe ge zi fu ji ye ke yi yong --default-character-set xuan xiang gei chu ; dan zhe ge xuan xiang yi jing xian de you dian guo shi le 。 collation-server = name xin shu ju ku huo shu ju biao de mo ren pai xu fang shi 。 lanuage = name yong zhi ding de yu yan xian shi chu cuo xin xi 。 mysqld cheng xu -- tong xin 、 wang luo 、 xin xi an quan enable-named-pipes yuan xu Windows 2000/XP huan jing xia de ke hu he fu wu qi shi yong ming ming guan dao (named pipe) jin xing tong xin 。 zhe ge ming ming guan dao de mo ren ming zi shi MySQL, dan ke yi yong --socket xuan xiang lai gai bian 。 local-infile [=0] yuan xu / jin zhi shi yong LOAD DATA LOCAL yu ju lai chu li ben di wen jian 。 myisam-recover [=opt1, opt2, ...] zai qi dong shi zi dong xiu fu suo you shou sun de MyISAM shu ju biao 。 zhe ge xuan xiang de ke qu zhi you 4 zhong :DEFAULT、BACKUP、QUICK he FORCE; ta men yu myisamchk cheng xu de tong ming xuan xiang zuo yong xiang tong 。 old-passwords shi yong MySQL 3.23 he 4.0 ban ben zhong de lao suan fa lai jia mi mysql shu ju ku li de mi ma ( mo ren shi yong MySQL 4.1 ban ben kai shi yin ru de xin jia mi suan fa )。 port = n wei MySQL cheng xu zhi ding yi ge TCP/IP tong xin duan kou ( tong chang shi 3306 duan kou )。 safe-user-create zhi you zai mysql.user shu ju ku biao shang yong you INSERT quan xian de yong hu cai neng shi yong GRANT ming ling ; zhe shi yi zhong shuang bao xian ji zhi ( ci yong hu huan bi xu ju bei GRANT quan xian cai neng zhi xing GRANT ming ling )。 shared-memory yuan xu shi yong nei cun (shared memory) jin xing tong xin ( jin shi yong yu Windows)。 shared-memory-base-name = name gei gong xiang nei cun kuai qi yi ge ming zi ( mo ren de ming zi shi MySQL)。 skip-grant-tables bu shi yong mysql shu ju ku li de xin xi lai jin xing fang wen kong zhi ( jing gao : zhe jiang yuan xu yong hu ren he yong hu qu xiu gai ren he shu ju ku )。 skip-host-cache bu shi yong gao su huan cun qu lai cun fang zhu ji ming he IP di zhi de dui ying guan xi 。 skip-name-resovle bu ba IP di zhi jie xi wei zhu ji ming ; yu fang wen kong zhi (mysql.user shu ju biao ) you guan de jian cha quan bu tong guo IP di zhi xing jin 。 skip-networking zhi yuan xu tong guo yi ge tao jie zi wen jian (Unix/Linux xi tong ) huo tong guo ming ming guan dao (Windows xi tong ) jin xing ben di lian jie , bu yuan xu ICP/IP lian jie ; zhe ti gao le an quan xing , dan zu duan le lai zi wang luo de wai bu lian jie he suo you de Java ke hu cheng xu (Java ke hu ji shi zai ben di lian jie li ye shi yong TCP/IP)。 user = name mysqld cheng xu zai qi dong hou jiang zai gei ding UNIX/Linux zhang hu xia zhi xing ; mysqld bi xu cong root zhang hu qi dong cai neng zai qi dong hou qie huan dao ling yi ge zhang hu xia zhi xing ; mysqld_safe jiao ben jiang mo ren shi yong --user=mysql xuan xiang lai qi dong mysqld cheng xu 。 mysqld cheng xu -- nei cun guan li 、 you hua 、 cha xun huan cun qu bulk_insert_buffer_size = n wei yi ci cha ru duo tiao xin ji lu de INSERT ming ling fen pei de huan cun qu chang du ( mo ren she zhi shi 8M)。 key_buffer_size = n yong lai cun fang suo yin qu kuai de RMA zhi ( mo ren she zhi shi 8M)。 join_buffer_size = n zai shen jia JOIN cao zuo de shu ju lie mei you suo yin shi wei JOIN cao zuo fen pei de huan cun qu chang du ( mo ren she zhi shi 128K)。 max_heap_table_size = n HEAP shu ju biao de zui da chang du ( mo ren she zhi shi 16M); chao guo zhe ge chang du de HEAP shu ju biao jiang bei cun ru yi ge lin shi wen jian er bu shi zhu liu zai nei cun li 。 max_connections = n MySQL fu wu qi tong shi chu li de shu ju ku lian jie de zui da shu liang ( mo ren she zhi shi 100)。 query_cache_limit = n yuan xu lin shi cun fang zai cha xun huan cun qu li de cha xun jie guo de zui da chang du ( mo ren she zhi shi 1M)。 query_cache_size = n cha xun huan cun qu de zui da chang du ( mo ren she zhi shi 0, bu kai pi cha xun huan cun qu )。 query_cache_type = 0/1/2 cha xun huan cun qu de gong zuo mo shi :0, jin yong cha xun huan cun qu ; 1, qi yong cha xun huan cun qu ( mo ren she zhi ); 2," an xu fen pei " mo shi , zhi xiang ying SELECT SQL_CACHE ming ling 。 read_buffer_size = n wei cong shu ju biao shun xu du qu shu ju de du cao zuo bao liu de huan cun qu de chang du ( mo ren she zhi shi 128KB); zhe ge xuan xiang de she zhi zhi zai bi yao shi ke yi yong SQL ming ling SET SESSION read_buffer_size = n ming ling jia yi gai bian 。 read_rnd_buffer_size = n lei si yu read_buffer_size xuan xiang , dan zhen dui de shi an mou zhong te ding shun xu ( bi ru shi yong le ORDER BY zi ju de cha xun ) shu chu de cha xun jie guo ( mo ren she zhi shi 256K)。 sore_buffer = n wei pai xu cao zuo fen pei de huan cun qu de chang du ( mo ren she zhi shi 2M); ru guo zhe ge huan cun qu tai xiao , ze bi xu chuang jian yi ge lin shi wen jian lai jin xing pai xu 。 table_cache = n tong shi da kai de shu ju biao de shu liang ( mo ren she zhi shi 64)。 tmp_table_size = n lin shi HEAP shu ju biao de zui da chang du ( mo ren she zhi shi 32M); chao guo zhe ge chang du de lin shi shu ju biao jiang bei zhuan huan wei MyISAM shu ju biao bing cun ru yi ge lin shi wen jian 。 mysqld cheng xu -- ri zhi log [= file] ba suo you de lian jie yi ji suo you de SQL ming ling ji ru ri zhi ( tong yong cha xun ri zhi ); ru guo mei you gei chu file shen shu ,MySQL jiang zai shu ju ku mu lu li chuang jian yi ge hostname.log wen jian zuo wei zhe zhong ri zhi wen jian (hostname shi fu wu qi de zhu ji ming )。 log-slow-queries [= file] ba zhi xing yong shi chao guo long_query_time bian liang zhi de cha xun ming ling ji ru ri zhi ( man cha xun ri zhi ); ru guo mei you gei chu file shen shu ,MySQL jiang zai shu ju ku mu lu li chuang jian yi ge hostname-slow.log wen jian zuo wei zhe zhong ri zhi wen jian (hostname shi fu wu qi zhu ji ming )。 long_query_time = n man cha xun de zhi xing yong shi shang xian ( mo ren she zhi shi 10s)。 long_queries_not_using_indexs ba man cha xun yi ji zhi xing shi mei you shi yong suo yin de cha xun ming ling quan dou ji ru ri zhi ( qi yu tong --log-slow-queries xuan xiang )。 log-bin [= filename] ba dui shu ju jin xing xiu gai de suo you SQL ming ling ( ye jiu shi INSERT、UPDATE he DELETE ming ling ) yi er jin zhi ge shi ji ru ri zhi ( er jin zhi bian geng ri zhi ,binary update log)。 zhe zhong ri zhi de wen jian ming shi filename.n huo mo ren de hostname.n, qi zhong n shi yi ge 6 wei shu zi de zheng shu ( ri zhi wen jian an shun xu bian hao )。 log-bin-index = filename er jin zhi ri zhi gong neng de suo yin wen jian ming 。 zai mo ren qing kuang xia , zhe ge suo yin wen jian yu er jin zhi ri zhi wen jian de ming zi xiang tong , dan hou zhui ming shi .index er bu shi .nnnnnn。 max_binlog_size = n er jin zhi ri zhi wen jian de zui da chang du ( mo ren she zhi shi 1GB)。 zai qian yi ge er jin zhi ri zhi wen jian li de xin xi liang chao guo zhe ge zui da chang du zhi qian ,MySQL fu wu qi hui zi dong ti gong yi ge xin de er jin zhi ri zhi wen jian jie xu shang 。 binlog-do-db = dbname zhi ba gei ding shu ju ku li de bian hua qing kuang ji ru er jin zhi ri zhi wen jian , qi ta shu ju ku li de bian hua qing kuang bu ji zai 。 ru guo xu yao ji zai duo ge shu ju ku li de bian hua qing kuang , jiu bi xu zai pei zhi wen jian shi yong duo ge ben xuan xiang lai she zhi , mei ge shu ju ku yi xing 。 binlog-ignore-db = dbname bu ba gei ding shu ju ku li de bian hua qing kuang ji ru er jin zhi ri zhi wen jian 。 sync_binlog = n mei jing guo n ci ri zhi xie cao zuo jiu ba ri zhi wen jian xie ru ying pan yi ci ( dui ri zhi xin xi jin xing yi ci tong bu )。n=1 shi zui an quan de zuo fa , dan xiao lv zui di 。 mo ren she zhi shi n=0, yi si shi you cao zuo xi tong lai fu ze er jin zhi ri zhi wen jian de tong bu gong zuo 。 log-update [= file] ji zai chu cuo qing kuang de ri zhi wen jian ming ( chu cuo ri zhi )。 zhe zhong ri zhi gong neng wu fa jin yong 。 ru guo mei you gei chu file shen shu ,MySQL hui shi yong hostname.err zuo wei zhong ri zhi wen jian de ming zi 。 mysqld cheng xu -- jing xiang ( zhu kong jing xiang fu wu qi ) server-id = n gei fu wu qi fen pei yi ge du yi wu er de ID bian hao ; n de qu zhi fan wei shi 1~2 de 32 ci fang qi yong er jin zhi ri zhi gong neng 。 log-bin = name qi yong er jin zhi ri zhi gong neng 。 zhe zhong ri zhi de wen jian ming shi filename.n huo mo ren de hostname.n, qi zhong de n shi yi ge 6 wei shu zi de zheng shu ( ri zhi wen jian shun xu bian hao )。 binlog-do/ignore-db = dbname zhi ba gei ding shu ju ku li de bian hua qing kuang ji ru er jin zhi ri zhi wen jian / bu ba gei ding de shu ju ku li de bian hua ji ru er jin zhi ri zhi wen jian 。 mysqld cheng xu -- jing xiang ( cong shu jing xiang fu wu qi ) server-id = n gei fu wu qi fen pei yi ge wei yi de ID bian hao log-slave-updates qi yong cong shu fu wu qi shang de ri zhi gong neng , shi zhe tai ji suan ji ke yi yong lai gou cheng yi ge jing xiang lian (A->B->C)。 master-host = hostname zhu kong fu wu qi de zhu ji ming huo IP di zhi 。 ru guo cong shu fu wu qi shang cun zai mater.info wen jian ( jing xiang guan xi ding yi wen jian ), ta jiang hu lue ci xuan xiang 。 master-user = replicusername cong shu fu wu qi yong lai lian jie zhu kong fu wu qi de yong hu ming 。 ru guo cong shu fu wu qi shang cun zai mater.info wen jian , ta jiang hu lue ci xuan xiang 。 master-password = passwd cong shu fu wu qi yong lai lian jie zhu kong fu wu qi de mi ma 。 ru guo cong shu fu wu qi shang cun zai mater.info wen jian , ta jiang hu lue ci xuan xiang 。 master-port = n cong shu fu wu qi yong lai lian jie zhu kong fu wu qi de TCP/IP duan kou ( mo ren she zhi shi 3306 duan kou )。 master-connect-retry = n ru guo yu zhu kong fu wu qi de lian jie mei you cheng gong , ze deng dai n miao (s) hou zai jin xing guan li fang shi ( mo ren she zhi shi 60s)。 ru guo cong shu fu wu qi cun zai mater.info wen jian , ta jiang hu lue ci xuan xiang 。 master-ssl-xxx = xxx dui zhu 、 cong fu wu qi zhi jian de SSL tong xin jin xing pei zhi 。 read-only = 0/1 0: yuan xu cong shu fu wu qi du li di zhi xing SQL ming ling ( mo ren she zhi ); 1: cong shu fu wu qi zhi neng zhi xing lai zi zhu kong fu wu qi de SQL ming ling 。 read-log-purge = 0/1 1: ba chu li wan de SQL ming ling li ke cong zhong ji ri zhi wen jian li shan chu ( mo ren she zhi ); 0: bu ba chu li wan de SQL ming ling li ke cong zhong ji ri zhi wen jian li shan chu 。 replicate-do-table = dbname.tablename yu --replicate-do-table xuan xiang de han yi he yong fa xiang tong , dan shu ju ku he shu ju ku biao ming zi li yuan xu chu xian tong pei fu "%" ( li ru : test%.%-- dui ming zi yi "test" kai tou de suo you shu ju ku li de suo yi shu ju ku biao jin xing jing xiang chu li )。 replicate-do-db = name zhi dui zhe ge shu ju ku jin xing jing xiang chu li 。 replicate-ignore-table = dbname.tablename bu dui zhe ge shu ju biao jin xing jing xiang chu li 。 replicate-wild-ignore-table = dbn.tablen bu dui zhe xie shu ju biao jin xing jing xiang chu li 。 replicate-ignore-db = dbname bu dui zhe ge shu ju ku jin xing jing xiang chu li 。 replicate-rewrite-db = db1name > db2name ba zhu kong shu ju ku shang de db1name shu ju ku jing xiang chu li wei cong shu fu wu qi shang de db2name shu ju ku 。 report-host = hostname cong shu fu wu qi de zhu ji ming ; zhe xiang xin xi zhi yu SHOW SLAVE HOSTS ming ling you guan -- zhu kong fu wu qi ke yi yong zhe tiao ming ling sheng cheng yi fen cong shu fu wu qi de ming dan 。 slave-compressed-protocol = 1 zhu 、 cong fu wu qi shi yong ya suo ge shi jin xing tong xin -- ru guo ta men dou zhi chi zhe me zuo de hua 。 slave-skip-errors = n1, n2, ... huo all ji shi fa sheng chu cuo dai ma wei n1、n2 deng de cuo wu , jing xiang chu li gong zuo ye ji xu jin xing ( ji bu guan fa sheng shen me cuo wu , jing xiang chu li gong zuo ye ji xu jin xing )。 ru guo pei zhi de dang , cong shu fu wu qi bu ying gai zai zhi xing SQL ming ling shi fa sheng cuo wu ( zai zhu kong fu wu qi shang zhi xing chu cuo de SQL ming ling bu hui bei fa song dao cong shu fu wu qi shang zuo jing xiang chu li ); ru guo bu shi yong slave-skip-errors xuan xiang , cong shu fu wu qi shang de jing xiang gong zuo jiu ke neng guo wei fa sheng cuo wu er zhong duan , zhong duan hou xu yao you ren gong shen yu cai neng ji xu jin xing 。 mysqld--InnoDB-- ji ben she zhi 、 biao kong jian wen jian skip-innodb bu jia zai InnoDB shu ju biao qu dong cheng xu -- ru guo yong bu zhe InnoDB shu ju biao , ke yi yong zhe ge xuan xiang jie sheng yi xie nei cun 。 innodb-file-per-table wei mei yi ge xin shu ju biao chuang jian yi ge biao kong jian wen jian er bu shi ba shu ju biao dou ji zhong bao cun zai zhong yang biao kong jian li ( hou zhe shi mo ren she zhi )。 gai xuan xiang shi jian yu MySQL 4.1。 innodb-open-file = n InnoDB shu ju biao qu dong cheng xu zui duo ke yi tong shi da kai de wen jian shu ( mo ren she zhi shi 300)。 ru guo shi yong le innodb-file-per-table xuan xiang bing qie xu yao tong shi da kai hen duo shu ju biao de hua , zhe ge shu zi hen ke neng xu yao jia da 。 innodb_data_home_dir = p InnoDB zhu mu lu , suo you yu InnoDB shu ju biao you guan de mu lu huo wen jian lu jing dou xiang dui yu zhe ge lu jing 。 zai mo ren de qing kuang xia , zhe ge zhu mu lu jiu shi MySQL de shu ju mu lu 。 innodb_data_file_path = ts yong lai rong na InnoDB wei shu ju biao de biao kong jian : ke neng she ji yi ge yi shang de wen jian ; mei yi ge biao kong jian wen jian de zui da chang du dou bi xu yi zi jie (B)、 zhao zi jie (MB) huo qian zhao zi jie (GB) wei dan wei gei chu ; biao kong jian wen jian de ming zi bi xu yi fen hao ge kai ; zui hou yi ge biao kong jian wen jian huan ke yi dai yi ge autoextend shu xing he yi ge zui da chang du (max:n)。 li ru ,ibdata1:1G; ibdata2:1G:autoextend:max:2G de yi si shi : biao kong jian wen jian ibdata1 de zui da chang du shi 1GB,ibdata2 de zui da chang du ye shi 1G, dan yuan xu ta kuo chong dao 2GB。 chu wen jian ming wai , huan ke yi yong ying pan fen qu de she zhi ming lai ding yi biao kong jian , ci shi bi xu gei biao kong jian de zui da chu shi chang du zhi jia shang newraw guan jian zi zuo hou zhui , gei biao kong jian de zui da kuo chong chang du zhi jia shang raw guan jian zi zuo hou zhui ( li ru /dev/hdb1:20Gnewraw huo /dev/hdb1:20Graw); MySQL 4.0 ji geng gao ban ben de mo ren she zhi shi ibdata1:10M:autoextend。 innodb_autoextend_increment = n dai you autoextend shu xing de biao kong jian wen jian mei ci jia da duo shao zhao zi jie ( mo ren she zhi shi 8MB)。 zhe ge shu xing bu she ji ju ti de shu ju biao wen jian , na xie wen jian de zeng da su du xiang dui shi bi jiao xiao de 。 innodb_lock_wait_timeout = n ru guo mou ge shi wu zai deng dai n miao (s) hou huan mei you huo de suo xu yao de zi yuan , jiu shi yong ROLLBACK ming ling fang qi zhe ge shi wu 。 zhe xiang she zhi dui yu fa xian he chu li wei neng bei InnoDB shu ju biao qu dong cheng xu shi bie chu lai de si suo tiao jian you zhe chong yao de yi yi 。 zhe ge xuan xiang de mo ren she zhi shi 50s。 innodb_fast_shutdown 0/1 shi fou yi zui kuai de su du guan bi InnoDB, mo ren she zhi shi 1, yi si shi bu ba huan cun zai INSERT huan cun qu de shu ju xie ru shu ju biao , na xie shu ju jiang zai MySQL fu wu qi xia ci qi dong shi zai xie ru ( zhe me zuo mei you shen me feng xian , yin wei INSERT huan cun qu shi biao kong jian de yi ge zu cheng bu fen , shu ju bu hui diu shi )。 ba zhe ge xuan xiang she zhi wei 0 fan mian wei xian , yin wei zai ji suan ji guan bi shi , InnoDB qu dong cheng xu hen ke neng mei you zu gou de shi jian wan cheng ta de shu ju tong bu gong zuo , cao zuo xi tong ye xu hui zai ta wan cheng shu ju tong bu gong zuo zhi qian qiang xing jie shu InnoDB, er zhe hui dao zhi shu ju bu wan zheng 。 mysqld cheng xu --InnoDB-- ri zhi innodb_log_group_home_dir = p yong lai cun fang InnoDB ri zhi wen jian de mu lu lu jing ( ru ib_logfile0、ib_logfile1 deng )。 zai mo ren de qing kuang xia ,InnoDB qu dong cheng xu jiang shi yong MySQL shu ju mu lu zuo wei zi ji bao cun ri zhi wen jian de wei zhi 。 innodb_log_files_in_group = n shi yong duo shao ge ri zhi wen jian ( mo ren she zhi shi 2)。InnoDB shu ju biao qu dong cheng xu jiang yi lun zhuan fang shi yi ci tian xie zhe xie wen jian ; dang suo you de ri zhi wen jian dou xie man yi hou , zhi hou de ri zhi xin xi jiang xie ru di yi ge ri zhi wen jian de zui da chang du ( mo ren she zhi shi 5MB)。 zhe ge chang du bi xu yi MB( zhao zi jie ) huo GB( qian zhao zi jie ) wei dan wei jin xing she zhi 。 innodb_flush_log_at_trx_commit = 0/1/2 zhe ge xuan xiang jue ding zhe shen me shi hou ba ri zhi xin xi xie ru ri zhi wen jian yi ji shen me shi hou ba zhe xie wen jian wu li di xie ( shu yu cheng wei " tong bu ") dao ying pan shang 。 she zhi zhi 0 de yi si shi mei ge yi miao xie yi ci ri zhi bing jin xing tong bu , zhe ke yi jian shao ying pan xie cao zuo ci shu , dan ke neng zao cheng shu ju diu shi ; she zhi zhi 1( she zhi she zhi ) de yi si shi zai mei zhi xing wan yi tiao COMMIT ming ling jiu xie yi ci ri zhi bing jin xing tong bu , zhe ke yi fang zhi shu ju diu shi , dan ying pan xie cao zuo ke neng hui hen pin fan ; she zhi zhi 2 shi yi ban zhe zhong de ban fa , ji mei zhi xing wan yi tiao COMMIT ming ling xie yi ci ri zhi , mei ge yi miao jin xing yi ci tong bu 。 innodb_flush_method = x InnoDB ri zhi wen jian de tong bu ban fa ( jin shi yong yu UNIX/Linux xi tong )。 zhe ge xuan xiang de ke qu zhi you liang zhong : fdatasync, yong fsync() han shu jin xing tong bu ; O_DSYNC, yong O_SYNC() han shu jin xing tong bu 。 innodb_log_archive = 1 qi yong InnoDB qu dong cheng xu de archive( dang an ) ri zhi gong neng , ba ri zhi xin xi xie ru ib_arch_log_n wen jian 。 qi yong zhe zhong ri zhi gong neng zai InnoDB yu MySQL yi qi shi yong shi mei you duo da yi yi ( qi yong MySQL fu wu qi de er jin zhi ri zhi gong neng jiu zu gou yong le )。 mysqld cheng xu --InnoDB-- huan cun qu de she zhi he you hua innodb_log_buffer_pool_size = n wei InnoDB shu ju biao ji qi suo yin er bao liu de RAM nei cun liang ( mo ren she zhi shi 8MB)。 zhe ge shen shu dui su du you zhe xiang dang da de ying xiang , ru guo ji suan ji shang zhi yun xing you MySQL/InnoDB shu ju ku fu wu qi , jiu ying gai ba quan bu nei cun de 80% yong yu zhe ge yong tu 。 innodb_log_buffer_size = n shi wu ri zhi wen jian xie cao zuo huan cun qu de zui da chang du ( mo ren she zhi shi 1MB)。 innodb_additional_men_pool_size = n wei yong yu nei bu guan li de ge zhong shu ju jie gou fen pei de huan cun qu zui da chang du ( mo ren she zhi shi 1MB)。 innodb_file_io_threads = n I/O cao zuo ( ying pan xie cao zuo ) de zui da xian cheng ge shu ( mo ren she zhi shi 4)。 innodb_thread_concurrency = n InnoDB qu dong cheng xu neng gou tong shi shi yong de zui da xian cheng ge shu ( mo ren she zhi shi 8)。 mysqld cheng xu -- qi ta xuan xiang bind-address = ipaddr MySQL fu wu qi de IP di zhi 。 ru guo MySQL fu wu qi suo zai de ji suan ji you duo ge IP di zhi , zhe ge xuan xiang jiang fei chang chong yao 。 default-storage-engine = type xin shu ju biao de mo ren shu ju biao lei xing ( mo ren she zhi shi MyISAM)。 zhe xiang she zhi huan ke yi tong guo --default-table-type xuan xiang lai she zhi 。 default-timezone = name wei MySQL fu wu qi she zhi yi ge di li shi qu ( ru guo ta yu ben di ji suan ji de di li shi qu bu yi yang )。 ft_min_word_len = n quan wen suo yin de zui xiao dan ci chang du gong 。 zhe ge xuan xiang de mo ren she zhi shi 4, yi si shi zai chuang jian quan wen suo yin shi bu kao lv na xie you 3 ge huo geng shao de zi fu gou jian dan ci 。 Max-allowed-packet = n ke hu yu fu wu qi zhi jian jiao huan de shu ju bao de zui da chang du , zhe ge shu zi zhi shao ying gai da yu ke hu cheng xu jiang yao chu li de zui da BLOB kuai de chang du 。 zhe ge xuan xiang de mo ren she zhi shi 1MB。 Sql-mode = model1, mode2, ... MySQL jiang yun xing zai na yi zhong SQL mo shi xia 。 zhe ge xuan xiang de zuo yong shi rang MySQL yu qi ta de shu ju ku xi tong bao chi zui da cheng du de jian rong 。 zhe ge xuan xiang de ke qu zhi bao kuo ansi、db2、oracle、no_zero_date、pipes_as_concat。 zhu yi : ru guo zai pei zhi wen jian li gei chu de mou ge xuan xiang shi mysqld wu fa shi bie de ( ru , yin wei fan le yi ge yu chun de da zi cuo wu ),MySQL fu wu qi jiang bu qi dong 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
时尚秀气模特裴裴(8)
时尚秀气模特裴裴(7)
时尚秀气模特裴裴(6)
时尚秀气模特裴裴(5)
白墙黑瓦
广州东郊[原创]
八美至丹巴的东谷天然盆景
不一样的
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有