Archive for August, 2008

Reason 392 to buy: This book can reduce power bills

Tuesday, August 12th, 2008

Sun’s Jenny Chen just wrote a very detailed post about measuring the power consumption of MySQL servers. She says the following:

There are different places that we can make changes to improve performance of a MySQL application: schema optimization and indexing, query performance optimization, tuning database server settings. The more detail and deep information on MySQL performance was covered in the guide book of High Performance MySQL, 2nd edition written by the MySQL performance experts. In this document, I have research test results bellow showing that increasing MySQL performance with these methods can actually reduce CPU utilization to save energy.

I couldn’t have said it better.  You should really read the post — it is a great investigation into how increased performance brings cost savings.  (Not only that, it helps conserve natural resources).

In general one of the reasons I felt so strongly about the need for this book, and spent so much time on it, is that it’s really possible to get order-of-magnitude performance gains from MySQL.  That means proportionally fewer servers, less power, less air conditioning, fewer toxic computers manufactured.  And I mean the gains can be dramatic.  One of my current consulting clients is doing exactly what my previous employer did — but less of it — and is using upwards of 80 servers for the task.  In my opinion they only need 4 or 6 servers to handle their load.  Opportunities for this type of performance improvement are all around me on a daily basis.

Second printing and upcoming translation

Saturday, August 2nd, 2008

The book has been selling very well–remaining in Amazon’s top 2000 titles–and the first printing has apparently sold out much more quickly than expected.  If they had known how soon a second printing would be necessary, they would have printed more.  In any case, O’Reilly has worked with us to go well above and beyond the norm for a second printing: not only have we fixed errata, we even went as far as rearranging page breaks and moving figures to improve readability. The second printing is on Monday August 4th.

To clarify, this is a second printing of the second edition, not an entirely new edition.  As each print run sells out there will be more printings to meet demand.

The book is also going to be translated into Spanish, Polish, and Portuguese.  Further translations may be announced in the future.