↓ 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

Month: July 2021

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 »

Updates to Code for MySQL Concurrency – v1.1 and v1.2

By Jesper Krogh Posted on 25 July, 2021 Posted in Book, Contribution, MySQL Shell

When I wrote the book MySQL Concurrency I included a Python module for MySQL Shell that would help reproducing the examples in the book. Since things change, it has been necessary to update the code. In this blog I will …

Updates to Code for MySQL Concurrency – v1.1 and v1.2 Read more »

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