.::: Simulation Deadlocks MariaDB MySQL :::

 

1. create table & insert
CREATE TABLE clients (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    balance DECIMAL(10, 2)
);

-- Memasukkan data awal ke tabel 'clients'
INSERT INTO clients (id, name, balance) VALUES
(1, 'John', 50),
(2, 'Alice', 150);

2. Memulai transaksi terminal 1
select connection_id() as session_id, user() as user;

 START TRANSACTION;

-- Melakukan update pada saldo (balance) untuk id = 1
UPDATE clients SET balance = balance + 50 WHERE id = 1;

3. Memulai transaksi terminal 2
select connection_id() as session_id, user() as user;

 START TRANSACTION;

-- Melakukan update pada saldo (balance) untuk id = 2
UPDATE clients SET balance = balance + 50 WHERE id = 2;

4. Memulai transaksi terminal 1
select connection_id() as session_id, user() as user;
-- Melakukan update pada saldo (balance) untuk id = 2
UPDATE clients SET balance = balance + 50 WHERE id = 2;
 

5. Memulai transaksi terminal 2
select connection_id() as session_id, user() as user;
-- Melakukan update pada saldo (balance) untuk id = 1
UPDATE clients SET balance = balance + 50 WHERE id = 1;

6. check running query