Product Description

This comprehensive reference manual covers issues at all stages in MySQL use, from installation problems through performance tuning. Included are suggested uses of privileges to enhance security, many performance tips, and a sophisticated guide to error recovery. It also offers a thorough comparison of MySQL with SQL standards and other databases. This version covers MySQL 4.0. Topics covered in this manual range from the hitches you may run in to when first installing MySQL to internals that should help you tune your queries. The manual contains comprehensive reference material for building the product, running administrative utilities, and using various API as well as MySQL's version of SQL. Also included in the book are: a comparison of MySQL with SQL standards and other databases; a discussion of privileges and suggested uses of privileges to enhance security; directions for replicating a database and for running several MySQL servers on a single system; directions for initializing a database from a flat file; guidelines for estimating the performance of different queries; a discussion of optimization, with reference to the implementation of MySQL; investigations of the differences between data types and the pros and cons of each type of number, string, or timest amp; an extended inquiry into the effects of using delayed inserts; a candid explanation of why various errors occur and how to recover from them; tips for weighted, full-text searches; detailed descriptions of the features, strengths, and weaknesses of available table formats; and a guide to adding new functions to MySQL.

Product Details

• Amazon Sales Rank: #692738 in Books
• Published on: 2002-06-03
• Original language: English
• Number of items: 1
• Binding: Paperback
• 712 pages

From the Publisher
This highly regarded and comprehensive reference manual comes directly from the members of the MySQL team. The book covers issues at all stages in MySQL use, from installation problems through performance tuning. Included are suggested uses of privileges to enhance security, many performance tips, and a sophisticated guide to error recovery. It also offers a thorough comparison of MySQL with SQL standards and other databases. No serious MySQL user should be without this book.

About the Author
David Axmark, Co-founder: David Axmark is one of the founders of MySQL and worked with the product well before it had a name. He has worked as a consultant and software developer for nearly 20 years. Interested in free software since the early '80s, David has been committed to developing a successful business model through open source software.

Customer Reviews

It's all you'll need for a long while...
This is a great book. It's written by the actual guys who develop the MySQL RDMS and their unmatched level of knowledge is apparent from page one. A lot of the material covered is freely available from the MySQL web site, but if you are like me and would rather sit down and read a book than have to read through reams of info on a screen then this is a wise buy. That said, there is still a lot of stuff in here that doesn't appear to be on their web site.

I already knew the basic stuff about MySQL before I bought this book but this has provided me with enough knowledge to keep me going a good while longer. The optimisation tips alone are worth the price.

1 : 1 copy of the online documentation
This book is a one to one copy of the online documentation, but then even outdated! Why would I buy this book if i can download the documentation in an up-to-date format onto my PC.

Like the title says, it is a reference. So no book that you read from page 1 until the end. On the contrary: if you have a problem you look that up. Although the book does have an index, searching for a particular topic is much faster in an e-document than in a printed book.

If i would have known that beforehand, I would not have bought this book. It maybe look nice on you bookshelf but is withou any practical use.