Last week I presented my talk, "How to Analyze and Tune SQL Queries for Better Performance" both at Percona Live in Santa Clara and at airbnb Tech Talks in San Francisco. The slides are available on slideshare. A video recording from the airbnb talk should eventually be available the airbnb Tech Talks page.
Tuesday, April 21, 2015
Wednesday, February 25, 2015
MySQL Webinar: Analyze & Tune Queries for Better Performance
Thanks to everyone who attended my webinar today, and thanks for all the positive feedback in the Q&A session. Unfortunately, I was not able to respond to everyone during the 15 minutes available for Q&A. If your question did not get answered, feel free to use the comments section of this blog post to ask your question. You can also ask questions on the MySQL Optimizer Forum.
The slides from the presentation are available here. In a few days, I expect it to be possible to access it as an MySQL On-Demand Webinar.
Wednesday, February 18, 2015
MySQL Webinar: Analyze & Tune Queries for Better Performance
On Wednesday, February 25 at 18:00 CET (9 am Pacific Time), I will do webinar on how to analyze and tune MySQL queries for better performance.
The webinar covers how the MySQL optimizer chooses a specific plan to execute SQL queries. I will also show you how to use tools such as EXPLAIN (including the new JSON-based output) and Optimizer Trace to analyze query plans. We will also review how the Visual Explain functionality available in MySQL Workbench helps us visualize these plans. The webinar will also contain several examples of how to take advantage of the query analysis to improve performance of MySQL queries.
The presentation will be approximately 60 minutes long followed by Q&A.
For details on how to register for the webinar visit http://www.mysql.com/news-and-events/web-seminars/analyze-tune-queries-for-better-performance/
The webinar covers how the MySQL optimizer chooses a specific plan to execute SQL queries. I will also show you how to use tools such as EXPLAIN (including the new JSON-based output) and Optimizer Trace to analyze query plans. We will also review how the Visual Explain functionality available in MySQL Workbench helps us visualize these plans. The webinar will also contain several examples of how to take advantage of the query analysis to improve performance of MySQL queries.
The presentation will be approximately 60 minutes long followed by Q&A.
For details on how to register for the webinar visit http://www.mysql.com/news-and-events/web-seminars/analyze-tune-queries-for-better-performance/
Subscribe to:
Posts (Atom)