標籤:
按照一個MySQL DBA在工作中接觸到部分的先後順序,編排培訓目錄如下。
欄位選取
int , decimal, char , varchar , blob ,timestamp
SQL最佳化
explain以及相關最佳化技巧
參數最佳化
常用參數最佳化
基本管理操作
show processlist;
grant ;
主從複製
position機制
gtid機制
備份與恢複
冷備,熱備
邏輯,物理
binlog線上備
高可用
MHA
中介軟體
監控與死結排查
安裝
|
Detect languageAfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBengaliBelarusianBulgarianCatalanChinese (Simp)Chinese (Trad)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKannadaKoreanLaoLatinLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTamilTeluguThaiTurkishUkrainianUrduVietnameseWelshYiddish |
|
AfrikaansAlbanianArabicArmenianAzerbaijaniBasqueBengaliBelarusianBulgarianCatalanChinese (Simp)Chinese (Trad)CroatianCzechDanishDutchEnglishEsperantoEstonianFilipinoFinnishFrenchGalicianGeorgianGermanGreekGujaratiHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKannadaKoreanLaoLatinLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTamilTeluguThaiTurkishUkrainianUrduVietnameseWelshYiddish |
|
|
|
|
|
|
|
Text-to-speech function is limited to 100 characters Options : History : Help : Feedback
MySQL初級培訓