January 25, 2012 6:30 PM. 50 attended.

Goldilocks and The Three Queries -- MySQL's EXPLAIN explained

Overview:
Goldilocks and The Three Queries -- MySQL's EXPLAIN explained

How do you know if your queries are running as well as they should?  Would an index help or hurt a particular query? Come hear Dave Stokes of the MySQL Community Team talk about using EXPLAIN, EXPLAIN extended, & the new Optimizer Tracer to see how MySQL is running your queries and how to use those tools to make your queries perform better.  Learn to see how your MySQL server sees your carefully crafted queries.

Bio:
Dave Stokes is a Community Manager for MySQL and previously was the MySQL AB Certification Manager.   He has been using MySQL since 3.23 and actually wrote his first computer program in FORTRAN using a keypunch, which was very dangerous with all the dinosaurs roaming about stepping on people.  He has worked alphabetically for companies ranging from the American Heart Association to Xerox and now travels the world evangelizing for MySQL

Agenda:  
6:30 - 7:00 -- Doors open/general socializing & food provided by Percona  
7:00 - 7:15 -- Intro/announcements  
7:15 - 8:00(ish) -- Main presentation  
8:00 - 9:00 -- Main presentation 
Q&A 9:00 - 10:00 -- General discussion/Q&A/networking/etc.  
10:00ish -- post-event socializing... aka beers someplace nearby

Sponsors
Percona is the oldest and largest independent MySQL support and consulting company, with a global 24×7 staff of over 40 people serving more than 1000 customers in 50+ countries since 2006. Our clients achieve breakthrough results with MySQL: cost savings, faster time to market, higher system uptime, and long-term scalability. With Percona, you can execute with confidence and clarity. Anyone can claim expertise, but we show our abilities by creating open-source software for MySQL users, writing industry-leading books, and publishing original research on the widely read MySQL Performance Blog. We also organize the Percona Live series of conferences to share what we know.

CBS Interactive is the premier online content network for information and entertainment. Our brands dive deep into the things people care most about across news, sports, entertainment, technology and business. With hundreds of millions of unique visitors from around the world each month, CBS Interactive is a global top 10 web property and the largest premium content network online.

Continuent offers industry-leading replication and clustering solutions for MySQL. Continuent's expert consulting helps users quickly solve difficult problems in replication and data management. Continuent's Tungsten software enables 24x7 data availability and increased database performance for data-driven applications while retaining the cost advantages of open source software.

IGN.com is driven by our core values of Fire, Innovation, Excellence, Multiplayer & Irreverence, IGN is a leading online media & services company obsessed with gaming, entertainment and everything people enjoy. Our days and frequent nights are spent reveling in the world of games and entertainment. We are elbow to hairy elbow with the immediate and beautifully fickle culture that captivates the minds of people across the globe.

O'Reilly Media spreads the knowledge of innovators through its books, online services, magazines, research, and conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, the company has a long history of advocacy, meme-making, and evangelism.

 

  • Dan Levine
    Dan Levine

    Is main presentation at 7:15 or at 8? If 8, what's at 7:15? Thanks

    Posted January 25 at 12:08 PM
  • erin
    erin

    6:30-7:00 pm is food. 7:00-7:15 are announcements. 7:15 is the talk.

    Posted January 25 at 12:25 PM
  • Nilesh Dosooye
    Nilesh Dosooye

    Is there going to be a livestream?

    Posted January 25 at 4:57 PM
  • You must be a member to post a comment. Join or login.

50 attended
4.50 4.507 (7 ratings)

Percona

Food, drinks, books and speakers.

Continuent

Logo, signs & swag.

IGN Entertainment

Time, money, swag, food, drinks & facilities

CBS Interactive

Food, beverages & facilities

O'Reilly User Group Program

The O'Reilly User Group Program provides the great books we get monthly.

MySQL

A great database for us all to use! :)

People in this
Meetup are also in:

Log in

Not registered with us yet?

Sign up

Meetup members, Log in

or
By clicking the "Sign up using Facebook" or "Sign up" buttons above, you agree to Meetup's Terms of Service