Effective MySQL Optimizing SQL Statements (Oracle Press) and over one million other books are available for Amazon Kindle. Learn more
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images
Have one to sell? Sell on Amazon

Effective MySQL Optimizing SQL Statements (Oracle Press) Paperback – September 28, 2011

ISBN-13: 978-0071782791 ISBN-10: 0071782796 Edition: 1st
Buy used
$12.94
Buy new
$26.18
Used & new from other sellers Delivery options vary per offer
53 used & new from $8.95
Amazon Price New from Used from
Kindle
"Please retry"
Paperback, September 28, 2011
"Please retry"
$26.18
$13.80 $8.95
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now
$26.18 FREE Shipping on orders over $35. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Effective MySQL Optimizing SQL Statements (Oracle Press) + Effective MySql Backup and Recovery (Oracle Press) (Oracle (McGraw-Hill)) + Effective MySQL Replication Techniques in Depth
Price for all three: $63.89

Buy the selected items together

Editorial Reviews

About the Author

Ronald Bradford is an Oracle ACE Director and MySQL Community Member of the Year. He is also the visionary force behind this series. Ronald is a respected industry expert with more than 20 years of experience in the relational database field, with 12 years of experience working with MySQL. He combines his extensive consulting expertise with numerous public speaking events at conferences worldwide. Ronald is the all-time top individual MySQL blogger and is co-author of Effective MySQL: Backup and Recovery.

NO_CONTENT_IN_FEATURE


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Oracle Press
  • Paperback: 184 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (September 28, 2011)
  • Language: English
  • ISBN-10: 0071782796
  • ISBN-13: 978-0071782791
  • Product Dimensions: 6 x 0.4 x 9 inches
  • Shipping Weight: 8.8 ounces (View shipping rates and policies)
  • Average Customer Review: 4.6 out of 5 stars  See all reviews (19 customer reviews)
  • Amazon Best Sellers Rank: #205,664 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.6 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

17 of 17 people found the following review helpful By David M. Stokes on November 22, 2011
Format: Paperback
The size of this book is deceiving -- it is packed with many time more information per its 160 some pages than many other books that cost much more. The sections on indexes are a must read for anyone using MySQL. The examples on using EXPLAIN are perfect someone needed into the art of tuning queries.

The first chapter, 'The 5 Minute DBA' should be required reading. Too many DBAs do not know how to delve into their systems to find or confirm problems. The three chapters on index are as clear and lucid on the subject as I have found.

So if you are new to MySQL query tuning or an old hand looking for a very clean explanation of the art, this is the book to get.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
11 of 11 people found the following review helpful By Plamen Mitev on December 12, 2011
Format: Paperback Verified Purchase
Easy to read, lots of valuable information, packed with useful examples. It helped me find and fix issues, which I never thought I had. Great value for money, easily worth the $26 purchase price.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Giuseppe Maxia on January 7, 2012
Format: Kindle Edition
This is a book where the author experience and his practical approach shows right from the beginning, and keeps up to the expectations till the end.
Contrary to a trend that wants technical books to be bulky and heavy, this one is short, and to the point. That doesn't mean the book lacks information. On the contrary, the topic is treated extensively and completely. Not only that, the book is organized in such a way that it becomes a handy guide to anyone dealing with MySQL queries.
As the title says, it's "Effective". I look forward to get more books in the same series.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Hans Forbrich on January 6, 2012
Format: Paperback
This book achieves it's aim of being a condensed compendium to some of the most powerful SQL Optimization techniques available. Ronald leans on his many years as a MySQL expert and consultant to pack a lot of useful tips and tricks into this small volume.

As a reviewer of the book, I felt I was already quite knowledgeable in the area, but Ronald was able to pull some new-to-me information into each and every chapter. I recommend this to all of my MySQL customers and am looking forward to the rest of the series.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Sergey Chernyshev on January 4, 2012
Format: Paperback Verified Purchase
It's a first book about DB optimization I see that I read from cover to cover with useful information on every page, even considering that I knew a few things about the topic already.

Author worked hard to remove the unnecessary details and theoretical fluff and left only enough information to make it very practical with examples illustrating the boundaries of the issue. Book is full of examples on realistic data-sets with notes and links to tools and additional information about the topic when diving deeper is useful, but optional.

I come primarily from web development background and this is an ideal book for developers who finally decided to work on their SQL. It doesn't give magical "silver bullet" solutions, instead it delivers understanding of the benefits and consequences for every action.

A must-have for the office library - I am giving to all my developers to read!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Keri S. on January 6, 2012
Format: Paperback
Effective MySQL Optimizing SQL Statements was a great read. This book has all the necessary information for SQL optimization along with professional tips, tricks and explanations on how to identify and solve SQL related problems. There is also a lot of good information on server tunable parameters and how to identify and use MySQL to its fullest extent.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By Declan on January 4, 2012
Format: Paperback
A great read packed with useful actionable information. I think the author has done a good job in of avoiding the impulse to fill with fluff. I love "The 5 Minutes DBA and the section on indexing. If you're serious about your career this book is a thankful quick, "Must Read" that worth ever penny of $26 and more.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 6 people found the following review helpful By glowens on January 4, 2012
Format: Paperback Verified Purchase
Great intro book for programmers just getting their feet wet in Mysql. The book is straight forward and to the point with not a lot of fluff as compared to similar books. Its a must read for programmer and I can't wait for the second book in the series.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Effective MySQL Optimizing SQL Statements (Oracle Press)
This item: Effective MySQL Optimizing SQL Statements (Oracle Press)
Price: $26.18
Ships from and sold by Amazon.com