Skip to Main Content
MySQL 8 Administrator???s Guide
book

MySQL 8 Administrator???s Guide

by Chintan Mehta, Hetal Oza, Subhash Shah, Ravi Shah
February 2018
Intermediate to advanced content levelIntermediate to advanced
510 pages
16h 10m
English
Packt Publishing
Content preview from MySQL 8 Administrator???s Guide

Optimizing locking operations

As discussed in one of the earlier chapters, MySQL 8 uses locking mechanisms to manage contention. Contention occurs when concurrently executing queries in multiple threads try to get ahold of one table at the same time. If these queries are performed on the table concurrently, the table data is left in an inconsistent state. MySQL 8 supports two types of locking: internal locking and external locking.

Internal locking is performed by multiple threads within the MySQL server to manage contention for table contents. This type of locking is performed entirely by the MySQL server, without involving any other programs. So, why it is called internal locking? In the case of external locking, the MySQL server and other ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Hands-On MySQL Administration

Hands-On MySQL Administration

Arunjith Aravindan, Jeyaram Ayyalusamy
SQL Cookbook, 2nd Edition

SQL Cookbook, 2nd Edition

Anthony Molinaro, Robert de Graaf

Publisher Resources

ISBN: 9781788395199Supplemental Content