Efficient MySQL Performance

Best Practices and Techniques



Bookstore > Books > Efficient MySQL Performance

Price$45.92 - $47.49
Rating
AuthorDaniel Nichter
PublisherO'Reilly Media
Published2021
Pages335
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101098105095
ISBN-139781098105099
EBook Hardcover Paperback

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.





Similar Books


High Performance MySQL, 2nd Edition

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:  $35.09  |  Publisher:  O'Reilly Media  |  Release:  2008

Scaling Big Data with Hadoop and Solr

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

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

High Performance MySQL, 3rd Edition

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

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

MySQL 8 Query Performance Tuning

MySQL 8 Query Performance Tuning

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

MySQL Concurrency

MySQL Concurrency

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

High Performance MySQL, 4th Edition

High Performance MySQL, 4th Edition

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