- Paperback: 816 pages
- Publisher: O'Reilly Media; 1 edition (10 Jun 2002)
- Language French
- ISBN-10: 0596002653
- ISBN-13: 978-0596002657
- Product Dimensions: 17.8 x 3.6 x 23.3 cm
- Average Customer Review: 2.5 out of 5 stars See all reviews (2 customer reviews)
-
Amazon Bestsellers Rank:
1,078,396 in Books (See Top 100 in Books)
- #25 in Books > Computers & Internet > Computer Science > Databases > Applications > MySQL > Advanced & Intermediate
- See Complete Table of Contents
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
MySQL is the most popular SQL database in the open source community and is used almost universally by web sites running on open source systems. As powerful and flexible as it is lightweight and efficient, MySQL packs a large feature set into a very small and fast engine that now runs on more than 500,000 servers. This renowned online manual that has supported MySQL administrators and database developers for years is now available in paperback format. This book is an exact reproduction of the MySQL Reference Manual from the MySQL development team's Web site, minus some non-technical appendices. This version covers MySQL 4.0.
Many sophisticated topics appear in this comprehensive manual, ranging from the hitches you may run into when first installing MySQL to internals that will help you tune your queries. MySQL Reference Manual contains all the comprehensive reference material one would expect for building the product, running administrative utilities, and using various API as well as MySQL's rich version of SQL. In addition, you can turn a page and find such unexpected riches as:
- A thorough 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 far-reaching 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 timestamp
- 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
- A guide to adding new functions to MySQL
No serious MySQL user should be without this book.
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.
Inside This Book
(Learn More)
First Sentence
The MySQLTM software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
The MySQLTM software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
Most Helpful Customer Reviews
25 of 25 people found the following review helpful
Format:Paperback
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.
10 of 14 people found the following review helpful
Format:Paperback
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.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
8 reviews
11 of 11 people found the following review helpful
Complete, but poorly organized
11 Oct 2002
Format:Paperback
A paper copy of the manual can be most useful, since I, like most people, find it hard to wade through an online manual.
But there is one area in which the online form is more useful: searching. By opening the MySQL manual in a text editor, one can search it, making the poor organization of the manual less of a problem.
The printed copy suffers from the same poor organization (indeed, it is the same as - or very, very close to - the online manual) but without the ameliorating factor of searchability. The index is not very good, but even if it was better, the scattering of information throughout the book would make for lengthy index entries.
Take security for example. What is the recommended process for securing a fresh MySQL installation? Start at the Table of Contents: Aha! 4.3 "MySQL User Account Management" Sounds promising. P. 249. GRANT and REVOKE Syntax? Not what I had in mind. I just want to know about the right way to secure the system and create new users. Back to the Contents. 2.4 "Post-Installation Setup and Testing" P.113. Nope, nothing there.
Last resort: The index. Security, against hackers, p.227. Nope. But that page is in section 4.2 "General Security Issues and the MySQL Access Privilege System." Now that sounds like it. Start reading section 4.2.1 on p. 224... "If you are able to connect successfully to the server without being asked for a password, you have problems! ... Review the MySQL installation instructions..." I thought I just did that. Now I know the secret is burried in the installation instructions. Back to Chapter 2. Still no dice.
Give up and install phpMyAdmin.
While I don't doubt that the answers to this and a myriad other questions are in there somewhere, the poor structure of the book makes it extremely hard to find anything.
A complete rewrite would do the trick.
17 of 20 people found the following review helpful
As stated earlier, complete but poorly organised...
25 Oct 2002
Format:Paperback
This book is the printed version of the online documentation available through the MySQL site. It is the definitive version of documentation for MySQL, but it is also left wanting. The authors, two of the principle programmers of MySQL, provide comprehensive coverage of all aspects of MySQL.
That being said, one of the biggest problem with this book is not its subject coverage, but its organization. Most technical books begin with installation instructions, or a brief overview of the software's purpose and the need it addresses and then moves into technical subjects. This one spends the first 10% telling you why you should use MySQL, and only then does it start delving into technical matters.
Skipping past that, the book's other big shortcoming is that it's biased towards a Unix mindset. Granted, the software was developed on Unix and the largest portion of deployments are on *nix. However, as a long-time Windows user with little *nix familiarity, a lot of the material is over my head. If they want Windows users to use MySQL correctly, they're going to have to make it much easier for Windows users/admins to understand.
The one thing I found the book does really well is to teach you exactly how to use MySQL using SQL, and documenting well where MySQL diverges from ANSI SQL compliance. The portion of the book strictly dedicated to teaching the user how to use it is well-written and thorough, I wish the rest of the manual was written this well.
That being said, one of the biggest problem with this book is not its subject coverage, but its organization. Most technical books begin with installation instructions, or a brief overview of the software's purpose and the need it addresses and then moves into technical subjects. This one spends the first 10% telling you why you should use MySQL, and only then does it start delving into technical matters.
Skipping past that, the book's other big shortcoming is that it's biased towards a Unix mindset. Granted, the software was developed on Unix and the largest portion of deployments are on *nix. However, as a long-time Windows user with little *nix familiarity, a lot of the material is over my head. If they want Windows users to use MySQL correctly, they're going to have to make it much easier for Windows users/admins to understand.
The one thing I found the book does really well is to teach you exactly how to use MySQL using SQL, and documenting well where MySQL diverges from ANSI SQL compliance. The portion of the book strictly dedicated to teaching the user how to use it is well-written and thorough, I wish the rest of the manual was written this well.
10 of 11 people found the following review helpful
Finally, The MySQL Reference Manual - On my shelf!
30 Jun 2002
Format:Paperback
As a longtime user (a happy one at that!) of MySQL, I am happy to finally have the REAL reference manual on the shelf where I can pick it up and use it - just like all the others!
Lack of a printed reference manual has long been a complication of using MySQL, although the electronic documentation has been great for the last couple of years! As author and MySQL developer Monty Widenius stated about the book (MySQL web site announcement), "The printed version of our highly-used reference manual will be an essential resource for any MySQL user, and it will complement the wide selection of MySQL books that are currently available."
This one, as the actual reference manual is a great complement to Paul DuBois' popular 'MySQL', which serves as the users manual. Together, these are the printed resources necessary to be a power administrator and user of MySQL! Thanks Monty!
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > MySQL > Advanced & Intermediate
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
