Efficient MySQL Performance e-Book:
Efficient MySQL Performance eBook download free book in pdf published by Oreilly Media, Author by Daniel Nichter, ISBN 9781098105082, 352 total pages, released in December 2021 (Early Access).
You'll find several books on MySQL basics today, but only one that covers advanced MySQL performance–and nothing in between. That's because explaining MySQL performance without addressing its complexity is difficult. This practical book bridges the gap by teaching developers mid-level MySQL knowledge beyond the fundamentals, but well shy of deep-level internals required by DBAs.
Daniel Nichter shows you how to apply best practices and techniques that directly affect efficient MySQL performances. You'll learn how to focus on query response time, optimize queries and data to increase performance, and monitor and understand the most important MySQL metrics. You'll also discover how not to use MySQL, including situations where this database is clearly the wrong choice.
- Understand why query response time is the North Star of MySQL performance
- Learn why indexing, not hardware or MySQL config, is the key to performance
- Examine query metrics in detail, including aggregation, reporting, and analysis
- Explore ways of improving query response time through query optimization
- Understand how to monitor MySQL and learn what the metrics mean
A gap in MySQL literature exists between basic MySQL knowledge and advanced MySQL performance. There are several books about the former, and one book about the latter: High Performance MySQL, also published by O’Reilly. This is the first and only book to bridge the gap.
The gap exists because MySQL is complex, and it’s difficult to teach performances without addressing that complexity—the proverbial elephant in the room. But engineers using (not managing) MySQL should not need to become MySQL experts to achieve remarkable MySQL performance. To bridge the gap, this book is unapologetically efficient—pay no attention to the elephant; it’s friendly.
Efficient MySQL performances means focus: learning and applying only the best practices and techniques that directly effect remarkable MySQL performance. Focus dramatically narrows the scope of MySQL complexity and allows me to show you a much simpler and faster path through the vast and complex field of MySQL performances. The journey begins with the first sentence of Chapter 1: performance is query response time. From there, we move fast through indexes, data, access patterns, and a lot more.
On a scale of one to five–where one is an introduction for anyone, and five is a deep dive for aspiring experts—this book ranges from three to four: deep, but far from the bottom. I presume that you’re an experienced engineer who has basic knowledge and experience with a relational database (MySQL or otherwise), so I do not explain SQL or database fundamentals. I presume that you’re an accomplished programmer who is responsible for one or more application that uses MySQL, so I continually reference the application and trust that you know the details of your application. I also presume that you’re familiar with computers in general, so I talk freely about hardware, software, networks, and so forth.
Since this book focuses on MySQL performance for engineers using MySQL, not managing it, a few references to MySQL configuration are made when necessary but not explained. For help configuring MySQL, ask a DBA where you work. If you don’t have a DBA, hire a MySQL consultant: there are many great consults with affordable contract options. And you can learn by reading the MySQL Reference Manual. The MySQL manual is superb, and experts use it all the time, so you’re in good company. Efficient MySQL Performance eBook download free book in pdf published by Oreilly Media, Author by Daniel Nichter, ISBN 9781098105082, 352 total pages, released in December 2021 (Early Access).
About the Publisher
O’Reilly’s mission is to change the world by sharing the knowledge of innovators. For over 40 years, we’ve inspired companies and individuals to do new things—and do things better—by providing them with the skills and understanding that’s necessary for success.