This is the 11th day of my participation in Gwen Challenge

The original

First of all, this series of columns has been translated from several chapters in the third edition of the High Performance MySQL book, with additional notes, explanations, and examples as I understand them. The reason why I want to learn more about MySQL is that I find many problems in business development. In retrospect, I often find that the design of the data table itself has problems. The mistakes made at the beginning lead to endless loopholes and fillings, and the process is very painful. Therefore, I decided to review the knowledge of MySQL again, so I chose High Performance MySQL to learn. In fact, there are two reasons why I choose to use the original version: one is to force my English reading level to recover a little bit (except for the open source code documentation, I haven’t read English documents carefully for a long time); Second, through the process of translation to deepen their understanding.

process

In fact, the process is quite long, if from the first draft (at that time was written in The sparrow), it has been nearly half a year. It was originally intended to be a weekly post, but when it moved to the Nuggets it was well received (and received a premium column from the nuggets in May), so it changed the frequency. This leads to a lot of time taken up after work in the evening, and even my children mistakenly think that I work overtime every day, from time to time to knock on the keyboard to make trouble. In fact, I know he wants me to play with him, but sometimes I still warn him to leave me alone. As a result, he took a piece of paper to write a lot of “warning dad” (also in the small class, crooked to write a lot of), made me laugh and cry. All in all, I sacrificed a lot of time to spend with my family. I basically sat in front of my computer after dinner and started coding. Then, another interesting thing is that he followed me to know that the Markdown I was inserting was SQL (thanks for the excellent editor functionality). This is probably how the little yard farmers were raised.

Now, if you look at people who write books, you know how much their families have to pay for the author. To write a really thick book, it takes a lot of time, and if you have to go to work, you don’t have time to spend with your family during the writing period.

The biggest challenge in the translation process is actually how to integrate the language, especially some technical terms into Chinese is sometimes awkward, so I have to look for relevant materials on the Internet to better understand. Again is the example, some original examples will be easier to understand, but you need to write SQL to verify. Another is to better understand, I will also think of some examples to supplement, write SQL to illustrate and verify. I gained a deeper understanding of many concepts and mechanisms, and left a lot of words behind. I will have the opportunity to “review the past and learn something new” later.

conclusion

The design of databases and data tables is critical to business systems and is the foundation of business. If there is a problem with the design in the early stage, it will lead to a very low efficiency and maintainability in the later stage, and it will eventually take a lot of managers to do refactoring and data migration, which is very expensive for a system that runs online for a long time. Therefore, it is important to master the principles and concepts of database and data table design and the mechanics of SQL.

In addition, one of the most valuable professional qualities for programmers is retrospection. Review the code you’ve written, the spreadsheet you’ve designed, and then reorganize, optimize, and refactor some of the code. This way down the harvest will be very much, but also to see their own shortcomings in the past, and promote their further. “Lying flat” on the Internet is all the rage these days, but for programmers, “lying flat” is definitely a bad behavior. “996”, “007” is suffocating, but even without “996”, “007”, you should keep the motivation and habit of learning. In the programmer industry, is always against the current, not to advance is a state of retreat. Don’t wait until you find yourself far behind the people, and then a sigh of regret.