EasyEnv
Engineering/Courses/Catalog/MySQL/Transactions and Storage Engines
MySQL
IntermediateLesson 9 of 1335 min · hands-on

Transactions and Storage Engines

Part of the MySQL course

Two UPDATE statements move twenty pounds from Ada to Bilal. The first runs, the connection drops, the second never happens, and twenty pounds have ceased to exist. Neither statement was buggy. The bug is that they were two separate events when they needed to be one indivisible one.

MySQL's answer to that is the transaction, and MySQL has an unusual wrinkle around it that no other mainstream database has: whether transactions work at all depends on a per-table setting. MySQL uses a pluggable storage engine model, where each table chooses the machinery that stores and locks its rows, and the engines do not have the same features. ...

Want to learn MySQL Transactions and Storage Engines in a real environment?

Click below, get a fresh Linux box with MySQL ready to go, and work through Transactions and Storage Engines hands-on with an AI tutor that knows your code.

Start this lessonTransactions and Storage Engines

What you'll learn

  • InnoDB vs MyISAM
  • START TRANSACTION
  • COMMIT
  • ROLLBACK
  • Isolation levels
  • REPEATABLE READ default
  • Gap locks

Read this lesson in your language

All lessons in this course

13 lessons
  1. 1What is MySQL20 min
  2. 2The mysql CLI and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types30 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes30 min
  9. 9Transactions and Storage Engines35 min
  10. 10Stored Procedures and Triggers35 min
  11. 11EXPLAIN and Query Tuning35 min
  12. 12mysqldump and Restore25 min
  13. 13Capstone: Design an Ecommerce Schema50 min

Explore other courses

Transactions and Storage Engines - MySQL (English) | Engineering Courses