馃敟 寮€澶寸伒榄傛嫹闂細浣犵殑鏁版嵁搴撳崱鎴怭PT浜嗗悧锛?/h3>

"鏄庢槑鍔犱簡绱㈠紩锛屼负鍟ユ煡涓鍗曡5绉掞紵""鐢ㄦ埛閲忎竴涓婃潵锛岀郴缁熷氨鐤媯鎶ラ敊锛?鍝庡摕鍠傦紝杩欏満鏅槸涓嶆槸鐗瑰埆鐔熸倝锛熸垜璺熶綘璇村晩锛屾悶涓嶅ソ灏辨槸瀛樺偍浼樺寲娌″仛鍒颁綅锛佷粖澶╁挶浠氨鍞犲敔杩欎釜鏁戝懡鎶€鑳斤紝涓夋鎿嶄綔璁╀綘鐨凪ySQL鍘熷湴璧烽锛?/p>

---

馃殌 绗竴姝ワ細缁欐暟鎹簱"鐦﹁韩"鎵嶆槸鐜嬮亾

锛堢獊鐒舵媿澶ц吙锛夊搸瀵逛簡锛佷綘浠煡閬撳悧锛熲€?strong>鈥?0%鐨勬€ц兘闂閮芥潵鑷瓨鍌ㄧ粨鏋勮璁♀€?/strong>鈥嬶紒鍓嶉樀瀛愭湁涓數鍟嗗钩鍙帮紝200涓囪鍗曞氨鍗℃垚鐙楋紝浣犵寽鎬庝箞鐫€锛熶粬浠妸鎵€鏈夌敤鎴疯涓烘棩蹇楅兘濉炲湪璁㈠崟琛ㄩ噷锛?/p>

馃憠 鈥?strong>鈥嬫纭Э鍔库€?/strong>鈥嬶細

1. 鈥?strong>鈥嬫媶琛ㄥぇ娉曗€?/strong>鈥嬶細涓昏〃鍙暀鏍稿績瀛楁锛堣鍗曞彿銆侀噾棰濄€佺姸鎬侊級
2. 鈥?strong>鈥嬪喎鐑垎绂烩€?/strong>鈥嬶細涓変釜鏈堝墠鐨勮鍗曡浆瀛樺巻鍙茶〃
3. 鈥?strong>鈥嬬鐢═EXT澶ф硶鈥?/strong>鈥嬶細鎶婂晢鍝佹弿杩板崟鐙瓨鏂囦欢绯荤粺
   锛堝暘锛佹暡榛戞澘锛夎浣忓晩鍏勫紵浠紝琛ㄥ瓧娈佃秴杩?0涓氨瑕佽鎯曚簡锛?/li>

馃搳 妗堜緥瀵规瘮锛氭煇鐢靛晢骞冲彴浼樺寲鍓嶅悗

馃洜锔?绗簩姝ワ細绱㈠紩涓嶆槸鐜勫锛佽浼氱畻璐?/h3>

锛堟尃澶达級鎴戝彂鐜板緢澶氭柊鎵嬬壒鍒埍涔卞缓绱㈠紩锛屽氨璺熶笉瑕侀挶浼肩殑銆備笂涓湀鏈変釜鍏勫紵锛岀粰鐢ㄦ埛琛ㄥ缓浜?5涓储寮曪紝缁撴灉鍐欏叆閫熷害鐩存帴鑵版柀锛?/p>

馃挕 鈥?strong>鈥嬮粍閲戞硶鍒欌€?/strong>鈥嬶細

1. 鈥?strong>鈥嬭仈鍚堢储寮曞乏鍖归厤鍘熷垯鈥?/strong>鈥嬶細where鏉′欢椤哄簭瑕佷弗鏍煎榻?/li>
2. 鈥?strong>鈥嬭鐩栫储寮曠粷鏉€鎶€鈥?/strong>鈥嬶細select瀛楁鍏ㄥ湪绱㈠紩閲?/li>
3. 鈥?strong>鈥嬪墠缂€绱㈠紩濡欑敤鈥?/strong>鈥嬶細varchar(255)鍙彇鍓?0瀛楃
   锛堢獊鐒朵弗鑲冿級娉ㄦ剰鍟婏紒姣忎釜绱㈠紩澧炲姞绾?0%鐨勫啓鍏ュ紑閿€锛岃繖涓处寰楃畻鏄庣櫧锛?/li>

---

鉂?鑷棶鑷瓟锛氫粈涔堟椂鍊欒鍒犵储寮曪紵

Q锛氱储寮曞浜嗕細鎬庢牱锛?br/> A锛氬氨璺熷閲屼笢瑗夸贡鏀句竴鏍凤紒鎵句笢瑗挎洿鎱㈣繕鍗犲湴鏂广€傚缓璁瘡鏈堝仛涓€娆＄储寮曞仴搴锋鏌ワ紝鐢?code>sys.schema_unused_indexes鎻嚭闂茬疆绱㈠紩銆?/p>

馃挜 绗笁姝ワ細鍙傛暟璋冧紭灏卞儚寮€璺戣溅鎹㈡尅

锛堟媿妗屽瓙锛夎繖涓渶瀹规槗琚拷鐣ワ紒浣犵煡閬撻粯璁ら厤缃兘鎵涘灏戝苟鍙戝悧锛熸拺姝?00锛佹兂瑕佷竾绾у苟鍙戯紵寰楄繖涔堢帺锛?/p>

馃敡 鈥?strong>鈥嬪繀鏀瑰弬鏁版竻鍗曗€?/strong>鈥嬶細

ini澶嶅埗
innodb_buffer_pool_size = 鐗╃悊鍐呭瓨鐨?span>70%
innodb_flush_log_at_trx_commit = 2
sync_binlog = 1000

锛堢獊鐒跺帇浣庡０闊筹級鎮勬倓璇翠釜楠氭搷浣滐細鎶妑edolog鏂囦欢浠庨粯璁ょ殑48MB璋冨埌2GB锛屼簨鍔℃彁浜ら€熷害鑳藉揩3鍊嶏紒

馃尠 鐪熷疄缈昏溅鐜板満

鍘诲勾鍙?1鏈変釜骞冲彴娌℃敼max_connections锛岀粨鏋滈浂鐐规祦閲忚繘鏉ョ洿鎺ヨ繛鎺ユ睜鐖嗙偢銆傚悗鏉ユ妸榛樿鐨?51鏀规垚2000锛岄厤鍚堢嚎绋嬫睜鎻掍欢鎵嶆墰浣忓帇鍔涖€?/p>

馃く 鐙瑙佽В锛歋SD涓嶆槸涓囪兘鑽紒

锛堢獊鐒舵縺鍔級鐜板湪寰堝浜鸿寰楃牳閽辨崲SSD灏辫兘瑙ｅ喅涓€鍒囷紵澶ч敊鐗归敊锛佹垜浠疄娴嬭繃锛氬湪鏈紭鍖栫殑鏁版嵁搴撲笂锛孲SD鍙兘鎻愬崌绾?0%鎬ц兘锛岃€屼紭鍖栧瓨鍌ㄧ粨鏋?绱㈠紩鑳藉甫鏉?00%鎻愬崌锛?/p>

馃挕 鏈潵瓒嬪娍锛?br/> 浜戝師鐢熸暟鎹簱寮€濮嬫祦琛屾櫤鑳藉瓨鍌ㄥ紩鎿庯紝鍍忛樋閲屼簯PolarDB鐨勫瓨鍌ㄨ绠楀垎绂绘灦鏋勶紝鎹鏌ヨ鎬ц兘姣斾紶缁烳ySQL蹇?鍊?..锛堢獊鐒舵墦浣忥級鍝庤繖涓笅娆″崟鐙敔锛?/p>

馃幆 鏈€鍚庡彯鍢憋細浼樺寲鏄寔缁繃绋嬶紒

灏卞儚鍋ヨ韩瑕佸畾鏈熸祴浣撹剛鐜囷紝鏁版嵁搴撲篃寰楁瘡鏈堝仛鍋ュ悍妫€鏌ャ€傝浣忚繖涓夋澘鏂э細鐦﹁韩鈫掑缓绱㈠紩鈫掕皟鍙傛暟锛屽惊鐜線澶嶆墠鑳芥案钁嗛潚鏄ワ紒锛堢獊鐒舵兂璧蜂粈涔堬級瀵逛簡锛佷紭鍖栧墠鍗冧竾瑕佸浠藉晩锛佸埆闂垜鎬庝箞鐭ラ亾鐨?..