MySQL InnoDB Storage Engine Deep Dive: Mydbops OpenSource Database Meetup 16

MySQL InnoDB Storage Engine Deep Dive: Mydbops OpenSource Database Meetup 16

In this session, Mayank Prasad from the MySQL-InnoDB Development Team at Oracle presents the latest advancements in MySQL-InnoDB. Join us as we dive into the dynamic configuration of REDO logs and the revolutionary INSTANT ADD/DROP column feature.

Topics Covered:

🔹 About the Speaker:

Mayank Prasad, Lead Developer in the MySQL-InnoDB Development Team,
Oracle
Part of MySQL Server Development since 2011
Part of MySQL-InnoDB Storage Engine Development team since 2017

🔹 Dynamic Configuration of REDOs:
Introduction to REDO Logs as Write-Ahead Logs (WAL) for InnoDB
Dynamic Configuration of REDO Logs
New dedicated folder: #innodb_redo in MySQL’s datadir
Introduction of checkpoint_lsn, current_lsn, and flushed_to_disk_lsn
Observability of REDO Logs in performance_schema
Resizing REDO Logs: Up and Down

🔹 INSTANT ADD/DROP Column:
Introduction to InnoDB Row Format and its impact on ADD/DROP column operations
New Design for INSTANT ADD/DROP Columns:
Row versioning to manage column changes
On disk row format changes
Transforming rows while fetching
Flow explanation for DML and DDL operations
Default ALGORITHM for ADD/DROP columns
Row version limits and compatibility for upgrades and IMPORT/EXPORT operations
Observability of INSTANT ADD/DROP columns in INFORMATION_SCHEMA
Examples and limitations
Join the conversation and stay updated with the latest MySQL-InnoDB enhancements that streamline your database management experience. Don’t forget to like, comment, and subscribe for more insightful sessions!

Mydbops Managed Services specializes in taking the pain out of database management while optimizing performance. Since 2015, we have been providing top-notch support and assistance for the top three open-source databases: MySQL, MongoDB, and PostgreSQL.

Our team offers a wide range of services, including assistance, support, consulting, 24/7 operations, and expertise in all relevant technologies. We help organizations improve their database's performance, scalability, efficiency, and availability.

For more details and updates, please follow up the below links.

​

#MySQL #InnoDB #Database #OpenSource #REDOLogs #AddDropColumns #Mydbops #Meetup #Oracle #DatabaseManagement #meetup #event #community