Overview of Different ALTER Algorithms and Its Locking Scenarios in MySQL (DEMO)

This session was presented on Percona Community Live Online June 21-23, 2022. Check out the full schedule here.

I would like to show the demo session on describing the different MySQL ALTER Algorithms ( COPY / INPLACE / INSTANT ) and how they are performing with different locking methods ( Exclusive / Shared / None ).

Watch Video Here

Link: https://youtu.be/MqWQH-WWFBE

Transcript

Speakers

Sri Sakthivel M.D.

MySQL DBA, Percona

See all talks by Sri Sakthivel M.D. »

Did you like this post? Why not read more?

Percona Community Live June 21 - Day 1

You are invited to participate in the first day of the Percona Community Live stream! Learn about VictoriaMetrics, flexible Indexing with Postgres, PostgreSQL backups, database resiliency, and many other things on June 21st. Join us on June 22nd and June 23d for more amazing content!

Dave Stokes Talks Open - Episode 1 - Sai Kondapalli, Product Manager at Microsoft

At Percona Live, Dave Stokes interviewed Sai Kondapalli, Microsoft’s Product Manager of Azure Database for MySQL. Let’s listen more about Azure, Security issues, databases, and MySQL.

Dave Stokes Talks Open - Episode 2 - Roger Barga, Microsoft - Percona Live 2023

At Percona Live, Dave Stokes talked to Roger Barga, Microsoft’s Vice President and General Manager of Azure Database for MySQL. They discussed relations between open source projects and cloud providers, and what Microsoft does in the open source space and MySQL.