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
Clasificación:Libro Electrónico
Autor principal: Krogh, Jesper Wisborg (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Berkeley] : Apress, [2021]
Temas:
MySQL (Electronic resource)
Relational databases.
Database management.
Bases de données relationnelles.
Bases de données > Gestion.
Relational databases
Database management
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
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