MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

Author:   Jesper Wisborg Krogh
Publisher:   APress
Edition:   1st ed.
ISBN:  

9781484266519


Pages:   376
Publication Date:   23 January 2021
Format:   Paperback
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Our Price $184.77 Quantity:  
Add to Cart

Share |

MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs


Add your own review!

Overview

Full Product Details

Author:   Jesper Wisborg Krogh
Publisher:   APress
Imprint:   APress
Edition:   1st ed.
Weight:   0.758kg
ISBN:  

9781484266519


ISBN 10:   148426651
Pages:   376
Publication Date:   23 January 2021
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand   Availability explained
We will order this item for you from a manufactured on demand supplier.

Table of Contents

1. Introduction 2. Monitoring Locks and Mutexes3. Monitoring InnoDB Transactions4. Transactions in the Performance Schema5. Lock Access Levels6. High-Level Lock Types7. InnoDB Locks8. Working with Lock Conflicts9. Reducing Locking Issues10. Indexes and Foreign Keys11. Transactions12. Transaction Isolation Levels13. Case Study: Flush Locks14. Case Study: Metadata and Schema Locks15. Case Study: Record-Level Locks 16. Case Study: Deadlocks 17. Case Study: Foreign Keys 18. Case Study: SemaphoresAppendix A. ReferencesAppendix B. MySQL Shell Module

Reviews

Author Information

Jesper Wisborg Krogh has worked with MySQL databases since 2006 both as a SQL developer and a database administrator, and for more than eight years as part of the Oracle MySQL Support team. He currently works as a database reliability engineer for Okta. He has spoken at MySQL Connect and Oracle OpenWorld on several occasions. In addition to his books, Jesper regularly blogs on MySQL topics and has authored approximately 800 documents in the Oracle Knowledge Base. He has contributed to the sys schema and four Oracle Certified Professional (OCP) exams for MySQL 5.6–8. Jesper holds a PhD in computational chemistry, lives in Sydney, Australia, and enjoys spending time outdoors walking, traveling, and reading. His areas of expertise include MySQL Cluster, MySQL Enterprise Backup (MEB), performance tuning, and the performance and sys schemas.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

RGJUNE2025

 

Shopping Cart
Your cart is empty
Shopping cart
Mailing List