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...

Descripción completa

Detalles Bibliográficos
Otros Autores: Krogh, Jesper Wisborg, author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] : Apress [2021]
Edición:1st ed. 2021.
Materias:
Relational databases.
MySQL (Electronic resource)
Database management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009631355706719
Tabla de Contenidos:
  • 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.

Ejemplares similares