Chapter聽5.聽Database Administration - MySQL 5.1参考手册中文版

MySQL绋嬪簭閲囩敤鍚勭�嶄笉鍚岀殑閫夐」銆備絾姣忎釜MySQL绋嬪簭鎻愪緵涓�涓�--help閫夐」,浣犲彲浠ョ敤鏉ユ煡闃呯▼搴忛�夐」鐩稿叧璇存槑銆備緥濡傦紝浣犲彲浠ヨ瘯璇�mysqld --help銆�

浣犲彲浠ュ湪鍛戒护琛屼腑鎴栧湪閫夐」鏂囦欢涓�鎸囧畾閫夐」鏉ユ浛鎹㈡墍鏈夋爣鍑嗙▼搴忎腑鐨勯粯璁ら�夐」銆傚弬瑙�4.3鑺傦紝鈥滄寚瀹氱▼搴忛�夐」鈥�銆�

涓嬮潰绠�鍗曟弿杩颁簡MySQL鏈嶅姟鍣ㄥ拰鏈嶅姟鍣ㄧ浉鍏崇▼搴忥細

路         mysqld

SQL鍚庡彴绋嬪簭(鍗�MySQL鏈嶅姟鍣�)銆傝�佹兂浣跨敤瀹㈡埛绔�绋嬪簭锛岃�ョ▼搴忓繀椤昏繍琛岋紝鍥犱负瀹㈡埛绔�閫氳繃杩炴帴鏈嶅姟鍣ㄦ潵璁块棶鏁版嵁搴撱�傚弬瑙�5.3鑺傦紝鈥渕ysqld锛歁ySQL鏈嶅姟鍣ㄢ��銆�

路         mysqld-max

鍖呮嫭鏇村�氱壒鎬х殑涓�涓�鏈嶅姟鍣ㄧ増鏈�銆傚弬瑙�5.1.2鑺傦紝鈥渕ysqld-max鎵╁睍MySQL鏈嶅姟鍣ㄢ��

路         mysqld_safe

鏈嶅姟鍣ㄥ惎鍔ㄨ剼鏈�銆傚�傛灉mysqld-max瀛樺湪,mysqld_safe璇曞浘鍚�鍔ㄥ畠锛屽惁鍒欏惎鍔�mysqld銆傚弬瑙�5.1.3鑺傦紝鈥渕ysqld_safe锛歁ySQL鏈嶅姟鍣ㄥ惎鍔ㄨ剼鏈�鈥�銆�

路         mysql.server

鏈嶅姟鍣ㄥ惎鍔ㄨ剼鏈�銆傝�ヨ剼鏈�鐢ㄤ簬浣跨敤鍖呭惈涓虹壒瀹氱骇鍒�鐨勮繍琛屽惎鍔ㄦ湇鍔＄殑鑴氭湰鐨勮繍琛岀洰褰曠殑绯荤粺銆傚畠璋冪敤mysqld_safe鏉ュ惎鍔�MySQL鏈嶅姟鍣ㄣ�傚弬瑙�5.1.4鑺傦紝鈥渕ysql.server锛歁ySQL鏈嶅姟鍣ㄥ惎鍔ㄨ剼鏈�鈥�銆�

路         mysqld_multi

鏈嶅姟鍣ㄥ惎鍔ㄨ剼鏈�锛屽彲浠ュ惎鍔ㄦ垨鍋滄�㈢郴缁熶笂瀹夎�呯殑澶氫釜鏈嶅姟鍣ㄣ�傚弬瑙�5.1.5鑺傦紝鈥渕ysqld_multi锛氱�＄悊澶氫釜MySQL鏈嶅姟鍣ㄧ殑绋嬪簭鈥�

路         mysql_install_db

璇ヨ剼鏈�鐢ㄩ粯璁ゆ潈闄愬垱寤�MySQL鎺堟潈琛ㄣ�傞�氬父鍙�鏄�鍦ㄧ郴缁熶笂棣栨�″畨瑁�MySQL鏃舵墽琛屼竴娆°�傚弬瑙�2.9.2鑺傦紝鈥淯nix涓嬪畨瑁呭悗鐨勮繃绋嬧��銆�

路         mysql_fix_ privilege_tables

鍦ㄥ崌绾у畨瑁呭悗锛屽�傛灉鏂扮増鏈�MySQL涓�鐨� 鎺堟潈琛ㄦ湁鏇存敼锛屽垯浣跨敤璇ヨ剼鏈�鏉ユ洿鏀规巿鏉冭〃銆傚弬瑙�2.10.2鑺傦紝鈥滃崌绾ф巿鏉冭〃鈥�銆�

鏈嶅姟鍣ㄤ富鏈轰笂杩樿繍琛屽叾瀹冨嚑涓�绋嬪簭锛�

路         myisamchk

鐢ㄦ潵鎻忚堪銆佹��鏌ャ�佷紭鍖栧拰缁存姢MyISAM琛ㄧ殑瀹炵敤宸ュ叿銆傚湪5.9.5鑺傦紝鈥渕yisamchk锛歁yISAM琛ㄧ淮鎶ゅ疄鐢ㄥ伐鍏封��涓�鎻忚堪浜�myisamchk銆�

路         make_binary_distribution

璇ョ▼搴忓彲浠ョ敓鎴愮紪璇戣繃鐨�MySQL鐨勪簩杩涘埗鐗堟湰銆傚彲浠ラ�氳繃FTP涓婁紶鍒�ftp.mysql.com鐨�/pub/mysql/upload/锛屼緵鍏跺畠MySQL鐢ㄦ埛浣跨敤銆�

路         mysqlbug

MySQL 缂洪櫡鎶ュ憡鑴氭湰銆傚畠鍙�浠ョ敤鏉ュ悜MySQL閭�浠剁郴缁熷彂閫佺己闄锋姤鍛娿��(浣犱篃鍙�浠ヨ�块棶http://bugs.mysql.com/鍦ㄧ嚎鍒涘缓缂洪櫡鎶ュ憡鏂囦欢銆傚弬瑙�1.7.1.3鑺傦紝鈥滃�備綍閫氭姤缂洪櫡鍜岄棶棰樷��锛�銆�

MySQL-Max鏈嶅姟鍣ㄦ槸mysqld MySQL鏈嶅姟鍣ㄧ殑涓�涓�鐗堟湰锛屽寘鍚�浜嗘洿澶氱殑鐗规�с��

璇ュ垎鍙戠増鐨勪娇鐢ㄥ彇鍐充簬浣犵殑骞冲彴锛�

路         瀵逛簬Windows锛�MySQL浜岃繘鍒跺垎鍙戠増鍖呮嫭鏍囧噯鏈嶅姟鍣� (mysqld.exe)鍜�MySQL-Max鏈嶅姟鍣�(mysqld-max.exe)锛屽洜姝や綘涓嶅啀闇�瑕佷笓鐢ㄥ垎鍙戠増銆傚彧闇�瑕佷娇鐢ㄤ竴涓�甯歌��Windows鍒嗗彂鐗堬紝鍙�浠ヤ粠http://dev.mysql.com/downloads/鑾峰緱銆傚弬瑙�2.3鑺傦紝鈥滃湪Windows涓婂畨瑁匨ySQL鈥�銆�

路         瀵逛簬Linux锛屽�傛灉浣犱娇鐢�RPM鍒嗗彂鐗堝畨瑁�MySQL锛岄�栧厛浣跨敤甯歌��MySQL-server RPM鏉ュ畨瑁呮爣鍑�mysqld鏈嶅姟鍣ㄣ�傜劧鍚庝娇鐢�MySQL-Max RPM鏉ュ畨瑁�mysqld-max鏈嶅姟鍣ㄣ��MySQL-Max RPM鍋囧畾浣犲凡缁忓畨瑁呬簡甯歌�勬湇鍔″櫒RPM銆傚叧浜�Linux RPM杞�浠跺寘鐨勮�︾粏淇℃伅锛屽弬瑙�2.4鑺傦紝鈥滃湪Linux涓嬪畨瑁匨ySQL鈥�銆�

路         鎵�鏈夊叾瀹�MySQL-Max鍒嗗彂鐗堝寘鍚�涓�涓�mysqld鏈嶅姟鍣�锛屼絾鍏锋湁鏇村�氱殑鐗规�с��

浣犲彲浠ヤ粠MySQL AB缃戝潃http://dev.mysql.com/downloads/鎵惧埌MySQL-Max浜岃繘鍒剁増鏈�銆�

MySQL AB浣跨敤涓嬮潰鐨�configure閫夐」鏋勫缓MySQL-Max鏈嶅姟鍣�锛�

路         --with-server-suffix=-max

璇ラ�夐」涓�mysqld鐗堟湰瀛楃�︿覆娣诲姞涓�涓�-max鍚庣紑銆�

路         --with-innodb

璇ラ�夐」鍚�鐢�InnoDB瀛樺偍寮曟搸鏀�鎸併��MySQL-Max鏈嶅姟鍣ㄥ寘鎷�InnoDB鏀�鎸併�傚湪MySQL 4.0鍙婁互涓婄増鏈�涓�锛岄粯璁�InnoDB鍖呮嫭鍦ㄦ墍鏈変簩杩涘埗鍒嗗彂鐗堜腑锛屽洜姝や綘涓嶉渶瑕佺敤MySQL-Max鏈嶅姟鍣ㄥ彧鏄�鐢ㄦ潵鑾峰彇InnoDB鏀�鎸併��

路         --with-bdb

璇ラ�夐」鍚�鐢�Berkeley DB (BDB)瀛樺偍寮曟搸鏀�鎸併��

路         --with-blackhole-storage-engine

璇ラ�夐」鍚�鐢�BLACKHOLE瀛樺偍寮曟搸鏀�鎸併��

路         USE_SYMDIR

鍚�鐢ㄨ�ュ畾涔夋潵涓�Windows鎵撳紑鏁版嵁搴撶�﹀彿閾炬帴鏀�鎸併�傜�﹀彿閾炬帴鏀�鎸侀�傜敤浜庢墍鏈�Windows鏈嶅姟鍣�锛屽洜姝�Max鏈嶅姟鍣ㄤ笉闇�瑕佹敮鎸佽�ョ壒鎬с��

路         --with-ndbcluster

璇ラ�夐」鍚�鐢�NDB Cluster瀛樺偍寮曟搸鏀�鎸併�傜洰鍓�(5.1.2-alpha)鍙�鏈�Linux銆�Solaris鍜�Mac OS X鏀�鎸�Cluster銆傚凡鏈変竴浜涚敤鎴锋姤鍛婂湪BSD 鎿嶄綔绯荤粺涓婃垚鍔熶娇鐢ㄤ簡浠庢簮鐮佹瀯寤虹殑MySQL Cluster锛屼絾鐩�鍓嶈繕娌℃湁寰楀埌瀹樻柟鏀�鎸併��

MySQL-Max浜岃繘鍒跺垎鍙戠増瀵逛簬鎯宠�佸畨瑁呴�勭紪璇戠▼搴忕殑鐢ㄦ埛寰堟柟渚裤�傚�傛灉浣犱娇鐢ㄦ簮鐮佸垎鍙戠増鏋勫缓MySQL锛屼綘鍙�浠ラ�氳繃鍦ㄩ厤缃�鏃跺惎鐢�MySQL-Max浜岃繘鍒跺垎鍙戠増鏋勫缓鎵�鐢ㄧ殑鐩稿悓鐨勭壒鎬ф潵鏋勫缓浣犺嚜宸辩殑Max-like鏈嶅姟鍣ㄣ��

MySQL-Max鏈嶅姟鍣ㄥ寘鎷�BerkeleyDB (BDB)瀛樺偍寮曟搸锛屼絾骞堕潪鎵�鏈夊钩鍙版敮鎸�BDB銆�

Solaris銆�Mac OS X鍜�Linux(鍦ㄥぇ澶氭暟骞冲彴涓�)鐨�MySQL-Max鏈嶅姟鍣ㄥ寘鎷�NDB CLUSTER瀛樺偍寮曟搸鏀�鎸併�傝�锋敞鎰忓繀椤荤敤ndbcluster閫夐」鍚�鍔ㄦ湇鍔″櫒锛屼互渚夸娇鏈嶅姟鍣ㄥ仛涓�MySQL Cluster鐨勪竴閮ㄥ垎鏉ヨ繍琛屻��(璇︾粏淇℃伅鍙傝��17.4鑺傦紝鈥淢ySQL绨囩殑閰嶇疆鈥�锛�銆�

涓嬮潰鐨勮〃鏄剧ず浜�MySQL-Max浜岃繘鍒跺湪鍝�涓�骞冲彴涓婂寘鎷�BDB鍜�/鎴�NDB CLUSTER鏀�鎸侊細

绯荤粺	BDB鏀�鎸�	NDB鏀�鎸�
AIX 4.3	N	N
HP-UX 11.0	N	N
Linux-Alpha	N	Y
Linux-IA-64	N	N
Linux-Intel	Y	Y
Mac OS X	N	N
NetWare	N	N
SCO OSR5	Y	N
Solaris-SPARC	Y	Y
Solaris-Intel	N	Y
UnixWare	Y	N
Windows NT/2000/XP	Y	N

瑕佹兂鎵惧嚭浣犵殑鏈嶅姟鍣ㄦ敮鎸佸摢涓�瀛樺偍寮曟搸锛屾墽琛屼笅闈㈢殑璇�鍙ワ細

mysql> SHOW ENGINES;

+------------+---------+----------------------------------------------------------------+

| Engine     | Support | Comment                                                        |

+------------+---------+----------------------------------------------------------------+

| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         |

| MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      |

| HEAP       | YES     | Alias for MEMORY                                               |

| MERGE      | YES     | Collection of identical MyISAM tables                          |

| MRG_MYISAM | YES     | Alias for MERGE                                                |

| ISAM       | NO      | Obsolete storage engine, now replaced by MyISAM                |

| MRG_ISAM   | NO      | Obsolete storage engine, now replaced by MERGE                 |

| InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     |

| INNOBASE   | YES     | Alias for INNODB                                               |

| BDB        | YES     | Supports transactions and page-level locking                   |

| BERKELEYDB | YES     | Alias for BDB                                                  |

| NDBCLUSTER | NO      | Clustered, fault-tolerant, memory-based tables                 |

| NDB        | NO      | Alias for NDBCLUSTER                                           |

| EXAMPLE    | NO      | Example storage engine                                         |

| ARCHIVE    | YES     | Archive storage engine                                         |

| CSV        | NO      | CSV storage engine                                             |

| FEDERATED  | YES     | Federated MySQL storage engine                                 |

| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it disappears) |

+------------+---------+----------------------------------------------------------------+

18 rows in set (0.00 sec)

(鍙﹀弬瑙�13.5.4.8鑺傦紝鈥淪HOW ENGINES璇�娉曗��锛�銆�

浣犺繕鍙�浠ヤ娇鐢ㄤ笅闈㈢殑璇�鍙ヤ唬鏇�SHOW ENGINES锛屽苟妫�鏌ヤ綘鎰熷叴瓒ｇ殑瀛樺偍寮曟搸鐨勫彉閲忓�硷細

mysql> SHOW VARIABLES LIKE 'have%';

+-----------------------+----------+

| Variable_name         | Value    |

+-----------------------+----------+

| have_archive          | YES      |

| have_bdb              | NO       |

| have_blackhole_engine | YES      |

| have_compress         | YES      |

| have_crypt            | YES      |

| have_csv              | YES      |

| have_example_engine   | NO       |

| have_federated_engine | NO       |

| have_geometry         | YES      |

| have_innodb           | YES      |

| have_isam             | NO       |

| have_ndbcluster       | DISABLED |

| have_openssl          | NO       |

| have_partition_engine | YES      |

| have_query_cache      | YES      |

| have_raid             | NO       |

| have_rtree_keys       | YES      |

| have_symlink          | YES      |

+-----------------------+----------+

18 rows in set (0.01 sec)

SHOW鍛戒护鐨勭簿纭�杈撳嚭闅忎娇鐢ㄧ殑MySQL鐗堟湰(鍜屽惎鐢ㄧ殑鐗规��)鐨勪笉鍚岃�屾湁鍙樺寲銆傜��2鍒楃殑鍊艰〃绀哄悇鐗规�ф敮鎸佺殑鏈嶅姟鍣ㄧ骇鍒�锛屽�備笅鎵�绀猴細

鍊�	鍚�涔�
YES	鏀�鎸佽�ョ壒鎬у苟宸茬粡婵�娲汇��
NO	涓嶆敮鎸佽�ョ壒鎬с��
DISABLED	鏀�鎸佽�ョ壒鎬т絾琚�绂佺敤銆�

NO鍊艰〃绀虹紪璇戠殑鏈嶅姟鍣ㄤ笉鏀�鎸佽�ョ壒鎬э紝鍥犳�ゅ湪杩愯�屾椂涓嶈兘婵�娲汇��

鍑虹幇DISABLED鍊兼槸鍥犱负鏈嶅姟鍣ㄥ惎鍔ㄦ椂璇ョ壒鎬ц��绂佺敤锛屾垨娌℃湁缁欏嚭鍚�鐢ㄥ畠鐨勬墍鏈夐�夐」銆傚湪鍚庝竴绉嶆儏鍐碉紝host_鍚�.err閿欒��鏃ュ織鏂囦欢搴斿寘鍚�璇ラ�夐」琚�绂佺敤鐨勫師鍥犮��

濡傛灉鏈嶅姟鍣ㄦ敮鎸�InnoDB鎴�BDB瀛樺偍寮曟搸锛屼綘杩樺彲浠ョ湅瑙�DISABLED锛屼絾鍦ㄨ繍琛屽惎鍔ㄦ椂浣跨敤浜�--skip-innodb鎴�--skip-bdb閫夐」銆傚�逛簬NDB CLUSTER瀛樺偍寮曟搸锛�DISABLED琛ㄧず鏈嶅姟鍣ㄦ敮鎸�MySQL Cluster锛屼絾鍚�鍔ㄦ椂鏈�鍚�鐢�--ndb-cluster閫夐」銆�

鎵�鏈�MySQL鏈嶅姟鍣ㄦ敮鎸�MyISAM琛�锛屽洜涓�MyISAM鏄� 榛樿�ゅ瓨鍌ㄥ紩鎿庛��

鍦�Unix鍜�NetWare涓�鎺ㄨ崘浣跨敤mysqld_safe鏉ュ惎鍔�mysqld鏈嶅姟鍣�銆�mysqld_safe澧炲姞浜嗕竴浜涘畨鍏ㄧ壒鎬э紝渚嬪�傚綋鍑虹幇閿欒��鏃堕噸鍚�鏈嶅姟鍣ㄥ苟鍚戦敊璇�鏃ュ織鏂囦欢鍐欏叆杩愯�屾椂闂翠俊鎭�銆傛湰鑺傚悗闈㈠垪鍑轰簡NetWare鐨勭壒瀹氳�屼负銆�

娉�閲婏細涓轰簡淇濇寔鍚屾棫鐗堟湰MySQL鐨勫悜鍚庡吋瀹规�э紝MySQL浜岃繘鍒跺垎鍙戠増浠嶇劧鍖呮嫭safe_mysqld浣滀负mysqld_safe鐨勭�﹀彿閾炬帴銆備絾鏄�锛屼綘涓嶅簲鍐嶄緷璧栧畠锛屽洜涓哄啀灏嗘潵灏嗗垹鎺夊畠銆�

榛樿�ゆ儏鍐典笅锛�mysqld_safe灏濊瘯鍚�鍔ㄥ彲鎵ц��mysqld-max锛堝�傛灉瀛樺湪锛夛紝鍚﹀垯鍚�鍔�mysqld銆傝�ヨ�屼负鐨勫惈涔夋槸锛�

路         鍦�Linux涓�锛�MySQL-Max RPM渚濊禆璇�mysqld_safe鐨勮�屼负銆�RPM瀹夎�呭彲鎵ц��mysqld-max锛屼娇mysqld_safe浠庤�ョ偣璧疯嚜鍔ㄤ娇鐢ㄥ彲鎵ц�屽懡浠ゃ��

路         濡傛灉浣犲畨瑁呭寘鎷�mysqld-max鏈嶅姟鍣ㄧ殑MySQL-Max鍒嗗彂鐗堬紝鍚庨潰鍗囩骇鍒伴潪-Max鐨�MySQL鐗堟湰锛�mysqld_safe浠嶇劧璇曞浘杩愯�屾棫鐨� mysqld-max鏈嶅姟鍣�銆傚崌绾ф椂锛屼綘搴旀墜鍔ㄥ垹闄ゆ棫鐨�mysqld-max鏈嶅姟鍣�浠ョ‘淇�mysqld_safe杩愯�屾柊鐨�mysqld鏈嶅姟鍣�銆�

瑕佹兂瓒婅繃榛樿�よ�屼负骞舵樉寮忔寚瀹氫綘鎯宠�佽繍琛屽摢涓�鏈嶅姟鍣�锛屼负mysqld_safe鎸囧畾--mysqld鎴�--mysqld-version閫夐」銆�

mysqld_safe鐨勮�稿�氶�夐」涓�mysqld鐨勭浉鍚岀殑銆傚弬瑙�5.3.1鑺傦紝鈥�mysqld鍛戒护琛岄�夐」鈥�銆�

鎵�鏈夊湪鍛戒护琛屼腑涓�mysqld_safe鎸囧畾鐨勯�夐」琚�浼犻�掔粰mysqld銆�濡傛灉浣犳兂瑕佷娇鐢�mysqld涓嶆敮鎸佺殑mysqld_safe鐨�閫夐」锛屼笉瑕佸湪鍛戒护琛屼腑鎸囧畾銆傜浉鍙嶏紝鍦ㄩ�夐」鏂囦欢鐨�[mysqld_safe]缁勫唴灏嗗畠浠�鍒楀嚭鏉ャ�傚弬瑙�4.3.2鑺傦紝鈥滀娇鐢ㄩ�夐」鏂囦欢鈥�銆�

mysqld_safe浠庨�夐」鏂囦欢鐨�[mysqld]銆�[server]鍜�[mysqld_safe]閮ㄥ垎璇诲彇鎵�鏈夐�夐」銆備负浜嗕繚璇佸悜鍚庡吋瀹规�э紝瀹冭繕璇诲彇 [safe_mysqld]閮ㄥ垎锛屽敖绠″湪MySQL 5.1瀹夎�呬腑浣犲簲灏嗚繖閮ㄥ垎閲嶆柊鍛藉悕涓�[mysqld_safe]銆�

mysqld_safe鏀�鎸佷笅闈㈢殑閫夐」锛�

路         --help

鏄剧ず甯�鍔╂秷鎭�骞堕��鍑恒��

路         --autoclose

(鍙�鍦�NetWare涓�)鍦�NetWare涓�锛�mysqld_safe鍙�浠ヤ繚鎸佺獥鍙ｃ�傚綋浣犲叧鎺�mysqld_safe NLM鏃讹紝绐楀彛涓嶆寜榛樿�よ�剧疆娑堝け銆傜浉鍙嶏紝瀹冩彁绀虹敤鎴疯緭鍏ワ細

*<NLM has terminated; Press any key to close the screen>*

濡傛灉浣犳兂璁�NetWare鑷�鍔ㄥ叧闂�绐楀彛锛屽湪mysqld_safe涓�浣跨敤--autoclose閫夐」銆�

路         --basedir=path

MySQL瀹夎�呯洰褰曠殑璺�寰勩��

路         --core-file-size=size

mysqld鑳藉�熷垱寤虹殑鍐呮牳鏂囦欢鐨勫ぇ灏忋�傞�夐」鍊间紶閫掔粰ulimit -c銆�

路         --datadir=path

鏁版嵁鐩�褰曠殑璺�寰勩��

路           --defaults-extra-file=path

闄や簡閫氱敤閫夐」鏂囦欢鎵�璇诲彇鐨勯�夐」鏂囦欢鍚嶃�傚�傛灉缁欏嚭锛屽繀椤婚�栭�夎�ラ�夐」銆�

路         --defaults-file=path

璇诲彇鐨勪唬鏇块�氱敤閫夐」鏂囦欢鐨勯�夐」鏂囦欢鍚嶃�傚�傛灉缁欏嚭锛屽繀椤婚�栭�夎�ラ�夐」銆�

路         --ledir=path

鍖呭惈mysqld绋嬪簭鐨勭洰褰曠殑璺�寰勩�備娇鐢ㄨ�ラ�夐」鏉ユ樉寮忚〃绀烘湇鍔″櫒浣嶇疆銆�

路         --log-error=path

灏嗛敊璇�鏃ュ織鍐欏叆缁欏畾鐨勬枃浠躲�傚弬瑙�5.11.1鑺傦紝鈥滈敊璇�鏃ュ織鈥�銆�

路         --mysqld=prog_name

鎯宠�佸惎鍔ㄧ殑鏈嶅姟鍣ㄧ▼搴忓悕(鍦�ledir鐩�褰�)銆傚�傛灉浣犱娇鐢�MySQL浜岃繘鍒跺垎鍙戠増浣嗘湁浜岃繘鍒跺垎鍙戠増涔嬪�栫殑鏁版嵁鐩�褰曢渶瑕佽�ラ�夐」銆�

路         --mysqld-version =suffix

璇ラ�夐」绫讳技--mysqld閫夐」锛屼絾浣犲彧鎸囧畾鏈嶅姟鍣ㄧ▼搴忓悕鐨勫悗缂�銆傚熀鏈�鍚嶅亣瀹氫负mysqld銆�渚嬪�傦紝濡傛灉浣犱娇鐢�--mysqld-version =max锛�mysqld_safe鍚�鍔�ledir鐩�褰曚腑鐨�mysqld-max绋嬪簭銆傚�傛灉--mysqld-version鐨勫弬鏁颁负绌猴紝mysqld_safe浣跨敤鐩�褰曚腑鐨�mysqld銆�

路         --nice=priority

浣跨敤nice绋嬪簭鏍规嵁缁欏畾鍊兼潵璁剧疆鏈嶅姟鍣ㄧ殑璋冨害浼樺厛绾с��

路         --no-defaults

涓嶈�佽�讳换浣曢�夐」鏂囦欢銆傚�傛灉缁欏嚭锛屽繀椤婚�栭�夎�ラ�夐」銆�

路         --open-files-limit=count

mysqld鑳藉�熸墦寮�鐨勬枃浠剁殑鏁伴噺銆傞�夐」鍊间紶閫掔粰 ulimit -n銆傝�锋敞鎰忎綘闇�瑕佺敤root鍚�鍔�mysqld_safe鏉ヤ繚璇佹�ｇ‘宸ヤ綔锛�

路         --pid-file=path

杩涚▼ID鏂囦欢鐨勮矾寰勩��

路         --port=port_num

 鐢ㄦ潵甯у惉TCP/IP杩炴帴鐨勭��鍙ｅ彿銆傜��鍙ｅ彿蹇呴』涓�1024鎴栨洿澶у�硷紝闄ら潪MySQL浠�root绯荤粺鐢ㄦ埛杩愯�屻��

路         --skip-character-set-client-handshake

蹇界暐瀹㈡埛绔�鍙戦�佺殑瀛楃�﹂泦淇℃伅锛屼娇鐢ㄦ湇鍔″櫒鐨勯粯璁ゅ瓧绗﹂泦銆�(閫夋嫨璇ラ�夐」锛�MySQL鐨勫姩浣滀笌MySQL 4.0鐩稿悓锛�銆�

路         --socket=path

鐢ㄤ簬鏈�鍦拌繛鎺ョ殑Unix濂楁帴瀛楁枃浠躲��

路         --timezone=zone

涓虹粰瀹氱殑閫夐」鍊艰�剧疆TZ鏃跺尯鐜�澧冨彉閲忋�備粠鎿嶄綔绯荤粺鏂囨。鏌ラ槄鍚堟硶鐨勬椂鍖鸿�勫畾鏍煎紡銆�

路         --user={user_name | user_id}

浠ョ敤鎴峰悕user_name鎴栨暟瀛楃敤鎴�ID user_id杩愯��mysqld鏈嶅姟鍣�銆�(鏈�鏂囦腑鐨勨��鐢ㄦ埛鈥濇寚绯荤粺鐧诲綍璐︽埛锛岃�屼笉鏄� 鎺堟潈琛ㄤ腑鐨�MySQL鐢ㄦ埛锛�銆�

鎵ц��mysqld_safe鏃讹紝蹇呴』鍏堢粰鍑�--defaults-file鎴�--defaults-extra-option锛屾垨涓嶄娇鐢ㄩ�夐」鏂囦欢銆備緥濡傦紝璇ュ懡浠ゅ皢涓嶄娇鐢ㄩ�夐」鏂囦欢锛�

mysqld_safe --port=port_num --defaults-file=file_name

鐩稿弽锛屼娇鐢ㄤ笅闈㈢殑鍛戒护锛�

mysqld_safe --defaults-file=file_name --port=port_num

涓�鑸�鎯呭喌mysqld_safe鑴氭湰鍙�浠ュ惎鍔ㄤ粠婧愮爜鎴栦簩杩涘埗MySQL鍒嗗彂鐗堝畨瑁呯殑鏈嶅姟鍣�锛屽嵆浣胯繖浜涘垎鍙戠増灏嗘湇鍔″櫒瀹夎�呭埌绋嶅井涓嶅悓鐨勪綅缃�銆�(鍙傝��2.1.5鑺傦紝鈥滃畨瑁呭竷灞�鈥�锛�銆� mysqld_safe鏈熸湜涓嬮潰鐨勫叾涓�涓�涓�鏉′欢鏄�鐪熺殑锛�

路         鍙�浠ユ牴鎹�璋冪敤mysqld_safe鐨勭洰褰曟壘鍒版湇鍔″櫒鍜屾暟鎹�搴撱�傚湪浜岃繘鍒跺垎鍙戠増涓�锛�mysqld_safe鐪嬩笂鍘诲湪bin鍜�data鐩�褰曠殑宸ヤ綔鐩�褰曚笅銆傚�逛簬婧愮爜鍒嗗彂鐗堬紝涓�libexec鍜�var鐩�褰曘�傚�傛灉浣犱粠MySQL瀹夎�呯洰褰曟墽琛�mysqld_safe搴旀弧瓒宠�ユ潯浠�(渚嬪�傦紝浜岃繘鍒跺垎鍙戠増涓�/usr/local/mysql)銆�

路         濡傛灉涓嶈兘鏍规嵁宸ヤ綔鐩�褰曟壘鍒版湇鍔″櫒鍜屾暟鎹�搴擄紝mysqld_safe璇曞浘閫氳繃缁濆�硅矾寰勫�瑰畠浠�瀹氫綅銆傚吀鍨嬩綅缃�涓�/usr/local/libexec鍜�/usr/local/var銆傚疄闄呬綅缃�鐢辨瀯寤哄垎鍙戠増鏃堕厤缃�鐨勫�肩‘瀹氬�傛灉MySQL瀹夎�呭埌閰嶇疆鏃舵寚瀹氱殑浣嶇疆锛屽畠浠�搴旇�ユ槸姝ｇ‘鐨勩��

鍥犱负mysqld_safe璇曞浘閫氳繃宸ヤ綔鐩�褰曟壘鍒版湇鍔″櫒鍜屾暟鎹�搴擄紝鍙�瑕佷綘浠�MySQL瀹夎�呯洰褰曡繍琛�mysqld_safe锛�鍙�浠ュ皢MySQL浜岃繘鍒跺垎鍙戠増瀹夎�呭埌鍏跺畠浣嶇疆锛�

shell> cd mysql_installation_directory

shell> bin/mysqld_safe &

濡傛灉mysqld_safe澶辫触锛屽嵆浣夸粠MySQL瀹夎�呯洰褰曡皟鐢ㄤ粛鐒跺け璐ワ紝浣犲彲浠ユ寚瀹�--ledir鍜�--datadir閫夐」鏉ユ寚绀烘湇鍔″櫒鍜屾暟鎹�搴撳湪浣犵殑绯荤粺涓�鐨勫畨瑁呯洰褰曘��

涓�鑸�鎯呭喌锛屼綘涓嶅簲缂栬緫mysqld_safe鑴氭湰銆傜浉鍙嶏紝搴斾娇鐢ㄥ懡浠よ�岄�夐」鎴�my.cnf閫夐」鏂囦欢鐨�[mysqld_safe]閮ㄥ垎鐨勯�夐」鏉ラ厤缃�mysqld_safe銆備竴鑸�涓嶉渶瑕佺紪杈�mysqld_safe鏉ユ�ｇ‘鍚�鍔ㄦ湇鍔″櫒銆備絾鏄�锛屽�傛灉浣犵紪杈戯紝灏嗘潵鍗囩骇MySQL鍚庝細瑕嗙洊浣犱慨鏀圭殑mysqld_safe鐗堟湰锛屽洜姝や綘搴斿�逛綘淇�鏀圭殑鐗堟湰杩涜�屽�囦唤浠ヤ究灏嗘潵閲嶈�呫��

鍦�NetWare涓�锛�mysqld_safe鏄�涓�涓�NetWare Loadable Module (NLM)锛屼粠鍘�Unix shell鑴氭湰绉绘�嶃�傚畠鎵ц�岋細

1.    妫�鏌ョ郴缁熷拰閫夐」銆�

2.    妫�鏌�MyISAM琛ㄣ��

3.    淇濇寔MySQL鏈嶅姟鍣ㄧ獥鍙ｃ��

4.    鍚�鍔ㄥ苟鐩戣��mysqld锛屽�傛灉鍥犻敊璇�缁堟�㈠垯閲嶅惎銆�

5.    灏�mysqld鐨�閿欒��娑堟伅鍙戦�佸埌鏁版嵁鐩�褰曚腑鐨�host_name.err 鏂囦欢銆�

6.    灏�mysqld_safe鐨勫睆骞曡緭鍑哄彂閫佸埌鏁版嵁鐩�褰曚腑鐨�host_name.safe鏂囦欢銆�

鍦�Unix涓�鐨�MySQL鍒嗗彂鐗堝寘鎷�mysql.server鑴氭湰銆傚畠鍙�浠ョ敤浜庝娇鐢�System V-style杩愯�岀洰褰曟潵鍚�鍔ㄥ拰鍋滄�㈢郴缁熸湇鍔＄殑绯荤粺锛屼緥濡�Linux鍜�Solaris銆傚畠杩樼敤浜�MySQL鐨�Mac OS X Startup Item銆�

mysql.server浣嶄簬MySQL婧愮爜鏍�MySQL瀹夎�呯洰褰曚笅鐨�support-files鐩�褰曚腑銆�

濡傛灉浣犱娇鐢�Linux 鏈嶅姟鍣�RPM杞�浠跺寘(MySQL-server-VERSION.rpm)锛�mysql.server鑴氭湰灏嗗畨瑁呭埌/etc/init.d鐩�褰曚笅锛屽悕涓�mysql銆備綘涓嶉渶瑕� 鎵嬪姩瀹夎�呫�傚叧浜�Linux RPM杞�浠跺寘鐨勮�︾粏淇℃伅鍙傝��2.4鑺傦紝鈥滃湪Linux涓嬪畨瑁匨ySQL鈥�銆�

涓�浜涘崠鏂规彁渚涚殑RPM杞�浠跺寘瀹夎�呯殑鍚�鍔ㄨ剼鏈�鐢ㄥ叾瀹冨悕锛屼緥濡�mysqld銆�

濡傛灉浣犱粠涓嶈嚜鍔ㄥ畨瑁�mysql.server鐨勬簮鐮佸垎鍙戠増鎴栦簩杩涘埗鍒嗗彂鐗堟牸寮忓畨瑁�MySQL锛屼篃鍙�浠ユ墜鍔ㄥ畨瑁呫�傜浉鍏宠�存槑鍙傝��2.9.2.2鑺傦紝鈥滆嚜鍔ㄥ惎鍔ㄥ拰鍋滄��MySQL鈥�銆�

mysql.server浠� [mysql.server]鍜岄�夐」鏂囦欢鐨�[mysqld]閮ㄥ垎璇诲彇閫夐」銆�(涓轰簡淇濊瘉鍚戝悗鍏煎�规�э紝瀹冭繕璇诲彇 [safe_mysqld]閮ㄥ垎锛屽敖绠″湪MySQL 5.1瀹夎�呬腑浣犲簲灏嗚繖閮ㄥ垎閲嶆柊鍛藉悕涓�[mysqld_safe]锛�銆�

mysqld_multi鍙�浠ョ�＄悊澶氫釜甯у惉涓嶅悓Unix濂楁帴瀛楁枃浠跺拰TCP/IP绔�鍙ｇ殑杩炴帴鐨�mysqld 杩涚▼銆傚畠鍙�浠ュ惎鍔ㄦ垨鍋滄�㈡湇鍔″櫒锛屾垨鎶ュ憡瀹冧滑鐨勫綋鍓嶇姸鎬併��

绋嬪簭瀵绘壘my.cnf涓�鐨�[mysqldN]缁�(鎴�--config-file閫夐」鎸囧畾鐨勬枃浠�)銆�N 鍙�浠ヤ负浠讳綍姝ｆ暣鏁般�傚湪涓嬮潰鐨勮�ㄨ�轰腑璇ユ暟瀛楁寚閫夐」缁勫彿锛屾垨GNR銆傜粍鍙峰尯鍒�鍚勯�夐」缁勶紝骞剁敤浣�mysqld_multi鐨勫弬鏁版潵鎸囧畾鎯宠�佸惎鍔ㄣ�佸仠姝㈠摢涓�鏈嶅姟鍣ㄦ垨鑾峰彇鍝�涓�鏈嶅姟鍣ㄧ殑鐘舵�佹姤鍛娿�傝繖浜涚粍涓�鐨勯�夐」涓庡皢鐢ㄦ潵鍚�鍔�mysqld鐨�[mysqld]缁勪腑鐨勭浉鍚屻��(渚嬪�傦紝鍙傝��2.9.2.2鑺傦紝鈥滆嚜鍔ㄥ惎鍔ㄥ拰鍋滄��MySQL鈥�锛�銆�浣嗘槸锛屽綋浣跨敤澶氫釜鏈嶅姟鍣ㄦ椂锛岄渶瑕佹瘡涓�鏈嶅姟鍣ㄤ娇鐢ㄨ嚜宸辩殑閫夐」鍊硷紝渚嬪��Unix濂楁帴瀛楁枃浠跺拰TCP/IP绔�鍙ｅ彿銆傚叧浜庡湪澶氭湇鍔″櫒鐜�澧冧腑锛屾瘡涓�鏈嶅姟鍣ㄥ�瑰簲鍞�涓�閫夐」鐨勮�︾粏淇℃伅锛屽弬瑙�5.12鑺傦紝鈥滃湪鍚屼竴鍙版満鍣ㄤ笂杩愯�屽�氫釜MySQL鏈嶅姟鍣ㄢ��銆�

瑕佹兂璋冪敤mysqld_multi锛屼娇鐢ㄤ笅闈㈢殑璇�娉曪細

shell> mysqld_multi [options] {start|stop|report} [GNR[,GNR] ...]

start銆�stop鍜�report琛ㄧず浣犳兂瑕佹墽琛岀殑鎿嶄綔銆備綘鍙�浠ュ湪鍗曚釜鏈嶅姟鍣ㄦ垨澶氫釜鏈嶅姟鍣ㄤ笂鎵ц�屾寚瀹氱殑鎿嶄綔锛屽彇鍐充簬閫夐」鍚嶅悗闈㈢殑GNR 鍒椼�傚�傛灉娌℃湁璇ュ垪锛�mysqld_multi涓洪�夐」鏂囦欢涓�鐨勬墍鏈夋湇鍔″櫒鎵ц�岃�ユ搷浣溿��

姣忎釜GNR鍊间唬琛ㄤ竴涓�閫夐」缁勫彿鎴栫粍鍙疯寖鍥淬��GNR鍊煎簲涓洪�夐」鏂囦欢涓�缁勫悕鏈�灏剧殑鍙枫�備緥濡傦紝缁�[mysqld17]鐨�GNR涓�17銆傝�佹兂鎸囧畾缁勫彿鐨勮寖鍥达紝鐢ㄧ牬鎶樺彿闂撮殧寮�绗�1涓�鍜屾渶鍚�1涓�鍙枫��GNR鍊�10-13浠ｈ〃缁�[mysqld10]鍒�[mysqld13]銆傚彲浠ュ湪鍛戒护琛屼腑鎸囧畾澶氫釜缁勬垨缁勮寖鍥达紝鐢ㄩ�楀彿闂撮殧寮�銆�GNR鍒椾笉鑳芥湁绌烘牸瀛楃��(绌烘牸鎴�tab)锛涚┖鏍煎瓧绗﹀悗闈㈢殑鍐呭�瑰皢琚�蹇界暐鎺夈��

璇ュ懡浠や娇鐢ㄩ�夐」缁�[mysqld17]鍚�鍔ㄥ崟涓�鏈嶅姟鍣�锛�

shell> mysqld_multi start 17

璇ュ懡浠ゅ仠姝㈠�氫釜鏈嶅姟鍣�锛屼娇鐢ㄩ�夐」缁�[mysql8]鍜�[mysqld10]鑷�[mysqld13]锛�

shell> mysqld_multi stop 8,10-13

浣跨敤璇ュ懡浠ゅ垪鍑鸿�剧疆閫夐」鏂囦欢鐨勭ず渚嬶細

shell> mysqld_multi --example

mysqld_multi鏀�鎸佷笅闈㈢殑閫夐」锛�

路         --config-file=name

鎸囧畾閫夐」鏂囦欢鍚嶃�傝繖鍏崇郴鍒�mysqld_multi浠庡摢閲屽�绘壘[mysqldN]閫夐」缁勩�傛病鏈夎�ラ�夐」锛屼粠閫氱敤my.cnf鏂囦欢璇绘墍鏈夐�夐」銆傞�夐」涓嶅奖鍝� mysqld_multi浠庡摢閲岃�诲彇鑷�宸辩殑閫夐」锛屾�绘槸浠庨�氱敤my.cnf鏂囦欢鐨�[mysqld_multi]缁勮�诲彇銆�

路         --example

鏄剧ず绀轰緥閫夐」鏂囦欢銆�

路         --help

鏄剧ず甯�鍔╂秷鎭�骞堕��鍑恒��

路         --log=name

鎸囧畾鏃ュ織鏂囦欢鍚嶃�傚�傛灉璇ユ枃浠跺瓨鍦�锛屽悗闈�涓烘棩蹇楄緭鍑恒��

路         --mysqladmin=prog_name

鐢ㄦ潵鍋滄�㈡湇鍔″櫒鐨�mysqladmin浜岃繘鍒躲��

路         --mysqld=prog_name

鍙�鐢ㄧ殑mysqld浜岃繘鍒躲�傝�锋敞鎰忎綘杩樺彲浠ュ皢璇ラ�夐」鐨勫�兼寚瀹氫负mysqld_safe銆傞�夐」琚�浼犻�掔粰 mysqld銆�纭�淇濆湪PATH鐜�澧冨彉閲忚�惧畾鍊兼垨mysqld_safe涓�鏈�mysqld鎵�鍦ㄧ洰褰曘��

路         --no-log

鎸夌収鏍囧噯杈撳嚭鎵撳嵃鏃ュ織淇℃伅锛屼笉瑕佸啓鍏ユ棩蹇楁枃浠躲�傞粯璁ゆ儏鍐典笅锛岃緭鍑哄啓鍏ユ棩蹇楁枃浠躲��

路         --password=password

璋冪敤mysqladmin鏃朵娇鐢ㄧ殑MySQL璐︽埛鐨勫瘑鐮併�傝�锋敞鎰忚�ュ瘑鐮佸�间笉鏄�鍙�閫夐」锛屼笉璞″叾瀹�MySQL绋嬪簭銆�

路         --silent

绂佺敤璀﹀憡銆�

路         --tcp-ip

閫氳繃TCP/IP绔�鍙ｈ�屼笉鏄�Unix濂楁帴瀛楁枃浠舵潵杩炴帴姣忎釜MySQL鏈嶅姟鍣ㄣ��(濡傛灉鎵句笉鍒板�楁帴瀛楁枃浠讹紝 鏈嶅姟鍣ㄤ粛鐒跺彲浠ヨ繍琛岋紝浣嗗彧鑳介�氳繃 TCP/IP绔�鍙ｈ�块棶锛�銆�榛樿�ゆ儏鍐典笅锛屼娇鐢�Unix濂楁帴瀛楁枃浠惰繘琛岃繛鎺ャ�傝�ラ�夐」褰卞搷stop鍜�report鎿嶄綔銆�

路         --user=user_name

璋冪敤mysqladmin鏃朵娇鐢ㄧ殑MySQL璐︽埛鐨勭敤鎴峰悕銆�

路         --verbose

鏇磋�︾粏銆�

路         --version

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

鍏充簬mysqld_multi鐨勪竴浜涙敞瑙ｏ細

路         纭�淇濆仠姝�mysqld鏈嶅姟鍣�(鐢�mysqladmin绋嬪簭)鐨�MySQL璐︽埛鍦ㄥ悇涓�鏈嶅姟鍣ㄤ腑鐨勭敤鎴峰悕鍜屽瘑鐮佺浉鍚屻�傚苟涓斿簲纭�淇濊处鎴峰叿鏈�SHUTDOWN鏉冮檺銆傚�傛灉浣犳兂瑕佺�＄悊鐨勬湇鍔″櫒鐨勭�＄悊璐︽埛鏈夎�稿�氫笉鍚岀殑鐢ㄦ埛鍚嶆垨瀵嗙爜锛屼綘闇�瑕佸湪姣忎釜鏈嶅姟鍣ㄤ笂鍒涘缓涓�涓�璐︽埛锛屽苟鍏锋湁鐩稿悓鐨勭敤鎴峰悕鍜屽瘑鐮併�備緥濡傦紝浣犲彲浠ユ墽琛屼笅闈㈢殑鍛戒护涓烘瘡涓�鏈嶅姟鍣ㄨ�剧疆涓�涓�鏅�閫�multi_admin璐︽埛锛�

路                shell> mysql -u root -S /tmp/mysql.sock -proot_password

路                mysql> GRANT SHUTDOWN ON *.*

路                    -> TO 'multi_admin'@'localhost' IDENTIFIED BY 'multipass'锛�

鍙傝��5.7.2鑺傦紝鈥滄潈闄愮郴缁熷伐浣滃師鐞嗏��銆備綘蹇呴』涓烘瘡涓�mysqld鏈嶅姟鍣ㄦ墽琛岃�ユ搷浣�銆傚綋杩炴帴鏃堕�傚綋鏇存敼杩炴帴鍙傛暟銆傝�锋敞鎰忚处鎴峰悕鐨勪富鏈洪儴鍒嗗繀椤诲厑璁镐綘鐢�multi_admin浠庝綘鎯宠�佽繍琛�mysqld_multi鐨勪富鏈鸿繘琛岃繛鎺ャ��

路         濡傛灉浣犱娇鐢�mysqld_safe鏉ュ惎鍔�mysqld(渚嬪�傦紝--mysqld=mysqld_safe)锛�--pid-file閫夐」寰堥噸瑕併�傛瘡涓�mysqld搴旀湁鑷�宸辩殑杩涚▼ID鏂囦欢銆備娇鐢�mysqld_safe鑰屼笉浣跨敤mysqld鐨勫ソ澶勬槸mysqld_safe鈥�瀹堟姢鈥濆叾mysqld杩涚▼锛屽�傛灉鐢�kill 鈥�9鍙戦�佺殑淇″彿鎴栫敱浜庡叾瀹冨師鍥狅紙渚嬪�傚垎娈垫晠闅滐級杩涚▼缁堟��锛屽垯閲嶅惎杩涚▼銆傝�锋敞鎰�mysqld_safe鑴氭湰闇�瑕佷綘浠庢煇涓�浣嶇疆鍚�鍔ㄥ畠銆傝繖璇存槑杩愯��mysqld_multi鍓嶄綘蹇呴』杩涘叆鏌愪釜鐩�褰曘�傚�傛灉鍚�鍔ㄦ椂鏈夐棶棰橈紝璇峰弬瑙�mysqld_safe鑴氭湰銆傜壒鍒�鏄�瑕佹��鏌ヤ笅鍒楄�岋細

路                ----------------------------------------------------------------

路                MY_PWD=`pwd`

路                # Check if we are starting this relative (for the binary release)

路                if test -d $MY_PWD/data/mysql -a -f ./share/mysql/english/errmsg.sys -a \

路                -x ./bin/mysqld

路                ----------------------------------------------------------------

鍙傝��5.1.3鑺傦紝鈥渕ysqld_safe锛歁ySQL鏈嶅姟鍣ㄥ惎鍔ㄨ剼鏈�鈥�銆備笂杩拌�屾墽琛岀殑娴嬭瘯搴旀垚鍔燂紝鍚﹀垯浣犲彲鑳介亣鍒颁簡闂�棰樸��

路         姣忎釜mysqld鐨�Unix濂楁帴瀛楁枃浠跺拰TCP/IP绔�鍙ｅ彿蹇呴』涓嶅悓銆�

路         浣犲彲鑳芥兂瑕佷负mysqld浣跨敤--user閫夐」锛屼絾涓烘�や綘闇�瑕佺敤Unix root鐢ㄦ埛杩愯��mysqld_multi鑴氭湰銆傞�夐」鏂囦欢涓�鏈夐�夐」涓嶈�佺揣锛涘�傛灉浣犱笉鏄�瓒呯骇鐢ㄦ埛锛屽苟涓斾綘鐢ㄨ嚜宸辩殑Unix璐︽埛閲嶅惎mysqld杩涚▼锛屼綘鍙�浼氬緱鍒拌�﹀憡銆�

路         閲嶈��锛氱‘淇�mysqld杩涚▼鍚�鍔ㄦ墍鐢�Unix璐︽埛鍙�浠ュ畬鍏ㄨ�块棶鏁版嵁鐩�褰曘��涓嶈��浣跨敤Unix root璐︽埛锛岄櫎闈炰綘鐭ラ亾浣犲湪鍋氫粈涔堛��

路         闈炲父閲嶈��锛氫娇鐢�mysqld_multi鍓嶏紝纭�淇濈悊瑙ｄ紶閫掔粰mysqld鏈嶅姟鍣ㄧ殑閫夐」鐨勫惈涔変互鍙婁綘涓轰粈涔�鎯宠�佺嫭绔嬬殑mysqld杩涚▼銆傚簲娓呮�� 鍦ㄧ浉鍚岀殑鏁版嵁鐩�褰曚笅浣跨敤澶氫釜mysqld鏈嶅姟鍣�鐨勫嵄闄┿�備娇鐢ㄥ崟鐙�鐨勬暟鎹�鐩�褰曪紝闄ら潪浣�鐭ラ亾浣犲湪鍋氫粈涔堛�傚湪绾跨▼绯荤粺涓�锛屽湪鐩稿悓鐨勬暟鎹�鐩�褰曚笅鍚�鍔ㄥ�氫釜鏈嶅姟鍣ㄤ笉浼氬緱鍒拌秴鎬ц兘銆傚弬瑙�5.12鑺傦紝鈥滃湪鍚屼竴鍙版満鍣ㄤ笂杩愯�屽�氫釜MySQL鏈嶅姟鍣ㄢ��銆�

涓嬮潰鐨勭ず渚嬫樉绀轰簡浣犲�備綍璁剧疆閫夐」鏂囦欢鏉ヤ娇鐢�mysqld_multi銆備笓闂ㄧ渷鍘荤��1涓�鍜岀��5涓�[mysqldN]缁勬潵璇存槑浣犵殑閫夐」鏂囦欢鍙�浠ョ◢鏈変笉鍚屻�傝繖鏍风粰浣犳洿澶х殑鐏垫椿鎬с��mysqld绋嬪簭閲嶅惎鎴栧仠姝㈢殑椤哄簭鐢卞畠浠�鍦ㄩ�夐」鏂囦欢涓�鐨勯『搴忓喅瀹氥��

# This file should probably be in your home dir (~/.my.cnf)

# or /etc/my.cnf

# Version 2.1 by Jani Tolonen

[mysqld_multi]

mysqld     = /usr/local/bin/mysqld_safe

mysqladmin = /usr/local/bin/mysqladmin

user       = multi_admin

password   = multipass

[mysqld2]

socket     = /tmp/mysql.sock2

port       = 3307

pid-file   = /usr/local/mysql/var2/hostname.pid2

datadir    = /usr/local/mysql/var2

language   = /usr/local/share/mysql/english

user       = john

[mysqld3]

socket     = /tmp/mysql.sock3

port       = 3308

pid-file   = /usr/local/mysql/var3/hostname.pid3

datadir    = /usr/local/mysql/var3

language   = /usr/local/share/mysql/swedish

user       = monty

[mysqld4]

socket     = /tmp/mysql.sock4

port       = 3309

pid-file   = /usr/local/mysql/var4/hostname.pid4

datadir    = /usr/local/mysql/var4

language   = /usr/local/share/mysql/estonia

user       = tonu

[mysqld6]

socket     = /tmp/mysql.sock6

port       = 3311

pid-file   = /usr/local/mysql/var6/hostname.pid6

datadir    = /usr/local/mysql/var6

language   = /usr/local/share/mysql/japanese

user       = jani

鍙傝��4.3.2鑺傦紝鈥滀娇鐢ㄩ�夐」鏂囦欢鈥�銆�

涓�鑸�鎯呭喌锛岀敤mysql.server鑴氭湰鍚�鍔�MySQL Database Server锛�MySQL鏁版嵁搴撴湇鍔″櫒锛夛紝閫氬父椹荤暀鍦�/etc/init.d/ 鏂囦欢澶广�傞粯璁ゆ儏鍐典笅璇ヨ剼鏈�璋冪敤mysqld_safe鑴氭湰銆備絾鏄�锛屼綘鍙�浠ュ湪鑴氭湰涓�灏�use_mysqld_safe鍙橀噺璁剧疆涓�0(闆�)浠ヤ究浣跨敤MySQL瀹炰緥绠＄悊鍣ㄦ潵鍚�鍔ㄦ湇鍔″櫒銆�

鍦ㄨ繖绉嶆儏鍐典笅锛�Instance Manager鐨勮�屼负鍙栧喅浜�MySQL閰嶇疆鏂囦欢涓�鐨勯�夐」銆傚�傛灉娌℃湁閰嶇疆鏂囦欢锛�MySQL瀹炰緥绠＄悊鍣ㄥ垱寤�mysqld瀹炰緥骞惰瘯鍥剧敤榛樿��(缂栬瘧宓屽叆鐨�)閰嶇疆鏉ュ惎鍔ㄣ�傝繖璇存槑濡傛灉mysqld娌℃湁瀹夎�呭埌 榛樿�や綅缃�锛�IM涓嶈兘鐚滃嚭瀹冪殑浣嶇疆銆傚�傛灉浣犲凡缁忓湪闈炴爣鍑嗕綅缃�瀹夎�呬簡MySQL鏈嶅姟鍣�锛屼綘搴斾娇鐢ㄩ厤缃�鏂囦欢銆傚弬瑙�2.1.5鑺傦紝鈥滃畨瑁呭竷灞�鈥�銆�

濡傛灉鏈夐厤缃�鏂囦欢锛�IM灏嗗垎鏋愰厤缃�鏂囦欢鎼滅储[mysqld]閮ㄥ垎(渚嬪��[mysqld]銆�[mysqld1]銆�[mysqld2]绛�)銆傛瘡涓�閮ㄥ垎鎸囧畾涓�涓�瀹炰緥銆傚惎鍔ㄦ椂IM灏嗗惎鍔ㄦ墍鏈夋壘鍒扮殑瀹炰緥銆�IM鍏抽棴鏃堕粯璁ゅ仠姝㈡墍鏈夊疄渚嬨��

璇锋敞鎰忔湁涓�涓�鐗规畩閫夐」mysqld-path(mysqld-path = path-to-mysqld- binary)锛屽彧鑳界敤IM璇嗗埆銆備娇鐢ㄨ�ュ彉閲忚��IM鐭ラ亾mysqld浜岃繘鍒堕┗鐣欏湪鍝�鍎裤�備綘杩樺簲璇ヤ负鏈嶅姟鍣ㄨ�剧疆basedir鍜�datadir閫夐」銆�

鍚�鐢�MySQL瀹炰緥绠＄悊鍣ㄧ殑鍏稿瀷MySQL鏈嶅姟鍣ㄥ惎鍔�/鍏抽棴寰�鐜�涓猴細

路          鐢�/etc/init.d/mysql鑴氭湰鍚�鍔�MySQL瀹炰緥绠＄悊鍣ㄣ��

路          MySQL瀹炰緥绠＄悊鍣ㄥ惎鍔ㄦ墍鏈夊疄渚嬪苟鐩戣�嗗畠浠�銆�

路         濡傛灉鏌愪釜鏈嶅姟鍣ㄥ疄渚嬪け璐ワ紝MySQL瀹炰緥绠＄悊鍣ㄩ噸鍚�瀹冦��

路         濡傛灉MySQL瀹炰緥绠＄悊鍣ㄨ��鍏抽棴(渚嬪�傜敤/etc/init.d/mysql stop鍛戒护)锛屾墍鏈夊疄渚嬭��MySQL瀹炰緥绠＄悊鍣ㄥ叧闂�銆�

浣跨敤MySQL瀹㈡埛绔�-鏈嶅姟鍣ㄥ崗璁�鏉ュ�勭悊鍚�MySQL瀹炰緥绠＄悊鍣ㄤ箣闂寸殑閫氫俊銆備綘涓嶈兘浣跨敤鏍囧噯mysql瀹㈡埛绔�绋嬪簭鍜�MySQL C API鏉ヨ繛鎺�IM銆�IM鏀�鎸佸�㈡埛绔�宸ュ叿鍜�mysql-4.1鎴栦互鍚庣殑鐗堟湰鎵�鍒嗗彂鐨勫簱鎵�鐢ㄧ殑MySQL瀹㈡埛绔�-鏈嶅姟鍣ㄥ崗璁�鐗堟湰銆�

IM灏嗙敤鎴蜂俊鎭�淇濆瓨鍒板瘑鐮佹枃浠朵腑銆傚瘑鐮佹枃浠剁殑榛樿�や綅缃�涓�/etc/mysqlmanager.passwd銆�

瀵嗙爜搴旂被浼间簬锛�

petr:*35110DC9B4D8140F5DE667E28C72DD2597B5C848

瑕佹兂鐢熸垚瀵嗙爜鐢�--passwd閫夐」璋冪敤IM銆傚垯杈撳嚭鍙�浠ラ噸瀹氬悜鍒�/etc/mysqlmanager.passwd鏂囦欢浠ユ坊鍔犳柊鐢ㄦ埛銆備笅闈�涓虹ず渚嬪懡浠ゃ��

./mysqlmanager --passwd >> /etc/mysqlmanager.passwd

Creating record for new user.

Enter user name: mike

Enter password: <password>

Re-type password: <password>

涓嬮潰鐨勮�屽皢鍔犲埌/etc/mysqlmanager.passwd锛�

mike:*00A51F3F48415C7D4E8908980D443C29C69B60C9

濡傛灉/etc/mysqlmanager.passwd鏂囦欢涓�娌℃湁璇ユ潯锛屽垯涓嶈兘杩炴帴IM銆�

# MySQL Instance Manager options section

[manager]

default-mysqld-path = /usr/local/mysql/libexec/mysqld

socket=/tmp/manager.sock

pid-file=/tmp/manager.pid

password-file = /home/cps/.mysqlmanager.passwd

monitoring-interval = 2

port = 1999

bind-address = 192.168.1.5

[mysqld]

mysqld-path=/usr/local/mysql/libexec/mysqld

socket=/tmp/mysql.sock

port=3307

server_id=1

skip-stack-trace

core-file

skip-bdb

log-bin

log-error

log=mylog

log-slow-queries

[mysqld2]

nonguarded

port=3308

server_id=2

mysqld-path= /home/cps/mysql/trees/mysql-5.1/sql/mysqld

socket     = /tmp/mysql.sock5

pid-file   = /tmp/hostname.pid5

datadir= /home/cps/mysql_data/data_dir1

language=/home/cps/mysql/trees/mysql-5.1/sql/share/english

log-bin

mysql> START INSTANCE mysqld4;

Query OK, 0 rows affected (0,00 sec)

mysql> STOP INSTANCE mysqld4;

Query OK, 0 rows affected (0,00 sec)

mysql> show instances;

+---------------+---------+

| instance_name | status  |

+---------------+---------+

| mysqld3       | offline |

| mysqld4       | online  |

| mysqld2       | offline |

+---------------+---------+

3 rows in set (0,04 sec)

mysql> SHOW INSTANCE STATUS mysqld3;

+---------------+--------+---------+

| instance_name | status | version |

+---------------+--------+---------+

| mysqld3       | online | unknown |

+---------------+--------+---------+

1 row in set (0.00 sec)

mysql> SHOW INSTANCE OPTIONS mysqld3;

+---------------+---------------------------------------------------+

| option_name   | value                                             |

+---------------+---------------------------------------------------+

| instance_name | mysqld3                                           |

| mysqld-path   | /home/cps/mysql/trees/mysql-4.1/sql/mysqld        |

| port          | 3309                                              |

| socket        | /tmp/mysql.sock3                                  |

| pid-file      | hostname.pid3                                     |

| datadir       | /home/cps/mysql_data/data_dir1/                   |

| language      | /home/cps/mysql/trees/mysql-4.1/sql/share/english |

+---------------+---------------------------------------------------+

7 rows in set (0.01 sec)

mysql> SHOW mysqld LOG FILES;

+-------------+------------------------------------+----------+

| Logfile     | Path                               | Filesize |

+-------------+------------------------------------+----------+

| ERROR LOG   | /home/cps/var/mysql/owlet.err      | 9186     |

| GENERAL LOG | /home/cps/var/mysql/owlet.log      | 471503   |

| SLOW LOG    | /home/cps/var/mysql/owlet-slow.log | 4463     |

+-------------+------------------------------------+----------+

3 rows in set (0.01 sec)

mysql> SHOW mysqld LOG GENERAL 21, 2;

+---------------------+

| Log                 |

+---------------------+

| using password: YES |

+---------------------+

1 row in set (0.00 sec)

mysql> SET mysqld2.port=3322;

Query OK, 0 rows affected (0.00 sec)

mysql> UNSET mysqld2.port;

Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH INSTANCES;

Query OK, 0 rows affected (0.04 sec)

褰撳惎鍔�mysqld鏈嶅姟鍣�鏃讹紝浣犲彲浠ヤ娇鐢�4.3鑺傦紝鈥滄寚瀹氱▼搴忛�夐」鈥�涓�鎻忚堪鐨勬柟娉曟寚瀹氱▼搴忛�夐」銆傛渶甯哥敤鐨勬柟娉曟槸鍦ㄩ�夐」鏂囦欢涓�鎴栧湪鍛戒护琛屾彁渚涢�夐」銆備絾鏄�锛屽湪澶у�氭暟鎯呭喌涓嬶紝甯屾湜鏈嶅姟鍣ㄦ瘡娆¤繍琛屾椂浣跨敤鐩稿悓鐨勯�夐」銆傛渶濂界殑鏂规硶鏄�纭�淇濆皢瀹冧滑鍒楀湪閫夐」鏂囦欢涓�銆傚弬瑙�4.3.2鑺傦紝鈥滀娇鐢ㄩ�夐」鏂囦欢鈥�銆�

mysqld浠�[mysqld]鍜�[server]缁勮�诲彇閫夐」銆�mysqld_safe浠�[mysqld]銆�[server]銆�[mysqld_safe]鍜�[safe_mysqld]缁勮�诲彇閫夐」銆�mysql.server浠� [mysqld]鍜�[mysql.server]缁勮�诲彇閫夐」銆傚祵鍏ュ紡MySQL鏈嶅姟鍣ㄩ�氬父浠�[server]銆�[embedded]鍜�[xxxxx_SERVER]缁勮�诲彇閫夐」锛屽叾涓�xxxxx鏄�鏈嶅姟鍣ㄥ祵鍏ョ殑搴旂敤绋嬪簭鍚嶃��

mysqld鎺ュ彈璁稿�氬懡浠よ�岄�夐」銆傛墽琛�mysqld --help鍙�浠ョ畝鍗曞垪鍑烘潵銆傝�佹兂鐪嬪叏閮ㄥ垪琛ㄥ垪锛屼娇鐢ㄥ懡浠�mysqld --verbose --help銆�

涓嬮潰鍒楀嚭浜嗕竴浜涙渶甯哥敤鐨勬湇鍔″櫒閫夐」銆傚叾瀹冪殑閫夐」鍦ㄥ叾瀹冨湴鏂规弿杩帮細

路         褰卞搷瀹夊叏鐨勯�夐」锛氬弬瑙�5.6.3鑺傦紝鈥淢ysqld瀹夊叏鐩稿叧鍚�鍔ㄩ�夐」鈥�銆�

路         SSL-鐩稿叧閫夐」锛氬弬瑙�5.8.7.6鑺傦紝鈥淪SL鍛戒护琛岄�夐」鈥�銆�

路         浜岃繘鍒舵棩蹇楁帶鍒堕�夐」锛氬弬瑙�5.11.3鑺傦紝鈥滀簩杩涘埗鏃ュ織鈥�銆�

路         澶嶅埗鐩稿叧閫夐」锛氬弬瑙�6.8鑺傦紝鈥滃�嶅埗鍚�鍔ㄩ�夐」鈥�銆�

路         鐗瑰畾瀛樺偍寮曟搸鐩稿叧閫夐」锛氬弬瑙�15.1.1鑺傦紝鈥淢yISAM鍚�鍔ㄩ�夐」鈥�銆�15.5.3鑺傦紝鈥淏DB鍚�鍔ㄩ�夐」鈥�鍜�15.2.4鑺傦紝鈥淚nnoDB鍚�鍔ㄩ�夐」鈥�銆�

浣犺繕鍙�浠ュ皢鍙橀噺鍚嶄綔涓轰竴涓�閫夐」锛岃�剧疆鏈嶅姟鍣ㄧ郴缁熷彉閲忕殑鍊硷紝濡傛湰鑺傚悗闈㈡墍杩般��

路         --help锛�-?

鏄剧ず绠�鐭�鐨勫府鍔╂秷鎭�骞堕��鍑恒�備娇鐢�--verbose鍜�--help閫夐」鏉ョ湅鍏ㄩ儴鍐呭�广��

路         --allow-suspicious-udfs

璇ラ�夐」鎺у埗鏄�鍚︾敤鎴峰畾涔夌殑鍑芥暟鍙�鏈変竴涓�xxx绗︼紝鐢ㄤ綔鍙�杞藉叆鐨勪富鍑芥暟銆傞粯璁ゆ儏鍐典笅锛岃�ラ�夐」琚�鍏抽棴锛屽彧鏈夎嚦灏戞湁涓�涓�闄勫睘绗︾殑UDF  鍙�浠ヨ浇鍏ャ�傝繖鏍峰彲浠ラ槻姝�浠庢湭鍖呭惈鍚堟硶UDF鐨勫叡浜�鏂囦欢瑁呰浇鍑芥暟銆傚弬瑙�27.2.3.6鑺傦紝鈥滅敤鎴峰畾涔夊嚱鏁板畨鍏ㄦ敞鎰忎簨椤光��銆�

路         --ansi

浣跨敤鏍囧噯(ANSI)SQL璇�娉曚唬鏇�MySQL璇�娉曘�傚弬瑙�1.8.3鑺傦紝鈥滃湪ANSI妯″紡涓嬭繍琛孧ySQL鈥�銆備娇鐢�--sql-mode閫夐」鍙�浠ユ洿绮剧‘鎺у埗鏈嶅姟鍣�SQL妯″紡銆�

路         --basedir=path, -b path

MySQL瀹夎�呯洰褰曠殑璺�寰勩�傞�氬父鎵�鏈夎矾寰勬牴鎹�璇ヨ矾寰勬潵瑙ｆ瀽銆�

路         --bind-address=IP

寰呯粦瀹氱殑IP鍦板潃銆�

路         --bootstrap

mysql_install_db鑴氭湰浣跨敤璇ラ�夐」鏉ュ垱寤�MySQL鎺堟潈琛�锛屼笉闇�瑕佸惎鍔�MySQL鏈嶅姟鍣ㄣ��

路         --console

灏嗛敊璇�鏃ュ織娑堟伅鍐欏叆stderr鍜�stdout锛屽嵆浣挎寚瀹氫簡--log-error銆傚湪Windows涓�锛屽�傛灉浣跨敤璇ラ�夐」锛�mysqld涓嶅叧闂�鎺у埗鍙扮獥鍙ｃ��

路         --character-sets-dir=path

瀛楃�﹂泦瀹夎�呯殑鐩�褰曘�傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --chroot=path

閫氳繃chroot()绯荤粺璋冪敤鍦ㄥ惎鍔ㄨ繃绋嬩腑灏�mysqld鏈嶅姟鍣ㄦ斁鍏ヤ竴涓�灏侀棴鐜�澧冧腑銆傝繖鏄�鎺ㄨ崘鐨勪竴涓�瀹夊叏鎺�鏂姐�傝�锋敞鎰忎娇鐢ㄨ�ラ�夐」鍙�浠� 闄愬埗LOAD DATA INFILE鍜�SELECT ... INTO OUTFILE銆�

路         --character-set-server=charset

浣跨敤charset浣滀负 榛樿�ゆ湇鍔″櫒瀛楃�﹂泦銆傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --core-file

濡傛灉mysqld缁堟��锛屽啓鍐呮牳鏂囦欢銆傚湪鏌愪簺绯荤粺涓�锛屼綘杩樺繀椤讳负mysqld_safe鎸囧畾--core-file-size 閫夐」銆傚弬瑙�5.1.3鑺傦紝鈥渕ysqld_safe锛歁ySQL鏈嶅姟鍣ㄥ惎鍔ㄨ剼鏈�鈥�銆傝�锋敞鎰忓�逛簬涓�浜涚郴缁燂紝渚嬪��Solaris锛屽�傛灉浣犱娇鐢�--user閫夐」涓嶄細鑾峰緱鍐呮牳鏂囦欢銆�

路         --collation-server=collation

浣跨敤collation浣滀负 榛樿�ゆ湇鍔″櫒鏍″�硅�勫垯銆傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --datadir=path, -h path

鏁版嵁鐩�褰曠殑璺�寰勩��

路         --debug[=debug_options], -# [debug_options]

濡傛灉MySQL閰嶇疆浜�--with-debug锛屼綘鍙�浠ヤ娇鐢ㄨ�ラ�夐」鏉ヨ幏寰椾竴涓�璺熻釜鏂囦欢锛岃窡韪�mysqld姝ｈ繘琛岀殑鎿嶄綔銆�debug_options瀛楃�︿覆閫氬父涓�'d:t:o锛�file_name'銆傚弬瑙�E.1.2鑺傦紝鈥滃垱寤鸿窡韪�鏂囦欢鈥�銆�

路         (DEPRECATED) --default-character-set=charset

浣跨敤char璁剧疆浣滀负 榛樿�ゅ瓧绗﹂泦銆傜敱浜�--character-set-server锛屽弽瀵逛娇鐢ㄨ�ラ�夐」銆傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --default-collation=collation

浣跨敤collation 浣滀负榛樿�ゆ牎瀵硅�勫垯銆傜敱浜�--collation-server锛屽弽瀵逛娇鐢ㄨ�ラ�夐」銆傚弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

路         --default-storage-engine=type

璇ラ�夐」涓�--default-table-type鐨勫悓涔夎瘝銆�

路         --default-table-type=type

璁剧疆琛ㄧ殑榛樿�ょ被鍨嬨�傚弬瑙�绗�15绔狅細瀛樺偍寮曟搸鍜岃〃绫诲瀷銆�

路         --default-time-zone=type

璁剧疆榛樿�ゆ湇鍔″櫒鏃跺尯銆傝�ラ�夐」璁剧疆鍏ㄥ眬time_zone绯荤粺鍙橀噺銆傚�傛灉鏈�缁欏嚭璇ラ�夐」锛� 榛樿�ゆ椂鍖轰笌绯荤粺鏃跺尯鐩稿悓(鐢�system_time_zone绯荤粺鍙橀噺鍊肩粰瀹�)銆�

路         --delay-key-write[= OFF | ON | ALL]

濡備綍浣跨敤DELAYED KEYS閫夐」銆傞敭鍐欏叆寤惰繜浼氶�犳垚鍐嶆�″啓MyISAM琛ㄦ椂閿�缂撳啿鍖轰笉鑳借��娓呯┖銆�OFF绂佺敤寤惰繜鐨勯敭鍐欏叆銆�ON鍚�鐢ㄧ敤DELAYED KEYS閫夐」鍒涘缓鐨勮〃鐨勫欢杩熺殑閿�鍐欏叆銆�ALL寤惰繜鎵�鏈�MyISAM琛ㄧ殑閿�鍐欏叆銆傚弬瑙�7.5.2鑺傦紝鈥滆皟鑺傛湇鍔″櫒鍙傛暟鈥�銆傚弬瑙�15.1.1鑺傦紝鈥淢yISAM鍚�鍔ㄩ�夐」鈥�銆�

娉�閲婏細濡傛灉浣犲皢璇ュ彉閲忚�剧疆涓�ALL锛屼綘涓嶅簲浠庡彟涓�涓�姝ｄ娇鐢�MyISAM琛ㄧ殑绋嬪簭涓�浣跨敤MyISAM琛�(渚嬪�備粠鍙︿竴涓�MySQL鏈嶅姟鍣ㄦ垨鐢�myisamchk)銆傝繖鏍锋搷浣滀細瀵艰嚧绱㈠紩鐮村潖銆�

路         --des-key-file=file_name

浠庤�ユ枃浠惰��DES_ENCRYPT()鍜�DES_DECRYPT()浣跨敤鐨� 榛樿�ら敭銆�

路         --enable-named-pipe

鍚�鐢ㄥ懡鍚嶇�￠亾鏀�鎸併�傝�ラ�夐」鍙�閫傜敤Windows NT銆�2000銆�XP鍜�2003绯荤粺锛屽苟涓斿彧閫傜敤鏀�鎸佸懡鍚嶇�￠亾杩炴帴鐨�mysqld-nt鍜�mysqld-max-nt鏈嶅姟鍣ㄣ��

 

路         --exit-info[=flags], -T [flags]

杩欐槸涓嶅悓鏍囧織鐨勪竴涓�浣嶆帺鐮侊紝浣犲彲浠ョ敤鏉ヨ皟璇�mysqld鏈嶅姟鍣�銆備笉瑕佷娇鐢ㄨ�ラ�夐」锛岄櫎闈炰綘纭�鍒�鐭ラ亾瀹冨湪鍋氫粈涔堬紒

路         --external-locking

鍚�鐢ㄧ郴缁熼攣瀹氥�傝�锋敞鎰忓�傛灉浣犲湪lockd涓嶈兘瀹屽叏宸ヤ綔鐨勭郴缁熶笂浣跨敤璇ラ�夐」(渚嬪�傚湪Linux涓�)锛�mysqld瀹规槗姝婚攣銆傝�ラ�夐」浠ュ墠鍙�--enable-locking銆�

娉�閲婏細濡傛灉浣犲湪璁稿��MySQL杩涚▼涓�浣跨敤璇ラ�夐」鏉ユ洿鏂�MyISAM琛�锛屼綘蹇呴』纭�淇濇弧瓒充笅杩版潯浠讹細

o        浣跨敤姝ｈ��鍙︿竴涓�杩涚▼鏇存柊鐨勮〃鐨勬煡璇㈢殑缂撳瓨涓嶅彲浣跨敤銆�

o        涓嶅簲鍦ㄥ叡浜�琛ㄤ腑浣跨敤--delay-key-write=ALL鎴�DELAY_KEY_WRITE=1銆�

鏈�绠�鍗曠殑鏂规硶鏄�缁撳悎浣跨敤--external-locking鍜�--delay-key-write=OFF --query-cache-size=0銆�

(榛樿�や笉鑳藉疄鐜帮紝鍥犱负鍦ㄨ�稿�氳�剧疆涓�锛岀粨鍚堜娇鐢ㄤ笂杩伴�夐」寰堟湁鐢�锛�銆�

路         --flush

鎵ц��SQL璇�鍙ュ悗鍚戠‖鐩樹笂娓呯┖鏇存敼銆備竴鑸�鎯呭喌鎵ц��SQL璇�鍙ュ悗 MySQL鍚戠‖鐩樺啓鍏ユ墍鏈夋洿鏀癸紝璁╂搷浣滅郴缁熷�勭悊涓庣‖鐩樼殑鍚屾�ャ�傚弬瑙�A.4.2鑺傦紝鈥滃�傛灉MySQL渚濈劧宕╂簝锛屽簲浣滀簺浠�涔堚��銆�

路         --init-file=file

鍚�鍔ㄦ椂浠庤�ユ枃浠惰��SQL璇�鍙ャ�傛瘡涓�璇�鍙ュ繀椤诲湪鍚屼竴琛屼腑骞朵笖涓嶅簲鍖呮嫭娉ㄩ噴銆�

路         --language=lang_name, -L lang_name

鐢ㄧ粰瀹氳��瑷�缁欏嚭瀹㈡埛绔�閿欒��娑堟伅銆�lang_name鍙�浠ヤ负璇�瑷�鍚嶆垨璇�瑷�鏂囦欢瀹夎�呯洰褰曠殑鍏ㄨ矾寰勫悕銆傚弬瑙�5.10.2鑺傦紝鈥滆�剧疆閿欒��娑堟伅璇�瑷�鈥�銆�

路         --large-pages

涓�浜涚‖浠�/鎿嶄綔绯荤粺鏋舵瀯鏀�鎸佸ぇ浜� 榛樿�ゅ��(閫氬父4 KB)鐨勫唴瀛橀〉銆傚疄闄呮敮鎸佸彇鍐充簬浣跨敤鐨勭‖浠跺拰OS銆傚ぇ閲忚�块棶鍐呭瓨鐨勫簲鐢ㄧ▼搴忛�氳繃浣跨敤杈冨ぇ鐨勯〉锛岄檷浣庝簡Translation Lookaside Buffer (TLB)鎹熷け锛屽彲浠ユ敼鍠勬�ц兘銆�

鐩�鍓嶏紝MySQL鍙�鍦�Linux涓�鏀�鎸佸ぇ椤甸潰(鍦�Linux涓�琚�绉颁綔HugeTLB)銆傛垜浠�宸茬粡璁″垝灏嗚�ユ敮鎸佹墿灞曞埌FreeBSD銆�Solaris鍜屽叾瀹冨彲鑳界殑骞冲彴銆�

鍦�Linux涓�鍙�浠ヤ娇鐢ㄥぇ椤甸潰鍓嶏紝闇�瑕侀厤缃�HugeTLB鍐呭瓨姹犮�傚弬鑰�Linux鍐呮牳婧愮爜涓�鐨�hugetlbpage.txt鏂囦欢銆�

榛樿�ゆ儏鍐典笅璇ラ�夐」琚�绂佺敤銆�

路         ---log[=file], -l [file]

鏃ュ織杩炴帴鍜屽�规枃浠剁殑鏌ヨ��銆傚弬瑙�5.11.2鑺傦紝鈥滈�氱敤鏌ヨ�㈡棩蹇椻��銆傚�傛灉浣犱笉鎸囧畾鏂囦欢鍚嶏紝MySQL浣跨敤host_name.log浣滀负鏂囦欢鍚嶃��

路         --log-bin=[file]

浜岃繘鍒舵棩蹇楁枃浠躲�傚皢鏇存敼鏁版嵁鐨勬墍鏈夋煡璇㈣�板叆璇ユ枃浠躲�傜敤浜庡�囦唤鍜屽�嶅埗銆傚弬瑙�5.11.3鑺傦紝鈥滀簩杩涘埗鏃ュ織鈥�銆傚缓璁�鎸囧畾涓�涓�鏂囦欢鍚�(鍘熷洜鍙傝��A.8.1鑺傦紝鈥淢ySQL涓�鐨勬墦寮�浜嬪疁鈥�)锛屽惁鍒�MySQL浣跨敤host_name-bin浣滀负鏃ュ織鏂囦欢鍩烘湰鍚嶃��

路         --log-bin-index[=file]

浜岃繘鍒舵棩蹇楁枃浠跺悕鐨勭储寮曟枃浠躲�傚弬瑙�5.11.3鑺傦紝鈥滀簩杩涘埗鏃ュ織鈥�銆傚�傛灉浣犱笉鎸囧畾鏂囦欢鍚嶏紝骞朵笖濡傛灉浣犳病鏈夊湪--log-bin涓�鎸囧畾锛�MySQL浣跨敤host_name-bin.index浣滀负鏂囦欢鍚嶃��

路         --log-bin-trust-routine-creators[={0|1}]

娌℃湁鍙傛暟鎴栧弬鏁颁负1,璇ラ�夐」灏嗙郴缁熷彉閲�log_bin_trust_routine_creators璁剧疆涓�1銆備负鍙傛暟 0鏃讹紝璇ラ�夐」灏嗙郴缁熷彉閲忚�剧疆涓�0銆�log_bin_trust_routine_creators褰卞搷MySQL濡備綍瀵逛繚瀛樼殑绋嬪簭鐨勫垱寤哄己鍔犻檺鍒躲�傚弬瑙�20.4鑺傦紝鈥滃瓨鍌ㄥ瓙绋嬪簭鍜岃Е鍙戠▼搴忕殑浜岃繘鍒舵棩蹇楀姛鑳解��銆�

路         --log-error[=file]

璇ユ枃浠剁殑鏃ュ織閿欒��鍜屽惎鍔ㄦ秷鎭�銆傚弬瑙�5.11.1鑺傦紝鈥滈敊璇�鏃ュ織鈥�銆傚�傛灉浣犱笉鎸囧畾鏂囦欢鍚嶏紝MySQL浣跨敤host_name.err浣滀负鏂囦欢鍚嶃�傚�傛灉鏂囦欢鍚嶆病鏈夋墿灞曞悕锛屽垯鍔犱笂.err鎵╁睍鍚嶃��

路         --log-isam[=file]

灏嗘墍鏈�MyISAM鏇存敼璁板叆璇ユ枃浠�(鍙�鏈夎皟璇�MyISAM鏃舵墠浣跨敤)銆�

路         (DEPRECATED) --log-long-format

璁板綍婵�娲荤殑鏇存柊鏃ュ織銆佷簩杩涘埗鏇存柊鏃ュ織銆佸拰鎱㈡煡璇㈡棩蹇楃殑澶ч噺淇℃伅銆備緥濡傦紝鎵�鏈夋煡璇㈢殑鐢ㄦ埛鍚嶅拰鏃堕棿鎴冲皢璁板綍涓嬫潵銆備笉璧炴垚閫夌敤璇ラ�夐」锛屽洜涓哄畠鐜板湪浠ｈ〃 榛樿�よ�板綍琛屼负銆�(鍙傝��--log-short-format鎻忚堪锛�銆�--log-queries-not-using-indexes閫夐」閫傚悎灏嗘湭浣跨敤绱㈠紩鐨勬煡璇㈣�板綍鍒版參鏌ヨ�㈡棩蹇椾腑銆�

路         --log-queries-not-using-indexes

濡傛灉浣犵粨鍚�--log-slow-queries浣跨敤璇ラ�夐」锛屾湭浣跨敤绱㈠紩鐨勬煡璇�涔熻��璁板綍鍒版參鏌ヨ�㈡棩蹇椾腑銆傚弬瑙�5.11.4鑺傦紝鈥滄參閫熸煡璇㈡棩蹇椻��銆�

路         --log-short-format

璁板綍婵�娲荤殑鏇存柊鏃ュ織銆佷簩杩涘埗鏇存柊鏃ュ織銆佸拰鎱㈡煡璇㈡棩蹇楃殑灏戦噺淇℃伅銆備緥濡傦紝鐢ㄦ埛鍚嶅拰鏃堕棿鎴充笉璁板綍涓嬫潵銆�

路         ---log-slow-admin-statements

灏嗘參绠＄悊璇�鍙ヤ緥濡�OPTIMIZE TABLE銆�ANALYZE TABLE鍜�ALTER TABLE璁板叆鎱㈡煡璇㈡棩蹇椼��

路         --log-slow-queries[=file]

灏嗘墍鏈夋墽琛屾椂闂磋秴杩�long_query_time 绉掔殑鏌ヨ�㈣�板叆璇ユ枃浠躲�傚弬瑙�5.11.4鑺傦紝鈥滄參閫熸煡璇㈡棩蹇椻��銆傝�︾粏淇℃伅鍙傝��--log-long-format鍜�--log-short-format閫夐」鎻忚堪銆�

 

路         --log-warnings, -W

灏嗚�﹀憡渚嬪��Aborted connection...鎵撳嵃鍒伴敊璇�鏃ュ織銆傚缓璁�鍚�鐢ㄨ�ラ�夐」锛屼緥濡傦紝濡傛灉浣犱娇鐢ㄥ�嶅埗 (浣犲彲浠ュ緱鍒板叧浜庢墍鍙戠敓浜嬫儏鐨勮�︾粏淇℃伅锛屼緥濡傚叧浜庣綉缁滄晠闅滃拰閲嶆柊杩炴帴鐨勬秷鎭�)銆傞粯璁ゆ儏鍐典笅鍚�鐢ㄨ�ラ�夐」锛涜�佹兂绂佺敤瀹冿紝浣跨敤--skip-log-warnings銆備腑鏂�鐨勮繛鎺ヤ笉浼氳�板叆閿欒��鏃ュ織锛岄櫎闈炲�煎ぇ浜�1銆傚弬瑙�A.2.10鑺傦紝鈥滈�氫俊閿欒��鍜屽け鏁堣繛鎺モ��銆�

路         --low-priority-updates

琛ㄤ慨鏀�(INSERT, REPLACE, DELETE, UPDATE)姣旈�夋嫨鐨勪紭鍏堢骇瑕佷綆銆備篃鍙�浠ラ�氳繃{INSERT | REPLACE | DELETE | UPDATE} LOW_PRIORITY ... 鏉ラ檷浣庢煇涓�鏌ヨ�㈢殑浼樺厛绾ф潵瀹炵幇锛屾垨閫氳繃SET LOW_PRIORITY_UPDATES=1鏉ユ洿鏀逛竴涓�绾跨▼鐨勪紭鍏堢骇銆傚弬瑙�7.3.2鑺傦紝鈥滆〃閿佸畾浜嬪疁鈥�銆�

路          --memlock

灏�mysqld 杩涚▼閿佸畾鍦ㄥ唴瀛樹腑銆傚湪鏀�鎸�mlockall()绯荤粺璋冪敤鐨勭郴缁熶笂鏈夋晥锛屼緥濡�Solaris銆傚�傛灉鎿嶄綔绯荤粺浣�mysqld鍦ㄧ‖鐩樹笂浜ゆ崲鏃跺嚭鐜伴棶棰橈紝鍙�浠ヤ负浣犳彁渚涘府鍔┿�傝�锋敞鎰忎娇鐢ㄨ�ラ�夐」鏃堕渶瑕佷互root杩愯�屾湇鍔″櫒锛屼絾浠庡畨鍏ㄨ�冭檻骞朵笉鏄�涓�涓�濂芥敞鎰忋��

路         --myisam-recover [=option[,option...]]]

灏嗗瓨鍌ㄥ紩鎿�MyISAM璁剧疆涓烘仮澶嶆ā寮忋�傝�ラ�夐」鍊兼槸DEFAULT銆�BACKUP銆�FORCE鎴�QUICK鍊肩殑浠讳綍缁勫悎銆傚�傛灉浣犳寚瀹氬�氫釜鍊硷紝鐢ㄩ�楀彿闂撮殧寮�銆備綘杩樺彲浠ヤ娇鐢�""鍊兼潵绂佺敤璇ラ�夐」銆備娇鐢ㄥ�傛灉璇ラ�夐」锛屽綋mysqld鎵撳紑MyISAM琛ㄦ椂锛屾��鏌ユ槸鍚﹁〃鏍囪�颁负宕╂簝鎴栨病鏈夋�ｇ‘鍏抽棴銆�(鍙�鏈夌敤--skip-external-lockingare杩愯�屾椂锛屾渶鍚庣殑閫夐」鎵嶅伐浣滐級銆� 濡傛灉鏄�杩欑�嶆儏鍐碉紝mysqld鍒欐��鏌� 琛ㄣ�傚�傛灉琛ㄨ��鐮村潖锛�mysqld璇曞浘缁存姢瀹冦��

涓嬮潰鐨勯�夐」褰卞搷缁存姢宸ヤ綔锛�

閫夐」	鎻忚堪
DEFAULT	涓庢病鏈変娇鐢�--myisam-recover閫夐」鐩稿悓銆�
BACKUP	濡傛灉鍦ㄦ仮澶嶈繃绋嬩腑锛屾暟鎹�鏂囦欢琚�鏇存敼浜嗭紝灏�tbl_name.MYD鏂囦欢澶囦唤涓�tbl_name-datetime.BAK銆�
FORCE	鍗充娇.MYD鏂囦欢灏嗕涪鎺夊�氫釜琛屼篃杩涜�屾仮澶嶃��
QUICK	濡傛灉娌℃湁鍒犻櫎鍧楋紝涓嶈�佹��鏌ヨ〃涓�鐨勮�屻��

鍦ㄨ〃鑷�鍔ㄤ慨澶嶅墠锛�MySQL閿欒��鏃ュ織娣诲姞涓�鏉℃敞瑙ｃ�傚�傛灉浣犱笉鎯崇敤鎴峰共娑夊共娑夊ぇ澶氭暟闂�棰橈紝浣犲簲浣跨敤BACKUP,FORCE閫夐」銆傝�ラ�夐」寮哄埗缁存姢琛�锛屽嵆浣夸竴浜涜�屽皢浼氳��鍒犻櫎涔熶笉渚嬪�栵紝浣嗗畠淇濇寔鏃х殑鏁版嵁鏂囦欢鍋氫负澶囦唤锛屼互渚夸綘鍙�浠ュ湪鍚庢潵杩涜�屾��鏌ャ��

路         --ndb-connectstring=connect_string

褰撲娇鐢�NDB瀛樺偍寮曟搸鏃讹紝鍙�浠ユ寚鍑洪�氳繃璁剧疆杩炴帴瀛楃�︿覆閫夐」鏉ュ垎鍙戠兢闆嗛厤缃�鐨勭�＄悊鏈嶅姟鍣ㄣ�傜浉鍏宠��娉曞弬瑙�17.4.4.2鑺傦紝鈥淢ySQL绨囪繛鎺ュ瓧绗︿覆鈥�銆�

路         --ndbcluster

濡傛灉浜岃繘鍒舵敮鎸�NDB CLUSTER瀛樺偍寮曟搸锛屼娇鐢ㄨ�ラ�夐」鍙�浠ヤ唬鏇跨�佺敤MySQL Cluster鏀�鎸佺殑 榛樿�よ�剧疆銆傚弬瑙�绗�17绔狅細MySQL绨�銆�

路         --old-passwords

寮哄埗鏈嶅姟鍣ㄤ负鏂板瘑鐮佺敓鎴愮煭(4.1鍓�)瀵嗙爜鍝堝笇銆傚�傛灉鏈嶅姟鍣ㄥ繀椤绘敮鎸佹棫瀹㈡埛绔�绋嬪簭锛屼负淇濊瘉鍏煎�规�ц繖寰堟湁鐢ㄣ�傚弬瑙�5.7.9鑺傦紝鈥淢ySQL 4.1涓�鐨勫瘑鐮佸搱甯屽�勭悊鈥�銆�

路         --one-thread

鍙�浣跨敤涓�涓�绾跨▼(鐢ㄤ簬鍦�Linux涓�璋冭瘯)銆傚彧鏈夋湇鍔″櫒鍚�鐢ㄤ簡璋冭瘯锛岃�ラ�夐」鎵嶅彲鐢ㄣ�傚弬瑙�E.1鑺傦紝鈥滆皟璇昅ySQL鏈嶅姟鍣ㄢ��銆�

路         --open-files-limit=count

鐢ㄦ潵鏇存敼mysqld鏂囦欢鎻忚堪绗︾殑鏁伴噺銆傚�傛灉娌℃湁璁剧疆鎴栬�剧疆涓�0锛屽垯mysqld閫氳繃setrlimit()浣跨敤璇ュ�兼潵淇濆瓨鏂囦欢鎻忚堪绗︺�傚�傛灉璇ュ�间负0锛屽垯mysqld 淇濆瓨max_connections*5鎴�max_connections + table_cache*2(鍙栬緝澶ц��)涓�鏂囦欢銆傚�傛灉mysqld缁欏嚭浣犻敊璇�"鎵撳紑鐨勬枃浠跺お澶氥��"锛屼綘搴旇瘯璇曞�炲姞璇ュ�笺��

路         --pid-file=path

mysqld_safe浣跨敤鐨勮繘绋�ID鏂囦欢鐨勮矾寰勩��

路         --port=port_num, -P port_num

甯у惉TCP/IP杩炴帴鏃朵娇鐢ㄧ殑绔�鍙ｅ彿銆�

路         --safe-mode

璺宠繃涓�浜涗紭鍖栭樁娈点��

路         (DEPRECATED) --safe-show-database

鍙傝��5.7.3鑺傦紝鈥淢ySQL鎻愪緵鐨勬潈闄愨��銆�

路         --safe-user-create

鍚�鐢ㄥ悗濡傛灉鐢ㄦ埛娌℃湁mysql.user琛ㄦ垨琛ㄤ腑鍒楃殑INSERT鏉冮檺锛屽垯鐢ㄦ埛涓嶈兘鐢�GRANT璇�鍙ュ垱寤烘柊鐢ㄦ埛銆�

路         --secure-auth

涓嶅厑璁镐娇鐢ㄦ棫(4.1涔嬪墠)瀵嗙爜鐨勮处鎴疯繘琛岄壌瀹氥��

路         --shared-memory

鍚�鐢ㄦ湰鍦板�㈡埛绔�鐨勫叡浜�鍐呭瓨杩炴帴銆傝�ラ�夐」鍙�鐢ㄤ簬Windows銆�

路         --shared-memory-base-name=name

鍏变韩鍐呭瓨杩炴帴鍚嶃�傝�ラ�夐」鍙�鐢ㄤ簬Windows銆�

路         --skip-bdb

绂佺敤BDB瀛樺偍寮曟搸銆傝繖鏍峰彲浠ヨ妭鐪佸唴瀛橈紝骞跺彲鑳藉姞閫熸煇浜涙搷浣溿�傚�傛灉浣犻渶瑕�BDB琛ㄥ垯涓嶈�佷娇鐢ㄨ�ラ�夐」銆�

路         --skip-concurrent-insert

鍏抽棴鍦ㄥ悓涓�鏃堕棿鍦�MyISAM琛ㄤ腑閫夋嫨鍜屾彃鍏ョ殑鑳藉姏銆�(鍙�鏈変綘鍙戠幇缂洪櫡鏃舵墠浣跨敤璇ラ�夐」锛�銆�

路         --skip-external-locking

涓嶈�佷娇鐢ㄧ郴缁熼攣瀹氥�傝�佹兂浣跨敤myisamchk锛屼綘蹇呴』鍏抽棴鏈嶅姟鍣ㄣ��(鍙傝��1.4.3鑺傦紝鈥淢ySQL绋冲畾鎬р��锛�銆� 瑕侀伩鍏嶈�ラ渶姹傦紝浣跨敤MySQL Monitor涓�鐨�CHECK TABLE鍜�REPAIR TABLE鏉ユ��鏌ュ苟缁存姢MyISAM琛ㄣ��

路         --skip-grant-tables

璇ラ�夐」浣挎湇鍔″櫒涓嶄娇鐢ㄦ潈闄愮郴缁熴�傝�ユ潈闄愬厑璁歌�块棶鏈嶅姟鍣ㄧ殑鐢ㄦ埛涓嶅彈闄愬埗鍦拌�块棶鎵�鏈�鏁版嵁搴�銆備綘鍙�浠ヤ粠绯荤粺澶栧３鍛戒护琛屾墽琛�mysqladmin flush-privileges鎴�mysqladmin reload鍛戒护锛屾垨鎵ц��MySQL FLUSH PRIVILEGES璇�鍙ヨ�╄繍琛岀殑鏈嶅姟鍣ㄩ噸鏂板紑濮嬩娇鐢� 鎺堟潈琛ㄣ��

路         --skip-host-cache

涓轰簡鏇村揩鍦板湪鍚嶇О-IP涔嬮棿杩涜�岃В鏋愶紝涓嶈�佷娇鐢ㄥ唴閮ㄤ富鏈哄悕缂撳瓨銆傜浉鍙嶏紝姣忔�″�㈡埛绔�杩炴帴鏃舵煡璇�DNS鏈嶅姟鍣ㄣ�傚弬瑙�7.5.6鑺傦紝鈥淢ySQL濡備綍浣跨敤DNS鈥�銆�

路         --skip-innodb

绂佺敤InnoDB瀛樺偍寮曟搸銆傝繖鏍峰彲浠ヨ妭鐪佸唴瀛橈紝骞跺彲鑳藉姞閫熸煇浜涙搷浣溿�傚�傛灉浣犻渶瑕�BDB琛ㄥ垯涓嶈�佷娇鐢ㄨ�ラ�夐」銆�

路         --skip-name-resolve

涓嶈�佽В鏋愭�ｆ��鏌ュ�㈡埛绔�杩炴帴鐨勪富鏈哄悕銆傚彧浣跨敤IP鍙枫�傚�傛灉浣犱娇鐢ㄨ�ラ」锛� 鎺堟潈琛ㄤ腑鐨勬墍鏈�Host鍒楀�煎繀椤讳负IP鍙锋垨localhost銆傚弬瑙�7.5.6鑺傦紝鈥淢ySQL濡備綍浣跨敤DNS鈥�銆�

路         --skip-ndbcluster

绂佺敤NDB CLUSTER瀛樺偍寮曟搸銆傝繖鏄�鏀�鎸�NDB CLUSTER瀛樺偍寮曟搸鐨勪簩杩涘埗鐨勯粯璁よ�剧疆锛岃�存槑鍙�鏈夌敤--ndbcluster閫夐」鏄惧紡瑕嗙洊--skip-ndbcluster閫夐」鏃讹紝绯荤粺鎵嶄负璇ュ瓨鍌ㄥ紩鎿庡垎閰嶅唴瀛樺拰鍏跺畠璧勬簮銆備娇鐢ㄧず渚嬪弬瑙�17.4.3鑺傦紝鈥淢ySQL绨囩殑蹇�閫熸祴璇曡�剧疆鈥�銆�

路         --skip-networking

涓嶅抚鍚�TCP/IP杩炴帴銆傚繀椤婚�氳繃鍛藉悕绠￠亾鎴栧叡浜�鍐呭瓨(鍦�Windows涓�)鎴�Unix濂楁帴瀛楁枃浠�(鍦�Unix涓�)瀹屾垚mysqld鐨勭浉浜掓搷浣溿�傚�逛簬鍙�鍏佽�告湰鍦板�㈡埛绔�鐨勭郴缁燂紝澶у姏鎺ㄨ崘璇ラ�夐」銆傚弬瑙�7.5.6鑺傦紝鈥淢ySQL濡備綍浣跨敤DNS鈥�銆�

路         --standalone

鍙�閫傚悎鍩轰簬Windows-NT鐨勭郴缁燂紱鎸囧��MySQL鏈嶅姟鍣ㄤ笉鍋氫负鏈嶅姟鏉ヨ繍琛屻��

路         --symbolic-links, --skip-symbolic-links

鍚�鐢ㄦ垨绂佺敤绗﹀彿閾炬帴鏀�鎸併�傚湪Windows鍜�Unix涓�锛岃�ラ�夐」鐨勪綔鐢ㄦ槸涓嶅悓鐨勶細

o        鍦�Windows涓�锛屽惎鐢ㄧ�﹀彿閾炬帴锛屼綘鍙�浠ラ�氳繃鍒涘缓鍖呭惈瀹為檯鐩�褰曡矾寰勭殑directory.sym鏂囦欢鏉ュ缓绔嬫暟鎹�搴撶洰褰曠殑绗﹀彿閾炬帴銆傚弬瑙�7.6.1.3鑺傦紝鈥滃湪Windows骞冲彴涓婁娇鐢ㄥ叧浜庢暟鎹�搴撶殑绗﹀彿閾炬帴鈥�銆�

鍦�Unix涓�锛屽惎鐢ㄧ�﹀彿閾炬帴琛ㄧず浣犲彲浠ョ敤CREATE TABLE璇�鍙ョ殑INDEX DIRECTORY鎴�DATA DIRECTORY閫夐」灏�MyISAM绱㈠紩鏂囦欢鎴栨暟鎹�鏂囦欢閾炬帴鍒板彟涓�涓�鐩�褰曘�傚�傛灉浣犲垹闄ゆ垨閲嶆柊鍛藉悕琛�锛岀�﹀彿閾炬帴鎵�鎸囩殑鏂囦欢涔熻��鍒犻櫎鎴栭噸鏂板懡鍚嶃�傚弬瑙�13.1.5鑺傦紝鈥淐REATE TABLE璇�娉曗��銆�

路         --skip-safemalloc

濡傛灉MySQL閰嶇疆浜�--with-debug=full锛屾墍鏈�MySQL绋嬪簭鍦ㄥ唴瀛樺垎閰嶅拰閲婃斁鏃舵��鏌ュ唴瀛樻槸鍚︽孩鍑恒�傛��鏌ュ緢鎱�锛屽洜姝ゅ�傛灉浣犱笉闇�瑕佷綘鍙�浠ョ敤--skip-safemalloc閫夐」鏉ラ伩鍏嶃��

路         --skip-show-database

浣跨敤璇ラ�夐」锛屽彧鍏佽�稿叿鏈�SHOW DATABASES鏉冮檺鐨勭敤鎴锋墽琛�SHOW DATABASES璇�鍙ワ紝璇ヨ��鍙ユ樉绀烘墍鏈夋暟鎹�搴撳悕銆備笉浣跨敤璇ラ�夐」锛屽厑璁告墍鏈夌敤鎴锋墽琛�SHOW DATABASES锛屼絾鍙�鍚戝叿鏈�SHOW DATABASES鏉冮檺鎴栭儴鍒嗘暟鎹�搴撴潈闄愮殑鐢ㄦ埛鏄剧ず姣忎釜鏁版嵁搴撳悕銆傝�锋敞鎰忓叏灞�鏉冮檺涓烘暟鎹�搴撶殑涓�绉嶆潈闄愩��

路         --skip-stack-trace

涓嶈窡韪�鍐欏爢鏍堛�傚綋璋冭瘯杩愯��mysqld鏃惰�ラ�夐」鏈夌敤銆傚湪涓�浜涚郴缁熶腑锛屼綘杩樺繀椤讳娇鐢ㄨ�ラ�夐」鏉ヨ幏寰楀唴鏍告枃浠躲�傚弬瑙�E.1鑺傦紝鈥滆皟璇昅ySQL鏈嶅姟鍣ㄢ��銆�

路         --skip-thread-priority

鍦ㄥ揩閫熷搷搴斾腑绂佺敤绾跨▼浼樺厛绾с��

路         --socket=path

鍦�Unix涓�锛岃�ラ�夐」鎸囧畾鐢ㄤ簬鏈�鍦拌繛鎺ョ殑Unix濂楁帴瀛楁枃浠躲�� 榛樿�ゅ�兼槸/tmp/mysql.sock銆傚湪Windows涓�锛岃�ラ�夐」鎸囧畾鏈�鍦拌繛鎺ユ墍浣跨敤鐨勭�￠亾鍚嶃�� 榛樿�ゅ�兼槸MySQL銆�

路         --sql-mode=value[,value[,value...]]

灏�MySQL璁剧疆涓�SQL妯″紡銆傚弬瑙�5.3.2鑺傦紝鈥淪QL鏈嶅姟鍣ㄦā寮忊��銆�

路         --temp-pool

璇ラ�夐」浣挎湇鍔″櫒鍒涘缓鐨勫ぇ澶氭暟涓存椂鏂囦欢浣跨敤涓�绯诲垪鏂囦欢鍚嶏紝鑰屼笉鏄�姣忎釜鏂版枃浠朵娇鐢ㄥ敮涓�鐨勬枃浠跺悕銆傝繖鏍疯В鍐充簡鍦�Linux鍐呮牳涓�鐢� 涓嶅悓鐨勫悕鍒涘缓璁稿�氭柊鏂囦欢鐨勯棶棰樸�傚湪浠ュ墠锛�Linux浼间箮鈥滄硠婕忊�濆唴瀛橈紝鍥犱负瀹冭��鐩存帴鍒嗛厤鍒�directory entry缂撳瓨鑰屼笉鏄�纭�鐩樼紦瀛樸��

路         --transaction-isolation=level

璁剧疆榛樿�や簨鍔￠殧绂荤骇鍒�锛屽彲浠�READ-UNCOMMITTED銆�READ-COMMITTEE銆�REPEATABLE-READ鎴�SERIALIZABLE銆傚弬瑙�13.4.6鑺傦紝鈥淪ET TRANSACTION璇�娉曗��銆�

路         --tmpdir=path, -t path

鍒涘缓涓存椂鏂囦欢鐨勭洰褰曡矾寰勩�傞粯璁�/tmp鐩�褰曞湪澶�灏忎笉鑳藉�圭撼涓存椂琛ㄧ殑鍒嗗尯鏃惰�ラ�夐」寰堟湁鐢ㄣ�傝�ラ�夐」鎺ュ彈round-robin妯″紡鐨勫嚑涓�璺�寰勩�傚湪Unix涓�璺�寰勫簲鐢ㄥ啋鍙�(鈥�:鈥�) 闂撮殧寮�锛屽湪Windows銆�NetWare鍜�OS/2涓�鐢ㄥ垎鍙�(鈥�锛�鈥�) 闂撮殧寮�銆傚�傛灉MySQL鏈嶅姟鍣ㄤ负澶嶅埗浠庢満锛屼綘涓嶅簲璁�--tmpdir鎸囧悜鍩轰簬鍐呭瓨鐨勬枃浠剁郴缁熶腑鐨勭洰褰曟垨鏈嶅姟鍣ㄤ富鏈洪噸鍚�鏃朵細娓呴櫎鐨勭洰褰曘�傚�嶅埗浠庢満闇�瑕佷复鏃舵枃浠讹紝鏈哄櫒閲嶅惎鏃跺彲浠ュ�嶅埗涓存椂琛ㄦ垨鎵ц��LOAD DATA INFILE鎿嶄綔銆傚�傛灉鏈嶅姟鍣ㄩ噸鍚�鏃朵复鏃舵枃浠剁洰褰曚腑鐨勬枃浠朵涪澶憋紝澶嶅埗澶辫触銆�

路         --user={user_name | user_id}, -u {user_name | user_id}

鐢�user_name鎴栨暟瀛楃敤鎴�ID user_id杩愯��mysqld鏈嶅姟鍣�銆�(鈥�鐢ㄦ埛鈥濇寚绯荤粺鐧诲綍璐︽埛锛岃�屼笉鏄� 鎺堟潈琛ㄤ腑鎵�鍒楃殑MySQL鐢ㄦ埛锛�銆�

鐢�root鍚�鍔�mysqld鏃�寮哄埗浣跨敤璇ラ�夐」銆傛湇鍔″櫒鍦ㄥ惎鍔ㄥ簭鍒椾腑鏇存敼鐢ㄦ埛ID锛岃�╁畠鍋氫负鍏蜂綋鐢ㄦ埛鑰屼笉鏄�root杩愯�屻�傚弬瑙�5.6.1鑺傦紝鈥滈�氱敤瀹夊叏鎸囧崡鈥�銆�

瑕侀伩鍏嶇敤鎴峰湪my.cnf鏂囦欢涓�娣诲姞--user=root閫夐」(浣挎湇鍔″櫒鐢�root杩愯��)鏃跺彲鑳藉嚭鐜扮殑瀹夊叏婕忔礊锛�mysqld鍙�浣跨敤鎸囧畾鐨勭��1涓�--user閫夐」锛屽�傛灉鏈夊�氫釜--user閫夐」鍒欎細鍑虹幇璀﹀憡銆傚湪鍛戒护琛岄�夐」鍓嶅�勭悊/etc/my.cnf鍜�$MYSQL_HOME/my.cnf涓�鐨勯�夐」锛屽洜姝ゅ缓璁�浣犲湪/etc/my.cnf涓�鏀句竴涓�--user閫夐」锛屽苟鎸囧畾root涔嬪�栫殑鍏跺畠鍊笺�傚湪鍏跺畠--user閫夐」鍓嶅厛鎵惧埌/etc/my.cnf涓�鐨勯�夐」锛岀‘淇濇湇鍔″櫒鐢ㄥ叾瀹冪敤鎴疯繍琛岋紝濡傛灉鎵惧埌鍏跺畠--user閫夐」鍒欎細鍑虹幇璀﹀憡銆�

路         --version, -V

鏄剧ず鐗堟湰淇℃伅骞堕��鍑恒��

浣犲彲浠ヤ娇鐢�--var_name=value褰㈠紡鐨勯�夐」涓烘湇鍔″櫒绯荤粺鍙橀噺銆備緥濡傦紝--key_buffer_size=32M灏嗗彉閲�key_buffer_size璁句负32MB銆�

璇锋敞鎰忚�剧疆鍙橀噺鏃讹紝MySQL鍙�浠ヨ嚜鍔ㄥ皢瀹冪籂姝ｅ埌鏌愪釜缁欏畾鑼冨洿鍐咃紝鎴栧�傛灉鍙�鍏佽�告煇涓�鍊硷紝鍒欏皢璁剧疆鍊艰皟鑺傚埌鏈�鎺ヨ繎鍏佽�哥殑鍊笺��

杩樺彲浠ラ�氳繃--set-variable=var_name=value鎴�-O var_name=value璇�娉曟潵璁剧疆鍙橀噺銆備絾鏄�锛岀幇鍦ㄤ笉璧炴垚浣跨敤璇ヨ��娉曘��

5.3.3鑺傦紝鈥滄湇鍔″櫒绯荤粺鍙橀噺鈥�瀹屽叏鎻忚堪浜嗗叏閮ㄧ郴缁熷彉閲忋�傝皟鑺傛湇鍔″櫒鍙傛暟閮ㄥ垎鍖呮嫭濡備綍瀵逛粬浠�杩涜�屼紭鍖栥�傚弬瑙�7.5.2鑺傦紝鈥滆皟鑺傛湇鍔″櫒鍙傛暟鈥�銆�

浣犲彲浠ョ敤SET璇�鍙ユ洿鏀瑰ぇ澶氭暟鏈嶅姟鍣ㄧ郴缁熷彉閲忕殑鍊笺�傚弬瑙�13.5.3鑺傦紝鈥淪ET璇�娉曗��銆�

濡傛灉浣犳兂鐢�SET 闄愬埗鍚�鍔ㄩ」鍙�璁剧殑鏈�澶у�硷紝浣犲彲浠ヤ娇鐢�--maximum-var_name鍛戒护琛岄�夐」鏉ュ畾涔夈��

MySQL鏈嶅姟鍣ㄥ彲浠ヤ互涓嶅悓鐨�SQL妯″紡鏉ユ搷浣滐紝骞朵笖鍙�浠ヤ负涓嶅悓瀹㈡埛绔�搴旂敤涓嶅悓妯″紡銆傝繖鏍锋瘡涓�搴旂敤绋嬪簭鍙�浠ユ牴鎹�鑷�宸辩殑闇�姹傛潵瀹氬埗鏈嶅姟鍣ㄧ殑鎿嶄綔妯″紡銆�

妯″紡瀹氫箟MySQL搴旀敮鎸佸摢浜�SQL璇�娉曪紝浠ュ強搴旀墽琛屽摢绉嶆暟鎹�楠岃瘉妫�鏌ャ�傝繖鏍峰彲浠ユ洿瀹规槗鍦板湪涓嶅悓鐨勭幆澧冧腑浣跨敤MySQL锛屽苟缁撳悎鍏跺畠鏁版嵁搴撴湇鍔″櫒浣跨敤MySQL銆�

浣犲彲浠ョ敤--sql-mode="modes"閫夐」鍚�鍔�mysqld鏉�璁剧疆榛樿��SQL妯″紡銆傚�傛灉浣犳兂瑕侀噸璁撅紝璇ュ�艰繕鍙�浠ヤ负绌�(--sql-mode ="")銆�

浣犺繕鍙�浠ュ湪鍚�鍔ㄥ悗鐢�SET [SESSION|GLOBAL] sql_mode='modes'璇�鍙ヨ�剧疆sql_mode鍙橀噺鏉ユ洿鏀�SQL妯″紡銆傝�剧疆 GLOBAL鍙橀噺鏃堕渶瑕佹嫢鏈�SUPER鏉冮檺锛屽苟涓斾細褰卞搷浠庨偅鏃惰捣杩炴帴鐨勬墍鏈夊�㈡埛绔�鐨勬搷浣溿�傝�剧疆SESSION鍙橀噺鍙�褰卞搷褰撳墠鐨勫�㈡埛绔�銆備换浣曞�㈡埛绔�鍙�浠ラ殢鏃舵洿鏀硅嚜宸辩殑浼氳瘽 sql_mode鍊笺��

Modesis鏄�鐢ㄩ�楀彿(鈥�锛�鈥�)闂撮殧寮�鐨勪竴绯诲垪涓嶅悓鐨勬ā寮忋�備綘鍙�浠ョ敤SELECT @@sql_mode璇�鍙ユ煡璇㈠綋鍓嶇殑妯″紡銆傞粯璁ゅ�兼槸绌�(娌℃湁璁剧疆浠讳綍妯″紡)銆�

涓昏�侀噸瑕�sql_mode鍊间负锛�

路         ANSI

鏇存敼璇�娉曞拰琛屼负锛屼娇鍏舵洿绗﹀悎鏍囧噯SQL銆�

路         STRICT_TRANS_TABLES

濡傛灉涓嶈兘灏嗙粰瀹氱殑鍊兼彃鍏ュ埌浜嬪姟琛ㄤ腑锛屽垯鏀惧純璇ヨ��鍙ャ�傚�逛簬闈炰簨鍔¤〃锛屽�傛灉鍊煎嚭鐜板湪鍗曡�岃��鍙ユ垨澶氳�岃��鍙ョ殑绗�1琛岋紝鍒欐斁寮冭�ヨ��鍙ャ�傛湰鑺傚悗闈㈢粰鍑轰簡鏇磋�︾粏鐨勬弿杩般��

路         TRADITIONAL

Make MySQL鐨勮�屼负璞♀��浼犵粺鈥�SQL鏁版嵁搴撶郴缁熴�傝�ユā寮忕殑绠�鍗曟弿杩版槸褰撳湪鍒椾腑鎻掑叆涓嶆�ｇ‘鐨勫�兼椂鈥滅粰鍑�閿欒��鑰屼笉鏄�璀﹀憡鈥濄��娉�閲婏細涓�鏃﹀彂鐜伴敊璇�绔嬪嵆鏀惧純INSERT/UPDATE銆傚�傛灉浣犱娇鐢ㄩ潪浜嬪姟瀛樺偍寮曟搸锛岃繖绉嶆柟寮忎笉鏄�浣犳兂瑕佺殑锛屽洜涓哄嚭鐜伴敊璇�鍓嶈繘琛岀殑鏁版嵁鏇存敼涓嶄細鈥滄粴鍔ㄢ�濓紝缁撴灉鏄�鏇存柊鈥滃彧杩涜�屼簡涓�閮ㄥ垎鈥濄��

鏈�鎵嬪唽鎸団��涓ユ牸妯″紡鈥濓紝琛ㄧず鑷冲皯STRICT _TRANS_TABLES鎴�STRICT _ALL_TABLES琚�鍚�鐢ㄧ殑妯″紡銆�

涓嬮潰鎻忚堪浜嗘敮鎸佺殑鎵�鏈夋ā寮忥細

路         ALLOW_INVALID_DATES

鍦ㄤ弗鏍兼ā寮忎笅涓嶈�佹��鏌ュ叏閮ㄦ棩鏈熴�傚彧妫�鏌�1鍒�12涔嬮棿鐨勬湀浠藉拰1鍒�31涔嬮棿鐨勬棩銆傝繖鍦�Web搴旂敤绋嬪簭涓�锛屽綋浣犱粠涓変釜涓嶅悓鐨勫瓧娈佃幏鍙栧勾銆佹湀銆佹棩锛屽苟涓旀兂瑕佺‘鍒囦繚瀛樼敤鎴锋彃鍏ョ殑鍐呭��(涓嶈繘琛屾棩鏈熼獙璇�)鏃跺緢閲嶈�併�傝�ユā寮忛�傜敤浜�DATE鍜�DATETIME鍒椼�備笉閫傚悎TIMESTAMP鍒楋紝TIMESTAMP鍒楅渶瑕侀獙璇佹棩鏈熴��

鍚�鐢ㄤ弗鏍兼ā寮忓悗锛屾湇鍔″櫒闇�瑕佸悎娉曠殑鏈堝拰鏃ワ紝涓嶄粎浠呮槸鍒嗗埆鍦�1鍒�12鍜�1鍒�31鑼冨洿鍐呫�備緥濡傦紝绂佺敤涓ユ牸妯″紡鏃�'2004-04-31'鏄�鍚堟硶鐨勶紝浣嗗惎鐢ㄤ弗鏍兼ā寮忓悗鏄�闈炴硶鐨勩�傝�佹兂鍦ㄤ弗鏍兼ā寮忓厑璁搁伄鎺╁浐瀹氭棩鏈燂紝杩樺簲鍚�鐢�ALLOW_INVALID_DATES銆�

路         ANSI_QUOTES

灏嗏��"鈥欒�嗕负璇嗗埆绗﹀紩鍙�(鈥�`鈥欏紩鍙峰瓧绗�)锛屼笉瑕佽�嗕负瀛楃�︿覆鐨勫紩鍙峰瓧绗︺�傚湪ANSI妯″紡锛屼綘鍙�浠ヤ粛鐒朵娇鐢ㄢ��`鈥欐潵寮曠敤璇嗗埆绗︺�傚惎鐢�ANSI_QUOTES鍚庯紝浣犱笉鑳界敤鍙屽紩鍙锋潵寮曠敤瀛楃�︿覆锛屽洜涓哄畠琚�瑙ｉ噴涓鸿瘑鍒�绗︺��

路         ERROR_FOR_DIVISION_BY_ZERO

鍦ㄤ弗鏍兼ā寮忥紝鍦�INSERT鎴�UPDATE杩囩▼涓�锛屽�傛灉琚�闆堕櫎(鎴�MOD(X锛�0))锛屽垯浜х敓閿欒��(鍚﹀垯涓鸿�﹀憡)銆傚�傛灉鏈�缁欏嚭璇ユā寮忥紝琚�闆堕櫎鏃�MySQL杩斿洖NULL銆傚�傛灉鐢ㄥ埌INSERT IGNORE鎴�UPDATE IGNORE涓�锛�MySQL鐢熸垚琚�闆堕櫎璀﹀憡锛屼絾鎿嶄綔缁撴灉涓�NULL銆�

路         HIGH_NOT_PRECEDENCE

NOT鎿嶄綔绗︾殑浼樺厛椤哄簭鏄�琛ㄨ揪寮忎緥濡�NOT a BETWEEN b AND c琚�瑙ｉ噴涓�NOT (a BETWEEN b AND c)銆傚湪涓�浜涙棫鐗堟湰MySQL涓�锛� 琛ㄨ揪寮忚��瑙ｉ噴涓�(NOT a) BETWEEN b AND c銆傚惎鐢�HIGH_NOT_PRECEDENCESQL妯″紡锛屽彲浠ヨ幏寰椾互鍓嶇殑鏇撮珮浼樺厛绾х殑缁撴灉銆�

mysql> SET sql_mode = '';

mysql> SELECT NOT 1 BETWEEN -5 AND 5;

        -> 0

mysql> SET sql_mode = 'broken_not';

mysql> SELECT NOT 1 BETWEEN -5 AND 5;

        -> 1

路         IGNORE_SPACE

鍏佽�稿嚱鏁板悕鍜屸��(鈥欎箣闂存湁绌烘牸銆傚己鍒跺皢鎵�鏈夊嚱鏁板悕瑙嗕负淇濆瓨鐨勫瓧銆傜粨鏋滄槸锛屽�傛灉浣犳兂瑕佽�块棶淇濆瓨涓哄瓧鐨勬暟鎹�搴撱�佽〃鎴栧垪鍚嶏紝浣犲繀椤诲紩鐢ㄥ畠銆備緥濡傦紝鍥犱负鏈�USER()鍑芥暟锛�mysql鏁版嵁搴撲腑鐨�user琛ㄥ悕鍜岃�ヨ〃鍐呯殑User鍒楄��淇濆瓨涓嬫潵锛屽洜姝や綘蹇呴』寮曠敤瀹冧滑锛�

SELECT "User" FROM mysql."user";

路         NO_AUTO_CREATE_USER

闃叉��GRANT鑷�鍔ㄥ垱寤烘柊鐢ㄦ埛锛岄櫎闈炶繕鎸囧畾浜嗗瘑鐮併��

路         NO_AUTO_VALUE_ON_ZERO

NO_AUTO_VALUE_ON_ZERO褰卞搷AUTO_INCREMENT鍒楃殑澶勭悊銆備竴鑸�鎯呭喌锛屼綘鍙�浠ュ悜璇ュ垪鎻掑叆NULL鎴�0鐢熸垚涓嬩竴涓�搴忓垪鍙枫��NO_AUTO_VALUE_ON_ZERO绂佺敤0锛屽洜姝ゅ彧鏈�NULL鍙�浠ョ敓鎴愪笅涓�涓�搴忓垪鍙枫��

濡傛灉灏�0淇濆瓨鍒拌〃鐨�AUTO_INCREMENT鍒楋紝璇ユā寮忎細寰堟湁鐢ㄣ��(涓嶆帹鑽愰噰鐢ㄨ�ユ儻渚�)銆備緥濡傦紝濡傛灉浣犵敤mysqldump杞�鍌ㄨ〃骞堕噸杞斤紝MySQL閬囧埌0鍊间竴鑸�浼氱敓鎴愭柊鐨勫簭鍒楀彿锛岀敓鎴愮殑琛ㄧ殑鍐呭�逛笌杞�鍌ㄧ殑琛ㄤ笉鍚屻�傞噸杞借浆鍌ㄦ枃浠跺墠鍚�鐢�NO_AUTO_VALUE_ON_ZERO鍙�浠ヨВ鍐宠�ラ棶棰樸��mysqldump鍦ㄨ緭鍑轰腑鑷�鍔ㄥ寘鎷�鍚�鐢�NO_AUTO_VALUE_ON_ZERO鐨勮��鍙ャ��

路         NO_BACKSLASH_ESCAPES

绂佺敤鍙嶆枩绾垮瓧绗�(鈥�\鈥�)鍋氫负瀛楃�︿覆鍐呯殑閫�鍑哄瓧绗︺�傚惎鐢ㄨ�ユā寮忥紝鍙嶆枩绾垮垯鎴愪负鏅�閫氬瓧绗︺��

路         NO_DIR_IN_CREATE

鍒涘缓琛ㄦ椂锛屽拷瑙嗘墍鏈�INDEX DIRECTORY鍜�DATA DIRECTORY鎸囦护銆傝�ラ�夐」瀵逛粠澶嶅埗鏈嶅姟鍣ㄦ湁鐢ㄣ��

路         NO_ENGINE_SUBSTITUTION

濡傛灉闇�瑕佺殑瀛樺偍寮曟搸琚�绂佺敤鎴栨湭缂栬瘧锛屽彲浠ラ槻姝㈣嚜鍔ㄦ浛鎹㈠瓨鍌ㄥ紩鎿庛��

路         NO_FIELD_OPTIONS

涓嶈�佸湪SHOW CREATE TABLE鐨勮緭鍑轰腑鎵撳嵃MySQL涓撶敤鍒楅�夐」銆傝�ユā寮忓湪鍙�绉绘�嶆ā寮忥紙portability mode锛変笅鐢ㄤ簬mysqldump銆�

路         NO_KEY_OPTIONS

涓嶈�佸湪SHOW CREATE TABLE鐨勮緭鍑轰腑鎵撳嵃MySQL涓撶敤绱㈠紩閫夐」銆傝�ユā寮忓湪鍙�绉绘�嶆ā寮忥紙portability mode锛変笅鐢ㄤ簬mysqldump銆�

路         NO_TABLE_OPTIONS

涓嶈�佸湪SHOW CREATE TABLE鐨勮緭鍑轰腑鎵撳嵃MySQL涓撶敤琛ㄩ�夐」锛堜緥濡�ENGINE锛夈�傝�ユā寮忓湪鍙�绉绘�嶆ā寮忥紙portability mode锛変笅鐢ㄤ簬mysqldump銆�

路         NO_UNSIGNED_SUBTRACTION

鍦ㄥ噺杩愮畻涓�锛屽�傛灉鏌愪釜鎿嶄綔鏁版病鏈夌�﹀彿锛屼笉瑕佸皢缁撴灉鏍囪�颁负UNSIGNED銆傝�锋敞鎰忚繖鏍蜂娇UNSIGNED BIGINT涓嶈兘100%鐢ㄤ簬涓婁笅鏂囦腑銆傚弬瑙�12.8鑺傦紝鈥淐ast鍑芥暟鍜屾搷浣滅�︹��銆�

 

路         NO_ZERO_DATE

鍦ㄤ弗鏍兼ā寮忥紝涓嶈�佸皢 '0000-00-00'鍋氫负鍚堟硶鏃ユ湡銆備綘浠嶇劧鍙�浠ョ敤IGNORE閫夐」鎻掑叆闆舵棩鏈熴�傚湪闈炰弗鏍兼ā寮忥紝鍙�浠ユ帴鍙楄�ユ棩鏈燂紝浣嗕細鐢熸垚璀﹀憡銆�

路         NO_ZERO_IN_DATE

鍦ㄤ弗鏍兼ā寮忥紝涓嶆帴鍙楁湀鎴栨棩閮ㄥ垎涓�0鐨勬棩鏈熴�傚�傛灉浣跨敤IGNORE閫夐」锛屾垜浠�涓虹被浼肩殑鏃ユ湡鎻掑叆'0000-00-00'銆傚湪闈炰弗鏍兼ā寮忥紝鍙�浠ユ帴鍙楄�ユ棩鏈燂紝浣嗕細鐢熸垚璀﹀憡銆�

路         ONLY_FULL_GROUP_BY

涓嶈�佽��GROUP BY閮ㄥ垎涓�鐨勬煡璇㈡寚鍚戞湭閫夋嫨鐨勫垪銆�

路         PIPES_AS_CONCAT

灏�||瑙嗕负瀛楃�︿覆杩炴帴鎿嶄綔绗︼紙锛嬶級(鍚�CONCAT())锛岃�屼笉瑙嗕负OR銆�

路         REAL_AS_FLOAT

灏�REAL瑙嗕负FLOAT鐨勫悓涔夎瘝锛岃�屼笉鏄�DOUBLE鐨勫悓涔夎瘝銆�

路         STRICT_TRANS_TABLES

涓烘墍鏈夊瓨鍌ㄥ紩鎿庡惎鐢ㄤ弗鏍兼ā寮忋�傞潪娉曟暟鎹�鍊艰��鎷掔粷銆傚悗闈㈡湁璇︾粏璇存槑銆�

路         STRICT_TRANS_TABLES

涓轰簨鍔″瓨鍌ㄥ紩鎿庡惎鐢ㄤ弗鏍兼ā寮忥紝涔熷彲鑳戒负闈炰簨鍔″瓨鍌ㄥ紩鎿庡惎鐢ㄤ弗鏍兼ā寮忋�傚悗闈㈡湁璇︾粏璇存槑銆�

涓ユ牸妯″紡鎺у埗MySQL濡備綍澶勭悊闈炴硶鎴栦涪澶辩殑杈撳叆鍊笺�傛湁鍑犵�嶅師鍥犲彲浠ヤ娇涓�涓�鍊间负闈炴硶銆備緥濡傦紝鏁版嵁绫诲瀷閿欒��锛屼笉閫傚悎鍒楋紝鎴栬秴鍑鸿寖鍥淬�傚綋鏂版彃鍏ョ殑琛屼笉鍖呭惈鏌愬垪鐨勬病鏈夋樉绀哄畾涔�DEFAULT瀛愬彞鐨勫�硷紝鍒欒�ュ�艰��涓㈠け銆�

瀵逛簬浜嬪姟琛�锛屽綋鍚�鐢�STRICT_ALL_TABLES鎴�STRICT_TRANS_TABLES妯″紡鏃讹紝濡傛灉璇�鍙ヤ腑鏈夐潪娉曟垨涓㈠け鍊硷紝鍒欎細鍑虹幇閿欒��銆傝��鍙ヨ��鏀惧純骞舵粴鍔ㄣ��

瀵逛簬闈炰簨鍔¤〃锛屽�傛灉鎻掑叆鎴栨洿鏂扮殑绗�1琛屽嚭鐜板潖鍊硷紝涓ょ�嶆ā寮忕殑琛屼负鐩稿悓銆傝��鍙ヨ��鏀惧純锛岃〃淇濇寔涓嶅彉銆傚�傛灉璇�鍙ユ彃鍏ユ垨淇�鏀瑰�氳�岋紝骞朵笖鍧忓�煎嚭鐜板湪绗�2鎴栧悗闈㈢殑琛岋紝缁撴灉鍙栧喅浜庡惎鐢ㄤ簡鍝�涓�涓ユ牸閫夐」锛�

路         瀵逛簬STRICT_ALL_TABLES锛�MySQL杩斿洖閿欒��骞跺拷瑙嗗墿浣欑殑琛屻�備絾鏄�锛屽湪杩欑�嶆儏鍐典笅锛屽墠闈㈢殑琛屽凡缁忚��鎻掑叆鎴栨洿鏂般�傝繖璇存槑浣犲彲浠ラ儴鍒嗘洿鏂帮紝杩欏彲鑳戒笉鏄�浣犳兂瑕佺殑銆傝�侀伩鍏嶈繖鐐癸紝鏈�濂戒娇鐢ㄥ崟琛岃��鍙ワ紝鍥犱负杩欐牱鍙�浠ヤ笉鏇存敼琛ㄥ嵆鍙�浠ユ斁寮冦��

路         瀵逛簬STRICT_TRANS_TABLES锛�MySQL灏嗛潪娉曞�艰浆鎹�涓烘渶鎺ヨ繎璇ュ垪鐨勫悎娉曞�煎苟鎻掑叆璋冩暣鍚庣殑鍊笺�傚�傛灉鍊间涪澶憋紝MySQL鍦ㄥ垪涓�鎻掑叆闅愬紡 榛樿�ゅ�笺�傚湪浠讳綍鎯呭喌涓嬶紝MySQL閮戒細鐢熸垚璀﹀憡鑰屼笉鏄�缁欏嚭閿欒��骞剁户缁�鎵ц�岃��鍙ャ��13.1.5鑺傦紝鈥淐REATE TABLE璇�娉曗��鎻忚堪浜嗛殣寮忛粯璁ゅ�笺��

涓ユ牸妯″紡涓嶅厑璁搁潪娉曟棩鏈燂紝渚嬪��'2004-04-31'銆傚畠涓嶅厑璁哥�佹�㈡棩鏈熶娇鐢ㄢ�滈浂鈥濋儴鍒嗭紝渚嬪��'2004-04-00'鎴栤��闆�鈥濇棩鏈熴�傝�佹兂绂佹��锛屽簲鍦ㄤ弗鏍兼ā寮忓熀纭�涓婏紝鍚�鐢�NO_ZERO_IN_DATE鍜�NO_ZERO_DATE SQL妯″紡銆�

濡傛灉浣犱笉浣跨敤涓ユ牸妯″紡(鍗充笉鍚�鐢�STRICT_TRANS_TABLES鎴�STRICT_ALL_TABLES妯″紡)锛屽�逛簬闈炴硶鎴栦涪澶辩殑鍊硷紝MySQL灏嗘彃鍏ヨ皟鏁村悗鐨勫�煎苟缁欏嚭璀﹀憡銆傚湪涓ユ牸妯″紡锛屼綘鍙�浠ラ�氳繃INSERT IGNORE鎴�UPDATE IGNORE鏉ュ疄鐜般�傚弬瑙�13.5.4.22鑺傦紝鈥淪HOW WARNINGS璇�娉曗��銆�

涓嬮潰鐨勭壒娈婃ā寮忓揩閫熺粍鍚堜簡鍓嶉潰鎵�鍒楃殑妯″紡銆�

鍏朵腑鍖呮嫭澶у�氭暟鏈�鏂扮増鏈�MySQL涓�鐨勬墍鏈夋ā寮忓�笺�傛棫鐗堟湰涓�锛岀粍鍚堟ā寮忎笉鍖呮嫭鏂扮増鏈�涓�娌℃湁鐨勪笉閫傜敤鐨勫叿浣撴ā寮忓�笺��

路         ANSI

绛夊悓REAL_AS_FLOAT銆�PIPES_AS_CONCAT銆�ANSI_QUOTES銆�IGNORE_SPACE銆傚弬瑙�1.8.3鑺傦紝鈥滃湪ANSI妯″紡涓嬭繍琛孧ySQL鈥�銆�

路         DB2

绛夊悓PIPES_AS_CONCAT銆�ANSI_QUOTES銆�IGNORE_SPACE銆�NO_KEY_OPTIONS銆�NO_TABLE_OPTIONS銆�NO_FIELD_OPTIONS銆�

路         MAXDB

绛夊悓PIPES_AS_CONCAT銆�ANSI_QUOTES銆�IGNORE_SPACE銆�NO_KEY_OPTIONS銆�NO_TABLE_OPTIONS銆�NO_FIELD_OPTIONS銆� NO_AUTO_CREATE_USER銆�

路         MSSQL

绛夊悓PIPES_AS_CONCAT銆�ANSI_QUOTES銆�IGNORE_SPACE銆�NO_KEY_OPTIONS銆�NO_TABLE_OPTIONS銆� NO_FIELD_OPTIONS銆�

路         MYSQL323

绛夊悓NO_FIELD_OPTIONS銆�HIGH_NOT_PRECEDENCE銆�

路         MYSQL40

绛夊悓NO_FIELD_OPTIONS銆�HIGH_NOT_PRECEDENCE銆�

路         ORACLE

绛夊悓PIPES_AS_CONCAT銆�ANSI_QUOTES銆�IGNORE_SPACE銆�NO_KEY_OPTIONS銆�NO_TABLE_OPTIONS銆�NO_FIELD_OPTIONS銆�NO_AUTO_CREATE_USER銆�

路         POSTGRESQL

绛夊悓PIPES_AS_CONCAT銆�ANSI_QUOTES銆�IGNORE_SPACE銆�NO_KEY_OPTIONS銆�NO_TABLE_OPTIONS銆�NO_FIELD_OPTIONS銆�

路         TRADITIONAL

绛夊悓STRICT_TRANS_TABLES銆丼TRICT_ALL_TABLES銆丯O_ZERO_IN_DATE銆丯O_ZERO_DATE銆丒RROR_FOR_DIVISION_BY_ZERO銆丯O_AUTO_CREATE_USER銆�

鏈嶅姟鍣ㄥ皢缁存姢璁稿�氳〃绀哄叾閰嶇疆鐨勭郴缁熷彉閲忋�傛墍鏈夊彉閲忓潎鏈夐粯璁ゅ�笺�傚彲浠ュ湪鍛戒护琛屼腑鎴栭�夐」鏂囦欢璁剧疆閫夐」鍦ㄦ湇鍔″櫒鍚�鍔ㄦ椂瀵瑰畠浠�杩涜�岃�剧疆銆傚ぇ澶氭暟鍙�浠ュ湪杩愯�屾椂浣跨敤SET璇�鍙ユ潵璁剧疆銆�

mysqld鏈嶅姟鍣�缁存姢涓ょ�嶅彉閲忋�傚叏灞�鍙橀噺褰卞搷鏈嶅姟鍣ㄧ殑鍏ㄥ眬鎿嶄綔銆備細璇濆彉閲忓奖鍝嶅叿浣撳�㈡埛绔�杩炴帴鐩稿叧鎿嶄綔銆�

鏈嶅姟鍣ㄥ惎鍔ㄦ椂锛屽皢鎵�鏈夊叏灞�鍙橀噺鍒濆�嬪寲涓洪粯璁ゅ�笺�傚彲浠ュ湪閫夐」鏂囦欢鎴栧懡浠よ�屼腑鎸囧畾鐨勯�夐」鏉ユ洿鏀硅繖浜涢粯璁ゅ�笺�傛湇鍔″櫒鍚�鍔ㄥ悗锛岄�氳繃杩炴帴鏈嶅姟鍣ㄥ苟鎵ц��SET GLOBAL var_name璇�鍙ュ彲浠ユ洿鏀瑰姩鎬佸叏灞�鍙橀噺銆傝�佹兂鏇存敼鍏ㄥ眬鍙橀噺锛屽繀椤诲叿鏈�SUPER鏉冮檺銆�

鏈嶅姟鍣ㄨ繕涓烘瘡涓�瀹㈡埛绔�杩炴帴缁存姢浼氳瘽鍙橀噺銆傝繛鎺ユ椂浣跨敤鐩稿簲鍏ㄥ眬鍙橀噺鐨勫綋鍓嶅�煎�瑰�㈡埛绔�浼氳瘽鍙橀噺杩涜�屽垵濮嬪寲銆傚�㈡埛鍙�浠ラ�氳繃SET SESSION var_name璇�鍙ユ潵鏇存敼鍔ㄦ�佷細璇濆彉閲忋�傝�剧疆浼氳瘽鍙橀噺涓嶉渶瑕佺壒娈婃潈闄愶紝浣嗗�㈡埛鍙�浠ュ彧鏇存敼鑷�宸辩殑浼氳瘽鍙橀噺锛岃�屼笉鏇存敼鍏跺畠瀹㈡埛鐨勪細璇濆彉閲忋��

浠讳綍璁块棶鍏ㄥ眬鍙橀噺鐨勫�㈡埛绔�閮藉彲浠ョ湅瑙佸�瑰叏灞�鍙橀噺鐨勬洿鏀广�備絾鏄�锛屽畠鍙�褰卞搷鍦ㄦ洿鏀瑰悗杩炴帴鐨勪粠璇ュ叏灞�鍙橀噺鍒濆�嬪寲鐩稿簲浼氳瘽鍙橀噺鐨勫�㈡埛绔�銆傚畠涓嶄細褰卞搷宸茬粡杩炴帴涓婄殑瀹㈡埛绔�鐨勪細璇濆彉閲�(鐢氳嚦鏄�鎵ц��SET GLOBAL璇�鍙ョ殑瀹㈡埛绔�)銆�

褰撲娇鐢ㄥ惎鍔ㄩ�夐」璁剧疆鍙橀噺鏃讹紝鍙橀噺鍊煎彲浠ヤ娇鐢ㄥ悗缂�K銆�M鎴�G鍒嗗埆琛ㄧず鍗冨瓧鑺傘�佸厗瀛楄妭鎴�gigabytes銆備緥濡傦紝涓嬮潰鐨勫懡浠ゅ惎鍔ㄦ湇鍔″櫒鏃剁殑閿�鍊肩紦鍐插尯澶у皬涓�16 megabytes锛�

mysqld --key_buffer_size=16M

鍚庣紑鐨勫ぇ灏忓啓缇庡叧绯伙紱16M鍜�16m鏄�鍚屾牱鐨勩��

杩愯�屾椂锛屼娇鐢�SET璇�鍙ユ潵璁剧疆绯荤粺鍙橀噺銆傛�ゆ椂锛屼笉鑳戒娇鐢ㄥ悗缂�锛屼絾鍊煎彲浠ラ噰鍙栦笅鍒楄〃杈惧紡锛�

mysql> SET sort_buffer_size = 10 * 1024 * 1024;

瑕佹兂鏄惧紡鎸囧畾鏄�鍚﹁�剧疆鍏ㄥ眬鎴栦細璇濆彉閲忥紝浣跨敤GLOBAL鎴�SESSION閫夐」锛�

mysql> SET GLOBAL sort_buffer_size = 10 * 1024 * 1024;

mysql> SET SESSION sort_buffer_size = 10 * 1024 * 1024;

涓や釜閫夐」鍧囨病鏈夛紝鍒欒��鍙ヨ�剧疆浼氳瘽鍙橀噺銆�

5.3.3.1鑺傦紝鈥滃姩鎬佺郴缁熷彉閲忊��涓�鍒楀嚭浜嗗彲浠ュ湪杩愯�屾椂璁剧疆鐨勫彉閲忋��

濡傛灉浣犳兂鐢�SET璇�鍙ラ檺鍒剁郴缁熷彉閲忓彲璁剧殑鏈�澶у�硷紝鍙�浠ュ湪鏈嶅姟鍣ㄥ惎鍔ㄦ椂閫氳繃--maximum-var_name褰㈠紡鐨勯�夐」鏉ユ寚瀹氥�備緥濡傦紝瑕佹兂闃叉��query_cache_size鐨勫�艰繍琛屾椂瓒呰繃32MB锛屼娇鐢ㄩ�夐」--maximum-query_cache_size=32M銆�

浣犲彲浠ラ�氳繃SHOW VARIABLES璇�鍙ユ煡鐪嬬郴缁熷彉閲忓強鍏跺�笺�傝�︾粏淇℃伅鍙傝��9.4鑺傦紝鈥滅郴缁熷彉閲忊��銆�

mysql> SHOW VARIABLES;
+---------------------------------+-------------------------------------------+
| Variable_name                   | Value                                     |
+---------------------------------+-------------------------------------------+
| auto_increment_increment        | 1                                         |
| auto_increment_offset           | 1                                         |
| automatic_sp_privileges         | ON                                        |
| back_log                        | 50                                        |
| basedir                         | /home/jon/bin/mysql/                      |
| binlog_cache_size               | 32768                                     |
| bulk_insert_buffer_size         | 8388608                                   |
| character_set_client            | latin1                                    |
| character_set_connection        | latin1                                    |
| character_set_database          | latin1                                    |
| character_set_results           | latin1                                    |
| character_set_server            | latin1                                    |
| character_set_system            | utf8                                      |
| character_sets_dir              | /home/jon/bin/mysql/share/mysql/charsets/ |
| collation_connection            | latin1_swedish_ci                         |
| collation_database              | latin1_swedish_ci                         |
| collation_server                | latin1_swedish_ci                         |
| completion_type                 | 0                                         |
| concurrent_insert               | 1                                         |
| connect_timeout                 | 5                                         |
| datadir                         | /home/jon/bin/mysql/var/                  |
| date_format                     | %Y-%m-%d                                  |
| datetime_format                 | %Y-%m-%d %H:%i:%s                         |
| default_week_format             | 0                                         |
| delay_key_write                 | ON                                        |
| delayed_insert_limit            | 100                                       |
| delayed_insert_timeout          | 300                                       |
| delayed_queue_size              | 1000                                      |
| div_precision_increment         | 4                                         |
| engine_condition_pushdown       | OFF                                       |
| expire_logs_days                | 0                                         |
| flush                           | OFF                                       |
| flush_time                      | 0                                         |
| ft_boolean_syntax               | + -><()~*:""&|                            |
| ft_max_word_len                 | 84                                        |
| ft_min_word_len                 | 4                                         |
| ft_query_expansion_limit        | 20                                        |
| ft_stopword_file                | (built-in)                                |
| group_concat_max_len            | 1024                                      |
| have_archive                    | YES                                       |
| have_bdb                        | NO                                        |
| have_blackhole_engine           | YES                                       |
| have_compress                   | YES                                       |
| have_crypt                      | YES                                       |
| have_csv                        | YES                                       |
| have_example_engine             | NO                                        |
| have_federated_engine           | NO                                        |
| have_geometry                   | YES                                       |
| have_innodb                     | YES                                       |
| have_isam                       | NO                                        |
| have_ndbcluster                 | DISABLED                                  |
| have_openssl                    | NO                                        |
| have_partition_engine           | YES                                       |
| have_query_cache                | YES                                       |
| have_raid                       | NO                                        |
| have_rtree_keys                 | YES                                       |
| have_symlink                    | YES                                       |
| init_connect                    |                                           |
| init_file                       |                                           |
| init_slave                      |                                           |
| innodb_additional_mem_pool_size | 1048576                                   |
| innodb_autoextend_increment     | 8                                         |
| innodb_buffer_pool_awe_mem_mb   | 0                                         |
| innodb_buffer_pool_size         | 8388608                                   |
| innodb_checksums                | ON                                        |
| innodb_commit_concurrency       | 0                                         |
| innodb_concurrency_tickets      | 500                                       |
| innodb_data_file_path           | ibdata1:10M:autoextend                    |
| innodb_data_home_dir            |                                           |
| innodb_doublewrite              | ON                                        |
| innodb_fast_shutdown            | 1                                         |
| innodb_file_io_threads          | 4                                         |
| innodb_file_per_table           | OFF                                       |
| innodb_flush_log_at_trx_commit  | 1                                         |
| innodb_flush_method             |                                           |
| innodb_force_recovery           | 0                                         |
| innodb_lock_wait_timeout        | 50                                        |
| innodb_locks_unsafe_for_binlog  | OFF                                       |
| innodb_log_arch_dir             |                                           |
| innodb_log_archive              | OFF                                       |
| innodb_log_buffer_size          | 1048576                                   |
| innodb_log_file_size            | 5242880                                   |
| innodb_log_files_in_group       | 2                                         |
| innodb_log_group_home_dir       | ./                                        |
| innodb_max_dirty_pages_pct      | 90                                        |
| innodb_max_purge_lag            | 0                                         |
| innodb_mirrored_log_groups      | 1                                         |
| innodb_open_files               | 300                                       |
| innodb_support_xa               | ON                                        |
| innodb_sync_spin_loops          | 20                                        |
| innodb_table_locks              | ON                                        |
| innodb_thread_concurrency       | 20                                        |
| innodb_thread_sleep_delay       | 10000                                     |
| interactive_timeout             | 28800                                     |
| join_buffer_size                | 131072                                    |
| key_buffer_size                 | 8388600                                   |
| key_cache_age_threshold         | 300                                       |
| key_cache_block_size            | 1024                                      |
| key_cache_division_limit        | 100                                       |
| language                        | /home/jon/bin/mysql/share/mysql/english/  |
| large_files_support             | ON                                        |
| large_page_size                 | 0                                         |
| large_pages                     | OFF                                       |
| license                         | GPL                                       |
| local_infile                    | ON                                        |
| locked_in_memory                | OFF                                       |
| log                             | ON                                        |
| log_bin                         | ON                                        |
| log_bin_trust_routine_creators  | OFF                                       |
| log_error                       | /home/jon/bin/mysql/var/master1.err       |
| log_slave_updates               | OFF                                       |
| log_slow_queries                | OFF                                       |
| log_warnings                    | 1                                         |
| long_query_time                 | 10                                        |
| low_priority_updates            | OFF                                       |
| lower_case_file_system          | OFF                                       |
| lower_case_table_names          | 0                                         |
| max_allowed_packet              | 1048576                                   |
| max_binlog_cache_size           | 4294967295                                |
| max_binlog_size                 | 1073741824                                |
| max_connect_errors              | 10                                        |
| max_connections                 | 100                                       |
| max_delayed_threads             | 20                                        |
| max_error_count                 | 64                                        |
| max_heap_table_size             | 16777216                                  |
| max_insert_delayed_threads      | 20                                        |
| max_join_size                   | 4294967295                                |
| max_length_for_sort_data        | 1024                                      |
| max_relay_log_size              | 0                                         |
| max_seeks_for_key               | 4294967295                                |
| max_sort_length                 | 1024                                      |
| max_tmp_tables                  | 32                                        |
| max_user_connections            | 0                                         |
| max_write_lock_count            | 4294967295                                |
| multi_range_count               | 256                                       |
| myisam_data_pointer_size        | 6                                         |
| myisam_max_sort_file_size       | 2147483647                                |
| myisam_recover_options          | OFF                                       |
| myisam_repair_threads           | 1                                         |
| myisam_sort_buffer_size         | 8388608                                   |
| ndb_autoincrement_prefetch_sz   | 32                                        |
| ndb_cache_check_time            | 0                                         |
| ndb_force_send                  | ON                                        |
| ndb_index_stat_cache_entries    | 32                                        |
| ndb_index_stat_enable           | ON                                        |
| ndb_index_stat_update_freq      | 20                                        |
| ndb_use_exact_count             | ON                                        |
| ndb_use_transactions            | ON                                        |
| net_buffer_length               | 16384                                     |
| net_read_timeout                | 30                                        |
| net_retry_count                 | 10                                        |
| net_write_timeout               | 60                                        |
| new                             | OFF                                       |
| old_alter_table                 | OFF                                       |
| old_passwords                   | OFF                                       |
| open_files_limit                | 1024                                      |
| optimizer_prune_level           | 1                                         |
| optimizer_search_depth          | 62                                        |
| pid_file                        | /home/jon/bin/mysql/var/hostname.pid1     |
| port                            | 3306                                      |
| preload_buffer_size             | 32768                                     |
| protocol_version                | 10                                        |
| query_alloc_block_size          | 8192                                      |
| query_cache_limit               | 1048576                                   |
| query_cache_min_res_unit        | 4096                                      |
| query_cache_size                | 0                                         |
| query_cache_type                | ON                                        |
| query_cache_wlock_invalidate    | OFF                                       |
| query_prealloc_size             | 8192                                      |
| range_alloc_block_size          | 2048                                      |
| read_buffer_size                | 131072                                    |
| read_only                       | OFF                                       |
| read_rnd_buffer_size            | 262144                                    |
| relay_log_purge                 | ON                                        |
| relay_log_space_limit           | 0                                         |
| rpl_recovery_rank               | 0                                         |
| secure_auth                     | OFF                                       |
| server_id                       | 1                                         |
| skip_external_locking           | ON                                        |
| skip_networking                 | OFF                                       |
| skip_show_database              | OFF                                       |
| slave_compressed_protocol       | OFF                                       |
| slave_load_tmpdir               | /tmp/                                     |
| slave_net_timeout               | 3600                                      |
| slave_skip_errors               | OFF                                       |
| slave_transaction_retries       | 10                                        |
| slow_launch_time                | 2                                         |
| socket                          | /tmp/mysql.sock                           |
| sort_buffer_size                | 2097144                                   |
| sql_mode                        |                                           |
| sql_notes                       | ON                                        |
| sql_warnings                    | ON                                        |
| storage_engine                  | MyISAM                                    |
| sync_binlog                     | 0                                         |
| sync_frm                        | ON                                        |
| sync_replication                | 0                                         |
| sync_replication_slave_id       | 0                                         |
| sync_replication_timeout        | 10                                        |
| system_time_zone                | EST                                       |
| table_cache                     | 64                                        |
| table_lock_wait_timeout         | 50                                        |
| table_type                      | MyISAM                                    |
| thread_cache_size               | 0                                         |
| thread_stack                    | 196608                                    |
| time_format                     | %H:%i:%s                                  |
| time_zone                       | SYSTEM                                    |
| timed_mutexes                   | OFF                                       |
| tmp_table_size                  | 33554432                                  |
| tmpdir                          |                                           |
| transaction_alloc_block_size    | 8192                                      |
| transaction_prealloc_size       | 4096                                      |
| tx_isolation                    | REPEATABLE-READ                           |
| updatable_views_with_limit      | YES                                       |
| version                         | 5.1.2-alpha-log                           |
| version_comment                 | Source distribution                       |
| version_compile_machine         | i686                                      |
| version_compile_os              | suse-linux                                |
| wait_timeout                    | 28800                                     |
+---------------------------------+-------------------------------------------+
218 rows in set (0.03 sec)

姝ゅ�勬弿杩颁簡澶у�氭暟绯荤粺鍙橀噺銆傛病鏈夌増鏈�鐨勫彉閲忓湪鎵�鏈�MySQL 5.1 鍙戝竷涓�閫傜敤銆傚叧浜庡叾浣跨敤鍘嗗彶淇℃伅锛岃�峰弬瑙�MySQL 5.0鍙傝�冩寚鍗�鍜�MySQL 4.1鍙傝�冩寚鍗�銆�InnoDB绯荤粺鍙橀噺鍒椾簬 15.2.4鑺傦紝鈥淚nnoDB鍚�鍔ㄩ�夐」鈥�銆�

鑻ユ病鏈夊彟琛岃�勫畾锛岀紦鍐插尯澶у皬銆侀暱搴﹀拰鍫嗘爤澶у皬鐨勫崟浣嶅潎涓哄瓧鑺傘��

鍏充簬杩欎簺鍙橀噺鐨勮皟鑺備俊鎭�鍙傝��7.5.2鑺傦紝鈥滆皟鑺傛湇鍔″櫒鍙傛暟鈥�銆�

路         auto_increment_increment

auto_increment_increment鍜�auto_increment_offset鐢ㄤ簬涓绘湇鍔″櫒锛嶄富鏈嶅姟鍣�锛�master-to-master锛夊�嶅埗锛屽苟鍙�浠ョ敤鏉ユ帶鍒�AUTO_INCREMENT鍒楃殑鎿嶄綔銆備袱涓�鍙橀噺鍧囧彲浠ヨ�剧疆涓哄叏灞�鎴栧眬閮ㄥ彉閲忥紝骞朵笖鍋囧畾姣忎釜鍊奸兘鍙�浠ヤ负1鍒�65,535涔嬮棿鐨勬暣鏁板�笺�傚皢鍏朵腑涓�涓�鍙橀噺璁剧疆涓�0浼氫娇璇ュ彉閲忎负1銆傚�傛灉璇曞浘灏嗚繖浜涘彉閲忚�剧疆涓哄ぇ浜�65,535鎴栧皬浜�0鐨勫�硷紝鍒欎細灏嗚�ュ�艰�剧疆涓�65,535銆傚�傛灉鍚戝皢auto_increment_increment鎴�auto_increment_offset璁剧疆涓洪潪鏁存暟鍊硷紝鍒欎細缁欏嚭閿欒��锛屽苟涓斿彉閲忕殑瀹為檯鍊煎湪杩欑�嶆儏鍐典笅淇濇寔涓嶅彉銆�

杩欎袱涓�鍙橀噺褰卞搷AUTO_INCREMENT鍒楃殑鏂瑰紡锛�

o        auto_increment_increment鎺у埗鍒椾腑鐨勫�肩殑澧為噺鍊笺�備緥濡�:

o                       mysql> SHOW VARIABLES LIKE 'auto_inc%';

o                       +--------------------------+-------+

o                       | Variable_name            | Value |

o                       +--------------------------+-------+

o                       | auto_increment_increment | 1     |

o                       | auto_increment_offset    | 1     |

o                       +--------------------------+-------+

o                       2 rows in set (0.00 sec)

o                      

o                       mysql> CREATE TABLE autoinc1 (col INT NOT NULL AUTO_INCREMENT PRIMARY KEY);

o                       Query OK, 0 rows affected (0.04 sec)

o                      

o                       mysql> SET @auto_increment_increment=10;

o                       Query OK, 0 rows affected (0.00 sec)

o                      

o                       mysql> SHOW VARIABLES LIKE 'auto_inc%';

o                       +--------------------------+-------+

o                       | Variable_name            | Value |

o                       +--------------------------+-------+

o                       | auto_increment_increment | 10    |

o                       | auto_increment_offset    | 1     |

o                       +--------------------------+-------+

o                       2 rows in set (0.01 sec)

o                      

o                       mysql> INSERT INTO autoinc1 VALUES (NULL), (NULL), (NULL), (NULL);

o                       Query OK, 4 rows affected (0.00 sec)

o                       Records: 4  Duplicates: 0  Warnings: 0

o                      

o                       mysql> SELECT col FROM autoinc1;

o                       +-----+

o                       | col |

o                       +-----+

o                       |   1 |

o                       |  11 |

o                       |  21 |

o                       |  31 |

o                       +-----+

o                       4 rows in set (0.00 sec)

(娉ㄦ槑濡備綍浣跨敤SHOW VARIABLES鏉ヨ幏鍙栬繖浜涘彉閲忕殑褰撳墠鍊硷級銆�

o        auto_increment_offset纭�瀹�AUTO_INCREMENT鍒楀�肩殑璧风偣銆傚亣瀹氬湪涓庡墠闈㈢殑渚嬪瓙鐨勭浉鍚岀殑浼氳瘽涓�鎵ц�屼笅闈㈢殑鍛戒护锛�

o                       mysql> SET @auto_increment_offset=5;

o                       Query OK, 0 rows affected (0.00 sec)

o                      

o                       mysql> SHOW VARIABLES LIKE 'auto_inc%';

o                       +--------------------------+-------+

o                       | Variable_name            | Value |

o                       +--------------------------+-------+

o                       | auto_increment_increment | 10    |

o                       | auto_increment_offset    | 5     |

o                       +--------------------------+-------+

o                       2 rows in set (0.00 sec)

o                      

o                       mysql> CREATE TABLE autoinc2 (col INT NOT NULL AUTO_INCREMENT PRIMARY KEY);

o                       Query OK, 0 rows affected (0.06 sec)

o                      

o                       mysql> INSERT INTO autoinc2 VALUES (NULL), (NULL), (NULL), (NULL);

o                       Query OK, 4 rows affected (0.00 sec)

o                       Records: 4  Duplicates: 0  Warnings: 0

o                      

o                       mysql> SELECT col FROM autoinc2;

o                       +-----+

o                       | col |

o                       +-----+

o                       |   5 |

o                       |  15 |

o                       |  25 |

o                       |  35 |

o                       +-----+

o                       4 rows in set (0.02 sec)

o                      

濡傛灉auto_increment_offset鐨勫�煎ぇ浜�auto_increment_increment鐨勫�硷紝鍒�auto_increment_offset鐨勫�艰��蹇界暐銆�

濡傛灉鍏朵腑涓�涓�鎴栦袱涓�鍙橀噺琚�鏇存敼浜嗭紝鐒跺悗鏇存敼鎻掑叆鍒板寘鍚�AUTO_INCREMENT鍒楃殑琛ㄤ腑鐨勬柊琛岋紝缁撴灉鍙�鑳界湅涓婂幓鏈夐棶棰橈紝鐢变簬璁＄畻AUTO_INCREMENT绯诲垪鍊兼椂娌℃湁鑰冭檻鍒楀唴宸茬粡瀛樺湪鐨勫�硷紝骞朵笖鎻掑叆鐨勪笅涓�涓�鍊兼槸鍒楀唴鏈�灏忕殑鍊硷紝澶т簬AUTO_INCREMENT鍒楀唴宸叉湁鐨勬渶澶у�笺�傛崲鍙ヨ瘽璇达紝鏁板�肩殑璁＄畻鏂规硶涓猴細

auto_increment_offset+ N * auto_increment_increment

鍏朵腑N涓虹郴鍒楀唴鐨勬�ｆ暣鏁板��[1,2,3,...]銆備緥濡傦細

mysql> SHOW VARIABLES LIKE 'auto_inc%';

+--------------------------+-------+

| Variable_name            | Value |

+--------------------------+-------+

| auto_increment_increment | 10    |

| auto_increment_offset    | 5     |

+--------------------------+-------+

2 rows in set (0.00 sec)

mysql> SELECT col FROM autoinc1;

+-----+

| col |

+-----+

|   1 |

|  11 |

|  21 |

|  31 |

+-----+

4 rows in set (0.00 sec)

mysql> INSERT INTO autoinc1 VALUES (NULL), (NULL), (NULL), (NULL);

Query OK, 4 rows affected (0.00 sec)

Records: 4  Duplicates: 0  Warnings: 0

mysql> SELECT col FROM autoinc1;

+-----+

| col |

+-----+

|   1 |

|  11 |

|  21 |

|  31 |

|  35 |

|  45 |

|  55 |

|  65 |

+-----+

8 rows in set (0.00 sec)

auto_increment_increment鍜�auto_increment_offset鎵�绀虹殑鍊煎彲浠ョ敓鎴愮郴鍒�5 + N * 10,鍗筹紝[5,15,25,35,45,...]銆傚湪INSERT鍓�col 鍒楀唴鏈�澶х殑鍊间负31,AUTO_INCREMENT鏁板垪鐨勪笅涓�涓�鍊间负35,鍥犳��col涓�鎻掑叆鐨勫�间粠璇ョ偣寮�濮嬶紝缁撴灉濡�SELECT鏌ヨ�㈡墍绀恒��

涓�瀹氳�佽�颁綇涓嶅彲鑳藉皢杩欎袱涓�鍙橀噺鐨勭粨鏋滈檺鍒跺埌涓�涓�琛ㄤ腑锛屽洜姝や笉浼氭浛浠ｅ叾瀹冩暟鎹�搴撶�＄悊绯荤粺鎻愪緵鐨勫簭鍒楋紱杩欎簺鍙橀噺鎺у埗MySQL鏈嶅姟鍣ㄤ笂all琛�AUTO_INCREMENT鍒楃殑鎵�鏈夎�屼负銆傚�傛灉鏌愪釜鍙橀噺璁句负鍏ㄥ眬鍙橀噺锛屽垯鍙�鏈夐�氳繃灞�閮ㄨ�剧疆灏嗗叏灞�鍊兼洿鏀瑰拰瑕嗙洊鍚庢垨mysqld閲嶅惎鍚庡叾浣滅敤鏂瑰彲鏀瑰彉锛涘�傛灉灞�閮ㄨ�剧疆锛屽垯鏂板�煎奖鍝嶆墍鏈夎〃鐨�AUTO_INCREMENT鍒楋紝鍦ㄨ繖涓�浼氳瘽鏈熼棿褰撳墠鐢ㄦ埛鍦ㄨ繖浜涜〃涓�鎻掑叆浜嗘柊琛岋紝闄ら潪鍦ㄤ細璇濇湡闂存洿鏀逛簡杩欎簺鍊笺��

auto_increment_increment鐨� 榛樿�ゅ�间负1銆傚弬瑙�6.12鑺傦紝鈥滃�氭湇鍔″櫒澶嶅埗涓�鐨凙uto-Increment鈥�銆�

路         auto_increment_offset

璇ュ彉閲忕殑榛樿�ゅ�间负1銆傝�﹁��auto_increment_increment鐨勬弿杩般��

路         back_log

MySQL鏈夌殑涓昏�佽繛鎺ヨ�锋眰鐨勬暟閲忋�傚綋涓�MySQL绾跨▼鍦ㄧ煭鏃堕棿鍐呭緱鍒拌�稿�氳繛鎺ヨ�锋眰鏃跺彂鎸ヤ綔鐢ㄣ�備富绾跨▼闇�瑕佽姳涓�浜涙椂闂�(灏界�″緢灏�)鏉ユ��鏌ヨ繛鎺ュ苟鍚�鍔ㄤ竴涓�鏂扮嚎绋嬨��back_log鍊艰�存槑MySQL涓存椂鍋滄�㈠搷搴旀柊璇锋眰鍓嶅湪鐭�鏃堕棿鍐呭彲浠ュ爢璧峰�氬皯璇锋眰銆傚�傛灉浣犻渶瑕佸湪鐭�鏃堕棿鍐呭厑璁稿ぇ閲忚繛鎺ワ紝鍙�浠ュ�炲姞璇ユ暟鍊笺��

鎹㈠彞璇濊�达紝璇ュ�间负鈥滆繘鈥�TCP/IP杩炴帴甯у惉闃熷垪鐨勫ぇ灏忋�傛搷浣滅郴缁熸湁璇ラ槦鍒楄嚜宸辩殑闄愬埗鍊笺�傛湰鎵嬪唽涓�Unix listen()绯荤粺璋冪敤椤靛簲鏈夋洿璇︾粏鐨勪俊鎭�銆傝�ュ彉閲忔渶澶у�艰�锋煡闃�OS鏂囨。銆備紒鍥惧皢back_log璁剧疆涓洪珮浜庝綘鐨勬搷浣滅郴缁熼檺鍊兼槸寰掑姵鏃犵泭鐨勩��

路         basedir

MySQL瀹夎�呭熀鍑嗙洰褰曘�傚彲浠ョ敤--basedir閫夐」璁剧疆璇ュ彉閲忋��

路         bdb_cache_size

涓�BDB琛ㄧ紦瀛樼储寮曞拰琛屽垎閰嶇殑缂撳啿鍖虹殑澶у皬銆傚�傛灉浣犱笉浣跨敤BDB琛�锛屼綘搴旂敤--skip-bdb鍚�鍔�mysqld浠ヤ究涓嶆氮璐硅�ョ紦瀛樸��

路         bdb_home

BDB琛ㄥ熀鍑嗙洰褰曘�傚簲涓�datadir鍙橀噺鐨勫�肩浉鍚屻��

路         bdb_log_buffer_size

涓�BDB琛ㄧ紦瀛樼储寮曞拰琛屽垎閰嶇殑缂撳啿鍖虹殑澶у皬銆傚�傛灉浣犱笉浣跨敤BDB琛�锛屼綘搴斿皢璇ュ�艰�剧疆涓�0鎴栫敤--skip-bdb鍚�鍔�mysqld浠ヤ究涓嶆氮璐硅�ョ紦瀛樸��

路         bdb_logdir

BDB瀛樺偍寮曟搸鍐欏畠鏃ュ織鏂囦欢鐨勭洰褰曘�傚彲浠ョ敤--bdb-logdir閫夐」璁剧疆璇ュ彉閲忋��

路         bdb_max_lock

鍦�BDB琛ㄤ笅鍙�浠ユ縺娲荤殑鏈�澶ч攣鏁�(榛樿�や负10,000)銆傚�傛灉褰撲綘鎵ц�岄暱浜嬪姟鎴栧綋mysqld蹇呴』妫�鏌ヨ�稿�氳�屾潵璁＄畻鏌ヨ�㈡椂鍑虹幇涓嬮潰鐨勯敊璇�锛屼綘搴斿�炲姞璇ュ�硷細

bdb: Lock table is out of available locks

Got error 12 from ...

路         bdb_shared_data

濡傛灉浣犳�ｄ娇鐢�--bdb-shared-data搴斾负ON銆�

路         bdb_tmpdir

--bdb-tmpdir閫夐」鐨勫�笺��

 

路         binlog_cache_size

鍦ㄤ簨鍔¤繃绋嬩腑瀹圭撼浜岃繘鍒舵棩蹇�SQL璇�鍙ョ殑缂撳瓨澶у皬銆備簩杩涘埗鏃ュ織缂撳瓨鏄�鏈嶅姟鍣ㄦ敮鎸佷簨鍔″瓨鍌ㄥ紩鎿庡苟涓旀湇鍔″櫒鍚�鐢ㄤ簡浜岃繘鍒舵棩蹇�(--log-bin閫夐」)鐨勫墠鎻愪笅涓烘瘡涓�瀹㈡埛绔�鍒嗛厤鐨勫唴瀛樸�傚�傛灉浣犵粡甯镐娇鐢ㄥぇ鐨勶紝澶氳��鍙ヤ簨鍔★紝浣犲彲浠ュ�炲姞璇ュ�间互鑾峰緱鏇存湁鐨勬�ц兘銆�Binlog_cache_use鍜�Binlog_cache_disk_use鐘舵�佸彉閲忓彲浠ョ敤鏉ヨ皟鏁磋�ュ彉閲忕殑澶у皬銆傚弬瑙�5.11.3鑺傦紝鈥滀簩杩涘埗鏃ュ織鈥�銆�

路         bulk_insert_buffer_size

MyISAM 浣跨敤涓撶敤鏍戠姸缂撳瓨鏉ヤ娇INSERT ... SELECT銆�INSERT ... VALUES (...)銆�(...)銆� ...鍜�LOAD DATA INFILE鐨勫ぇ鍧楁彃鍏ユ洿蹇�銆傝�ュ彉閲忕敤姣忕嚎绋嬬殑瀛楄妭鏁伴檺鍒剁紦瀛樻爲鐨勫ぇ灏忋�傚皢瀹冭�剧疆涓�0绂佺敤浼樺寲銆�娉�閲婏細鍙�鏈夊悜闈炵┖琛ㄦ坊鍔犳暟鎹�鏃舵墠浣跨敤璇ョ紦瀛樸�� 榛樿�ゅ�兼槸8MB銆�

路         character_set_client

鏉ヨ嚜瀹㈡埛绔�鐨勮��鍙ョ殑瀛楃�﹂泦銆�

路         character_set_connection

鐢ㄤ簬娌℃湁瀛楃�﹂泦瀵煎叆绗︾殑鏂囧瓧鍜屾暟瀛楋紞瀛楃�︿覆杞�鎹�銆�

路         character_set_database

榛樿�ゆ暟鎹�搴撲娇鐢ㄧ殑瀛楃�﹂泦銆傚綋榛樿�ゆ暟鎹�搴撴洿鏀规椂锛屾湇鍔″櫒鍒欒�剧疆璇ュ彉閲忋�傚�傛灉娌℃湁榛樿�ゆ暟鎹�搴擄紝鍙橀噺鐨勫�煎悓character_set_server銆�

路         character_set_results

鐢ㄤ簬鍚戝�㈡埛绔�杩斿洖鏌ヨ�㈢粨鏋滅殑瀛楃�﹂泦銆�

路         character_set_ server

鏈嶅姟鍣ㄧ殑榛樿�ゅ瓧绗﹂泦銆�

路         character_set_system

鏈嶅姟鍣ㄧ敤鏉ヤ繚瀛樿瘑鍒�绗︾殑瀛楃�﹂泦銆傝�ュ�间竴瀹氭槸utf8銆�

路         character_sets_dir

瀛楃�﹂泦瀹夎�呯洰褰曘��

路         collation_connection

杩炴帴瀛楃�﹂泦鐨勬牎瀵硅�勫垯銆�

路         collation_database

榛樿�ゆ暟鎹�搴撲娇鐢ㄧ殑鏍″�硅�勫垯銆傚綋榛樿�ゆ暟鎹�搴撴敼鍙樻椂鏈嶅姟鍣ㄥ垯璁剧疆璇ュ彉閲忋�傚�傛灉娌℃湁榛樿�ゆ暟鎹�搴擄紝鍙橀噺鐨勫�煎悓collation_server銆�

路         collation_server

鏈嶅姟鍣ㄧ殑榛樿�ゆ牎瀵硅�勫垯銆�

路         completion_type

浜嬪姟缁撴潫绫诲瀷锛�

o        濡傛灉璇ュ�间负0(榛樿��)锛�COMMIT鍜�ROLLBACK涓嶅彈褰卞搷銆�

o        濡傛灉璇ュ�间负1锛�COMMIT鍜�ROLLBACK鍒嗗埆绛夊悓浜�COMMIT AND CHAIN鍜�ROLLBACK AND CHAIN銆�(鏂颁簨鍔＄敤鍒氬垰缁撴潫鐨勪簨鍔＄浉鍚岀殑闂撮殧绛夌骇绔嬪嵆鍚�鍔�锛�銆�

o        濡傛灉璇ュ�间负2锛�COMMIT鍜�ROLLBACK鍒嗗埆绛夊悓浜�COMM瀹�RELEASE鍜�ROLLBACK RELEASE銆�(浜嬪姟缁堟�㈠悗锛屾湇鍔″櫒鏂�寮�锛�銆�

路         concurrent_insert

濡傛灉涓�ON(榛樿�ゅ��)锛�MySQL鍏佽��INSERT鍜�SELECT璇�鍙ュ湪涓�闂存病鏈夌┖鏁版嵁鍧楃殑MyISAM琛ㄤ腑骞惰�岃繍琛屻�備綘鍙�浠ョ敤--safe鎴�--skip-new鍚�鍔�mysqld鍏抽棴璇ラ�夐」銆�

璇ュ彉閲忎负鏁存暟锛屾湁3涓�鍊硷細

鍊�	鎻忚堪
0	鍏�
1	(榛樿��)鍦ㄦ病鏈夌┖鏁版嵁鍧楃殑MyISAM琛ㄤ腑鍚�鐢ㄥ苟琛屾彃鍏�
2	涓烘墍鏈�MyISAM琛ㄥ惎鐢ㄥ苟琛屾彃鍏ャ�傚�傛灉琛ㄦ湁绌鸿�板綍鎴栨�ｈ��鍙︿竴绾跨▼浣跨敤锛屾柊琛屽皢鎻掑叆鍒拌〃鐨勬渶鍚庛�傚�傛灉琛ㄦ湭浣跨敤锛�MySQL灏嗚繘琛屾櫘閫氳�婚攣瀹氬苟灏嗘柊琛屾彃鍏ョ┖璁板綍銆�

路         connect_timeout

mysqld鏈嶅姟鍣�鐢�Bad handshake鍝嶅簲鍓嶇瓑寰呰繛鎺ュ寘鐨勭�掓暟銆�

路         datadir

MySQL鏁版嵁鐩�褰曘�傚彲浠ョ敤--datadir閫夐」璁剧疆璇ュ彉閲忋��

路         date_format

璇ュ彉閲忔湭浣跨敤銆�

路         datetime_format

璇ュ彉閲忔湭浣跨敤銆�

路         default_week_format

WEEK() 鍑芥暟浣跨敤鐨勯粯璁ゆā寮忋��

路         delay_key_write

璇ラ�夐」鍙�閫傜敤MyISAM琛ㄣ�傚畠鍏锋湁涓嬭堪鍊煎彲浠ュ奖鍝�CREATE TABLE璇�鍙ヤ娇鐢ㄧ殑DELAY_KEY_WRITE琛ㄩ�夐」鐨勫�勭悊銆�

閫夐」	鎻忚堪
OFF	DELAY_KEY_WRITE琚�蹇界暐銆�
ON	MySQL鍦�CREATE TABLE涓�鐢�DELAY_KEY_WRITE閫夐」銆傝繖鏄� 榛樿�ゅ�笺��
ALL	鐢ㄥ惎鐢�DELAY_KEY_WRITE閫夐」鍒涘缓琛ㄧ殑鐩稿悓鏂规硶瀵规墍鏈夋柊鎵撳紑琛ㄧ殑杩涜�屽�勭悊銆�

濡傛灉鍚�鐢ㄤ簡DELAY_KEY_WRITE锛岃�存槑浣跨敤璇ラ」鐨勮〃鐨勯敭缂撳啿鍖哄湪姣忔�℃洿鏂扮储寮曟椂涓嶈��娓呯┖锛屽彧鏈夊叧闂�琛ㄦ椂鎵嶆竻绌恒�傞伄鎺╃洊鍙�浠ュぇ澶у姞蹇�閿�鐨勫啓鎿嶄綔锛屼絾濡傛灉浣犱娇鐢ㄨ�ョ壒鎬э紝浣犲簲鐢�--myisam-recover閫夐」鍚�鍔ㄦ湇鍔″櫒锛屼负鎵�鏈�MyISAM琛ㄦ坊鍔犺嚜鍔ㄦ��鏌�(渚嬪�傦紝--myisam-recover=BACKUP,FORCE)銆傚弬瑙�5.3.1鑺傦紝鈥�mysqld鍛戒护琛岄�夐」鈥�鍜�15.1.1鑺傦紝鈥淢yISAM鍚�鍔ㄩ�夐」鈥�銆�

璇锋敞鎰�--external-locking涓嶄负浣跨敤寤惰繜閿�鍐欏叆鐨勮〃鎻愪緵绱㈠紩鐮村潖淇濇姢銆�

路         delayed_insert_limit

鎻掑叆delayed_insert_limit 寤惰繜琛屽悗锛�INSERT DELAYED 澶勭悊鍣ㄧ嚎绋嬫��鏌ユ槸鍚︽湁鎸傝捣鐨�SELECT璇�鍙ャ�傚�傛灉鏈夛紝鍦ㄧ户缁�鎻掑叆寤惰繜鐨勮�屼箣鍓嶏紝鍏佽�稿畠浠�鍏堟墽琛屻��

路         delayed_insert_timeout

INSERT DELAYED澶勭悊鍣ㄧ嚎绋嬬粓姝㈠墠搴旂瓑寰�INSERT璇�鍙ョ殑鏃堕棿銆�

路         delayed_queue_size

杩欐槸鍚勪釜琛ㄤ腑澶勭悊INSERT DELAYED璇�鍙ユ椂闃熷垪涓�琛岀殑鏁伴噺闄愬埗銆傚�傛灉闃熷垪婊′簡锛屾墽琛�INSERT DELAYED璇�鍙ョ殑瀹㈡埛绔�搴旂瓑寰呯洿鍒伴槦鍒楀唴鍐嶆湁绌洪棿銆�

路         div_precision_increment

璇ュ彉閲忚�存槑鐢�/鎿嶄綔绗︽墽琛岄櫎鎿嶄綔鐨勭粨鏋滃彲澧炲姞鐨勭簿纭�搴︾殑浣嶆暟銆� 榛樿�ゅ�兼槸4銆傛渶灏忓拰鏈�澶у�煎垎鍒�涓�0鍜�30銆備笅闈㈢殑绀轰緥璇存槑浜嗗�炲姞 榛樿�ゅ�肩殑缁撴灉銆�

mysql> SELECT 1/7;

+--------+

| 1/7    |

+--------+

| 0.1429 |

+--------+

mysql> SET div_precision_increment = 12;

mysql> SELECT 1/7;

+----------------+

| 1/7            |

+----------------+

| 0.142857142857 |

+----------------+

路         engine_condition_pushdown

璇ュ彉閲忛�傜敤浜�NDB銆傞粯璁ゅ�间负0(OFF)锛氬�傛灉浣犳墽琛岀被浼兼煡璇�SELECT * FROM t WHERE mycol = 42锛屽叾涓�mycol涓烘病鏈夌储寮曠殑鍒楋紝褰撴弧浜嗙殑琛ㄦ壂鎻忔瘡涓�NDB鑺傜偣鏃讹紝鎵ц�岃�ユ煡璇�銆傛瘡涓�鑺傜偣浣跨敤WHERE鏉′欢灏嗘瘡涓�琛屽彂閫佺粰MySQL鏈嶅姟鍣ㄣ�傚�傛灉engine_condition_pushdown琚�璁剧疆涓�1(ON)锛岃�ユ潯浠垛��pushed down鈥濈粰瀛樺偍寮曟搸骞跺彂閫佺粰NDB鑺傜偣銆傛瘡涓�鑺傜偣閮芥墽琛屾壂鎻忥紝骞跺彧鍚�MySQL鏈嶅姟鍣ㄥ彂閫佸洖鍖归厤鏉′欢鐨勮�屻��

路         expire_logs_days

浜岃繘鍒舵棩蹇楄嚜鍔ㄥ垹闄ょ殑澶╂暟銆傞粯璁ゅ�间负0,琛ㄧず鈥滄病鏈�鑷�鍔ㄥ垹闄�鈥濄�傚惎鍔ㄦ椂鍜屼簩杩涘埗鏃ュ織寰�鐜�鏃跺彲鑳藉垹闄ゃ��

路         flush

濡傛灉鐢�--flush閫夐」鍚�鍔�mysqld璇ュ�间负ON銆�

路         flush_time

濡傛灉璁句负闈為浂鍊硷紝姣忛殧flush_time绉掑垯鍏抽棴鎵�鏈夎〃浠ラ噴鏀剧‖鐩樿祫婧愬苟鍚屾�ユ湭娓呯┖鐨勬暟鎹�銆傛垜浠�寤鸿��鍙�鍦�Windows 9x鎴�Me锛屾垨鏈夋渶灏忚祫婧愮殑绯荤粺涓�浣跨敤璇ラ�夐」銆�

路         ft_boolean_syntax

浣跨敤IN BOOLEAN MODE鎵ц�岀殑甯冨皵鍏ㄦ枃鎼滅储鏀�鎸佺殑鎿嶄綔绗︾郴鍒椼�傚弬瑙�12.7.1鑺傦紝鈥滃竷灏斿叏鏂囨悳绱⑩��銆�

榛樿�ゅ彉閲忓�间负 '+ -><()~*:""&|'銆傛洿鏀硅繖浜涘�肩殑瑙勫垯鏄�锛�

o        鎿嶄綔绗﹀嚱鏁扮敱鍏跺湪瀛楃�︿覆鍐呯殑浣嶇疆鍐冲畾銆�

o        鏇挎崲鍊煎繀椤绘槸14涓�瀛楃�︺��

o        姣忎釜瀛楃�﹀繀椤讳负ASCII鐮侀潪鏂囧瓧鏁板瓧瀛楃�︺��

o        绗�1涓�鎴栫��2涓�瀛楃�﹀繀椤讳负绌烘牸銆�

o        闄ら潪璇�鍙ュ湪绗�11涓�瀛楃�﹀拰绗�12涓�瀛楃�﹀�勫紩鐢ㄤ簡鎿嶄綔绗︼紝鍚﹀垯涓嶅厑璁稿�嶅埗銆傝繖涓や釜瀛楃�﹀彲浠ヤ笉鐩稿悓锛屼絾杩欐槸鍞�涓�鍙�鑳界殑涓や釜銆�

o        浣嶇疆10銆�13鍜�14(榛樿�よ�剧疆涓衡��:鈥欍�佲��&鈥欏拰鈥�|鈥�)淇濈暀鐢ㄤ簬灏嗘潵鎵╁睍銆�

路         ft_max_word_len

FULLTEXT绱㈠紩涓�鎵�鍖呭惈鐨勫瓧鐨勬渶澶ч暱搴︺��

娉�閲婏細鏇存敼璇ュ彉閲忓悗蹇呴』閲嶅缓FULLTEXT绱㈠紩銆傚簲浣跨敤REPAIR TABLE tbl_name QUICK銆�

路         ft_min_word_len

FULLTEXT绱㈠紩涓�鎵�鍖呭惈鐨勫瓧鐨勬渶灏忛暱搴︺��

娉�閲婏細鏇存敼璇ュ彉閲忓悗蹇呴』閲嶅缓FULLTEXT绱㈠紩銆傚簲浣跨敤REPAIR TABLE tbl_name QUICK銆�

路         ft_query_expansion_limit

浣跨敤WITH QUERY EXPANSION杩涜�屽叏鏂囨悳绱㈢殑鏈�澶у尮閰嶆暟銆�

路         ft_stopword_file

鐢ㄤ簬璇诲彇鍏ㄦ枃鎼滅储鐨勫仠姝㈠瓧娓呭崟鐨勬枃浠躲�傝�ユ枃浠朵腑鐨勬墍鏈夊瓧閮戒細鐢ㄥ埌锛涙敞閲婁笉閲嶈�併�傞粯璁ゆ儏鍐典笅锛屼娇鐢ㄥ唴宓屽紡鍋滄�㈠瓧娓呭崟(濡�myisam/ft_static.c鏂囦欢涓�鎵�瀹氫箟)銆傚皢璇ュ彉閲忚�剧疆涓虹┖瀛楃�︿覆('')鍒欑�佺敤鍋滄�㈠瓧杩囨护銆�

娉�閲婏細鏇存敼璇ュ彉閲忔垨鍋滄�㈠瓧鏂囦欢鐨勫唴瀹瑰悗蹇呴』閲嶅缓FULLTEXT绱㈠紩銆傚簲浣跨敤REPAIR TABLE tbl_name QUICK銆�

路         group_concat_max_len

鍏佽�哥殑GROUP_CONCAT()鍑芥暟缁撴灉鐨勬渶澶ч暱搴︺��

路         have_archive

濡傛灉mysqld鏀�鎸�ARCHIVE琛ㄥ垯涓�YES锛屽惁鍒欎负NO銆�

路         have_bdb

濡傛灉mysqld鏀�鎸�BDB琛ㄥ垯涓�YES銆傚�傛灉浣跨敤--skip-bdb鍒欎负DISABLED銆�

路         have_blackhole_engine

濡傛灉mysqld鏀�鎸�BLACKHOLE琛ㄥ垯涓�YES锛屽惁鍒欎负NO銆�

路         have_compress

鏄�鍚�zlib鍘嬬缉搴撻�傚悎璇ユ湇鍔″櫒銆傚�傛灉涓嶉�傚悎锛屼笉鑳戒娇鐢�COMPRESS()鍜�UNCOMPRESS()鍑芥暟銆�

路         have_crypt

鏄�鍚�crypt()绯荤粺璋冪敤閫傚悎璇ユ湇鍔″櫒銆傚�傛灉涓嶉�傚悎锛屼笉鑳戒娇鐢�CRYPT()鍑芥暟銆�

路         have_csv

濡傛灉mysqld鏀�鎸�ARCHIVE琛ㄥ垯涓�YES锛屽惁鍒欎负NO銆�

路         have_example_engine

濡傛灉mysqld鏀�鎸�EXAMPLE琛ㄥ垯涓�YES锛屽惁鍒欎负NO銆�

have_federated_engine

濡傛灉mysqld鏀�鎸�FEDERATED琛ㄥ垯涓�YES锛屽惁鍒欎负NO銆�

路         have_geometry

鏄�鍚︽湇鍔″櫒鏀�鎸佺┖闂存暟鎹�绫诲瀷銆�

路         have_innodb

濡傛灉mysqld鏀�鎸�InnoDB琛ㄥ垯涓�YES銆傚�傛灉浣跨敤--skip-innodb鍒欎负DISABLED銆�

路         have_isam

鍦�MySQL 5.1涓�,鍙�鏄�涓轰簡鍚戝悗鍏煎�规樉绀鸿�ュ�硷紝骞朵笖鎬绘槸NO锛屽洜涓轰笉鍐嶆敮鎸�ISAM琛ㄣ��

路         have_ndbcluster

濡傛灉mysqld鏀�鎸�NDB CLUSTER琛ㄥ垯涓�YES銆傚�傛灉浣跨敤浜�--skip-ndbcluster鍒欎负DISABLED銆�

路         have_partition_engine

濡傛灉mysqld鏀�鎸佸垎鍖哄垯涓�YES銆傚湪MySQL 5.1.1涓�鍔犲叆銆�

路         have_openssl

濡傛灉mysqld鏀�鎸佸�㈡埛绔�/鏈嶅姟鍣ㄥ崗璁�鐨�SSL(鍔犲瘑)鍒欎负YES銆�

路         have_query_cache

濡傛灉mysqld鏀�鎸佹煡璇㈢紦瀛樺垯涓�YES銆�

路         have_raid

濡傛灉mysqld鏀�鎸�RAID閫夐」鍒欎负YES銆�

路         have_rtree_keys

RTREE绱㈠紩鏄�鍚﹀彲鐢ㄣ��(鐢ㄤ簬MyISAM琛ㄧ殑绌洪棿绱㈠紩锛�銆�

路         have_symlink

鏄�鍚﹀惎鐢ㄧ�﹀彿閾炬帴鏀�鎸併�傚湪Unix涓�闇�瑕佺敤浜庢敮鎸�DATA DIRECTORY鍜�INDEX DIRECTORY琛ㄩ�夐」銆�

路         init_connect

鏈嶅姟鍣ㄤ负姣忎釜杩炴帴鐨勫�㈡埛绔�鎵ц�岀殑瀛楃�︿覆銆傚瓧绗︿覆鐢变竴涓�鎴栧�氫釜SQL璇�鍙ョ粍鎴愩�傝�佹兂鎸囧畾澶氫釜璇�鍙ワ紝鐢ㄥ垎鍙烽棿闅斿紑銆備緥濡傦紝姣忎釜瀹㈡埛绔�寮�濮嬫椂榛樿�ゅ惎鐢�autocommit妯″紡銆傛病鏈夊叏灞�鏈嶅姟鍣ㄥ彉閲忓彲浠ヨ�勫畾autocommit榛樿�ゆ儏鍐典笅搴旂�佺敤锛屼絾鍙�浠ョ敤init_connect鏉ヨ幏寰楃浉鍚岀殑鏁堟灉锛�

SET GLOBAL init_connect='SET AUTOCOMMIT=0';

杩樺彲浠ュ湪鍛戒护琛屾垨閫夐」鏂囦欢涓�璁剧疆璇ュ彉閲忋�傝�佹兂浣跨敤閫夐」鏂囦欢璁剧疆鍙橀噺锛屽簲鍖呮嫭涓嬭堪琛岋細

[mysqld]

init_connect='SET AUTOCOMMIT=0'

璇锋敞鎰�init_connect鐨勫唴瀹瑰苟涓嶄负鎷ユ湁SUPER鏉冮檺鐨勭敤鎴锋墽琛岋紱瀹為檯鏄�鍐呭�硅�剧疆閿欒��(鍖呭惈閿欒��鏌ヨ��锛屼緥濡傝��娉曢敊璇�)锛岃繖鏍蜂娇鎵�鏈夎繛鎺ュけ璐ャ�備笉涓�SUPER鐢ㄦ埛鎵ц�岋紝浣�SUPER鐢ㄦ埛鍙�浠ユ墦寮�杩炴帴骞跺浐瀹�init_connect銆�

路         init_file

鍚�鍔ㄦ湇鍔″櫒鏃剁敤--init-file閫夐」鎸囧畾鐨勬枃浠跺悕銆傛枃浠朵腑鍖呭惈鏈嶅姟鍣ㄥ惎鍔ㄦ椂瑕佹墽琛岀殑SQL璇�鍙ャ�傛瘡涓�璇�鍙ュ繀椤诲湪鍚屼竴琛屼腑骞朵笖涓嶈兘鍖呮嫭娉ㄩ噴銆�

路         init_slave

璇ュ彉閲忕被浼�init_connect锛屼絾鏄�姣忔��SQL绾跨▼鍚�鍔ㄦ椂浠庢湇鍔″櫒搴旀墽琛岃�ュ瓧绗︿覆銆傝�ュ瓧绗︿覆鐨勬牸寮忎笌init_connect鍙橀噺鐩稿悓銆�

路         innodb_xxx

InnoDB绯荤粺鍙橀噺鍒楀叆15.2.4鑺傦紝鈥淚nnoDB鍚�鍔ㄩ�夐」鈥�銆�

路         interactive_timeout

鏈嶅姟鍣ㄥ叧闂�浜や簰寮忚繛鎺ュ墠绛夊緟娲诲姩鐨勭�掓暟銆備氦浜掑紡瀹㈡埛绔�瀹氫箟涓哄湪mysql_real_connect()涓�浣跨敤CLIENT_INTERACTIVE閫夐」鐨勫�㈡埛绔�銆傚張瑙�wait_timeout銆�

路         join_buffer_size

鐢ㄤ簬瀹屽叏鑱旀帴鐨勭紦鍐插尯鐨勫ぇ灏�(褰撲笉浣跨敤绱㈠紩鐨勬椂鍊欎娇鐢ㄨ仈鎺ユ搷浣�)銆備竴鑸�鎯呭喌鑾峰緱蹇�閫熻仈鎺ョ殑鏈�濂芥柟娉曟槸娣诲姞绱㈠紩銆傚綋澧炲姞绱㈠紩鏃朵笉鍙�鑳介�氳繃澧炲姞join_buffer_size鍊兼潵鑾峰緱蹇�閫熷畬鍏ㄨ仈鎺ャ�傚皢涓轰袱涓�琛ㄤ箣闂寸殑姣忎釜瀹屽叏鑱旀帴鍒嗛厤鑱旀帴缂撳啿鍖恒�傚�逛簬澶氫釜琛ㄤ箣闂翠笉浣跨敤绱㈠紩鐨勫�嶆潅鑱旀帴锛岄渶瑕佸�氳仈鎺ョ紦鍐插尯銆�

路         key_buffer_size

MyISAM琛ㄧ殑绱㈠紩鍧楀垎閰嶄簡缂撳啿鍖猴紝鐢辨墍鏈夌嚎绋嬪叡浜�銆�key_buffer_size鏄�绱㈠紩鍧楃紦鍐插尯鐨勫ぇ灏忋�傞敭鍊肩紦鍐插尯鍗充负閿�鍊肩紦瀛樸��

key_buffer_size鐨勬渶澶у厑璁歌�惧畾鍊间负4GB銆傛湁鏁堟渶澶у�煎彲浠ユ洿灏忥紝鍙栧喅浜庡彲鐢ㄧ墿鐞�RAM鍜屾搷浣滅郴缁熸垨纭�浠跺钩鍙板己鍔犵殑姣忎釜杩涚▼鐨�RAM闄愬埗銆�

澧炲姞璇ュ�硷紝杈惧埌浣犲彲浠ユ彁渚涚殑鏇村ソ鐨勭储寮曞�勭悊(鎵�鏈夎�诲拰澶氫釜鍐欐搷浣�)銆傞�氬父涓轰富瑕佽繍琛�MySQL鐨勬満鍣ㄥ唴瀛樼殑25%銆備絾鏄�锛屽�傛灉浣犲皢璇ュ�艰�惧緱杩囧ぇ(渚嬪�傦紝澶т簬鎬诲唴瀛樼殑50%)锛岀郴缁熷皢杞�鎹�涓洪〉骞跺彉寰楁瀬鎱�銆�MySQL渚濊禆鎿嶄綔绯荤粺鏉ユ墽琛屾暟鎹�璇诲彇鏃剁殑鏂囦欢绯荤粺缂撳瓨锛屽洜姝や綘蹇呴』涓烘枃浠剁郴缁熺紦瀛樼暀涓�浜涚┖闂淬��

鍚屾椂鍐欏�氳�屾椂瑕佹兂閫熷害鏇村揩锛屽簲浣跨敤LOCK TABLES銆傚弬瑙�13.4.5鑺傦紝鈥淟OCK TABLES鍜孶NLOCK TABLES璇�娉曗��銆�

浣犲彲浠ラ�氳繃鎵ц��SHOW STATUS璇�鍙ュ苟妫�鏌�Key_read_requests銆�Key_reads銆�Key_write_requests鍜�Key_writes鐘舵�佸彉閲忔潵妫�鏌ラ敭鍊肩紦鍐插尯鐨勬�ц兘銆傚弬瑙�13.5.4鑺傦紝鈥淪HOW璇�娉曗��銆�

Key_reads/Key_read_requests姣斾緥涓�鑸�搴斿皬浜�0.01銆傚�傛灉浣犱娇鐢ㄦ洿鏂板拰鍒犻櫎锛�Key_writes/Key_write_requests姣斾緥閫氬父鎺ヨ繎1锛屼絾濡傛灉浣犳洿鏂版椂浼氬悓鏃跺奖鍝嶅埌澶氳�屾垨濡傛灉浣犳�ｄ娇鐢�DELAY_KEY_WRITE琛ㄩ�夐」锛屽彲鑳藉皬寰楀�氥��

鐢�key_buffer_size缁撳悎Key_blocks_unused鐘舵�佸彉閲忓拰缂撳啿鍖哄潡澶у皬锛屽彲浠ョ‘瀹氫娇鐢ㄧ殑閿�鍊肩紦鍐插尯鐨勬瘮渚嬨�備粠key_cache_block_size鏈嶅姟鍣ㄥ彉閲忓彲浠ヨ幏寰楃紦鍐插尯鍧楀ぇ灏忋�備娇鐢ㄧ殑缂撳啿鍖虹殑姣斾緥涓猴細

1 - ((Key_blocks_unused * key_cache_block_size) / key_buffer_size)

璇ュ�间负绾︽暟锛屽洜涓洪敭鍊肩紦鍐插尯鐨勯儴鍒嗙┖闂磋��鍒嗛厤鐢ㄤ綔鍐呴儴绠＄悊缁撴瀯銆�

鍙�浠ュ垱寤哄�氫釜MyISAM閿�鍊肩紦瀛樸��4GB闄愬埗鍙�浠ラ�傚悎姣忎釜缂撳瓨锛岃�屼笉鏄�涓�涓�缁勩�傚弬瑙�7.4.6鑺傦紝鈥淢yISAM閿�楂橀�熺紦鍐测��銆�

路         key_cache_age_threshold

璇ュ�兼帶鍒跺皢缂撳啿鍖轰粠閿�鍊肩紦瀛樼儹瀛愰摼(sub-chain)闄嶇骇鍒版俯瀛愰摼(sub-chain)銆傚�傛灉鍊兼洿浣庯紝鍒欓檷绾ф洿蹇�銆傛渶灏忓�间负100銆� 榛樿�ゅ�兼槸300銆傚弬瑙�7.4.6鑺傦紝鈥淢yISAM閿�楂橀�熺紦鍐测��銆�

路         key_cache_block_size

閿�鍊肩紦瀛樺唴鍧楃殑瀛楄妭澶у皬銆傞粯璁ゅ�兼槸1024銆傚弬瑙�7.4.6鑺傦紝鈥淢yISAM閿�楂橀�熺紦鍐测��銆�

路         key_cache_division_limit

閿�鍊肩紦瀛樼紦鍐插尯閾剧儹瀛愰摼鍜屾俯瀛愰摼鐨勫垝鍒嗙偣銆傝�ュ�间负缂撳啿鍖洪摼鐢ㄤ簬娓╁瓙閾剧殑鐧惧垎姣斻�傚厑璁哥殑鍊肩殑鑼冨洿涓�1鍒�100銆� 榛樿�ゅ�兼槸100銆傚弬瑙�7.4.6鑺傦紝鈥淢yISAM閿�楂橀�熺紦鍐测��銆�

路         language

閿欒��娑堟伅鎵�鐢ㄨ��瑷�銆�

路          large_file_support

mysqld缂栬瘧鏃舵槸鍚︿娇鐢ㄤ簡澶ф枃浠舵敮鎸侀�夐」銆�

路         large_pages

璇存槑鏄�鍚﹀惎鐢ㄤ簡澶ч〉闈㈡敮鎸併��

路         license

鏈嶅姟鍣ㄧ殑璁稿彲绫诲瀷銆�

路         local_infile

鏄�鍚�LOCAL鏀�鎸�LOAD DATA INFILE璇�鍙ャ��

路         locked_in_memory

鏄�鍚︾敤鈥�memlock灏�mysqld閿佸湪鍐呭瓨涓�銆�

路         log

鏄�鍚﹀惎鐢ㄥ皢鎵�鏈夋煡璇㈣�板綍鍒板父瑙勬煡璇㈡棩蹇椾腑銆傚弬瑙�5.11.2鑺傦紝鈥滈�氱敤鏌ヨ�㈡棩蹇椻��銆�

路         log_bin

鏄�鍚﹀惎鐢ㄤ簩杩涘埗鏃ュ織銆傚弬瑙�5.11.3鑺傦紝鈥滀簩杩涘埗鏃ュ織鈥�銆�

路         log_bin_trust_routine_creators

鑻ュ惎鐢ㄤ簡浜岃繘鍒惰�板綍锛屽垯璇ュ彉閲忛�傜敤銆傚畠鎺у埗鏄�鍚﹀彲浠ヤ俊浠讳繚瀛樼殑绋嬪簭鐨勪綔鑰呬笉浼氬垱寤哄悜浜岃繘鍒舵棩蹇楀啓鍏ヤ笉瀹夊叏浜嬩欢鐨勭▼搴忋�傚�傛灉璁剧疆涓�0(榛樿�ゆ儏鍐�)锛屼笉鍏佽�哥敤鎴峰垱寤烘垨淇�鏀逛繚瀛樼殑绋嬪簭锛岄櫎闈炰粬浠�涓嶄粎鎷ユ湁CREATE ROUTINE鎴�ALTER ROUTINE鏉冮檺杩樻嫢鏈�SUPER鏉冮檺銆�

璁剧疆涓�0杩樺己鍒堕檺鍒讹紝绋嬪簭蹇呴』鐢�DETERMINISTIC 鐗瑰緛鎴栫敤READS SQL DATA鎴�NO SQL鐗瑰緛澹版槑銆傚�傛灉鍙橀噺璁剧疆涓�1,MySQL涓嶅�逛繚瀛樼▼搴忕殑鍒涘缓寮哄姞闄愬埗銆�

鍙傝��20.4鑺傦紝鈥滃瓨鍌ㄥ瓙绋嬪簭鍜岃Е鍙戠▼搴忕殑浜岃繘鍒舵棩蹇楀姛鑳解��銆�

路         log_error

閿欒��鏃ュ織鐨勪綅缃�銆�

路         log_slave_updates

鏄�鍚︿粠鏈嶅姟鍣ㄤ粠涓绘湇鍔″櫒鏀跺埌鐨勬洿鏂板簲璁板叆浠庢湇鍔″櫒鑷�宸辩殑浜岃繘鍒舵棩蹇椼�傝�佹兂鐢熸晥锛屽繀椤诲惎鐢ㄤ粠鏈嶅姟鍣ㄧ殑浜岃繘鍒惰�板綍銆傚弬瑙�6.8鑺傦紝鈥滃�嶅埗鍚�鍔ㄩ�夐」鈥�銆�

路         log_slow_queries

鏄�鍚﹁�板綍鎱㈡煡璇�銆傜敤long_query_time鍙橀噺鐨勫�兼潵纭�瀹氣�滄參鏌ヨ�⑩�濄�傚弬瑙�5.11.4鑺傦紝鈥滄參閫熸煡璇㈡棩蹇椻��銆�

路         log_warnings

鏄�鍚︿骇鐢熷叾瀹冭�﹀憡娑堟伅銆傞粯璁ゆ儏鍐典笅鍚�鐢ㄣ�傛斁寮冪殑杩炴帴涓嶈�板叆閿欒��鏃ュ織锛岄櫎闈炲�煎ぇ浜�1銆�

路         long_query_time

濡傛灉鏌ヨ�㈡椂闂磋秴杩囪�ュ�硷紝鍒欏�炲姞Slow_queries鐘舵�佸彉閲忋�傚�傛灉浣犳�ｄ娇鐢�--log-slow-queries閫夐」锛屽垯鏌ヨ�㈣�板叆鎱㈡煡璇㈡棩蹇楁枃浠躲�傜敤瀹為檯鏃堕棿娴嬮噺璇ュ�硷紝鑰屼笉鏄�CPU鏃堕棿锛屽洜姝や綆浜庤交璐熻浇绯荤粺闃堝�肩殑鏌ヨ�㈠彲鑳借秴杩囬噸璐熻浇绯荤粺鐨勯槇鍊笺�傚弬瑙�5.11.4鑺傦紝鈥滄參閫熸煡璇㈡棩蹇椻��銆�

路         low_priority_updates

濡傛灉璁剧疆涓�1锛屾墍鏈�INSERT銆�UPDATE銆�DELETE鍜�LOCK TABLE WRITE璇�鍙ュ皢绛夊緟鐩村埌鍙楀奖鍝嶇殑琛ㄦ病鏈夋寕璧风殑SELECT鎴�LOCK TABLE READ銆傝�ュ彉閲忎互鍓嶅彨鍋�sql_low_priority_updates銆�

路         lower_case_file_system

璇ュ彉閲忚�存槑鏄�鍚︽暟鎹�鐩�褰曟墍鍦ㄧ殑鏂囦欢绯荤粺瀵规枃浠跺悕鐨勫ぇ灏忓啓鏁忔劅銆�ON璇存槑瀵规枃浠跺悕鐨勫ぇ灏忓啓涓嶆晱鎰燂紝OFF琛ㄧず鏁忔劅銆�

路           lower_case_table_names

濡傛灉璁剧疆涓�1,琛ㄥ悕鐢ㄥ皬鍐欎繚瀛樺埌纭�鐩樹笂锛屽苟涓旇〃鍚嶆瘮杈冩椂涓嶅�瑰ぇ灏忓啓鏁忔劅銆傚�傛灉璁剧疆涓�2锛屾寜鐓ф寚瀹氱殑淇濆瓨琛ㄥ悕锛屼絾鎸夌収灏忓啓鏉ユ瘮杈冦�傝�ラ�夐」杩橀�傚悎鏁版嵁搴撳悕鍜岃〃鐨勫埆鍚嶃�傚弬瑙�9.2.2鑺傦紝鈥滆瘑鍒�绗﹀ぇ灏忓啓鏁忔劅鎬р��銆�

濡傛灉浣犳�ｄ娇鐢�InnoDB琛�锛屼綘搴斿湪鎵�鏈夊钩鍙颁笂灏嗚�ュ彉閲忚�剧疆涓�1锛屽己鍒跺皢鍚嶅瓧杞�鎹�涓哄皬鍐欍��

濡傛灉杩愯��MySQL鐨勭郴缁熷�规枃浠跺悕鐨勫ぇ灏忓啓涓嶆晱鎰�(渚嬪��Windows鎴�Mac OS X)锛屼綘涓嶅簲灏嗚�ュ彉閲忚�剧疆涓�0銆傚�傛灉鍚�鍔ㄦ椂娌℃湁璁剧疆璇ュ彉閲忥紝骞朵笖鏁版嵁鐩�褰曟墍鍦ㄦ枃浠剁郴缁熷�规枃浠跺悕鐨勫ぇ灏忓啓涓嶆晱鎰燂紝MySQL鑷�鍔ㄥ皢lower_case_table_names璁剧疆涓�2銆�

路         max_allowed_packet

鍖呮垨浠讳綍鐢熸垚鐨�/涓�闂村瓧绗︿覆鐨勬渶澶уぇ灏忋��

鍖呮秷鎭�缂撳啿鍖哄垵濮嬪寲涓�net_buffer_length瀛楄妭锛屼絾闇�瑕佹椂鍙�浠ュ�為暱鍒�max_allowed_packet瀛楄妭銆傝�ュ�奸粯璁ゅ緢灏忥紝浠ユ崟鑾峰ぇ鐨�(鍙�鑳芥槸閿欒��鐨�)鏁版嵁鍖呫��

濡傛灉浣犱娇鐢ㄥぇ鐨�BLOB 鍒楁垨闀垮瓧绗︿覆锛屼綘蹇呴』澧炲姞璇ュ�笺�傚簲鍚屼綘鎯宠�佷娇鐢ㄧ殑鏈�澶х殑BLOB涓�鏍峰ぇ銆�max_allowed_packet鐨勫崗璁�闄愬埗涓�1GB銆�

路         max_binlog_cache_size

濡傛灉澶氳��鍙ヤ簨鍔￠渶瑕佹洿澶х殑鍐呭瓨锛屼綘浼氬緱鍒伴敊璇�Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage銆�

路         max_binlog_size

濡傛灉浜岃繘鍒舵棩蹇楀啓鍏ョ殑鍐呭�硅秴鍑虹粰瀹氬�硷紝鏃ュ織灏变細鍙戠敓婊氬姩銆備綘涓嶈兘灏嗚�ュ彉閲忚�剧疆涓哄ぇ浜�1GB鎴栧皬浜�4096瀛楄妭銆� 榛樿�ゅ�兼槸1GB銆�

璇锋敞鎰忓�傛灉浣犳�ｄ娇鐢ㄤ簨鍔★細浜嬪姟浠ヤ竴涓�鍧楀啓鍏ヤ簩杩涘埗鏃ュ織锛屽洜姝や笉涓嶈兘琚�鍑犱釜浜岃繘鍒舵棩蹇楁媶鍒嗐�傚洜姝わ紝濡傛灉浣犳湁澶х殑浜嬪姟锛屼簩杩涘埗鏃ュ織鍙�鑳戒細澶т簬max_binlog_size銆�

濡傛灉max_relay_log_size涓�0, max_binlog_size鐨勫�间篃閫傜敤浜庝腑缁ф棩蹇�銆�

路         max_connect_errors

濡傛灉涓�鏂�鐨勪笌涓绘満鐨勮繛鎺ヨ秴杩囪�ユ暟鐩�锛岃�ヤ富鏈哄垯闃诲�炲悗闈㈢殑杩炴帴銆備綘鍙�浠ョ敤 FLUSH HOSTS璇�鍙ヨВ閿侀攣瀹氱殑涓绘満銆�

路         max_connections

鍏佽�哥殑骞惰�屽�㈡埛绔�杩炴帴鏁扮洰銆傚�炲ぇ璇ュ�煎垯澧炲姞mysqld 闇�瑕佺殑鏂囦欢鎻忚堪绗︾殑鏁伴噺銆傚叧浜庢枃浠舵弿杩扮�﹂檺鍒剁殑娉ㄩ噴鍙傝��7.4.9鑺傦紝鈥淢ySQL濡備綍鎵撳紑鍜屽叧闂�琛ㄢ��銆傝繕鍙�鍙傝��A.2.6鑺傦紝鈥滆繛鎺ユ暟杩囧�氣��銆�

路         max_delayed_threads

涓嶈�佸惎鍔ㄥぇ浜庤�ユ暟鐩�鐨勭嚎绋嬫潵澶勭悊INSERT DELAYED璇�鍙ャ�傚�傛灉鎵�鏈�INSERT DELAYED绾跨▼宸茬粡鍦ㄤ娇鐢�锛屼綘鎯冲湪鏂拌〃涓�鎻掑叆鏁版嵁锛岃�� 鎻掑叆鏃跺ソ鍍忔湭鎸囧畾DELAYED灞炴�с�傚�傛灉浣犲皢璇ュ�艰�剧疆涓�0,MySQL涓嶄細鍒涘缓绾跨▼鏉ュ�勭悊DELAYED琛岋紱鍏剁粨鏋滄槸瀹屽叏绂佺敤浜�DELAYED銆�

路         max_error_count

淇濆瓨鐢�SHOW ERRORS鎴�SHOW WARNINGS鏄剧ず鐨勯敊璇�銆佽�﹀憡鍜屾敞瑙ｇ殑鏈�澶ф暟鐩�銆�

路         max_heap_table_size

璇ュ彉閲忚�剧疆MEMORY (HEAP)琛ㄥ彲浠ュ�為暱鍒扮殑鏈�澶х┖闂村ぇ灏忋�傝�ュ彉閲忕敤鏉ヨ�＄畻MEMORY琛ㄧ殑MAX_ROWS鍊笺�傚湪宸叉湁鐨�MEMORY琛ㄤ笂璁剧疆璇ュ彉閲忔病鏈夋晥鏋滐紝闄ら潪鐢�CREATE TABLE鎴�TRUNCATE TABLE绛夎��鍙ラ噸鏂板垱寤鸿〃銆�

路         max_insert_delayed_threads

璇ュ彉閲忎负max_delayed_threads鐨勫悓涔夎瘝銆�

路         max_join_size

涓嶅厑璁稿彲鑳介渶瑕佹��鏌ュ�氫簬max_join_size琛�(涓哄崟涓�琛ㄨ��鍙�)鎴栬�岀粍鍚�(涓哄�氫釜琛ㄨ��鍙�)鎴栧彲鑳芥墽琛屽ぇ浜�max_join_size娆＄‖鐩樻煡璇㈢殑SELECT璇�鍙ャ�傞�氳繃璁剧疆璇ュ�硷紝浣犲彲浠ユ崟鑾烽敭浣跨敤涓嶆�ｇ‘骞跺彲鑳借姳寰堥暱鏃堕棿鐨�SELECT璇�鍙ャ�傚�傛灉鐢ㄦ埛鎯宠�佹墽琛屾病鏈�WHERE瀛愬彞鐨勮姳杈冮暱鏃堕棿鎴栬繑鍥炴暟鐧句竾琛岀殑鑱旀帴锛屽垯璁剧疆瀹冦��

灏嗚�ュ彉閲忚�剧疆涓�DEFAULT涔嬪�栫殑鍊硷紝灏�SQL_BIG_SELECTS鐨勫�奸噸璁句负0銆�濡傛灉浣犻噸鏂拌�剧疆SQL_BIG_SELECTS鍊硷紝max_join_size鍙橀噺琚�蹇界暐銆�

濡傛灉鏌ヨ�㈢粨鏋滀綅浜庢煡璇㈢紦瀛樹腑锛屽垯涓嶆��鏌ョ粨鏋滃ぇ灏忥紝鍥犱负鍓嶉潰宸茬粡璁＄畻浜嗙粨鏋滐紝涓嶄細瑕佹眰鏈嶅姟鍣ㄥ皢瀹冨彂閫佺粰瀹㈡埛绔�銆�

璇ュ彉閲忎互鍓嶅彨鍋�sql_max_join_size銆�

路         max_length_for_sort_data

纭�瀹氫娇鐢ㄧ殑filesort绠楁硶鐨勭储寮曞�煎ぇ灏忕殑闄愬�笺�傚弬瑙�7.2.12鑺傦紝鈥淢ySQL濡備綍浼樺寲ORDER BY鈥�銆�

路         max_relay_log_size

濡傛灉澶嶅埗浠庢湇鍔″櫒鍐欏叆涓�缁ф棩蹇楁椂瓒呭嚭缁欏畾鍊硷紝鍒欐粴鍔ㄤ腑缁ф棩蹇椼�傞�氳繃璇ュ彉閲忎綘鍙�浠ュ�逛腑缁ф棩蹇楀拰浜岃繘鍒舵棩蹇楄�剧疆涓嶅悓鐨勯檺鍒躲�備絾鏄�锛屽皢璇ュ彉閲忚�剧疆涓�0锛�MySQL鍙�浠ュ�逛簩杩涘埗鏃ュ織鍜屼腑缁ф棩蹇椾娇鐢�max_binlog_size銆�max_relay_log_size蹇呴』璁剧疆鍦�4096瀛楄妭鍜�1GB(鍖呮嫭)涔嬮棿锛屾垨涓�0銆� 榛樿�ゅ�兼槸0銆傚弬瑙�6.3鑺傦紝鈥滃�嶅埗瀹炴柦缁嗚妭鈥�銆�

路         max_seeks_for_key

闄愬埗鏍规嵁閿�鍊煎�绘壘琛屾椂鐨勬渶澶ф悳绱㈡暟銆�MySQL浼樺寲鍣ㄥ亣瀹氬綋鐢ㄦ壂鎻忛敭鍦ㄨ〃鍐呮悳绱㈠尮閰嶇殑琛屾椂锛屼笉闇�瑕佽秴杩囪�ユ暟閲忕殑閿�鍊兼悳绱�锛岃�屼笉绠￠敭鐨勫疄闄呭熀鏁版槸浠�涔�(鍙傝��13.5.4.11鑺傦紝鈥淪HOW INDEX璇�娉曗��)銆傚皢璇ュ�艰�剧疆涓鸿緝浣庣殑鍊�(100?)锛屼綘鍙�浠ュ己鍒�MySQL閫夋嫨閿�鍊艰�屼笉閫夋嫨琛ㄦ壂鎻忋��

路         max_sort_length

褰撴帓搴�BLOB鎴�TEXT鍊兼椂浣跨敤鐨勫瓧鑺傛暟銆傚彧浣跨敤姣忎釜鍊肩殑鍓�max_sort_length瀛楄妭锛涘叾瀹冪殑琚�蹇界暐銆�

路         max_tmp_tables

瀹㈡埛绔�鍙�浠ュ悓鏃舵墦寮�鐨勪复鏃惰〃鐨勬渶澶ф暟銆�(浣嗚�ラ�夐」杩樻湭鐢熸晥锛�銆�

路         max_user_connections

浠讳綍缁欏畾鐨�MySQL璐︽埛鍏佽�哥殑鏈�澶у悓鏃惰繛鎺ユ暟銆�0鍊艰〃绀衡�滄病鏈�闄愬埗鈥濄��

璇ュ彉閲忓叿鏈夊叏灞�鑼冨洿鍜�(鍙�璇�)浼氳瘽鑼冨洿銆備細璇濆彉閲忕殑鐨勫�间笌鍏ㄥ眬鍙橀噺鐨勫�肩浉鍚岋紝闄ら潪褰撳墠璐︽埛鍏锋湁闈為浂MAX_USER_CONNECTIONS璧勬簮闄愬埗銆傚湪杩欑�嶆儏鍐典笅锛屼細璇濆�煎弽搴斾簡璐︽埛闄愬埗銆�

路         max_write_lock_count

瓒呰繃鍐欓攣瀹氶檺鍒跺悗锛屽厑璁搁儴鍒嗚�婚攣瀹氥��

路         myisam_data_pointer_size

榛樿�ゆ寚閽堝ぇ灏忥紝鍗曚綅鏄�瀛楄妭锛屽綋鏈�鎸囧畾MAX_ROWS閫夐」鏃讹紝CREATE TABLE浣跨敤璇ュ彉閲忓垱寤�MyISAM琛ㄣ�傝�ュ彉閲忎笉鑳藉皬浜�2鎴栧ぇ浜�7銆� 榛樿�ゅ�兼槸6銆傚弬瑙�A.2.11鑺傦紝鈥滆〃宸叉弧鈥�銆�

路         (DEPRECATED) myisam_max_extra_sort_file_size

娉�閲婏細MySQL 5.1涓嶆敮鎸佽�ュ彉閲忋�傝�︾粏淇℃伅鍙傝��MySQL 5.0 鍙傝�冩墜鍐�銆�

路         myisam_max_sort_file_size

閲嶅缓MyISAM绱㈠紩(鍦�REPAIR TABLE銆�ALTER TABLE鎴�LOAD DATA INFILE杩囩▼涓�)鏃讹紝鍏佽��MySQL浣跨敤鐨勪复鏃舵枃浠剁殑鏈�澶х┖闂村ぇ灏忋�傚�傛灉鏂囦欢鐨勫ぇ灏忚秴杩囪�ュ�硷紝鍒欎娇鐢ㄩ敭鍊肩紦瀛樺垱寤虹储寮曪紝瑕佹參寰楀�氥�傝�ュ�肩殑鍗曚綅涓哄瓧鑺傘��

路         myisam_recover_options

--myisam-recover閫夐」鐨勫�笺��

路         myisam_repair_threads

濡傛灉璇ュ�煎ぇ浜�1锛屽湪Repair by sorting杩囩▼涓�骞惰�屽垱寤�MyISAM琛ㄧ储寮�(姣忎釜绱㈠紩鍦ㄨ嚜宸辩殑绾跨▼鍐�)銆� 榛樿�ゅ�兼槸1銆�娉�閲婏細澶氱嚎绋嬬淮鎶や粛鐒舵槸alpha 缂栫爜銆�

路         myisam_sort_buffer_size

褰撳湪REPAIR TABLE鎴栫敤CREATE INDEX鍒涘缓绱㈠紩鎴�ALTER TABLE杩囩▼涓�鎺掑簭 MyISAM绱㈠紩鍒嗛厤鐨勭紦鍐插尯銆�

路         myisam_stats_method

褰撲负MyISAM琛ㄦ悳闆嗗叧浜庣储寮曞�煎垎鍙戠殑缁熻�′俊鎭�鏃舵湇鍔″櫒濡備綍澶勭悊NULL鍊笺�傝�ュ彉閲忔湁涓や釜鍙�鑳界殑鍊硷紝nulls_equal鍜�nulls_unequal銆傚�逛簬nulls_equal锛岃�や负鎵�鏈�NULL绱㈠紩鍊兼椂鐩哥瓑鐨勶紝骞跺舰鎴愪竴涓�鏁板�肩粍锛屽叾绌洪棿澶у皬绛変簬NULL鍊肩殑鏁般�傚�逛簬nulls_unequal锛�NULL鍊艰�や负鏄�涓嶇浉绛夌殑锛屾瘡涓�NULL褰㈡垚涓�涓�鏁板�肩粍锛屽ぇ灏忎负1銆�

鏂规硶鐢ㄤ簬鐢熸垚琛ㄧ粺璁′俊鎭�锛屽奖鍝嶄紭鍖栧櫒濡備綍閫夋嫨绱㈠紩鏉ユ墽琛屾煡璇�锛岃�︾粏鎻忚堪瑙�7.4.7鑺傦紝鈥淢yISAM绱㈠紩缁熻�￠泦鍚堚��銆�

路         multi_read_range

鎸囧畾鑼冨洿閫夋嫨杩囩▼涓�鍙戦�佸埌瀛樺偍寮曟搸鐨勮寖鍥寸殑鏈�澶у�笺�傞粯璁ゅ�兼槸256銆傚悜寮曟搸鍙戦�佸�氫釜鑼冨洿鍙�浠ュぇ澶ф敼杩涙煇浜涢�夋嫨鐨勬�ц兘锛岀壒鍒�鏄�瀵�NDBCLUSTER銆傝�ュ紩鎿庨渶瑕佸悜鎵�鏈夎妭鐐瑰彂閫佽寖鍥磋�锋眰锛屽悓鏃跺彂閫佽�稿�氳�锋眰鍙�浠ュぇ澶ч檷浣庨�氫俊鎴愭湰銆�

路         named_pipe

(鍙�閫傜敤Windows)璇存槑鏈嶅姟鍣ㄦ槸鍚︽敮鎸佸懡鍚嶇�￠亾杩炴帴銆�

路         net_buffer_length

鍦ㄦ煡璇�涔嬮棿灏嗛�氫俊缂撳啿鍖洪噸璁句负璇ュ�笺�備竴鑸�鎯呭喌涓嶅簲鏀瑰彉锛屼絾濡傛灉鍐呭瓨寰堝皬锛屽彲浠ュ皢瀹冭�剧疆涓烘湡鏈涚殑瀹㈡埛绔�鍙戦�佺殑SQL璇�鍙ョ殑闀垮害銆傚�傛灉璇�鍙ヨ秴鍑鸿�ラ暱搴︼紝缂撳啿鍖鸿嚜鍔ㄦ墿澶э紝鐩村埌max_allowed_packet瀛楄妭銆�

路         net_read_timeout

涓�鏂�璇诲墠绛夊緟杩炴帴鐨勫叾瀹冩暟鎹�鐨勭�掓暟銆傚綋鏈嶅姟鍣ㄤ粠瀹㈡埛绔�璇绘暟鏃讹紝net_read_timeout鎸囨帶鍒朵綍鏃朵腑鏂�鐨勮秴鏃跺�笺�傚綋鏈嶅姟鍣ㄥ悜瀹㈡埛绔�鍐欐椂锛�net_write_timeout鎸囨帶鍒朵綍鏃朵腑鏂�鐨勮秴鏃跺�笺�傚張瑙�slave_net_timeout銆�

路         net_retry_count

濡傛灉鏌愪釜閫氫俊绔�鍙ｇ殑璇绘搷浣滀腑鏂�浜嗭紝鍦ㄦ斁寮冨墠閲嶈瘯澶氭�°�傚湪FreeBSD涓�璇ュ�煎簲璁惧緱寰堥珮锛屽洜涓哄唴閮ㄤ腑鏂�灏嗗彂閫佽嚦鎵�鏈夌嚎绋嬨��

路         net_write_timeout

涓�鏂�鍐欎箣鍓嶇瓑寰呭潡鍐欏叆杩炴帴鐨勭�掓暟銆傚張瑙�net_read_timeout銆�

路         new

鍦�MySQL 4.0涓�浣跨敤璇ュ彉閲忔潵鎵撳紑4.1涓�鐨勪竴浜涜�屼负锛屽苟鐢ㄤ簬鍚戝悗鍏煎�规�с�傚湪MySQL 5.1涓�,瀹冪殑鍊间竴鐩存槸OFF.

路         old_passwords

鏄�鍚︽湇鍔″櫒搴斾负MySQL鐢ㄦ埛璐︽埛浣跨敤pre-4.1-style瀵嗙爜銆傚弬瑙�A.2.3鑺傦紝鈥滃�㈡埛绔�涓嶆敮鎸侀壌瀹氬崗璁�鈥�銆�

路         one_shot

杩欎笉鏄�涓�涓�鍙橀噺锛屼絾褰撹�剧疆鍙橀噺鏄�鍙�浠ヤ娇鐢ㄥ畠銆傚叾鎻忚堪瑙�13.5.3鑺傦紝鈥淪ET璇�娉曗��銆�

路         one_shot

杩欎笉鏄�涓�涓�鍙橀噺锛屼絾褰撹�剧疆鍙橀噺鏄�鍙�浠ヤ娇鐢ㄥ畠銆傚叾鎻忚堪瑙�13.5.3鑺傦紝鈥淪ET璇�娉曗��銆�

路         open_files_limit

鎿嶄綔绯荤粺鍏佽��mysqld鎵撳紑鐨勬枃浠剁殑鏁伴噺銆傝繖鏄�绯荤粺鍏佽�哥殑瀹為檯鍊硷紝鍙�鑳戒笌浣犲湪鍚�鍔ㄩ�夐」涓�璧嬬粰mysqld鐨勫�间笉鍚屻�傝嫢鍦ㄧ郴缁熶腑MySQL涓嶈兘鏇存敼鎵撳紑鐨勬枃浠剁殑鏁伴噺锛屽垯璇ュ�间负0銆�

路         optimizer_prune_level

鍦ㄦ煡璇�浼樺寲浠庝紭鍖栧櫒鎼滅储绌洪棿瑁佸噺浣庡笇鏈涘眬閮ㄨ�″垝涓�浣跨敤鐨勬帶鍒舵柟娉曘��0鍊肩�佺敤璇ユ柟娉曪紝浠ヤ究浼樺寲鍣ㄨ繘琛岀┓涓炬悳绱�銆傚�间负1浣夸紭鍖栧櫒鏍规嵁涓�闂存柟妗堜腑寰楀嚭鐨勮�屾暟鏉ヨ�佸噺鏂规�堛��

路         optimizer_search_depth

鏌ヨ��浼樺寲鍣ㄨ繘琛岀殑鎼滅储鐨勬渶澶ф繁搴︺�傚�傛灉鍊煎ぇ浜庢煡璇�涓�鐨勫叧绯绘暟鍒欐煡璇㈡柟妗堟瘮杈冧匠锛屼絾鐢熸垚鏌ヨ�㈡墽琛屾柟妗堥渶瑕佺殑鏃堕棿鏇撮暱銆傚�煎ぇ浜庢煡璇�涓�鐨勫叧绯绘暟鍒欒繑鍥炵殑鎵ц�屾柟妗堟洿蹇�锛屼絾鏂规�堣繙娌℃湁浼樺寲銆傚�傛灉璁剧疆涓�0, 绯荤粺鑷�鍔ㄩ�夋嫨鍚堢悊鐨勫�笺�傚�傛灉璁剧疆涓烘煡璇�涓�浣跨敤鐨勮〃鐨勬渶澶ф暟鍔�2,浼樺寲鍣ㄨ浆鎹�涓�MySQL 5.0.0(鍜屼互鍓嶇殑鐗堟湰)涓�浣跨敤鐨勭畻娉曞苟鎼滅储銆�

路         pid_file

杩涚▼ID (PID)鏂囦欢鐨勮矾寰勫悕銆傚彲浠ョ敤--pid-file閫夐」璁剧疆璇ュ彉閲忋��

路         plugin_dir

鎻掍欢鐩�褰曠殑璺�寰勩�傚湪MySQL 5.1.2涓�鍔犲叆浜嗚�ュ彉閲忋��

路         port

鏈嶅姟鍣ㄥ抚鍚�TCP/IP杩炴帴鎵�鐢ㄧ��鍙ｃ�傚彲浠ョ敤--port閫夐」璁剧疆璇ュ彉閲忋��

路         preload_buffer_size

閲嶈浇绱㈠紩鏃跺垎閰嶇殑缂撳啿鍖哄ぇ灏忋��

路         protocol_version

MySQL鏈嶅姟鍣ㄤ娇鐢ㄧ殑瀹㈡埛绔�/鏈嶅姟鍣ㄥ崗璁�鐨勭増鏈�銆�

路         query_alloc_block_size

涓烘煡璇㈠垎鏋愬拰鎵ц�岃繃绋嬩腑鍒涘缓鐨勫�硅薄鍒嗛厤鐨勫唴瀛樺潡澶у皬銆傚�傛灉鍐呭瓨鍒嗘�佃繃绋嬩腑閬囧埌闂�棰橈紝灏嗚�ュ彉閲忓�炲姞涓�浣嶄細鏈夊府鍔┿��

路         query_cache_limit

涓嶈�佺紦瀛樺ぇ浜庤�ュ�肩殑缁撴灉銆傞粯璁ゅ�兼槸1048576(1MB)銆�

路         query_cache_min_res_unit

鏌ヨ�㈢紦瀛樺垎閰嶇殑鏈�灏忓潡鐨勫ぇ灏�(瀛楄妭)銆� 榛樿�ゅ�兼槸4096(4KB)銆傚叧浜庤�ュ彉閲忕殑璋冭妭淇℃伅鍙傝��5.13.3鑺傦紝鈥滄煡璇㈤珮閫熺紦鍐查厤缃�鈥�銆�

路         query_cache_size

涓虹紦瀛樻煡璇㈢粨鏋滃垎閰嶇殑鍐呭瓨鐨勬暟閲忋�傞粯璁ゅ�兼槸0锛屽嵆绂佺敤鏌ヨ�㈢紦瀛樸�傝�锋敞鎰忓嵆浣�query_cache_type璁剧疆涓�0涔熷皢鍒嗛厤姝ゆ暟閲忕殑鍐呭瓨銆傝�︾粏淇℃伅鍙傝��5.13.3鑺傦紝鈥滄煡璇㈤珮閫熺紦鍐查厤缃�鈥�銆�

路         query_cache_type

璁剧疆鏌ヨ�㈢紦瀛樼被鍨嬨�傝�剧疆GLOBAL鍊煎彲浠ヨ�剧疆鍚庨潰鐨勬墍鏈夊�㈡埛绔�杩炴帴鐨勭被鍨嬨�傚�㈡埛绔�鍙�浠ヨ�剧疆SESSION鍊间互褰卞搷浠栦滑鑷�宸卞�规煡璇㈢紦瀛樼殑浣跨敤銆備笅闈㈢殑琛ㄦ樉绀轰簡鍙�鑳界殑鍊硷細

閫夐」	鎻忚堪
0鎴�OFF	涓嶈�佺紦瀛樻垨鏌ヨ�㈢粨鏋溿�傝�锋敞鎰忚繖鏍蜂笉浼氬彇娑堝垎閰嶇殑鏌ヨ�㈢紦瀛樺尯銆傝�佹兂鍙栨秷锛屼綘搴斿皢query_cache_size璁剧疆涓�0銆�
1鎴�ON	缂撳瓨闄や簡浠�SELECT SQL_NO_CACHE寮�澶寸殑鎵�鏈夋煡璇㈢粨鏋溿��
2鎴�DEMAND	鍙�缂撳瓨浠�SELECT SQL_NO_CACHE寮�澶寸殑鏌ヨ�㈢粨鏋溿��

璇ュ彉閲忛粯璁よ�句负ON銆�

路         query_cache_wlock_invalidate

涓�鑸�鎯呭喌锛屽綋瀹㈡埛绔�瀵�MyISAM琛ㄨ繘琛�WRITE閿佸畾鏃讹紝濡傛灉鏌ヨ�㈢粨鏋滀綅浜庢煡璇㈢紦瀛樹腑锛屽垯鍏跺畠瀹㈡埛绔�鏈�琚�閿佸畾锛屽彲浠ュ�硅�ヨ〃杩涜�屾煡璇�銆傚皢璇ュ彉閲忚�剧疆涓�1锛屽垯鍙�浠ュ�硅〃杩涜��WRITE閿佸畾锛屼娇鏌ヨ�㈢紦瀛樺唴鎵�鏈夊�硅�ヨ〃杩涜�岀殑鏌ヨ�㈠彉寰楅潪娉曘�傝繖鏍峰綋閿佸畾鐢熸晥鏃讹紝鍙�浠ュ己鍒跺叾瀹冭瘯鍥捐�块棶琛ㄧ殑瀹㈡埛绔�鏉ョ瓑寰呫��

路         query_prealloc_size

鐢ㄤ簬鏌ヨ�㈠垎鏋愬拰鎵ц�岀殑鍥哄畾缂撳啿鍖虹殑澶у皬銆傚湪鏌ヨ��涔嬮棿璇ョ紦鍐插尯涓嶉噴鏀俱�傚�傛灉浣犳墽琛屽�嶆潅鏌ヨ��锛屽垎閰嶆洿澶х殑query_prealloc_size鍊煎彲浠ュ府鍔╂彁楂樻�ц兘锛屽洜涓哄畠鍙�浠ラ檷浣庢煡璇㈣繃绋嬩腑鏈嶅姟鍣ㄥ垎閰嶅唴瀛樼殑闇�姹傘��

路         range_alloc_block_size

鑼冨洿浼樺寲鏃跺垎閰嶇殑鍧楃殑澶у皬銆�

路         read_buffer_size

姣忎釜绾跨▼杩炵画鎵�鎻忔椂涓烘壂鎻忕殑姣忎釜琛ㄥ垎閰嶇殑缂撳啿鍖虹殑澶у皬(瀛楄妭)銆傚�傛灉杩涜�屽�氭�¤繛缁�鎵�鎻忥紝鍙�鑳介渶瑕佸�炲姞璇ュ�硷紝 榛樿�ゅ�间负131072銆�

路         read_only

褰撳彉閲忓�瑰�嶅埗浠庢湇鍔″櫒璁剧疆涓�ON鏃讹紝浠庢湇鍔″櫒涓嶅厑璁告洿鏂帮紝闄ら潪閫氳繃浠庢湇鍔″櫒鐨勭嚎绋嬫垨鐢ㄦ埛鎷ユ湁SUPER鏉冮檺銆傚彲浠ョ‘淇濅粠鏈嶅姟鍣ㄤ笉鎺ュ彈瀹㈡埛绔�鐨勬洿鏂板懡浠ゃ��

路         relay_log_purge

褰撲笉鍐嶉渶瑕佷腑缁ф棩蹇楁椂绂佺敤鎴栧惎鐢ㄨ嚜鍔ㄦ竻绌轰腑缁ф棩蹇椼�傞粯璁ゅ�兼槸1(鍚�鐢�)銆�

路         read_rnd_buffer_size

褰撴帓搴忓悗鎸夋帓搴忓悗鐨勯『搴忚�诲彇琛屾椂锛屽垯閫氳繃璇ョ紦鍐插尯璇诲彇琛岋紝閬垮厤鎼滅储纭�鐩樸�傚皢璇ュ彉閲忚�剧疆涓鸿緝澶х殑鍊煎彲浠ュぇ澶ф敼杩�ORDER BY鐨勬�ц兘銆備絾鏄�锛岃繖鏄�涓烘瘡涓�瀹㈡埛绔�鍒嗛厤鐨勭紦鍐插尯锛屽洜姝や綘涓嶅簲灏嗗叏灞�鍙橀噺璁剧疆涓鸿緝澶х殑鍊笺�傜浉鍙嶏紝鍙�涓洪渶瑕佽繍琛屽ぇ鏌ヨ�㈢殑瀹㈡埛绔�鏇存敼浼氳瘽鍙橀噺銆�

路         secure_auth

濡傛灉鐢�--secure-auth閫夐」鍚�鍔ㄤ簡MySQL鏈嶅姟鍣�锛屽畠灏嗛樆濉炴湁鏃ф牸寮�(4.1涔嬪墠)瀵嗙爜鐨勬墍鏈夎处鎴锋墍鍙戣捣鐨勮繛鎺ャ�傚湪杩欑�嶆儏鍐典笅锛岃�ュ彉閲忕殑鍊间负ON锛屽惁鍒欎负OFF銆�

濡傛灉浣犳兂瑕侀槻姝�浣跨敤鏃ф牸寮忕殑瀵嗙爜(鑷翠娇缃戠粶閫氫俊涓嶅畨鍏�)锛屼綘搴斿惎鐢ㄨ�ラ�夐」銆�

濡傛灉鍚�鐢ㄨ�ラ�夐」骞朵笖鎺堟潈琛ㄤ负pre-4.1鏍煎紡锛屾湇鍔″櫒鍚�鍔ㄥけ璐ュ苟涓斾細鍑虹幇閿欒��銆傚弬瑙�A.2.3鑺傦紝鈥滃�㈡埛绔�涓嶆敮鎸侀壌瀹氬崗璁�鈥�銆�

褰撶敤浜庡�㈡埛绔�閫夐」鏃讹紝濡傛灉鏈嶅姟鍣ㄩ渶瑕佽�ュ�㈡埛绔�璐︽埛鐨勬棫鏍煎紡鐨勫瘑鐮侊紝鍒欏�㈡埛绔�鎷掔粷杩炴帴璇ユ湇鍔″櫒銆�

路         server_id

--server-id閫夐」鐨勫�笺�傜敤浜庝富澶嶅埗鏈嶅姟鍣ㄥ拰浠庡�嶅埗鏈嶅姟鍣ㄣ��

路         shared_memory

(鍙�鐢ㄤ簬Windows)鏈嶅姟鍣ㄦ槸鍚﹀厑璁稿叡浜�鍐呭瓨杩炴帴銆�

路         shared_memory_base_name

(鍙�鐢ㄤ簬Windows)璇存槑鏈嶅姟鍣ㄦ槸鍚﹀厑璁稿叡浜�鍐呭瓨杩炴帴锛屽苟涓哄叡浜�鍐呭瓨璁剧疆璇嗗埆绗︺�傚綋鍦ㄥ崟鍙版満鍣ㄤ笂杩愯�屽�氫釜MySQL瀹炰緥鏃跺緢鏈夌敤銆�

路         skip_external_locking

濡傛灉mysqld浣跨敤澶栭儴閿佸畾锛岃�ュ�间负OFF銆�

路         skip_networking

濡傛灉鏈嶅姟鍣ㄥ彧鍏佽�告湰鍦�(闈�TCP/IP)杩炴帴锛岃�ュ�间负ON銆傚湪Unix涓�锛屾湰鍦拌繛鎺ヤ娇鐢�Unix濂楁帴瀛楁枃浠躲�傚湪Windows涓�锛屾湰鍦拌繛鎺ヤ娇鐢ㄥ懡鍚嶇�￠亾鎴栧叡浜�鍐呭瓨銆傚湪NetWare涓�锛屽彧鏀�鎸�TCP/IP杩炴帴锛屽洜姝や笉瑕佸皢璇ュ彉閲忚�剧疆涓�ON銆�

路         skip_show_database

闃叉��涓嶅叿鏈�SHOW DATABASES鏉冮檺鐨勪汉浠�浣跨敤SHOW DATABASES璇�鍙ャ�傚�傛灉浣犳媴蹇冪敤鎴疯兘澶熺湅瑙佸睘浜庡叾瀹冪敤鎴风殑鏁版嵁搴擄紝杩欐牱璁剧疆鍙�浠ユ彁楂樺畨鍏ㄦ�с�傚叾鏁堟灉鍙栧喅浜�SHOW DATABASES鏉冮檺锛氬�傛灉鍙橀噺鍊间负ON锛屽彧鍏佽�稿叿鏈�SHOW DATABASES鏉冮檺鐨勪汉浠�浣跨敤SHOW DATABASES 璇�鍙ワ紝骞朵笖璇ヨ��鍙ュ皢鏄剧ず鎵�鏈夋暟鎹�搴撳悕銆傚�傛灉鍊间负OFF锛屽厑璁告墍鏈夌敤鎴锋墽琛�SHOW DATABASES锛屼絾鍙�鏄剧ず鐢ㄦ埛鍏锋湁SHOW DATABASES鎴栧叾瀹冩潈闄愮殑鏁版嵁搴撶殑鍚嶇О銆�

路         slave_compressed_protocol

濡傛灉涓汇�佷粠鏈嶅姟鍣ㄥ潎鏀�鎸侊紝纭�瀹氭槸鍚︿娇鐢ㄤ粠/涓诲帇缂╁崗璁�銆�

路         slave_load_tmpdir

浠庢湇鍔″櫒涓哄�嶅埗LOAD DATA INFILE璇�鍙ュ垱寤轰复鏃舵枃浠剁殑鐩�褰曞悕銆�

路         slave_net_timeout

鏀惧純璇绘搷浣滃墠绛夊緟涓�/浠庤繛鎺ョ殑鏇村�氭暟鎹�鐨勭瓑寰呯�掓暟銆�

路         slave_skip_errors

浠庢湇鍔″櫒搴旇烦杩�(蹇借��)鐨勫�嶅埗閿欒��銆�

路         slave_transaction_retries

濡傛灉鐢变簬ofInnoDB姝婚攣鎴栬秴杩�InnoDB鐨�innodb_lock_wait_timeout鎴�NDBCLUSTER鐨�TransactionDeadlockDetectionTimeout鎴�TransactionInactiveTimeout锛�澶嶅埗浠庢湇鍔″櫒SQL绾跨▼鏈�鑳芥墽琛屼簨鍔★紝鍦ㄦ彁绀洪敊璇�骞跺仠姝㈠墠瀹冭嚜鍔ㄩ噸澶�slave_transaction_retries娆°�� 榛樿�ゅ�兼槸10銆�

路         slow_launch_time

濡傛灉鍒涘缓绾跨▼鐨勬椂闂磋秴杩囪�ョ�掓暟锛屾湇鍔″櫒澧炲姞Slow_launch_threads鐘舵�佸彉閲忋��

路         socket

Unix骞冲彴锛氱敤浜庢湰鍦板�㈡埛绔�杩炴帴鐨勫�楁帴瀛楁枃浠躲�傞粯璁や负/var/lib/mysql/mysql.sock銆�

Windows锛氱敤浜庢湰鍦板�㈡埛绔�杩炴帴鐨勫懡鍚嶇�￠亾鍚嶃�傞粯璁や负mysql銆�

路         sort_buffer_size

姣忎釜鎺掑簭绾跨▼鍒嗛厤鐨勭紦鍐插尯鐨勫ぇ灏忋�傚�炲姞璇ュ�煎彲浠ュ姞蹇�ORDER BY鎴�GROUP BY鎿嶄綔銆傚弬瑙�A.4.4鑺傦紝鈥淢ySQL灏嗕复鏃舵枃浠跺偍瀛樺湪鍝�閲屸��銆�

路         sql_mode

褰撳墠鐨勬湇鍔″櫒SQL妯″紡锛屽彲浠ュ姩鎬佽�剧疆銆傚弬瑙�5.3.2鑺傦紝鈥淪QL鏈嶅姟鍣ㄦā寮忊��銆�

路         sql_slave_skip_counter

浠庢湇鍔″櫒搴旇烦杩囩殑鏉ヨ嚜涓绘湇鍔″櫒鐨勪簨浠舵暟銆�

路         storage_engine

璇ュ彉閲忔槸table_typeis鐨勫悓涔夎瘝銆傚湪MySQL 5.1涓�,棣栭��storage_engine銆�

路         sync_binlog

濡傛灉涓烘�ｏ紝褰撴瘡涓�sync_binlog'th鍐欏叆璇ヤ簩杩涘埗鏃ュ織鍚庯紝MySQL鏈嶅姟鍣ㄥ皢瀹冪殑浜岃繘鍒舵棩蹇楀悓姝ュ埌纭�鐩樹笂(fdatasync())銆傝�锋敞鎰忓�傛灉鍦�autocommit妯″紡锛屾瘡鎵ц�屼竴涓�璇�鍙ュ悜浜岃繘鍒舵棩蹇楀啓鍏ヤ竴娆★紝鍚﹀垯姣忎釜浜嬪姟鍐欏叆涓�娆°�� 榛樿�ゅ�兼槸0锛屼笉涓庣‖鐩樺悓姝ャ�傚�间负1鏄�鏈�瀹夊叏鐨勯�夋嫨锛屽洜涓哄穿婧冩椂锛屼綘鏈�澶氫涪鎺変簩杩涘埗鏃ュ織涓�鐨勪竴涓�璇�鍙�/浜嬪姟锛涗絾鏄�锛岃繖鏄�鏈�鎱㈢殑閫夋嫨(闄ら潪纭�鐩樻湁鐢垫睜澶囦唤缂撳瓨锛屼粠鑰屼娇鍚屾�ュ伐浣滆緝蹇�)銆�

路         sync_frm

濡傛灉璇ュ彉閲忚�句负1,褰撳垱寤洪潪涓存椂琛ㄦ椂瀹冪殑.frm鏂囦欢琚�鍚屾�ュ埌纭�鐩樹笂(fdatasync())锛涜繖鏍疯緝鎱�浣嗗嚭鐜板穿婧冩椂杈冨畨鍏ㄣ�� 榛樿�ゅ�间负1銆�

路         system_time_zone

鏈嶅姟鍣ㄧ郴缁熸椂鍖恒�傚綋 鏈嶅姟鍣ㄥ紑濮嬫墽琛屾椂锛屽畠缁ф壙鏈哄櫒榛樿�ゆ椂鍖鸿�剧疆鍊硷紝鍙�浠ョ敱杩愯�屾湇鍔″櫒鐨勮处鎴锋垨鍦ㄥ惎鍔ㄨ剼鏈�涓�杩涜�屼慨鏀广�傝�ュ�肩敤鏉ヨ�剧疆system_time_zone銆傚吀鍨嬫儏鍐电敤TZ鐜�澧冨彉閲忔潵鎸囧畾鏃跺尯銆傝繕鍙�浠ョ敤mysqld_safe鑴氭湰鐨�--timez閫夐」鏉ユ寚瀹氥��

路         table_cache

鎵�鏈夌嚎绋嬫墦寮�鐨勮〃鐨勬暟鐩�銆傚�炲ぇ璇ュ�煎彲浠ュ�炲姞mysqld闇�瑕佺殑鏂囦欢鎻忚堪绗︾殑鏁伴噺銆備綘鍙�浠ユ��鏌�Opened_tables鐘舵�佸彉閲忔潵妫�鏌ヤ綘鏄�鍚﹂渶瑕佸�炲姞琛ㄧ紦瀛樸�傚弬瑙�5.3.4鑺傦紝鈥滄湇鍔″櫒鐘舵�佸彉閲忊��銆傚�傛灉Opened_tables鍊艰緝澶э紝骞朵笖澶氭�℃墽琛�FLUSH TABLES(鍙�鏄�寮哄埗鍏抽棴鎵�鏈夎〃骞堕噸鏂�)锛屽垯搴斿�炲姞table_cache鍙橀噺鐨勫�笺��

鍏充簬琛ㄧ紦瀛樼殑璇︾粏淇℃伅锛屽弬瑙�7.4.9鑺傦紝鈥淢ySQL濡備綍鎵撳紑鍜屽叧闂�琛ㄢ��銆�

路         table_type

榛樿�よ〃绫诲瀷(瀛樺偍寮曟搸)銆傝�佹兂鍦ㄦ湇鍔″櫒鍚�鍔ㄦ椂璁剧疆琛ㄧ被鍨嬶紝浣跨敤--default-table-type閫夐」銆傚弬瑙�5.3.1鑺傦紝鈥�mysqld鍛戒护琛岄�夐」鈥�銆�

路         thread_cache_size

鏈嶅姟鍣ㄥ簲缂撳瓨澶氬皯绾跨▼浠ヤ究閲嶆柊浣跨敤銆傚綋瀹㈡埛绔�鏂�寮�杩炴帴鏃讹紝濡傛灉绾跨▼灏戜簬thread_cache_size锛屽垯瀹㈡埛绔�鐨勭嚎绋嬭��鏀惧叆缂撳瓨銆傚綋璇锋眰绾跨▼鏃跺�傛灉鍏佽�稿彲浠ヤ粠缂撳瓨涓�閲嶆柊鍒╃敤绾跨▼锛屽苟涓斿彧鏈夊綋缂撳瓨绌轰簡鏃舵墠浼氬垱寤烘柊绾跨▼銆傚�傛灉鏂拌繛鎺ュ緢澶氾紝鍙�浠ュ�炲姞璇ュ彉閲忎互鎻愰珮鎬ц兘銆�(涓�鑸�鎯呭喌锛屽�傛灉绾跨▼鎵ц�屽緱寰堝ソ锛屾�ц兘鎻愰珮涓嶆槑鏄�)銆傛��鏌�Connections鍜�Threads_created鐘舵�佸彉閲忕殑宸�(璇﹁��5.3.4鑺傦紝鈥滄湇鍔″櫒鐘舵�佸彉閲忊��)锛屼綘鍙�浠ョ湅瑙佺嚎绋嬬紦瀛樼殑鏁堢巼銆�

路         thread_concurrency

鍦�Solaris涓�锛�mysqld鐢ㄨ�ュ�艰皟鐢�thr_setconcurrency()銆傝�ュ嚱鏁颁娇搴旂敤绋嬪簭鍚戠嚎绋嬬郴缁熸彁渚涢渶瑕佸悓鏃惰繍琛岀殑鏈熸湜鐨勭嚎绋嬫暟鐩�鐨勬彁绀恒��

路         thread_stack

姣忎釜绾跨▼鐨勫爢鏍堝ぇ灏忋�傜敤crash-me娴嬭瘯妫�娴嬪嚭鐨勮�稿�氶檺鍒跺彇鍐充簬璇ュ�笺�� 榛樿�ゅ�艰冻澶熷ぇ锛屽彲浠ユ弧瓒虫櫘閫氭搷浣溿�傚弬瑙�7.1.4鑺傦紝鈥淢ySQL鍩哄噯濂椾欢鈥�銆�

路         time_format

璇ュ彉閲忎负浣跨敤銆�

路         time_zone

褰撳墠鐨勬椂鍖恒�傚垵浣垮�兼槸'SYSTEM'(浣跨敤system_time_zone鐨勫��)锛屼絾鍙�浠ョ敤--default-time-zone閫夐」鍦ㄦ湇鍔″櫒鍚�鍔ㄦ椂鏄惧紡鎸囧畾銆�

路         tmp_table_size

濡傛灉鍐呭瓨鍐呯殑涓存椂琛ㄨ秴杩囪�ュ�硷紝MySQL鑷�鍔ㄥ皢瀹冭浆鎹�涓虹‖鐩樹笂鐨�MyISAM琛ㄣ�傚�傛灉浣犳墽琛岃�稿�氶珮绾�GROUP BY鏌ヨ�㈠苟涓旀湁澶ч噺鍐呭瓨锛屽垯鍙�浠ュ�炲姞tmp_table_size鐨勫�笺��

路         tmpdir

淇濆瓨涓存椂鏂囦欢鍜屼复鏃惰〃鐨勭洰褰曘�傝�ュ彉閲忓彲浠ヨ�剧疆涓哄嚑涓�璺�寰勶紝鎸�round-robin妯″紡浣跨敤銆傚湪Unix涓�搴旇�ョ敤鍐掑彿(鈥�:鈥�)闂撮殧寮�璺�寰勶紝鍦�Windows銆�NetWare鍜�OS/2涓�鐢ㄥ垎鍙�(鈥�锛�鈥�)銆�

鐢ㄦ潵灏嗚礋鑽峰垎鏁ｅ埌鍑犱釜鐗╃悊纭�鐩樹笂銆傚�傛灉MySQL鏈嶅姟鍣ㄤ负澶嶅埗浠庢湇鍔″櫒锛屼綘涓嶅簲灏�tmpdir璁剧疆涓烘寚鍚戝熀浜庡唴瀛樼殑鏂囦欢绯荤粺涓婄殑鐩�褰曟垨褰撴湇鍔″櫒涓绘満閲嶅惎鏃跺０鏄庣殑鐩�褰曘�傚�嶅埗浠庢湇鍔″櫒闇�瑕侀儴鍒嗕复鏃舵枃浠舵潵鍦ㄦ満鍣ㄩ噸鍚�鍚庝粛鍙�鐢�锛屼互渚垮畠鍙�浠ュ�嶅埗涓存椂琛ㄦ垨鎵ц��LOAD DATA INFILE鎿嶄綔銆傚�傛灉鏈嶅姟鍣ㄩ噸鍚�鏃朵复鏃舵枃浠跺す涓�鐨勬枃浠朵涪澶变簡锛屽垯澶嶅埗澶辫触銆備絾鏄�锛屽�傛灉浣犱娇鐢�MySQL 4.0.0鎴栨洿鏂扮増鏈�锛屼綘鍙�浠ヤ娇鐢� slave_load_tmpdir鍙橀噺璁剧疆浠庢湇鍔″櫒鐨勪复鏃剁洰褰曘�傚湪杩欑�嶆儏鍐典笅锛屼粠鏈嶅姟鍣ㄤ笉鍐嶄娇鐢ㄥ父瑙�tmpdir锛岃�存槑浣犲彲浠ュ皢tmpdir璁剧疆鍒颁竴涓�闈炲浐瀹氫綅缃�銆�

路         transaction_alloc_block_size

涓轰繚瀛樺皢淇濆瓨鍒颁簩杩涘埗鏃ュ織涓�鐨勪簨鍔＄殑鏌ヨ�㈣�屽垎閰嶇殑鍐呭瓨鍧楃殑澶у皬(瀛楄妭)銆�

路         transaction_prealloc_size

涓�transaction_alloc_blocks鍒嗛厤鐨勫浐瀹氱紦鍐插尯鐨勫ぇ灏忥紙瀛楄妭锛夛紝鍦ㄤ袱娆℃煡璇�涔嬮棿涓嶄細閲婃斁銆備娇璇ュ�艰冻澶熷ぇ锛屽皢鎵�鏈夋煡璇㈠浐瀹氬埌涓�涓�浜嬪姟涓�锛屽彲浠ラ伩鍏嶅�氭��malloc()璋冪敤銆�

路         tx_isolation

榛樿�や簨鍔￠殧绂荤骇鍒�銆傞粯璁ゅ�间负REPEATABLE-READ銆�

路         updatable_views_with_limit

璇ュ彉閲忔帶鍒跺�傛灉鏇存柊鍖呭惈LIMIT瀛愬彞锛屾槸鍚﹀彲浠ュ湪褰撳墠琛ㄤ腑浣跨敤涓嶅寘鍚�涓诲叧閿�瀛楃殑瑙嗗浘杩涜�屾洿鏂般��(閫氬父鐢�GUI宸ュ叿鐢熸垚杩欑被鏇存柊)銆傛洿鏂版寚UPDATE鎴�DELETE璇�鍙ャ�傝繖鍎夸富鍏抽敭瀛楁寚PRIMARY KEY锛屾垨涓�涓�UNIQUE绱㈠紩锛屽叾涓�浠讳綍鍒椾笉鍙�浠ュ寘鍚�NULL銆�

璇ュ彉閲忔湁涓や釜鍊硷細

o        1鎴�YES锛氬彧鍙戝嚭璀﹀憡(娌℃湁閿欒��娑堟伅)銆傝繖鏄� 榛樿�ゅ�笺��

o        0鎴�NO锛氱�佹�㈡洿鏂般��

路         version

鏈嶅姟鍣ㄧ増鏈�鍙枫��

路         version_bdb

BDB瀛樺偍寮曟搸鐗堟湰銆�

路         version_comment

configure鑴氭湰鏈変竴涓�--with-comment閫夐」锛屽綋鏋勫缓MySQL鏃跺彲浠ヨ繘琛屾敞閲娿�傝�ュ彉閲忓寘鍚�娉ㄩ噴鍊笺��

路         version_compile_machine

MySQL鏋勫缓鐨勬満鍣ㄦ垨鏋舵瀯鐨勭被鍨嬨��

路         version_compile_os

MySQL鏋勫缓鐨勬搷浣滅郴缁熺殑绫诲瀷銆�

路         wait_timeout

鏈嶅姟鍣ㄥ叧闂�闈炰氦浜掕繛鎺ヤ箣鍓嶇瓑寰呮椿鍔ㄧ殑绉掓暟銆�

鍦ㄧ嚎绋嬪惎鍔ㄦ椂锛屾牴鎹�鍏ㄥ眬wait_timeout鍊兼垨鍏ㄥ眬interactive_timeout鍊煎垵濮嬪寲浼氳瘽wait_timeout鍊硷紝鍙栧喅浜庡�㈡埛绔�绫诲瀷(鐢�mysql_real_connect()鐨勮繛鎺ラ�夐」CLIENT_INTERACTIVE瀹氫箟)銆傚張瑙�interactive_timeout銆�