MySQL concurrency : locking and transactions for MySQL developers and DBAs

MySQL concurrency locking and transactions for MySQL developers and DBAs

Know how locks work in MySQL and how they relate to transactions. This book explains the major role that locks play in database systems, showing how locks are essential in allowing high-concurrency workloads. You will learn about lock access levels and lock granularities from the user level as well...

Full description

Bibliographic Details
Other Authors: Krogh, Jesper Wisborg, author (author)
Format: eBook
Language:Inglés
Published: [Place of publication not identified] : Apress [2021]
Edition:1st ed. 2021.
Subjects:
Relational databases.
MySQL (Electronic resource)
Database management.
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631355706719
Table of Contents:
  • 1. Introduction
  • 2. Monitoring Locks and Mutexes
  • 3. Monitoring InnoDB Transactions
  • 4. Transactions in the Performance Schema
  • 5. Lock Access Levels
  • 6. High-Level Lock Types
  • 7. InnoDB Locks
  • 8. Working with Lock Conflicts
  • 9. Reducing Locking Issues
  • 10. Indexes and Foreign Keys
  • 11. Transactions
  • 12. Transaction Isolation Levels
  • 13. Case Study: Flush Locks
  • 14. Case Study: Metadata and Schema Locks
  • 15. Case Study: Record-Level Locks
  • 16. Case Study: Deadlocks
  • 17. Case Study: Foreign Keys
  • 18. Case Study: Semaphores
  • Appendix A. References
  • Appendix B. MySQL Shell Module.

Similar Items