Nuggets community best-selling booklet wonderful accumulation! How MySQL Works: Finding ways to Understand MySQL is finally here!
The relationship between this book and the Gold digger booklet
In March 2018, children released a booklet entitled how MySQL Works: Understanding MySQL from the Root on the Nuggets Platform. This booklet is the first draft of the book, and the chapter structure of the book is basically the same as that of the booklet. However, this does not mean that the book is simply a paper version of the contents of the small volume. The paper book has made many improvements on the basis of the small volume:
- In the two and a half years since the release of the first draft, hundreds of students have raised various questions about the difficult parts of the booklet. The paper book has optimized its original expression to make it easier to understand.
- Chapter 3, chapter 7, Chapter 10, Chapter 21, and Chapter 22 of the paper book have been rewritten, which is completely different from the small book. This is mainly because I think the content of the corresponding chapters in the booklet is too shallow or too general, the details are not enough, there may be ambiguity, anyway there are some strange reading, so it is better to rewrite them completely, in order to achieve better results.
- Each chapter is optimized word for word, adding several new details and removing unnecessary paragraphs to make the user experience better.
- In a word, the small book is the predecessor of the book, equivalent to the previous version, this book is the upgrade version of the small book, I believe that even if the students who read the small book, read the book will have a lot of new harvest ~
What are the features of this book
This is not a traditional technical book. It has the following characteristics.
- The full text is written in plain English, and some places are “bullshit”, just like someone is talking to the students, I hope you don’t look sleepy.
- From a beginner’s point of view, try to avoid introducing a new concept with an unlearned one.
- Language is always very pale in front of pictures, so I drew a lot of pictures, you take your time.
- The devil is in the details. In the past, many students felt confused when reading, because the details were not given enough, leading to big guesses.
- The structural division of layers of matting. The contents of this book form a closed loop, and I hope that after reading the book, you will have a feeling that you have read a complete story.
- Wait, wait, wait…
What is the book about
While this book may seem a little less serious in some ways, it is a technical book devoted to covering some of the core concepts of MySQL that you will encounter most often in your work and interview process. The book is divided into four parts, with about 450 pages of text printed in two colors. The sections are described below.
- Part 1 (Chapters 1 ~ 3) : Reexamine what MySQL really is as a white person who can only write add, delete, change and query statements. Introduce MySQL server and client programs, startup options and system variables, and some things about the character set.
- Part 2 (chapters 4-9) : Structure and usage of nagging records, pages, indexes, and table Spaces. Part 2 is the foundation of the whole, and the rest of the chapters rely on these structures.
- Part 3 (Chapters 10 ~ 17) : Introduces the query optimization problems that students often encounter in their work, such as how single-table queries are executed, how join queries are executed, and what cost and rule-based optimization of MySQL is. This section also explains in great detail how to view the execution results of Explain statements.
- Part 4 (Chapters 18-22) : Explains why transactions exist and how MySQL implements transactions, including redo logs, undo logs, MVCC, various locks, and more.
- The contents of this book are as follows:
The target audience of this book
It is important to note that this book is not a database introduction book, so you need to know what add, delete, change and check means, and can write it in SQL. Of course, you are not required to know too much, even do not know the syntax of the join. In addition, the reader should have some basic computer knowledge, such as what is a bit, what is a byte, base conversion, etc. This book is generally suitable for the following readers:
- Those who have just learned the basics of SQL;
- Job seekers plagued by database problems;
- Business development partners who are forced to optimize SQL by DBAs every day;
- Novice DBAs and non-novice DBAs;
- Have a strong interest in the MySQL kernel, but a look at the source code confused friends.
How to get a book for free
To thank you for your continued support, the Nuggets community has teamed up with the Asynchronous community to bring you more than a few benefits:
- Nuggets community surrounding gift package 5 sets!
- How MySQL is running: Understanding MySQL from the root 20 physical books!
- Asynchronous community VIP membership monthly card 20!
Rules of lucky draw:
1. You must follow the ‘Nuggets Developer Community’ account.
2. Reply keyword: “Dig friend welfare” to get lucky draw address.
Drawing time:
18:00 sharp on Monday, November 16
Matters needing attention:
- Winners must fill in the address carefully, we will send out within 5 working days after the drawing.
- Non nuggets developer community public number fans won the prize invalid oh! 3. After participating in the lottery, you can invite more people to help, and the chance of winning will be greatly improved!
Special thanks to
- Special thanks toAsynchronous communityBook sponsorship provided. Asynchronous Community is the leading IT professional book community in China. Sponsored by Posts and Telecommunications Press, asynchronous Community is committed to publishing and sharing high-quality learning content, providing readers with high-quality learning content, and providing readers and authors with online communication community.
How to Buy a Book
99 yuan (this is a text book pricing is more than 450 pages, and double color printing of books), but as the little green frog fans, not 99, 79, of course, also can’t sell 9 9 (I’d be lost), scan the qr code below can be half price to buy this book, that is, can buy book 49.5 (must through the qr code below to buy oh, So the author can earn a few more dollars).
1. Students using JINGdong can click on the link: u.jd.com/tv4vK1V or scan the QR code in the lower left:
2. Students using Dangdang can click the link:u.dangdang.com/H8quWOr scan the QR code at the bottom right:
Everyone’s support is the motivation for the authors to continue to create oh, I believe that the author will create more easy-to-understand technical books to make everyone’s learning process easier and faster.