Efficient MySQL Performance: Best Practices and Techniques

Daniel Nichter

  • 4.65 out of 5 stars
    20 ratings by Goodreads
ISBN 10: 1098105095 ISBN 13: 9781098105099
Published by O'Reilly Media, Inc, USA, 2022
New Paperback / softback

From THE SAINT BOOKSTORE, Southport, United Kingdom Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

AbeBooks Seller since June 14, 2006

This specific item is no longer available.

About this Item

Description:

New copy - Usually dispatched within 4 working days. Seller Inventory # B9781098105099

  • 4.65 out of 5 stars
    20 ratings by Goodreads

Report this item

Synopsis:

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

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.

"About this title" may belong to another edition of this title.

Bibliographic Details

Title: Efficient MySQL Performance: Best Practices ...
Publisher: O'Reilly Media, Inc, USA
Publication Date: 2022
Binding: Paperback / softback
Condition: New

Top Search Results from the AbeBooks Marketplace

Stock Image

Nichter, Daniel
Published by O'Reilly Media, 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
Used paperback

Seller: HPB-Red, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_453806177

Contact seller

Buy Used

US$ 30.65
US$ 3.75 shipping
Ships within U.S.A.

Quantity: 1 available

Add to basket

Stock Image

Nichter, Daniel
Published by O'Reilly Media, 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
Used Softcover

Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00069697432

Contact seller

Buy Used

US$ 32.12
Free Shipping
Ships within U.S.A.

Quantity: 4 available

Add to basket

Stock Image

Nichter, Daniel
Published by O'Reilly Media (edition 1), 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
Used Paperback

Seller: BooksRun, Philadelphia, PA, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Paperback. Condition: As New. 1. It's a preowned item in almost perfect condition. It has no visible cosmetic imperfections. May come without any shrink wrap; pages are clean and not marred by notes or folds of any kind. Seller Inventory # 1098105095-10-1

Contact seller

Buy Used

US$ 32.14
Free Shipping
Ships within U.S.A.

Quantity: 1 available

Add to basket

Stock Image

Nichter, Daniel
Published by O'Reilly Media, 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
New Softcover

Seller: Lakeside Books, Benton Harbor, MI, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books! Seller Inventory # OTF-S-9781098105099

Contact seller

Buy New

US$ 44.81
US$ 3.99 shipping
Ships within U.S.A.

Quantity: Over 20 available

Add to basket

Seller Image

Nichter, Daniel
Published by O'Reilly Media, 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
New Softcover

Seller: GreatBookPrices, Columbia, MD, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 43597372-n

Contact seller

Buy New

US$ 46.15
US$ 2.64 shipping
Ships within U.S.A.

Quantity: 12 available

Add to basket

Stock Image

Nichter, Daniel
Published by O'Reilly Media, 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
New Softcover

Seller: Lucky's Textbooks, Dallas, TX, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # ABLIING23Mar2317530257119

Contact seller

Buy New

US$ 48.16
US$ 3.99 shipping
Ships within U.S.A.

Quantity: Over 20 available

Add to basket

Seller Image

Nichter, Daniel
Published by O'Reilly Media, 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
New Softcover

Seller: GreatBookPricesUK, Woodford Green, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: New. Seller Inventory # 43597372-n

Contact seller

Buy New

US$ 49.47
US$ 20.06 shipping
Ships from United Kingdom to U.S.A.

Quantity: 1 available

Add to basket

Stock Image

Daniel Nichter
Published by O'Reilly Media, 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
New PAP

Seller: PBShop.store UK, Fairford, GLOS, United Kingdom

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # WO-9781098105099

Contact seller

Buy New

US$ 49.48
US$ 6.71 shipping
Ships from United Kingdom to U.S.A.

Quantity: 10 available

Add to basket

Seller Image

Nichter, Daniel
Published by O'Reilly Media, 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
Used Softcover

Seller: GreatBookPrices, Columbia, MD, U.S.A.

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: As New. Unread book in perfect condition. Seller Inventory # 43597372

Contact seller

Buy Used

US$ 50.26
US$ 2.64 shipping
Ships within U.S.A.

Quantity: 12 available

Add to basket

Stock Image

Nichter, Daniel
Published by O'Reilly Media, 2022
ISBN 10: 1098105095 ISBN 13: 9781098105099
New Softcover

Seller: Brook Bookstore On Demand, Napoli, NA, Italy

Seller rating 5 out of 5 stars 5-star rating, Learn more about seller ratings

Condition: new. Seller Inventory # GGI8YRQNHD

Contact seller

Buy New

US$ 56.47
US$ 12.92 shipping
Ships from Italy to U.S.A.

Quantity: 10 available

Add to basket

There are 15 more copies of this book

View all search results for this book