If you are looking for the epic motorcycle journey blog that I've written, please see the Miles By Motorcycle site I put together. 
  • Ian
    Books: Boning up on MySQL
    11/07/2006 1:27AM
    After years of using MySQL, I finally decided to it was time to do some homework and put MySQL to better use.  I bought High Performance MySQL and PRO MySQL and am glad I did. 

    With a couple of interesting database projects on the horizon and a long history of using MySQL at a basic level, it was a good time to ramp up.  These two books have been helpful in enlightening me in a number of ways, making me aware of features in MySQL that I had never used, and teaching me how to do more complicated jobs far more efficiently. 

    High Performance MySQL is a relatively short book - around 200 pages.  The authors are not experienced book writers, but the depth of their experience with and knowledge of MySQL is clear.  I picked up a number of tidbits from this book.  It was written in 2004 before MySQL version 5.  I'm using version 5 now on my servers, though client accounts on shared servers are still 4.1.x.

    PRO MySQL, on the other hand, is over 700 pages and packed with the kind of information a veteran C programmer could appreciate.  For example, the authors break down a simple MySQL query into the many steps that the software takes along the way and describe where to look in the source code to find the meat of the database.  Not being a C programmer myself, I gloss over these sections and pick up the important stuff that I am looking for.  Haven't finished this book yet, but its value is clear and has already paid off in my daily work.  It covers version 5 better, being a newer book.

    I found these books to be very helpful.  Since database work has become a more and more important part of what I do every day, expanding my horizons was as logical as it has been fruitful.