↓ Skip to Main Content
Jesper's MySQL Blog
Jesper's MySQL Blog

Main Navigation

  • Home
  • Recent Activity
    • Latest Posts
    • Top Posts
    • Latest Tweets
    • MySQL Shell Blogs
  • My Books
    • MySQL Concurrency
    • MySQL 8 Query Performance Tuning
    • MySQL Connector/Python Revealed
    • Pro MySQL NDB Cluster
  • MySQL Books
    • My Books
    • Books by Oracle Employees
  • Who Am I?
  • Privacy Policy
Jesper's MySQL Blog
Jesper's MySQL Blog

Off Canvas Menu

  • Home
  • Recent Activity
    • Latest Posts
    • Top Posts
    • Latest Tweets
    • MySQL Shell Blogs
  • My Books
    • MySQL Concurrency
    • MySQL 8 Query Performance Tuning
    • MySQL Connector/Python Revealed
    • Pro MySQL NDB Cluster
  • MySQL Books
    • My Books
    • Books by Oracle Employees
  • Who Am I?
  • Privacy Policy

Category: Locking

Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables

By Jesper Krogh Posted on 31 July, 2021 Posted in InnoDB, Locking, Performance Schema, Transacftion Isolation Level

Locking is an important concept in databases. They help regulate access to the data, so your SELECT queries return consistent results and DML and DDL statements leave the data and schema in a consistent state. For the data, there are …

Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables Read more »

Copyright © 2026 Jesper's MySQL Blog | Powered by Responsive Theme
Copyright © 2026 Jesper's MySQL Blog | Powered by Responsive Theme