Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels

This article explains the concept and importance of MySQL database transactions, describes the ACID properties, shows how to use transaction control statements and savepoints, and demonstrates each isolation level (read uncommitted, read committed, repeatable read, serializable) with practical SQL examples.

ACIDDatabase TransactionsIsolation Levels

0 likes · 10 min read

Understanding MySQL Database Transactions: ACID Properties, Control Statements, and Isolation Levels

Aikesheng Open Source Community

Apr 24, 2024 · Databases

Summary of the MySQL Transaction Module Series

This article reviews the 14-part series on MySQL's transaction module, covering initialization, transaction types, two‑phase commit, binlog handling, savepoints, and full rollback, and provides links to each detailed post, including discussions on BEGIN statements, read‑only transactions, and the internal mechanisms of InnoDB.

BinlogInnoDBSavepoint

0 likes · 5 min read

Summary of the MySQL Transaction Module Series

Aikesheng Open Source Community

Apr 3, 2024 · Databases

Understanding InnoDB Savepoint Implementation: Undo Log Sequence, Savepoint Structure, and Management

This article explains how InnoDB implements savepoints in MySQL 8.0.32, covering undo log sequencing, the savepoint structures in the server, binlog, and InnoDB layers, the process of locating and deleting duplicate savepoints, and the three-step procedure for creating a new savepoint.

BinlogDatabase InternalsInnoDB

0 likes · 8 min read

Understanding InnoDB Savepoint Implementation: Undo Log Sequence, Savepoint Structure, and Management

Liangxu Linux

Mar 16, 2021 · Databases

Master MySQL Transactions, Locks, and Advanced Functions: A Hands‑On Guide

This tutorial walks through MySQL's transaction control, lock statements, autocommit settings, manual commit and rollback, savepoints, differences between transactional and non‑transactional tables, SQL mode configurations, common SQL tricks, regular expressions, and a comprehensive catalog of built‑in functions, all illustrated with step‑by‑step examples and code snippets.

SQL ModeSavepointTransactions

0 likes · 25 min read

Master MySQL Transactions, Locks, and Advanced Functions: A Hands‑On Guide

Big Data Technology Architecture

Nov 23, 2019 · Backend Development

State as Database in Apache Flink: QueryableState and Savepoint Processor API

The article examines how Apache Flink's state management features, including QueryableState and the upcoming Savepoint Processor API, can serve as a lightweight database for real‑time applications, discussing their advantages, limitations, and practical usage scenarios.

FlinkQueryableStateReal‑Time Computing

0 likes · 10 min read

State as Database in Apache Flink: QueryableState and Savepoint Processor API

Big Data Technology & Architecture

Sep 21, 2019 · Big Data

Deploying Apache Flink on Kubernetes: A Step‑by‑Step Guide

This tutorial explains how to run Apache Flink jobs on Kubernetes by building Docker images, deploying JobManager and TaskManager components with Kubernetes manifests, configuring high‑availability with ZooKeeper and HDFS, and using SavePoints and scaling techniques to manage and extend Flink streaming applications.

Big DataDockerFlink

0 likes · 14 min read

Deploying Apache Flink on Kubernetes: A Step‑by‑Step Guide