Companies Home Search Profile

Efficient MySQL Performance: Best Practices and Techniques

Efficient MySQL Performance: Best Practices and Techniques

Download pdf

Efficient MySQL Performance: Best Practices and Techniques

Efficient MySQL Performance: Best Practices and Techniques

Category

SQL

MySQL

Author

Daniel Nichter

Publication

OReilly Media

0 View

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 influence MySQL 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

'

Download pdf

ISBN-10

1098105095

ISBN-13

978-1098105099

Publisher

OReilly Media

Price

40.49

File Type

PDF

Page No.

335

Daniel Nichter

Discover more of the author’s books, see similar authors, read author blogs and more ...

About the Author

Daniel Nichter is a DBA with over 15 years of experience with MySQL. He started optimizing MySQL performance in 2004 while working in a data center. Soon after, he created HackMySQL.com to share information and tools about MySQL. Daniel is most known for the tools he published during his eight-year tenure at Percona, several of which remain the de facto standard and in use at the largest tech companies in the world. He is also a MySQL Community Award winner, conference speaker, and wide-ranging open source contributor. Daniel currently works as a DBA and software engineer at Block (Square and Cash App), a fintech company with thousands of MySQL servers.

Similar Books

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

Scott Cosentino

Software Development

Professional Azure SQL Database Administration: Equip yourself with the skills to manage and maintain data in the cloud, 2nd Edition

Professional Azure SQL Database Administration: Equip yourself with the skills to manage and maintain data in the cloud, 2nd Edition

Ahmad Osama

Microsoft Azure

Mastering PostgreSQL 11: Expert techniques to build scalable, reliable, and fault-tolerant database applications, 2nd Edition

Mastering PostgreSQL 11: Expert techniques to build scalable, reliable, and fault-tolerant database applications, 2nd Edition

Hans-Jürgen Schönig

Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data

Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data

Anthony DeBarros

SQL Pocket Primer

SQL Pocket Primer

Oswald Campesato

Apache Pulsar in Action

Apache Pulsar in Action

David Kjerrumgaard

SQLScript for SAP HANA (Second Edition) (SAP PRESS)

SQLScript for SAP HANA (Second Edition) (SAP PRESS)

Jörg Brandeis

Practical Fraud Prevention: Fraud and AML Analytics for Fintech and eCommerce, Using SQL and Python

Practical Fraud Prevention: Fraud and AML Analytics for Fintech and eCommerce, Using SQL and Python

Gilit Saporta

MySQL Cookbook: Solutions for Database Developers and Administrators

MySQL Cookbook: Solutions for Database Developers and Administrators

Alkin Tezuysal

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

Scott Cosentino

Software Development

MySQL Cookbook: Solutions for Database Developers and Administrators

MySQL Cookbook: Solutions for Database Developers and Administrators

Alkin Tezuysal

High Performance MySQL: Proven Strategies for Operating at Scale

High Performance MySQL: Proven Strategies for Operating at Scale

Jeremy Tinley

Software Development

Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible (English Edition)

Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible (English Edition)

Adam Aspin

Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

Eric Vanier

Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites

Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites

Adrian W. West

Web Development

MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers

MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers

Jesper Wisborg Krogh

Software Development

Learn PHP 7: Object Oriented Modular Programming using HTML5, CSS3, JavaScript, XML, JSON, and MySQL

Learn PHP 7: Object Oriented Modular Programming using HTML5, CSS3, JavaScript, XML, JSON, and MySQL

Steve Prettyman

PHP, MySQL, & JavaScript All-in-One For Dummies

PHP, MySQL, & JavaScript All-in-One For Dummies

Richard Blum

PHP, MySQL, & JavaScript All-in-One For Dummies (For Dummies (Computer/Tech))

PHP, MySQL, & JavaScript All-in-One For Dummies (For Dummies (Computer/Tech))

Richard Blum

Other Authors' Books

Other Publishing Books

Learning Domain-Driven Design: Aligning Software Architecture and Business Strategy

Learning Domain-Driven Design: Aligning Software Architecture and Business Strategy

Vlad Khononov

Software Architecture

CockroachDB: The Definitive Guide: Distributed Data at Scale

CockroachDB: The Definitive Guide: Distributed Data at Scale

Guy Harrison

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

Dmitri Korotkevitch

Advanced Analytics with PySpark: Patterns for Learning from Data at Scale Using Python and Spark

Advanced Analytics with PySpark: Patterns for Learning from Data at Scale Using Python and Spark

Akash Tandon

Snowflake: The Definitive Guide: Architecting, Designing, and Deploying on the Snowflake Data Cloud

Snowflake: The Definitive Guide: Architecting, Designing, and Deploying on the Snowflake Data Cloud

Joyce Avila

Cloud Computing

Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter

Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter

Wes McKinney

Python for Geospatial Data Analysis: Theory, Tools, and Practice for Location Intelligence

Python for Geospatial Data Analysis: Theory, Tools, and Practice for Location Intelligence

Bonny P McClain

Efficient Go: Data-Driven Performance Optimization

Efficient Go: Data-Driven Performance Optimization

Bartlomiej Plotka

Software Development

Foundations of Scalable Systems: Designing Distributed Architectures

Foundations of Scalable Systems: Designing Distributed Architectures

Ian Gorton

Software Development

Consul: Up and Running: Service Mesh for Any Runtime or Cloud

Consul: Up and Running: Service Mesh for Any Runtime or Cloud

Luke Kysow

Reliable Machine Learning: Applying SRE Principles to ML in Production

Reliable Machine Learning: Applying SRE Principles to ML in Production

Todd Underwood

Machine Learning

Operating OpenShift: An SRE Approach to Managing Infrastructure

Operating OpenShift: An SRE Approach to Managing Infrastructure

Manuel Dewald

Software Development

User Reviews

Log in first to post a comment

Rating

0

0

0

0

0

average 0

Total votes0