Overview

Full Product Details

Author:   Jesper Wisborg Krogh
Publisher:   APress
Imprint:   APress
Edition:   1st ed.
Weight:   1.871kg
ISBN:  

9781484255834

ISBN 10:   1484255836
Pages:   965
Publication Date:   17 March 2020
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Not yet available  
This item is yet to be released. You can pre-order this item and we will dispatch it to you upon its release.

Table of Contents

Part I. Getting Started1. MySQL Performance Tuning2. Query Tuning Methodology3. Benchmarking with Sysbench4. Test Data Part II. Sources of Information5. The Performance Schema6. The sys Schema7. The Information Schema8. SHOW Statements9. The Slow Query Log Part III. Tools10. MySQL Enterprise Monitor11. MySQL Workbench12. MySQL Shell Part IV. Schema Considerations and the Query Optimizer13. Data Types14. Indexes15. Index Statistics16. Histograms17. The Query Optimizer18. Locking Theory and Monitoring Part V. Query Analysis19. Finding Candidate Queries  for Optimization20. Analyzing Queries21. Transactions22. Diagnosing Lock Contention Part VI. Improving the Queries23. Configuration24. Change the Query Plan25. DDL and Bulk Data Load26. Replication27. Caching

Reviews

Author Information

Jesper Wisborg Krogh has worked with MySQL databases since 2006 both as an SQL developer, a database administrator, and for more than eight years as part of the Oracle MySQL Support team. He has spoken at MySQL Connect and Oracle OpenWorld on several occasions, and addition to his books, he regularly blogs on MySQL topics and has authored around 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 to 8.0. He earned a PhD in computational chemistry before changing to work with MySQL and other software development in 2006. Jesper lives in Sydney, Australia, and enjoys spending time outdoors walking, traveling, and reading. His areas of expertise include MySQL Cluster, MySQL Enterprise Backup, performance tuning, and the Performance and sys schemas.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions