Recently I shared a few articles about the principle of MySQL, after writing, I always feel a little empty chatter, as if something is missing… So, the following thoughts come to mind:

Work accumulated a lot of things, some colleagues, friends positive influence, also have self-summary. Although I have been working for so many years, I can hardly call myself a “god”. However, there are always two voices echoing in my ears recently:

  • Let more friends become excellent
  • I am grateful for the influence and help of my colleagues and friends, and pass on the heart of influencing others

I want to share more excellent content with you, but how do I get started?

It occurred to me that I had been reading geek Time’s MySQL In Action 45 column in its entirety. To be honest, the author really wrote very well, with many illustrations and easy to understand content. However, I always feel that many contents of this column are not detailed and in-depth enough to resolve my inner pursuit of the extreme impulse and curiosity.

After careful consideration, I decided to share more in-depth articles on MySQL. At the same time, I combined with various problems related to MySQL encountered in our daily work, so that my articles can not only solve practical problems, but also not to point to the end, so that friends can truly feel the charm of technology. Therefore, I try to make my article embody the following characteristics:

  1. No repetition and less overlap: Compared with other similar columns, for example, MySQL Practice 45, my article will reflect more of the content that is not explained in other similar columns
  2. Simple in depth: As we all know, it is easy to write the original rational things into obscure articles. Therefore, IN my article, I will introduce as many illustrations as possible to ensure that everyone can understand the content of all articles in simple in depth.

Finally, I hope I can give more inspiration, guidance and help to the following three types of students by sharing my article:

  1. 2 years of working or project experience: As a developer who has worked for 2 years, I have mastered the SQL statements, tools and simple problem analysis of MySQL. I also admit that some tools of MySQL can help us quickly analyze and solve many problems, such as EXPLAIN, optimize Tracer and so on. Meanwhile, MySQL internal in each version of iteration step by step process, made a lot of a lot of optimization, performance, reliability, these for us to make good with MySQL, crucial to maximize play its value, however, we have a lot of work for 2 or 3 years the development of the students of these optimization or not clear, or understanding is not deep, so, I hope that by explaining these optimizations in detail, I can help them better cooperate with DBAs to make good use of MySQL and give full play to the maximum value of MySQL.
  2. Non-c /C++ candidates: We all know that no matter what you are doing the development of language, database operation and principle are unavoidable problem in the interview process, at the same time, for those who are not C/C + + language of the interviewer, reading the MySQL source in a short period of time quickly to raise their leverage in the interview process, the cost is very high, have to spend a lot of time and energy, so, I hope that through my article, I can help these interviewees to grasp the principles of MySQL more quickly, so that they can have more confidence and confidence in salary negotiation.
  3. Students: There will be people who tell me: my article is about the principle, but also based on MySQL source code to explain, too deep, not suitable for the little white students without too much MySQL actual combat experience.MySQL source code contains too many textbook classical algorithms, such as tree correlation algorithm, search algorithm, sorting algorithm (quick sort, merge sort, etc.), approximate algorithm (greedy algorithm, etc.), etcTherefore, I hope that through these articles, I can help those students have a deeper understanding of the actual application of data structures and algorithms in real scenarios in textbooks.

These are my original intention in writing MySQL series: let more partners grow and improve, let us become better people together!

If any of you are inspired by my article and end up as a “god” in your field, I am really proud of you