Cargando…
Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database.
Businesses, right from small-sized to large giants are using MySQL to access and manipulate their enterprise database across the world. Advanced MySQL 8 will be your one-stop destination in how to implement and manage large-scale MySQL distributed clusters to run high-volume websites, enterprise sys...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing Ltd,
2019.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Title Page; Copyright and Credits; About Packt; Contributors; Table of Contents; Preface; Chapter 1: Introduction; Why MySQL 8? ; Why is MySQL 8.0 the next generation?; Why it is so important to have a good MySQL architecture design; Summary; Chapter 2: MySQL 8's New Features; Global data dictionary; MySQL 8's support roles and history; MySQL 8 supports the creation and management of resource groups and permissions; InnoDB enhancements; JSON enhancements functionalities; Invisible indexes from MySQL optimizer; Features deprecated in MySQL 8.0
- A quick look at the features removed from MySQL 8.0Summary; Chapter 3: Indexing Your Data for High Performance; How does MySQL optimizer think in MySQL 8.0?; What kind of data type should I consider indexing first and why?; Why should I have a good index strategy?; What impact does an index have on MySQL performance?; How to display and analyze a table structure; How to efficiently read MySQL query execution plans; How to effectively read the EXPLAIN results; id (JSON name: select_id); select_type (JSON name: none); table (JSON name: table_name); partitions (JSON name: partitions)
- Type (JSON name: access_type)EXPLAIN extra information; How to know when to create an index; Multiple column index versus multiple indexes; How to organize your columns in an index for good performance; Case study 1
- how to use the EXPLAIN plan tool in MySQL 8.0; EXPLAIN options; Case study 2
- how to display and analyze a table structure versus the EXPLAIN plan tool; Case study 3
- how to organize your columns in an index efficiently; Creating a missing index; Tips and techniques; The five general rules for your indexes; Tip 2
- the five general rules to optimize your queries
- Tip 3
- understand your material resourcesTip 4
- the configuration is not the only thing to take into consideration; Tip 5
- recommendations on the performance of the MySQL architecture; A technical case study; Summary; Chapter 4: Advanced Data Techniques for Large Queries; The most important variables are full-scan indicators; Partitioning a table; An overview of partitioning in MySQL 8.0; Available partitioning type; Horizontally partitioning your data; Managing partitions; RANGE partitioning; LIST partitioning; HASH partitioning; KEY partitioning; Using partitions; Partition pruning
- Getting rid of unused and duplicate indexesUnused indexes; Duplicate indexes; Bonus
- potentially missing indexes; The most important query optimizations; Optimizing a query with the WHERE clause; Optimizing a query with a GROUP BY clause; Optimizing a query with the ORDER BY clause; Temporary tables; Case study 1
- an example of how to optimize a complex query; Case study 2
- how to optimize sort indexes; Tips and techniques; Partitions; Optimization; Techniques; A typical use case: time series data; Example of a mass DELETE; Summary; Chapter 5: MySQL Data Dictionary in MySQL 8.0