Speaking at Percona Live

Percona Live is next week, and on Monday morning I will give a tutorial on "How to Analyze and Tune MySQL Queries for Better Performance".  I hope to see some of you there!  

For those of you that are not able to come, I recommend my on demand webinar on the same topic.  I will also give talks about query tuning at the upcoming Oracle MySQL Innovation Days to be held in the Bay Area (April 28) and in the Boston Area (May 2).

I would also like to recommend the following MySQL optimizer related talks at Percona Live:

• Monday 1:30pm: MySQL 8.0 Optimizer Guide (Morgan Tocker)
• Tuesday 1:20pm: MySQL 8.0: What is New in the Optimizer? (Manyi Lu)
• Wednesday 11:10pm: Cookbook for Creating INDEXes - All about Indexing (Rick James)
• Thursday 12:50pm: Recursive Query Throwdown in MySQL 8 (Bill Karwin)

MySQL 8.0: Improved performance with CTE

Last week I published a blog post in the MySQL Server Blog where I showed how the execution time of a query was reduced by 50% by using a Common Table Expression (CTE) instead of a view.

In the coming weeks, there will be several opportunities to attend a presentation on CTE and another SQL feature that will arrive in MySQL 8.0, Window Functions.  This presentation is part of the Oracle MySQL Innovation Day that will be held both in the Bay Area (April 28) and in the Boston Area (May 2).

I will also give the presentation at the Boston MySQL Meetup on May 1st.

I hope to see some of you there!