| Description |
1 online resource (280 pages) |
| Physical Medium |
polychrome |
| Description |
text file |
| Contents |
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 |
| Note |
MySQL data dictionary structure in MySQL 8.0 |
| Summary |
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 systems, and packaged software. |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
MySQL (Electronic resource)
|
|
MySQL (Electronic resource) |
|
MySQL (Electronic resource) |
|
SQL (Computer program language)
|
|
SQL (Computer program language) |
|
Database management.
|
|
Database management. |
|
Relational databases.
|
|
Relational databases. |
| Genre/Form |
Electronic books.
|
| Added Author |
Shah, Birju, author.
|
|
Malepati, Tejaswi, author.
|
| Added Title |
Advanced MySQL eight |
| Other Form: |
Print version: Vanier, Eric. Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database. Birmingham : Packt Publishing Ltd, ©2019 9781788834445 |
| ISBN |
9781788833790 (electronic book) |
|
1788833791 (electronic book) |
|
