Buy Percona ServicesBuy Now!

ANALYZE TABLE Is No Longer a Blocking Operation

 | March 27, 2018 |  Posted In: InnoDB, Insight for DBAs, MyRocks, MySQL, TokuDB

analyze table

In this post, I’ll discuss the fix for lp:1704195 (migrated to PS-2503), which prevents ANALYZE TABLE from blocking all subsequent queries on the same table. In November 2017, Percona released a fix for lp:1704195 (migrated to PS-2503), created by Laurynas Biveinis. The fix, included with Percona Server for MySQL since versions 5.6.38-83.0 and 5.7.20-18, stops ANALYZE TABLE from invalidating query and […]

Read More

Percona Live Featured Tutorial with Morgan Tocker — MySQL 8.0 Optimizer Guide

 | January 16, 2017 |  Posted In: MySQL, MySQL 8.0, Percona Live

Percona Live Featured Tutorial

Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona […]

Read More

Q&A: Even More Deadly Mistakes of MySQL Development

 | July 17, 2014 |  Posted In: Insight for Developers, MySQL, Technical Webinars

On Wednesday I gave a presentation on “How to Avoid Even More Common (but Deadly) MySQL Development Mistakes” for Percona MySQL Webinars.  If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions.  I answered as many as we had […]

Read More

Many-table joins in MySQL 5.6

 | March 6, 2014 |  Posted In: Insight for DBAs, MySQL

I recently worked on an uncommon slow query: less than 100 rows were read and returned, the whole dataset was fitting in memory but the query took several seconds to run. Long story short: the query was a join involving 21 tables, running on MySQL 5.1. But by default MySQL 5.1 is not good at […]

Read More

MySQL Query Patterns, Optimized – Webinar questions followup

 | June 3, 2013 |  Posted In: Insight for Developers, MySQL, Technical Webinars

On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars.  If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions.  I answered as many as we had time for  during the session, but here […]

Read More