MySQL 8 Query Performance Tuning: A Systematic Method for Improving Execution Speeds - Brossura

Krogh, Jesper Wisborg

Brossura

ISBN 10: 1484255852 ISBN 13: 9781484255858

Casa editrice: Apress, 2020

Riassunto

Part I. Getting Started

1. MySQL Performance Tuning

2. Query Tuning Methodology

3. Benchmarking with Sysbench

4. Test Data

Part II. Sources of Information

5. The Performance Schema

6. The sys Schema

7. The Information Schema

8. SHOW Statements

9. The Slow Query Log

Part III. Tools

10. MySQL Enterprise Monitor

11. MySQL Workbench

12. MySQL Shell

Part IV. Schema Considerations and the Query Optimizer

13. Data Types

14. Indexes

15. Index Statistics

16. Histograms

17. The Query Optimizer

18. Locking Theory and Monitoring

Part V. Query Analysis

19. Finding Candidate Queries  for Optimization

20. Analyzing Queries

21. Transactions

22. Diagnosing Lock Contention

Part VI. Improving the Queries

23. Configuration

24. Change the Query Plan

25. DDL and Bulk Data Load

26. Replication

27. Caching

Dettagli dell?edizione

• Editore: Apress
• Data di pubblicazione: 2020
• Lingua: Inglese
• ISBN 10: 1484255852
• ISBN 13: 9781484255858
• Rilegatura: Paperback
• Contatto del produttore: non disponibile
• Persona responsabile: non disponibile