- Jubilee offer: spend £10 or more on any product sold by Amazon.co.uk on or before June 6 and you can buy The Diamond Jubilee A Classical Celebration Album for just £2.50 Here's how (terms and conditions apply)
High Performance MySQL
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £11.90
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in High Performance MySQL: Optimization, Backups, Replication, and More for an Amazon.co.uk gift card of up to £11.90, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
|
There is a newer edition of this item:
|
Special Offers and Product Promotions
Frequently Bought Together
Product details
|
More About the Authors
Discover books, learn about writers, and more.
Product Description
Book Description
The Path to Optimal Queries and Robust Servers
Product Description
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity.
High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover.
This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include:
- Emphasis throughout on both performance and reliability
- Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine
- Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views
- A detailed discussion on how to build very large, highly scalable systems with MySQL
- New options for backups and replication
- Optimization of advanced querying features, such as full-text searches
- Four new appendices
The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
7 of 7 people found the following review helpful
Format:Paperback
This book is not for beginners! This book is aimed at experienced developers who wish to take their mysql skills to the next level.
If you think you know it all, then you probably dont and this book is worth every penny! It will teach you how to choose the correct engine, optimise & bench mark your work to make sure you get the best out of your system. Its not easy and there is plenty to take in.
Excellent book - I gave it 4/5 because I felt that it went into too much details in some unimportant areas and skimmed over other areas that I thought were more important - however, this is probably just a personal preference. So might deserve closer to 4.8/5 :)
If you think you know it all, then you probably dont and this book is worth every penny! It will teach you how to choose the correct engine, optimise & bench mark your work to make sure you get the best out of your system. Its not easy and there is plenty to take in.
Excellent book - I gave it 4/5 because I felt that it went into too much details in some unimportant areas and skimmed over other areas that I thought were more important - however, this is probably just a personal preference. So might deserve closer to 4.8/5 :)
4 of 4 people found the following review helpful
Format:Paperback
I'm about halfway through reading this book and I've found it extremely enlighting. Though I am not working with applications that require performance of the level this book is referring to, it has taught me lot.
I finally have a clear picture of indexes and I should work with them, designing queries to use indexes and their sometimes not so obvious features. I generally have found this book to be detailed enough, in many cases there are explanation how MySQL works giving you the necessary info on how to design your schema and queries. I personally find it more pleasing to know why I should implement something in a certain way and not just how. This book offers both.
So, even though you might not be after that "High Performance", there's no need to pass this book, it will explain a great deal of MySQL's inner workings and give you tools to a secure and efficient database handling.
I finally have a clear picture of indexes and I should work with them, designing queries to use indexes and their sometimes not so obvious features. I generally have found this book to be detailed enough, in many cases there are explanation how MySQL works giving you the necessary info on how to design your schema and queries. I personally find it more pleasing to know why I should implement something in a certain way and not just how. This book offers both.
So, even though you might not be after that "High Performance", there's no need to pass this book, it will explain a great deal of MySQL's inner workings and give you tools to a secure and efficient database handling.
4 of 4 people found the following review helpful
Format:Paperback
The first edition of this book was a real find - at last a non-introductory book about MySQL that covers its use in more serious applications, the pros and cons of the variety of DB engines and coverage of other enterprise issues like backup and replication.
4yrs on after the 1st edition I was delighted to see an updated version of this book. The new book is more than double the thickness of the original, covering MySQL right up to v5.1. The good news is that the high density of detailed useful information packed into the original book has been maintained in this edition.
You really get the sense the authors know MySQL like the back of their hands, both in theory and practice and are passionate about getting their knowledge across in the book to help in your real-world applications.
This book is not for beginners learning databases, MySQL or SQL, but must surely be the de-facto reference for performance and enterprise use of MySQL.
4yrs on after the 1st edition I was delighted to see an updated version of this book. The new book is more than double the thickness of the original, covering MySQL right up to v5.1. The good news is that the high density of detailed useful information packed into the original book has been maintained in this edition.
You really get the sense the authors know MySQL like the back of their hands, both in theory and practice and are passionate about getting their knowledge across in the book to help in your real-world applications.
This book is not for beginners learning databases, MySQL or SQL, but must surely be the de-facto reference for performance and enterprise use of MySQL.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Worth every penny and more...
I have been developing with MySQL for a few years, albeit as a periphery to my PHP activities and limited to the usual few suspects of INSERT, SELECT and UPDATE along with... Read more
Published 7 months ago by Dr. Edward Austin
One of the most useful book on the topic
Finally something everybody who manages MySQL databases would like to read. It goes in deep details and covers almost all aspect of the performance issues when dealing with large... Read more
Published on 30 Dec 2009 by Sergio Paternoster
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 Design & Theory
- 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.
|
