Wednesday, September 8, 2021

Run ANALYZE TABLE — Do Not Rely on InnoDB's Automatic Recalculation of Statistics

›
This blog post is inspired by Jesper's recent blog post on how the automatic update of InnoDB persistent statistics may never trigger ...
3 comments:
Wednesday, June 9, 2021

Use Window Functions to Speed Up Correlated Subqueries

›
In my previous blog post , I discussed different ways to rewrite correlated scalar subqueries to improve performance. In this blog post...
Friday, May 7, 2021

Transformations of Correlated Scalar Subqueries

›
MySQL 8.0.24 introduces transformation of correlated scalar subqueries to derived tables . In my presentation in the MySQL devroom at FOS...
Thursday, June 25, 2020

Memory Usage for MySQL Hash Join

›
At Percona Live Online my colleague at Alibaba, Jim Tommaney, presented a study of hash join performance in MySQL and Mar who? iaDB. Fo...
2 comments:
Saturday, October 12, 2019

MySQL Parallel Index Range Scans: One is Sometimes Better Than Two

›
As presented at the Percona Live Conference in Austin in May, at Alibaba we are working on adding support for parallel query execution to P...
Tuesday, May 28, 2019

My presentations at Percona Live

›
Percona Live 2019 is starting in Austin today.  You may already have read that I have a presentation on how to use Optimizer Trace to unde...
Wednesday, January 30, 2019

Inspecting the Content of a MySQL Histogram

›
FOSDEM is coming up. I do not have a presentation in the MySQL and Friends devroom  this year, but it reminded me that I had planned to po...