책 이미지
eBook 미리보기
책 정보
· 제목 : MySQL Concurrency: Locking and Transactions for MySQL Developers and Dbas (Paperback)
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9781484266519
· 쪽수 : 376쪽
· 출판일 : 2021-01-23
· 분류 : 외국도서 > 컴퓨터 > 데이터베이스 관리 > 일반
· ISBN : 9781484266519
· 쪽수 : 376쪽
· 출판일 : 2021-01-23
목차
1. Introduction to Locking and Transactions
2. Monitoring Locks
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. Reduce 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 1
16. Case Study: Record-Level Locks 2
17. Case Study: Deadlocks 1
18. Case Study: Deadlocks 2
Appendix A. References
Appendix B. MySQL Shell Module
