MySQL初級培訓

標籤：

按照一個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初級培訓