“High Performance MySQL” by Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko; O’Reilly Media

lrgPeter and Vadim are long-term contributors to MySQL open source code base and are the founders of Percona, MySQL consultancy. This is really THE book about MySQL written by engineers who have spent more than a decade working on MySQL code.

The book is equally valuable to devops and DB admins, as well as software developers. It assumes that you have a good working knowledge of MySQL, as it dives straight into the intricate details of the system architecture and performance fine-tuning.

I have first-hand experience using second edition of this book, and I can say that it paid itself back many times over when I was debugging critical performance issues I came across in HeiaHeia.com operations. Now this third edition (published in 2012) covers also new features in MySQL version 5.5.

In this new edition authors make real effort to explain not only how MySQL works, but why certain features in MySQL work the way they do.

Case studies peppered throughout the book are particularly interesting, as they give insight into how to deal with MySQL in large scale setups with high load and demand for high availability.

This book covers a lot of very complex topics from replication, clustering and sharding to high availability. Practical advice on how to profile your server, find and fix the bottlenecks in server setup as well as on the application side in SQL queries is invaluable.

I very much liked that book is organized in such a way that it can easily be used as a reference.

This is a must read for anyone who has a somewhat significant load on their MySQL DB server or is considering moving from a single server setup to a cluster.

Get your copy of the book at O’Reilly.


Comments

15 responses to ““High Performance MySQL” by Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko; O’Reilly Media”

  1. Useful info. Fortunate me I found your website accidentally, and I’m shocked
    why this accident did not came about in advance! I bookmarked it.

  2. Wow! Thank you! I permanently wanted to write on my website
    something like that. Can I take a fragment of your
    post to my blog? https://www.zotero.org/groups/openwindow2122

  3. Buddyskele

    I was skeptical not far from CBD at initial, but after tiresome them like https://joyorganics.com/products/organic-cbd-gummies , I’m absolutely impressed. They present a convenient and enjoyable way to take CBD without any hassle. I’ve noticed a calming object, primarily in the evenings, which has helped with both significance and sleep. The finery as regards is the pre-measured dosage, so there’s no guessing involved. If you’re looking for an easy and tasty course of action to acquaintance CBD, gummies are plainly value in view of—nothing but modify steady to gain from a reputable disgrace!

  4. JamesBrata

    https://joyorganics.com/products/organic-cbg-cbd-tincture produce a tactful and enjoyable method in return experiencing the intricate’s effects. Close by in a broad cover of flavors, strengths, and blends, they agree to for faithful dosing and manumit effects that tend to matrix longer. Uncountable users addle to these gummies to save their calming and stress-reducing benefits. That said, it’s quintessential to use them responsibly, as the inception of effects is typically slower than with methods like smoking or vaping. Every follow dosage recommendations and affirm that their avail is authorized in your area prior to consuming or purchasing.

  5. DavidZoope

    Kamagra Commander maintenant: kamagra en ligne – Kamagra Oral Jelly pas cher

  6. PeterVof

    kamagra 100mg prix Acheter Kamagra site fiable kamagra gel

  7. BernardBroam

    pharmacie en ligne fiable: pharmacie en ligne pas cher – pharmacie en ligne france livraison internationale pharmafst.com

  8. RobertFloob

    http://pharmafst.com/# acheter mГ©dicament en ligne sans ordonnance

  9. Bradleynag

    cialis prix: cialis sans ordonnance – Cialis sans ordonnance 24h tadalmed.shop

  10. Dog registries help in tracking a pet’s breed and confirm authenticity.
    Thinking of registering your dog? Let’s discuss!

  11. BillieOxymn

    kamagra gel: Kamagra Commander maintenant – kamagra pas cher

  12. RobertFloob

    https://pharmafst.com/# acheter mГ©dicament en ligne sans ordonnance

  13. Bradleynag

    Kamagra Oral Jelly pas cher: kamagra pas cher – acheter kamagra site fiable

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.