MySQL Concurrency
portes grátis
MySQL Concurrency
Locking and Transactions for MySQL Developers and DBAs
Krogh, Jesper Wisborg
APress
01/2021
376
Mole
Inglês
9781484266519
15 a 20 dias
758
Descrição não disponível.
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.
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.
MySQL Server;MariaDB;Monitoring;Locks;Transactions;Lock Contention;Gap Locks;InnoDB;Deadlocks;Metadata Locks;Schema Locks;Isolation Levels;Information Schema;Performance Schema;Shared and Exclusive Locks;High Performance MySQL;Query Performance Tuning
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.
Este título pertence ao(s) assunto(s) indicados(s). Para ver outros títulos clique no assunto desejado.
