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.
Is main presentation at 7:15 or at 8? If 8, what's at 7:15? Thanks