Database is a comprehensive system, behind which is the database theory which has been developed for several decades. You may not find the database difficult because you can write SQL fluently and play with the various clients with ease. But take the most common MySQL as an example. As a programmer, have you ever encountered similar problems in the process of using MySQL?

1. Why is my count(*) so slow?
2. Why do I create an index and it doesn’t work at all?
3. Why am I running so slowly on only one line?
4. How to optimize MySQL for large tables?

Some time ago, there was a big on a giant, gave me a number of learning materials, organize, has formed the following document (database), mainly including MySQL interview questions, MySQL base to the senior to tuning notes, MySQL knowledge summary, MySQL performance tuning and architecture design document parse, packaged good, have free access at the end of the article.

MySQL interview questions

MySQL Basic to advanced tuning Notes

Study notes are divided into 12 modules. The main contents are as follows:

As a result of the length of the number of words, in this only show the detailed directory and content of the screenshots, there is a need for friends can be at the end of the free access!

MySQL Knowledge summary

Mainly summarized from six aspects: MySQL basic module, MySQL index module, MySQL transaction module, MySQL log module, MySQL log, MySQL performance optimization module …………

Above:

MySQL performance tuning and architecture Design parsing documentation

First, the foundation

Second, performance optimization

Iii. Architecture Design

Due to the number of words, the above learning materials about MySQL have been packed