Unique Books on MySQL

These books are specialty books related to MySQL for which there may be only one book published in its category. These topics are generally advanced. Until we have more of the same kind, we’re piling them in here.
  • overall rating:
  • skill level:
  • technical level:
MySQL Stored Procedure Programming
  • edition: 1st
  • authors: Guy Harrison, Steven Feuerstein
  • publisher: O'Reilly Media
  • year published: 2006
  • isbn: 978-0596100896
  • pages: 636
In MySQL Stored Procedure Programming, they put that hard-won experience to good use. Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. It consists of four major sections: MySQL stored programming fundamentals—tutorial, basic statements, SQL in stored programs, and error handling. Building MySQL stored programs—transaction handling, built-in functions, stored functions, and triggers.
  • overall rating:
  • skill level:
  • technical level:
MySQL 5.0 Certification Study Guide
  • edition: 1st
  • authors: Paul DuBois, Stefan Hinz, Carsten Pedersen
  • publisher: MySQL Press
  • year published: 2008
  • isbn: 978-0672328121
  • pages: 672
The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide .
  • overall rating:
  • skill level:
  • technical level:
Understanding MySQL Internals
  • edition: 1st
  • author: Sasha Pachev
  • publisher: O'Reilly Media
  • year published: 2007
  • isbn: 978-0596009571
  • pages: 256
Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev—a former member of the MySQL Development Team—provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.