|
![]() |
|||
|
||||
OverviewFull Product DetailsAuthor: Jesper Wisborg KroghPublisher: APress Imprint: APress Edition: 1st ed. Weight: 0.758kg ISBN: 9781484266519ISBN 10: 148426651 Pages: 376 Publication Date: 23 January 2021 Audience: Professional and scholarly , Professional & Vocational Format: Paperback Publisher's Status: Active Availability: Manufactured on demand ![]() We will order this item for you from a manufactured on demand supplier. Table of Contents1. Introduction 2. Monitoring Locks and Mutexes3. Monitoring InnoDB Transactions4. Transactions in the Performance Schema5. Lock Access Levels6. High-Level Lock Types7. InnoDB Locks8. Working with Lock Conflicts9. Reducing Locking Issues10. Indexes and Foreign Keys11. Transactions12. Transaction Isolation Levels13. Case Study: Flush Locks14. Case Study: Metadata and Schema Locks15. Case Study: Record-Level Locks 16. Case Study: Deadlocks 17. Case Study: Foreign Keys 18. Case Study: SemaphoresAppendix A. ReferencesAppendix B. MySQL Shell ModuleReviewsAuthor InformationJesper Wisborg Krogh has worked with MySQL databases since 2006 both as a SQL developer and a database administrator, and for more than eight years as part of the Oracle MySQL Support team. He currently works as a database reliability engineer for Okta. He has spoken at MySQL Connect and Oracle OpenWorld on several occasions. In addition to his books, Jesper regularly blogs on MySQL topics and has authored approximately 800 documents in the Oracle Knowledge Base. He has contributed to the sys schema and four Oracle Certified Professional (OCP) exams for MySQL 5.6–8. Jesper holds a PhD in computational chemistry, lives in Sydney, Australia, and enjoys spending time outdoors walking, traveling, and reading. His areas of expertise include MySQL Cluster, MySQL Enterprise Backup (MEB), performance tuning, and the performance and sys schemas. Tab Content 6Author Website:Countries AvailableAll regions |