MySQL Administrator's Guide and over one million other books are available for Amazon Kindle. Learn more


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Sell Back Your Copy
For a $2.62 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
MySQL Administrator's Guide and Language Reference (2nd Edition)
 
 
Start reading MySQL Administrator's Guide on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

MySQL Administrator's Guide and Language Reference (2nd Edition) [Paperback]

MySQL AB (Author)
4.0 out of 5 stars  See all reviews (7 customer reviews)

List Price: $54.99
Price: $29.99 & this item ships for FREE with Super Saver Shipping. Details
You Save: $25.00 (45%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Only 6 left in stock--order soon (more on the way).
Want it delivered Tuesday, February 14? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for students on millions of items. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $14.15  
Paperback $29.99  

Book Description

May 7, 2006 0672328704 978-0672328701 2
<>Written by the creators of MySQL and edited by one of the most highly respected MySQL authors, the MySQL Administrator's Guide and Language Reference is the official guide to installing MySQL, to setting up and administering MySQL databases, and to storing and retrieving data in these databases. This new edition combines into one book the MySQL Language Reference (on CD) with the practical information of the MySQL Administrator's Guide book. 

 

 


Frequently Bought Together

MySQL Administrator's Guide and Language Reference (2nd Edition) + MySQL Database Design and Tuning + MySQL 5.0 Certification Study Guide
Price For All Three: $100.00

Show availability and shipping details

Buy the selected items together
  • In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • MySQL Database Design and Tuning $34.21

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • MySQL 5.0 Certification Study Guide $35.80

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought


Editorial Reviews

About the Author

Paul DuBois is the leading author of books on MySQL topics. His book, MySQL (0672326736), is considered the definitive guide to using, administering and programming MySQL. He is currently an employee of MySQL AB and is in charge of editing and maintaining the official English-language documentation for MySQL.

Product Details

  • Paperback: 888 pages
  • Publisher: MySQL Press; 2 edition (May 7, 2006)
  • Language: English
  • ISBN-10: 0672328704
  • ISBN-13: 978-0672328701
  • Product Dimensions: 9 x 7.1 x 2 inches
  • Shipping Weight: 2.9 pounds (View shipping rates and policies)
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (7 customer reviews)
  • Amazon Best Sellers Rank: #213,071 in Books (See Top 100 in Books)

 

Customer Reviews

7 Reviews
5 star:
 (2)
4 star:
 (3)
3 star:
 (2)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.0 out of 5 stars (7 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

13 of 14 people found the following review helpful:
4.0 out of 5 stars Well Worth It, July 27, 2005
By 
The MySQL Administrator's Guide by MySQL Press is the ultimate reference for anyone installing, upgrading or maintaining the MySQL database server. I found this guide to be completely invaluable when using MySQL, even before I had downloaded the software. The Guide uses clear, easy to read, formatting which makes shell instructions stand out from MySQL statements. A detailed index takes no time to show you where in 600 pages your answer lies. And you can bet you'll find the answer in this Guide. Beginners beware, however, this is no introduction to MySQL. Readers should have a clear understanding of their system, along with experience of MySQL, although an insight into MySQL AB and MySQL's history is included in Chapter 1.

As I began reading through this Guide, I couldn't help notice immediately how it sets itself apart from similar books. The MySQL Admin Guide has a detail which you will not find anywhere else. Such is to be expected from the company who make the software, and this book certainly shows the high quality of MySQL. After reading through this book, I can't help but agree with Kaj Arno (Vice President Software Engineering, MySQL AB) who is quoted on the back page; "'It is not possible to find a more thorough and more current reference in print, anywhere'". One of the best example I can make of this fact is in Chapter 2 which focuses on Installing MySQL. Not only does this Guide list all the option of a source distribution, all the ins and outs of installing MySQL on all likely platforms - Windows, Mac OS X, NetWare, Linux and other general Unix systems - this guide also deals with Upgrading and Downgrading the most recent version of the MySQL database server. And of course, to ensure that the entire knowledge is in print, Perl installation notes are included too. What other book covers the often troublesome installation process in almost 150 pages of detail?

And that's only the second chapter. Throughout the book you're assured to find comprehensive information straight from the people who know it best. You may think that this book simply offers too much information, and for most people I would have to agree. It is unlikely to bother a system administrator how MySQL server optimizes the WHERE clause, or how to avoid table scans. Even if someone was interested in understanding something like this, they'd have the opportunity of looking at the MySQL Reference Manual online. So why buy the print version? The printed Guide not only allows for offline viewing, it also includes information which has not been included in the Reference Manual, such as how details are stored and the many feature of MySQL's MaxDB. If your not content with only having part of the story, you'll want to get this Guide.

The MySQL Administrator's Guide is the ideal book for system administrators who want to get the most out of their MySQL server. With all the advice on installing, maintaining and administering that you'll ever need to know, this Guide by MySQL AB is ideal for those who long for a comprehensive printed reference.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


14 of 17 people found the following review helpful:
4.0 out of 5 stars extensive documentation, September 30, 2004
With what appears to be stunning speed, the open source relational database known as MySQL has been installed on many thousands of sites. Of course, the cost-free nature is its best selling point. With its rise, so too is the necessity for books like this.

Its bulk should be reassuring. The MySQL company has put a lot of sweat into making the manual as extensive as possible. Not light reading. But the individual sections should be within your grasp, if you have some sysadmin experience. For example, the introductory sections that deal with installations are on a par of complexity comparable to installing GCC or Tomcat. Not a one click installation. Because MySQL offers a lot of configuration options, if you go with a source distribution.

The toughest part may be later, when you have a populated database and you want to optimise it. Unsurprisingly, you will need good prior background in SQL. Take note that this book does not teach you SQL, per se. That is properly the remit of another text.

By the way, the book mentions that (finally) stored procedures are implemented. In version 5. Other database vendors, like IBM and Oracle, have had this ability for years, and have hammered on MySQL for its lack. Here, the book could do with an expanded discussion of how to use these procedures. It just has a cursory note. Hopefully, the next edition will improve on this. Because stored procedures are an important performance optimiser in many large databases.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1 of 1 people found the following review helpful:
5.0 out of 5 stars Excellent -- if your running version 5, May 17, 2007
By 
Michael Shavel (Charlottesville, VA) - See all my reviews
(REAL NAME)   
This review is from: MySQL Administrator's Guide and Language Reference (2nd Edition) (Paperback)
This is an excellent book, but it is written for MySql 5. Check your version before buying.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews





Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
myi samchk, general query log, user table row, myi sampack, development source tree, mysgld server, specifying program options, key caches, slow query log, default service name, orphaned table, mysql server, mysql dump, binary log files, ndex table, undo log entries, innodb data, lock struct, record references index, relay logs, condition pushdown, default storage engine, doublewrite buffer, innodb status, guilhem guilhem
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Configuration Wizard, Program Files, Installation Wizard, Index Merge, Open Source, Language Reference, Keeping Your Password Secure, Startup Item, Using Option Files, Database Backup Program, Hot Backup, Securing the Initial, Tuning Server Parameters, Password Hashing, Synchronization Manager, General Public License, Perl Installation Notes, Database Administration, Distinguished Name, Multi-Computer Configuration, Option Description, Query Browser, Scalable Coherent Interface, Table-Maintenance Utility, Using High-Speed Interconnects
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Back Cover | Surprise Me!
Search Inside This Book:

Citations (learn more)
This book cites 1 book:



What Other Items Do Customers Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(2)

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums



So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject