Start reading Effective MySQL Optimizing SQL Statements (Oracle Press) on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Effective MySQL Optimizing SQL Statements (Oracle Press)

Effective MySQL Optimizing SQL Statements (Oracle Press) [Kindle Edition]

Ronald Bradford
4.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £24.99
Kindle Price: £18.42 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £6.57 (26%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £18.42  
Paperback £19.39  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Product Description

Product Description

The Essential Guide to SQL Statement Optimization

Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements.

  • Identify the essential analysis commands for gathering and diagnosing issues
  • Learn how different index theories are applied and represented in MySQL
  • Plan and execute informed SQL optimizations
  • Create MySQL indexes to improve query performance
  • Master the MySQL query execution plan
  • Identify key configuration variables that impact SQL execution and performance
  • Apply the SQL optimization lifecycle to capture, identify, confirm, analyze, and optimize SQL statements and verify the results
  • Improve index utilization with covering indexes and partial indexes
  • Learn hidden performance tips for improving index efficiency and simplifying SQL statements

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.

Product details

  • Format: Kindle Edition
  • File Size: 1174 KB
  • Print Length: 184 pages
  • Simultaneous Device Usage: Up to 4 simultaneous devices, per publisher limits
  • Publisher: McGraw-Hill Osborne Media; 1 edition (28 Sep 2011)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B006402OBI
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #559,654 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5 star
3 star
2 star
1 star
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
4.0 out of 5 stars How I wish software developers would read this. 13 April 2014
By Simon_K
Format:Paperback|Verified Purchase
As a database analyst I found it well written and in an understandable format. A bit OTT for my own home needs but then it is better to learn the right way first.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.6 out of 5 stars  19 reviews
17 of 17 people found the following review helpful
5.0 out of 5 stars No fluff guide to optimizing MySQL queries 22 Nov 2011
By David M. Stokes - Published on
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.
11 of 11 people found the following review helpful
5.0 out of 5 stars Great book 12 Dec 2011
By Plamen Mitev - Published on
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.
9 of 9 people found the following review helpful
5.0 out of 5 stars A great practical book 7 Jan 2012
By Giuseppe Maxia - Published on
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.
7 of 7 people found the following review helpful
5.0 out of 5 stars Good introduction to MySQL Optimization 6 Jan 2012
By Hans Forbrich - Published on
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.
7 of 7 people found the following review helpful
5.0 out of 5 stars Great practical insight without fluff usual for this kind of books 4 Jan 2012
By Sergey Chernyshev - Published on
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!
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

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

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

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category