addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Improving Performance with Better Indexes by Ronald Bradford

  • Feb 15, 2012 · 3:00 PM

Ronald Bradford a MySQL Oracle ACE Director will present !

Learn how to use one simple advanced technique to make better MySQL indexes and improve your queries by 500% or more. Even with a highly indexed schema significant improvements in performance can be achieved by creating better indexes.

This presentation introduces the approach for correct identification and verification of problem SQL statements and then describes the means of identifying index choices for optimization. Then discussed is not only how to apply indexes to improve query performance, but how to apply better indexes and provide even greater performance gains.

This presentation includes:

  • Effective examples of capture SQL via application logging and TCP/IP analysis necessary for identifying the best candidates. Slow is not always the best query to start with.
  • All the commands necessary to identify why you may need an index, how to create varying types of indexes, and how to confirm there true effectiveness.
  • How the number of table rows and different storage engines can greatly effect the optimization choice and query performance
  • The presentation shows how to determine/create and verify covering indexes for a single table example, a master/child example and a production 13 table join.

 

Our meeting will be in Conference Center room 2 in Building 1 of the Oracle Broomfield Campus. 

Pizza to Follow.

Join or login to comment.

  • SrinivasaKrishna

    it was useful and informative.

    March 12, 2012

  • A former member
    A former member

    Thanks to Ronald and everyone who attended.
    Some talk afterwards revolved around MySQL Cluster. Here one of the blog posts we talked about http://www.clusterdb.com/mysql-cluster/1-billion-queries-per-minute-and-much-more-free-webinar-on-mysql-cluster-7-2-ga/

    February 16, 2012

  • Brady B.

    Definitely useful! Learned some new stuff!

    February 16, 2012

  • Richard S.

    The presentation was a little short, but was HUGELY informative.

    February 16, 2012

  • A former member
    A former member

    Ron's presentation was informative and helpful.

    February 16, 2012

  • Roy F. D.

    This topic is something the developer should be aware of so the SQL can be properly created the first time.

    February 16, 2012

  • A former member
    A former member

    Sorry to host events at the Oracle Campus I need to have them during work hours.
    I am open to other venues if people have any?

    January 12, 2012

  • Brian O.

    3PM on a weekday? Would love to attend, but I'll be at work.

    January 12, 2012

22 went

Our Sponsors

  • Oracle

    Meeting space and food

Sign up

Meetup members, Log in