https://wiki.quizz.vn/ 2026-06-26T19:00:36+00:00 https://wiki.quizz.vn/ https://wiki.quizz.vn/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2026-05-16T04:12:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.quizz.vn/doku.php?id=mysql:tx:acid&rev=1778904760&do=diff ACID Properties in Databases ACID is a set of 4 properties that every database transaction must guarantee to ensure data stays correct and reliable — even when things go wrong (crashes, errors, concurrent users). The name is an acronym: * A — Atomicity text/html 2026-05-16T04:01:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.quizz.vn/doku.php?id=mysql:tx:best-practices-solving-transaction-anomalies-with-default-isolation-level&rev=1778904110&do=diff Best Practices — Solving Transaction Anomalies with Default Isolation Level " Core idea: Don't change the default isolation level globally. Use `READ COMMITTED` (default) + the right lock technique per situation. This gives you safety where needed without sacrificing performance everywhere. text/html 2026-05-16T03:52:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.quizz.vn/doku.php?id=mysql:tx:isolation&rev=1778903570&do=diff SQL Isolation Levels " A complete guide to understanding the 4 isolation levels in SQL — what they protect against, how they work internally, and when to use each one." ---------- Table of Contents * * * * * * * * * text/html 2026-05-16T08:09:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.quizz.vn/doku.php?id=mysql:tx:locking&rev=1778918970&do=diff Locks in MySQL Locks control concurrent access to data during transactions. Without locks, multiple transactions reading and writing the same rows simultaneously can cause dirty reads, lost updates, and write skew. Read lock (Shared) - FOR SHARE → I am reading, others can read too, but no one can write text/html 2026-05-16T03:26:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.quizz.vn/doku.php?id=mysql:tx:transaction-anomalies&rev=1778902014&do=diff SQL Transaction Anomalies — Concurrency Problems in Databases " A comprehensive guide to the 5 anomalies that occur when multiple transactions run concurrently, with real-world examples and solutions." ---------- Table of Contents * * *