Skip to content

“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.

Share

17 Comments

  1. levitra wrote:

    Hi, I do believe your website could possibly be having web browser compatibility problems.
    When I take a look at your blog in Safari, it looks fine but when opening in I.
    E., it’s got some overlapping issues. I simply wanted to provide you with a quick heads up! Besides that, excellent blog!

    Saturday, June 8, 2013 at 9:59 | Permalink
  2. phentermine wrote:

    I do not even know how I ended up here, but I thought this post was great.
    I do not know who you are but certainly you are going to
    a famous blogger if you are not already ;) Cheers!

    Sunday, June 23, 2013 at 9:05 | Permalink
  3. Thanks for sharing your thoughts about Linux. Regards

    Tuesday, July 2, 2013 at 4:02 | Permalink
  4. This is a topic which is near to my heart…
    Take care! Where are your contact details though?

    Saturday, July 6, 2013 at 15:19 | Permalink
  5. Bo Jiang wrote:

    Have you changed your career to run a book store ?

    Wednesday, September 18, 2013 at 23:18 | Permalink
  6. telecharger wrote:

    Hello there I am so glad I found your blog, I really found you by mistake, while I was browsing on Askjeeve for something
    else, Anyhow I am here now and would just like to say thank you for a
    tremendous post and a all round interesting blog (I also love the theme/design), I don’t have time to
    go through it all at the minute but I have book-marked it and also added in your
    RSS feeds, so when I have time I will be back to read much more,
    Please do keep up the superb work.

    Sunday, April 13, 2014 at 11:31 | Permalink
  7. Thank you, I’ve just been searching for info about this topic
    for ages and yours is the greatest I’ve found out so far.
    However, what in regards to the conclusion? Are you sure
    about the source?

    Tuesday, April 15, 2014 at 18:45 | Permalink
  8. Excellent blog here! Also your website loads up very fast!
    What host are you the use of? Can I am getting your associate
    link for your host? I want my web site loaded up as fast as yours lol

    Saturday, April 26, 2014 at 12:05 | Permalink
  9. Write more, thats all I have to say. Literally, it seems as though you relied
    on the video to make your point. You clearly know what youre talking about,
    why throw away your intelligence on just posting videos to your
    site when you could be giving us something informative to read?

    Sunday, April 27, 2014 at 21:43 | Permalink
  10. I’m gone to tell my little brother, that he should also pay a quick visit this webpage on regular basis
    to obtain updated from most up-to-date information.

    Thursday, May 1, 2014 at 0:20 | Permalink
  11. Hello, I think your website might be having browser
    compatibility issues. When I look at your website in Safari,
    it looks fine but when opening in Internet Explorer, it has some overlapping.

    I just wanted to give you a quick heads up! Other then
    that, awesome blog!

    Friday, May 2, 2014 at 5:47 | Permalink
  12. Hello there, I found your website via Google even as looking for a
    similar topic, your web site came up, it looks great.
    I’ve bookmarked it in my google bookmarks.
    Hi there, just become alert to your weblog thru Google,
    and found that it’s truly informative. I’m going to be careful for brussels.
    I’ll be grateful if you happen to proceed this in future.

    Numerous other people will likely be benefited out of your writing.
    Cheers!

    Tuesday, May 6, 2014 at 2:32 | Permalink
  13. I enjoy what you guys are usually up too. This kind of clever work and exposure!
    Keep up the excellent works guys I’ve included you
    guys to my blogroll.

    Monday, May 19, 2014 at 21:29 | Permalink
  14. Loretta wrote:

    Hey! I’m at work surfing around your blog from my new iphone!
    Just wanted to say I love reading your blog and look forward to all your
    posts! Keep up the excellent work!

    Tuesday, May 20, 2014 at 9:51 | Permalink
  15. Heya i am for the first time here. I found this
    board and I find It really useful & it helped me out a lot.
    I hope to give something back and help others like you aided me.

    Thursday, June 12, 2014 at 23:51 | Permalink
  16. Awesome issues here. I’m very happy to look your post. Thanks a lot
    and I’m taking a look ahead to contact you.
    Will you kindly drop me a e-mail?

    Tuesday, June 17, 2014 at 22:15 | Permalink
  17. At this time it looks like Expression Engine is the preferred
    blogging platform available right now. (from what I’ve read) Is that what
    you are using on your blog?

    Wednesday, June 18, 2014 at 5:09 | Permalink

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*