Slashdot Mirror


High Performance MySQL

swsuehr (Steve Suehring) writes "Knowing that Jeremy Zawodny works with MySQL in a highly demanding environment at Yahoo! Finance, I have to admit that I was somewhat anxious to crack open a copy of the book High Performance MySQL published by O'Reilly and written by Jeremy and Derek J. Balling. With such high expectations, it would be easy to be disappointed with the content or level of the material in the book. Far from disappointing, High Performance MySQL was exactly what I had hoped it would be and more." Read on for the rest of Suehring's review. High Performance MySQL author Zawodny & Balling pages 294 publisher O'Reilly rating Excellent reviewer Steve Suehring ISBN 0596003064 summary Optimization, Backups, Replication, Load Balancing & More

With a title like High Performance MySQL, the reader should not expect assistance with tasks such as installation or the basics of SQL. The authors acknowledge that the book isn't meant for the MySQL beginner. Even so, the book does spend a little time going over a refresher of MySQL. If the reader is looking for a book on the basics of MySQL, though, I'd recommend picking up a different title. I might be so brazen as to suggest looking at the book on MySQL that I wrote a couple years ago, but I'll leave it for the reader to find an appropriate title for their level of knowledge with MySQL.

The book is broken out into ten chapters, beginning with a chapter on the basics of MySQL as seen from someone with some level of MySQL experience. (And since I am someone with some level of MySQL knowledge, this chapter didn't seem to be too painful of a read.) That statement begs for a further explanation. I find it painful to read books that claim to have advanced topics but find it necessary to spend (or waste) time by giving yet another explanation of how to type ./configure; make; make install in the beginning chapter. In this regard, I find High Performance MySQL to be quite good at providing the appropriate level of explanation for the audience.

The first pages alone are a great starting point for those who are wondering about the performance as it relates to the different versions of MySQL. A discussion of the binary versions of MySQL versus the source code versions gives the reader a good understanding of the implications of this important decision. Choosing correctly between the versions of MySQL can help to maximize performance.

Though only the first chapter is titled "Back to Basics," most chapters include some basic or background information pertinent to that chapter. For example, both the query and index performance-related chapters include sections with the word 'Basic' in their titles. These two chapters, "Index Performance" and "Query Performance," cover topics often misunderstood when considering performance on a database. Naturally, any database administrator worth their pay (insert your own joke here) will tell you that an index can help to improve performance. But High Performance MySQL takes it a step further by diving into why you might use a particular index given your database needs. This type of practical information is common throughout the book. Rather than just give the reader a listing of the indexes (which are mostly common among RDBMS anyway), the authors choose to tell you why you might choose one method over another.

Other chapters within High Performance MySQL include chapters on server performance tuning, replication, load balancing, and high-availability, backup and recovery, and security. I've followed MySQL forums and mailing lists over the years and some of the more common questions relate to MySQL security. The chapter on security gives the reader a great explanation of the MySQL GRANT tables and includes a sidebar on the significance of 'localhost' in MySQL which nearly always seems to be a source of confusion, though maybe not for the reader of this particular book. Like other chapters, the security chapter includes tips for the underlying environment upon which MySQL operates. For example, regardless of how good the MySQL database permissions are configured, if another piece of software on the server isn't kept up to date then the entire server, including the MySQL data, could be compromised.

Looking back at the book, I might have laid the chapters out in a different order or provided more structure through sections of the book. However, this can be dismissed as personal opinion and is non-substantive anyway. I believe High Performance MySQL is an excellent choice for the MySQL administrator or developer not only looking to improve their database performance but also to improve his knowledge of MySQL.

You can purchase High Performance MySQL from bn.com. (And the book that Suehring alludes to is the MySQL Bible . Slashdot welcomes readers' book reviews -- to see your own review here, read the book review guidelines, then visit the submission page.

3 of 307 comments (clear)

  1. GNAA announces victory over mbonig by Anonymous Coward · · Score: -1, Troll
    GNAA announces victory over mbonig

    GNAA freedom fighters attack mbonig into submission

    Cakedrink KillsPics - Sinclair Broadcasting Correspondent

    In the GNAA's continued effort to combat mindless idiocy, blogging, and bigoted oppression of gay nigger rights, GNAA member Penisbird has announced victory over mindless slashbot and blogger mbonig.

    In true Hitlerian fashion, mbonig wanted to deny freedom speech to gay black men under the guise of his own nazi-esque values of censorship. "Gasgaynigs", mbonig was quoted as saying to a swooning crowd of neo-nazis ready for a golden shower of his drivel.

    GNAA member Penisbird, who is considered of one of the most gifted and intelligent members, according to the GNAT or Gay Nigger Aptitude Test, excellently crafted his arguments against the nazi, as shown here, and was able to counter every point with concise and irrefutable facts. In the usual Slashdot hypocrisy, anyone who fights for the legitimate rights of the unpopular is considered a troll and this thread was no different.

    The tragic defeat on Slashdot forced mbonig to retreat to his blog and admit that the GNAA's posts are free speech (unlike what he said earlier) while at the same time slandering Penisbird's impeccable character. Penisbird does not tolerate such insolence and proceeded to attack his wretched blog.

    In the most skilled fashion, Penisbird proceeded to flood his blog as a form of legitimate protest. Like an relentless flood of nigger cocks, Mbonig (which is an intentional slur against niggers) tried to squelch the massive flood of protest posts by deleting hundreds of comments but could not keep up. His next step was to disable commenting for a couple of days. The very morning he restored comments and declared that by requiring logins, the attacks would cease. Wrong. Penisbird was on the attack and continued the assault.

    After the morning offensive, mbonig quickly and embarrassingly disabled comments, declaring that "script kiddies" (the scripts in question consist of Microsoft Internet Explorer and the refresh button) do not deserve the same free speech rights he enjoys. However, Penisbird was victorious in that he caused mbonig to permanently disable comments. Penisbird vows to keep up the assault on his Slashdot posts and anywhere else he tries to oppress free speech rights online.

    mbonig claims that he is not hiding who he is. Really? What is your last name? Where do you live? Oh, it seems that you are hiding who you are. Hypocrite.

    About mbonig:

    mbonig is a mindless Slashbot and blogger who constantly tries to oppress free speech online. He is a known neo-Nazi and supports the gassing of Gay Men of African Descent.

    Mbonig is currently offering gmail invites, You may partake his invitation below:
    https://gmail.google.com/gmail/a-b0ab39f1a8-51723

    About GNAA:

    GNAA
    (GAY NIGGER ASSOCIATION OF AMERICA) is the first organization which
    gathers GAY NIGGERS from all over America and abroad for one common goal - being GAY NIGGERS.

    Are you GAY ?
    Are you a NIGGER ?
    Are you a GAY NIGGER ?

    If you answered "Yes" to all of the above questions, then GNAA (GAY NIGGER ASSOCIATION OF AMERICA) might be exactly what you've been looking for!
    Join GNAA (GAY NIGGER ASSOCIATION OF AMERICA) today, and enjoy all the benefits of being a full-time GNAA member.
    GNAA (GAY NIGGER

  2. Re:Sometimes MySQL indexes are bad... by Anonymous Coward · · Score: -1, Troll

    I would like to kick you in the testes.

  3. Comment removed by account_deleted · · Score: -1, Troll

    Comment removed based on user account deletion