MySQL Webinar: Analyze & Tune Queries for Better Performance

http://ift.tt/1E6KtmF

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://ift.tt/1E6Kvei

from Planet MySQL http://ift.tt/1du18ol