Retrace, some MySQL knowledge points

There's nothing more to see.

Basic Knowledge Review

1. Basic knowledge, especially some theoretical knowledge, such as:

   • What are the index types of MySQL, which is a semi-open proposition;

• From the data structure angle can be divided into B + Tree index , hash index , and infrequently used Fulltext index (now supported by MyISAM and InnoDB engines) and R-tree index (used to create spatial indexes on GIS data types);
• From the physical storage angle can be divided into clustered index （clustered index） , non-clustered index （non-clustered index） ;
• From the logical angle can be divided into primary key index , Ordinary index , or single-column index , multicolumn index , unique index , non-unique index and so on. The differences between these different concepts need to be mastered, for example 主键索引和唯一索引的区别是什么 .

  • Why the InnoDB table is best to have self-added key;
  • Why the need to set a double 1 to ensure the consistency of master-slave data;
  • There are several binlog formats *, and what the difference is;
  • How to confirm the true replication delay of MySQL replication;
  • Have been impressed with the practical experience.

By examining the level of the candidate's basic knowledge, it can reflect the candidate's attitude towards learning and whether it is only superficial understanding.

Research on core technical capability

1. Core key technical capabilities, such as:

   • How to do MySQL backup recovery Scheme and strategy, why do that, with what tools;
   • MySQL master-slave copy of the specific principles of what, the actual use of the process, encountered what pits, how to solve;
   • How to implement the online DDL for a large tableto minimize the impact;
   • What are the differences between MyISAM and InnoDB;
   • Whether the architecture of InnoDB can speak clearly, at least say a ballpark;
   • Assuming the server load is very high, what are the performance problems to troubleshoot , and optimize the program;
   • What is deadlock, what is lock wait , how to optimize;
   • About MySQL and InnoDB optimization, talk about your own opinions or practical experience ;
   • How to determine and implement MySQL high-availability program , the advantages and disadvantages of different schemes are compared;
   • A certain scale of MySQL Automation operation and maintenance experience how;
   • What is the experience of schema design ?
   • Based on MySQL has done some database architecture design, implementation experience.

By examining the degree of candidates ' mastery of these key technologies, it is possible to know the candidate's mastery of the deep-seated knowledge, in addition to practice, how much is mastered in theory.

Retrace, some MySQL knowledge points