Efficient MySQL Performance
Best Practices and Techniques
| Price | $45.92 - $47.49
|
| Rating |  |
| Author | Daniel Nichter |
| Publisher | O'Reilly Media |
| Published | 2021 |
| Pages | 335 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1098105095 |
| ISBN-13 | 9781098105099 |
You'll find several books on basic or advanced MySQL performance, but nothing in between. That's because explaining MySQL performance without addressing its complexity is difficult. This practical book bridges the gap by teaching software engineers mid-level MySQL knowledge beyond the fundamentals, but well shy of deep-level internals required by database administrators (DBAs).
Daniel Nichter shows you how to apply the best practices and techniques that directly affect MySQL performance. You'll learn how to improve performance by analyzing query execution, indexing for common SQL clauses and table joins, optimizing data access, and understanding the most important MySQL metrics. You'll also discover how replication, transactions, row locking, and the cloud influenceMySQL performance.
Understand why query response time is the North Star of MySQL performance; Learn query metrics in detail, including aggregation, reporting, and analysis; See how to index effectively for common SQL clauses and table joins; Explore the most important server metrics and what they reveal about performance; Dive into transactions and row locking to gain deep, actionable insight; Achieve remarkable MySQL performance at any scale.
- Daniel Nichter
5 5 8
Similar Books
High Performance MySQL, 2nd Edition
by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy D. Zawodny, Arjen Lentz, Derek J. Balling
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. Learn advanced techniques in depth so...
Price: $6.29 | Publisher: O'Reilly Media | Release: 2008
Scaling Big Data with Hadoop and Solr 
by Hrishikesh Vijay Karambelkar
As data grows exponentially day-by-day, extracting information becomes a tedious activity in itself. Technologies like Hadoop are trying to address some of the concerns, while Solr provides high-speed faceted search. Bringing these two technologies together is helping organizations resolve the problem of information extraction from Big Da...
Price: $26.99 | Publisher: Packt Publishing | Release: 2013
MySQL Stored Procedure Programming
by Guy Harrison, Steven Feuerstein
MySQL Stored Procedure Programming covers a lot of ground. The book starts with a thorough introduction to stored procedures programming and functions, covering the fundamentals of data types, operators, and using SQL in stored procedures. You'll learn how to build and maintain stored programs -- covering transactions, stored functio...
Price: $6.38 | Publisher: O'Reilly Media | Release: 2006
by Nicholas C. Zakas
If you're like most developers, you rely heavily on JavaScript to build interactive and quick-responding web applications. The problem is that all of those lines of JavaScript code can slow down your apps. This book reveals techniques and strategies to help you eliminate performance bottlenecks during development. You'll learn o...
Price: $19.59 | Publisher: O'Reilly Media | Release: 2010
by Bartlomiej Plotka
With technological advancements, fast markets, and higher complexity of systems, software engineers tend to skip the uncomfortable topic of software efficiency. However, tactical, observability-driven performance optimizations are vital for every product to save money and ensure business success.With this book, any engineer can learn how ...
Price: $45.65 | Publisher: O'Reilly Media | Release: 2022
Pro PHP Application Performance
by Armando Padilla , Tim Hawkins
This book contains tips, tricks, and techniques to make new and existing PHP applications much faster and less resource-hungry.Pro PHP Application Performance will help you understand all the technologies and components which play a role in how well your applications run. When seconds can mean the difference between retaining a user and l...
Price: $33.74 | Publisher: Apress | Release: 2010
High Performance MySQL, 3rd Edition
by Baron Schwartz, Peter Zaitsev, Vadim Tkachenko
How can you bring out MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications thro...
Price: $37.69 | Publisher: O'Reilly Media | Release: 2012
High Performance Browser Networking
by Ilya Grigorik
How prepared are you to build fast and efficient web applications? This eloquent book provides what every web developer should know about the network, from fundamental limitations that affect performance to major innovations for building even more powerful browser applications - including HTTP 2.0 and XHR improvements, Server-Sent Events ...
Price: $28.99 | Publisher: O'Reilly Media | Release: 2013