MySQL Forums
Forum List  »  InnoDB

MySQL from a Developers Perspective
Posted by: Edwin Desouza
Date: July 30, 2020 10:54PM
• MySQL Transactions - the physical side. Looking at how MySQL InnoDB handles transactions on the physical media, enabling rollback and commit. Introduces a number of important concepts: The Undo Log, the Redo Log, the Doublewrite Buffer, and the corrosponding in memory structures, the Log Buffer and the InnoDB Buffer Pool, as well as the concept of a page.
• MySQL Commit Size and Speed. This article has code in Github, in mysql-commit-size/. We benchmark MySQL write speed as a function of number of rows written per commit.
• MySQL Connection Scoped State. Looking at things that are stateful and attached to a MySQL connection, and are lost on disconnect.
• MySQL Transactions - the logical view. This article introduces the concept of TRANSACTION ISOLATION LEVEL and how pushing things into the Undo Log, while a necessity to implement ROLLBACK for a Writer, enables features for a Reader.
• MySQL Transactions - writing data. This article has code in Github, in mysql-transactions-counter. We increment a counter in the database, with multiple concurrent writers, and see what happens.

Options: ReplyQuote

Written By
MySQL from a Developers Perspective
July 30, 2020 10:54PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.