Preface:
As operation and peacekeeping programmers, MySQL must not be unfamiliar, especially in the Internet industry, the use of MySQL is more. MySQL, as the mainstream database, is a knowledge point that the interviewers of major factories never tire of, but what degree do they need to know? It is not enough to stay at the basic level of database construction, table creation, addition, deletion, check and change.
MySQL is not difficult. Today’s most comprehensive summary of MySQL, a total of 1200 pages, almost covers all knowledge, including interview questions, study notes, use documentation, especially highlights the practical skills and advanced knowledge, whether it is a job or interview to read enough!
MySQL Basic development
This part of the content should be more suitable for those who just pit friends or for the basic part of the master is not solid friends, because this has certain experience or good foundation can automatically skip to the next chapter content to read, this part I only put the contents of the directory screenshots show.
MySQL optimization and management maintenance
MySQL as a relational database, the optimization of SQL statements is particularly important. If the SQL statement is written well, it also determines the speed of taking data from MySQL. Think about asking others as long as 3s, while you need 30s (for example).
MySQL Performance tuning and Architecture Design topics
In this special topic, we will focus on performance optimization and architecture design of MySQL, which will essentially give you a deeper understanding of MySQL and a more principled grasp of the content, which is the embodiment of what we call technical depth.
In this topic, we are mainly divided into three parts:
- basis
- Performance optimization
- Architecture design
Basic article:
MySQL storage engine (MyISAM storage engine) MySQL storage engine (MyISAM storage engine) Innodb storage engine introduction, NDBCluster storage engine introduction and other engines introduction) MySQL security management (including database system security factors, permission system introduction, access authorization policies, etc.) MySQL backup and recovery (including database backup scenarios, logical backup and recovery tests, Physical backup and recovery test and backup strategy design ideas)
Performance Optimization:
MySQL database locking mechanism (introduction to locking mechanism) MySQL database locking mechanism (introduction to locking mechanism) MySQL database Query optimization (understand MySQL QueryOptimizer, Query statement optimization basic ideas and principles, make full use of Explain and Profiling, reasonable design and use of index, MySQL database Schema design performance optimization (efficient model design, appropriate data types, standard object naming) MySQLServer performance optimization (MySQL installation optimization, MySQL log setting optimization, QueryCache optimization, MyISAM storage engine optimization, Innodb storage engine optimization
Architectural Design:
Basic principles of MySQL extensible design
Extensible design for MySQLReplication
Scalable design for data sharding
Use of Cache and Search in scalable design
MySQLCluster
High availability design ideas and schemes
MySQL monitoring in a highly available design
conclusion
From basic to advanced and practical, this paper distinguished, the MySQL speak clearly, clearly, I’ve seen so far this is the best learning notes about MySQL, I believe that if you put the note carefully, after see whether problems encountered in the work or by the interviewer asked the problem can be solved!
Finally: The fall of 2021 is about to begin. So here’s a list of the questions you should ask yourself:
