|
Pro MySQL (Expert's Voice in Open Source)
|
List Price:
$49.99
Homebizpc.com Price:
$40.45
Your Savings: $ 9.54 ( 19% )
Subject To Change Without Notice
Availability: Usually ships in 24 hours
Manufacturer: Apress
|
Average Customer Rating:  
|
|
Binding: Paperback
Dewey Decimal Number: 005.7585
EAN: 9781590595053
ISBN: 159059505X
Label: Apress
Manufacturer: Apress
Number Of Items: 1
Number Of Pages: 768
Publication Date: 2005-07-25
Publisher: Apress
Studio: Apress
|
|
|
|
|
|
|
|
|
Editorial Reviews:
|
|
Pro MySQL Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world's most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or you’re a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you. The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The authors also delve deep into the MySQL source code and system architecture at a level you won't find anywhere else. Essential advanced SQL is also covered, with discussion of subqueries, derived tables, and joins. These concepts are demonstrated in a range of situation-specific examples—from dealing with hierarchical data to performing Geographic Information System (GIS) examples with just MySQL. This section also covers MySQL 5's new enterprise features like stored procedures, triggers, and views. The latter part of this book devotes itself to administration topics. Topics include MySQL installation and upgrading, user administration, database backups, replication, and clustering. You'll also learn about the new data dictionary features available in MySQL 5.
|
|
|
Spotlight customer reviews:
|
Customer Rating: 
Summary: Not too impressed
Comment: This book attempts to cover too much material instead of spending more time on specific topics. If you're interested in performance, replication, backup or recovery, skip this book and get the High Performance MySQL book. You'll quickly see the material on those topics has a lot more depth in the other book. Especially for replication, backup and recovery.
For everything else, you might as well just get a introductory/reference mysql book.
Also, the coverage of mysql 5 is based upon an early beta.
Customer Rating:
Summary: Solid in-depth coverage - not for the feint of heart
Comment: I've managed to get about halfway through this book so far. It's NOT an easy read. Coverage and detail are excellent, however, and if you're interested in plumbing the depths of how MySql works, I would recommend this book as a solid reference for improving your overall knowledge.
Customer Rating:
Summary: If you are into MySQL then GET THIS BOOK!
Comment: No, I am not associated with the authors in any way. I was looking for a book for MySQL that was beyond "this is a database, here is how you select".
I wanted something more challenging that covered topics like clustering, backups, etc.
This book dives deep into MySQL database use and design, including detailed information on indexes, optimizations, etc.
Very good read. I totally recommend this book.
cbmeeks
Customer Rating:
Summary: Great Expert Overview
Comment: This book is a great expert overview of all that is current in MySQL 5. This covers both the SQL interaction with the database and the management. There are aspects that users often don't use in any SQL platform, and it is a shame. The effort expended to learn stored procedures and custom functions is greatly rewarded in code creation and support. This is another book I rate as ROI super positive.
Customer Rating:
Summary: Best book to learn Advanced MYSQL
Comment: For people like me who have a good understanding of MYSQL, the next logical step would be this book. I already know about stored procedures, transactions and the basics of triggers, but I want to learn more about these topics in more "real-world" scenarios in how to develop larger, enterprise-wide applications. Also I want to know more about other advanced topics that I may not even know to think about. If this sounds like you as well, then read on...
The author starts in with reviewing how business requirements and the software development cycle can be part of database development. This a great chapter for people like me who would like to learn how different approaches are taken from different IT perspectives in a team environment (business analysts, application developers, and project managers) This chapter gives you a good understanding of how the other side thinks.
The next chapter focuses on the importance of proper indexing and strategies as pertaining to data storage. Because once your databases reach to the multiple gigabits of storage space, you need to very focused on how long each request takes. A few seconds here and there begin to add up and can cause serious issues if not taken into consideration early in your database design. Like me who only deals with small to an occasional medium-size database I never really had to think about this before.
The next chapter focuses on transaction processing in MYSQL which is one of the more difficult concepts for many and I am in the process now of reading it. I really like the author's explanations and examples. Each point is explained thoroughly and in an easy to read manner.
The rest of the book goes into more advanced topics (system architecture, benchmarking and profiling, security, replication and clustering) as well as giving more detail and explanation to topics that may only be briefly covered in other MYSQL books (stored procedures, functions, and views).
If you already know the basics of MYSQL and want to really advance your knowledge with "real-world" scenarios, this is the book for you.
|
|
|
|
|
|
|
|
