Efficient MySQL Performance
Best Practices and Techniques
|Price||$45.92 - $47.49
|Format||Paper book / ebook (PDF)|
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.
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: $35.09 | Publisher: O'Reilly Media | Release: 2008
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
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 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
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
by Jesper Wisborg Krogh
Identify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue for your business. This book will help you make query tuning an integral part of your daily routine through a multi-step process that includes monitoring of execution times, identifying candidate queries for optimization, analyzin...
Price: $19.24 | Publisher: Apress | Release: 2020
by Jesper Wisborg Krogh
Know how locks work in MySQL and how they relate to transactions. This book explains the major role that locks play in database systems, showing how locks are essential in allowing high-concurrency workloads. You will learn about lock access levels and lock granularities from the user level as well as table locks to record and gap locks. ...
Price: $40.08 | Publisher: Apress | Release: 2021
by Silvia Botros, Jeremy Tinley
How can you realize MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from setting service-level objectives to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve your platform's full potential. This guide also teaches databa...
Price: $50.75 | Publisher: O'Reilly Media | Release: 2021