- Taschenbuch: 710 Seiten
- Verlag: O'Reilly & Associates; Auflage: 1 (12. Juni 2002)
- Sprache: Englisch
- ISBN-10: 0596002653
- ISBN-13: 978-0596002657
- Größe und/oder Gewicht: 17,8 x 3,6 x 23,3 cm
- Durchschnittliche Kundenbewertung: Schreiben Sie die erste Bewertung
- Amazon Bestseller-Rang: Nr. 558.588 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
- Komplettes Inhaltsverzeichnis ansehen
MySQL Reference Manual (Classique Us) (Englisch) Taschenbuch – 12. Juni 2002
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
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.
Über den Autor und weitere Mitwirkende
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.
Die hilfreichsten Kundenrezensionen auf Amazon.com
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.
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.
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!