Description
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
Author: Jesper Wisborg Krogh
Publisher: Apress
Published: 03/17/2020
Pages: 965
Binding Type: Paperback
Weight: 3.75lbs
Size: 10.00h x 7.00w x 1.97d
ISBN13: 9781484255834
ISBN10: 1484255836
BISAC Categories:
- Computers | Database Administration & Management
- Computers | Programming | Open Source
About the Author
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.