Archive for the ‘Announcements’ Category

What changed from the first to second edition of High Performance MySQL?

Wednesday, July 16th, 2008

A pretty frequent comment I get is “I’m thinking about buying the second edition. What’s the difference from the first edition?” I’ll try to answer that question here.

  • A lot more content.  684 pages instead of 230, plus it’s compactly written.  You can count on about 3 or 4 times as much real information.
  • Much deeper insight into server internals.  If you found the first edition’s coverage of indexing, schema optimization and query optimization a bit superficial, you will not be disappointed by the second edition.  It probably tells you more than you want to know, really.
  • InnoDB, InnoDB, InnoDB.  InnoDB is the leading storage engine for MySQL, and for good reason: it’s fast, stable, robust and has lots of advanced features.  We cover it like nothing you’ve ever read before.  If you’re having trouble with InnoDB tuning or if it’s giving you problems under extreme load, this book is for you.
  • A changed focus.  We wrote the book for people who have “real money” in their servers and need to rely on MySQL.  Default installations of MySQL are fine for lightweight forums or something, but we’ve built some of the largest and most heavily trafficked sites in the world on MySQL.  The second edition shows you how to build a MySQL installation that you can really count on.
  • A lot of details on operating system and hardware tuning, plus how to choose hardware for your server.
  • Much more information on replication. You can get setup guides from anywhere.  What you can’t get from anywhere is how to make replication rock-solid.
  • Real insight into how you can scale your systems big.  We give specific advice, not generic “oh, you might consider this and that.” We’ve been through a lot of projects building MySQL out to really really big sizes, and we’ve seen dozens of different ways to do it.  If you ever think your systems won’t fit on a single server, buy the book and save a ton of time and money.  Scaling big is no simple matter.
  • Much more useful advice on benchmarking and profiling.
  • Tons of “hacks” that get around MySQL’s weaknesses, with advice on when to use them.
  • A thorough guide to tuning MySQL.  Again this is an area where the first edition was not very comprehensive.  Special attention is given to InnoDB and MyISAM tuning.
  • Deep dives into advanced topics: the query cache, views, character sets, partitioning, and so on.  Most of these were not mentioned in the first edition, and certainly not in any depth.
  • Advice on how to optimize your applications.  Three of the authors are full-stack performance consulting experts — we know a lot more than just MySQL.
  • Backup advice that actually works.  Backing up MySQL is non-trivial, especially in mixed environments (common these days).  If you do it the first edition’s way, you are likely to be doing it wrong.  The first edition’s advice was pretty much good only for MyISAM tables.
  • The best information anywhere on SHOW INNODB STATUS and many other advanced topics.
  • Four appendixes about essential topics.

You can download the sample table of contents from the Download tab above to browse the topic list in more detail.

Preview content of High Performance MySQL

Monday, June 23rd, 2008

Looking for a sample of what the book is like? Here are two ways you can try before you buy:

What does it take to be the lead author of High Performance MySQL?

Monday, June 16th, 2008

Baron wrote a blog post about his experiences writing this book. Just in case you were wondering how much work it takes to write a book like this.

Being an author gives you a lot of appreciation for other authors, and helps you understand how much a book is worth.

Final versions of High Performance MySQL sample content posted

Monday, June 9th, 2008

Now that the book has gone to the printing press, we can post final versions of our sample content. You can download unrestricted PDFs of the foreword, table of contents, chapter 4 (Query Performance Optimization), and the index from the Downloads page. Enjoy!

High Performance MySQL, Second Edition is #3,868 on Amazon

Sunday, June 8th, 2008

Amazon.com Sales Rank #3,868 in Books.

And that’s before it’s even available!

This is sales rank in all books. Not technical books, not MySQL books. All books.

Unbelievable.

The book has gone to press!

Sunday, June 8th, 2008

As of Friday, June 6th, the book has gone to press.  The in-stock date is June 19th, 2008.

I’ve asked for the PDF of the final book as it went to press, and will extract and update the sample material when I get it.  The figures were revised until literally the last few hours. (Note to prospective authors: consider figures just like text; make sure you have a professional helping with them along the way, just as you do with the text.)

The publisher has promised that they’ll have the books at the upcoming Velocity conference, so you will be able to physically buy one there.  Stop in and see Peter; he is speaking at that conference, too.

Official website launched for High Performance MySQL

Monday, May 26th, 2008

We’ve launched the official website for the new High Performance MySQL book — that is, the second edition. The second edition is the long-awaited follow-up to 2004′s groundbreaking work by Jeremy Zawodny and Derek J. Balling. We’ve had some troubles with the domain that was registered for the first edition, so we’ve registered a similar domain and will set up a redirect if the original domain becomes available again.

What can you expect to find here?

  • Updates on the book’s progress. (It’s currently in final quality control, scheduled for press on June 6, 2008).
  • Code samples, links, and sample content. Rough drafts are already posted. We’ll post final versions once final quality control is finished.
  • News about any further work we do. Will there be a third edition? Maybe…
  • Anything else relevant, such as errata.

These updates may be infrequent. If you subscribe to our RSS feed, you won’t miss anything.

A note on comments and trackbacks: because we don’t have a lot of time to spend on this website, we don’t want to enable comments and trackbacks. They’d just be abused by spammers.