search
Home / Course / MySQL

SQL optimization and troubleshooting (MySQL version)

IntroductionChapterCourseware
MySQL installation and configuration under Linux, database logical layering, parsing process, index, detailed analysis of SQL execution plan, principles to avoid index failure, optimization cases, common optimization strategies, slow SQL troubleshooting, simulation of massive data, lock mechanism, MySQL under windows and linux Master-slave replication.
  • Difficulty:Intermediate
  • Total of26 chapters
  • 19080 plays
  • About Instructor

    王林
    王林
    student
    You will learn:

    MySQL installation and configuration under Linux, database logical layering, parsing process, index, detailed analysis of SQL execution plan, principles to avoid index failure, optimization cases, common optimization strategies, slow SQL troubleshooting, simulation of massive data, lock mechanism, MySQL under windows and linux Master-slave replication.

  • CancelreplySending
  • php.cn