TR

MySQL Performance Optimization

Course Audience

MY202
1 DAY

System administrators managing a MySQL database service and seeking better performance from this service.

Course Prerequsities

Informations that required by participants before course:

  • Participants who will join this course should also have joined MY201, MY101 courses before or mastered related subjects of these courses.

Course Goals

  • To be able to choose the right hardware to increase MySQL performance,
  • To be able to make necessary settings in the Linux operating system to improve MySQL performance,
  • To be able to adjust MySQL parameters to enhance performance,
  • To measure the performance of SQL queries and identify slow queries,
  • To measure the impact of indexes on performance and be able to adjust indexes,
  • To measure the impact of table partitioning on performance and be able to adjust partitions.

Course Subjects

  • Introduction to Performance Improvement
  • Hardware Performance
  • Operating System Settings
  • Adjusting Database Parameters
  • Performance Schema
  • Query Cache
  • Logging Slow Queries
  • Optimizing SQL Queries
  • Table Statistics
  • Indexing
  • Table Partitioning