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...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham ; Mumbai
Packt
2019
|
| Subjects: | |
| Online Access: | FHD01 FHI01 UBY01 |
| 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 |
| Item Description: | MySQL data dictionary structure in MySQL 8.0 |
| Physical Description: | 1 Online-Ressource (vi, 267 Seiten) |
| ISBN: | 9781788833790 |
Staff View
MARC
| LEADER | 00000nmm a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV046227470 | ||
| 003 | DE-604 | ||
| 005 | 20220323 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 191104s2019 |||| o||u| ||||||eng d | ||
| 020 | |a 9781788833790 |9 978-1-78883-379-0 | ||
| 035 | |a (ZDB-221-PDA)9781788833790 | ||
| 035 | |a (OCoLC)1126569046 | ||
| 035 | |a (DE-599)BVBBV046227470 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1050 |a DE-573 |a DE-11 |a DE-706 | ||
| 100 | 1 | |a Vanier, Eric |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Advanced MySQL 8 |b discover the full potential of MySQL and ensure high performance of your database |c Eric Vanier, Birju Shah, Tejaswi Malepati |
| 264 | 1 | |a Birmingham ; Mumbai |b Packt |c 2019 | |
| 300 | |a 1 Online-Ressource (vi, 267 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a MySQL data dictionary structure in MySQL 8.0 | ||
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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) | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 520 | |a 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 | ||
| 650 | 4 | |a MySQL (Electronic resource) | |
| 650 | 7 | |a MySQL (Electronic resource) |2 fast | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 4 | |a Database management | |
| 650 | 4 | |a Relational databases | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 650 | 0 | 7 | |a MySQL 8.0 |0 (DE-588)1193210577 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a MySQL 8.0 |0 (DE-588)1193210577 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Shah, Birju |e Verfasser |4 aut | |
| 700 | 1 | |a Malepati, Tejaswi |e Verfasser |4 aut | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 978-1-78883-444-5 |
| 912 | |a ZDB-30-PQE |a ZDB-5-WPSE |a ZDB-221-PDA | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-031606005 | ||
| 966 | e | |u https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=5675584 |l FHD01 |p ZDB-30-PQE |q FHD01_PQE_Kauf |x Aggregator |3 Volltext | |
| 966 | e | |u https://portal.igpublish.com/iglibrary/search/PACKT0005101.html |l FHI01 |p ZDB-221-PDA |x Aggregator |3 Volltext | |
| 966 | e | |u https://portal.igpublish.com/iglibrary/search/PACKT0005101.html |l UBY01 |p ZDB-221-PDA |q UBY01_ZDB-221-PDA21 |x Verlag |3 Volltext | |
Record in the Search Index
| _version_ | 1804180634238713856 |
|---|---|
| any_adam_object | |
| author | Vanier, Eric Shah, Birju Malepati, Tejaswi |
| author_facet | Vanier, Eric Shah, Birju Malepati, Tejaswi |
| author_role | aut aut aut |
| author_sort | Vanier, Eric |
| author_variant | e v ev b s bs t m tm |
| building | Verbundindex |
| bvnumber | BV046227470 |
| collection | ZDB-30-PQE ZDB-5-WPSE ZDB-221-PDA |
| 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 |
| ctrlnum | (ZDB-221-PDA)9781788833790 (OCoLC)1126569046 (DE-599)BVBBV046227470 |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>05414nmm a2200565 c 4500</leader><controlfield tag="001">BV046227470</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20220323 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">191104s2019 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781788833790</subfield><subfield code="9">978-1-78883-379-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-221-PDA)9781788833790</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1126569046</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV046227470</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1050</subfield><subfield code="a">DE-573</subfield><subfield code="a">DE-11</subfield><subfield code="a">DE-706</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Vanier, Eric</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Advanced MySQL 8</subfield><subfield code="b">discover the full potential of MySQL and ensure high performance of your database</subfield><subfield code="c">Eric Vanier, Birju Shah, Tejaswi Malepati</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham ; Mumbai</subfield><subfield code="b">Packt</subfield><subfield code="c">2019</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (vi, 267 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">MySQL data dictionary structure in MySQL 8.0</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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)</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">MySQL (Electronic resource)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">MySQL (Electronic resource)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database management</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Relational databases</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">MySQL 8.0</subfield><subfield code="0">(DE-588)1193210577</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">MySQL 8.0</subfield><subfield code="0">(DE-588)1193210577</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Shah, Birju</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Malepati, Tejaswi</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">978-1-78883-444-5</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield><subfield code="a">ZDB-5-WPSE</subfield><subfield code="a">ZDB-221-PDA</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-031606005</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=5675584</subfield><subfield code="l">FHD01</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">FHD01_PQE_Kauf</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://portal.igpublish.com/iglibrary/search/PACKT0005101.html</subfield><subfield code="l">FHI01</subfield><subfield code="p">ZDB-221-PDA</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://portal.igpublish.com/iglibrary/search/PACKT0005101.html</subfield><subfield code="l">UBY01</subfield><subfield code="p">ZDB-221-PDA</subfield><subfield code="q">UBY01_ZDB-221-PDA21</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV046227470 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T08:38:52Z |
| institution | BVB |
| isbn | 9781788833790 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-031606005 |
| oclc_num | 1126569046 |
| open_access_boolean | |
| owner | DE-1050 DE-573 DE-11 DE-706 |
| owner_facet | DE-1050 DE-573 DE-11 DE-706 |
| physical | 1 Online-Ressource (vi, 267 Seiten) |
| psigel | ZDB-30-PQE ZDB-5-WPSE ZDB-221-PDA ZDB-30-PQE FHD01_PQE_Kauf ZDB-221-PDA UBY01_ZDB-221-PDA21 |
| publishDate | 2019 |
| publishDateSearch | 2019 |
| publishDateSort | 2019 |
| publisher | Packt |
| record_format | marc |
| spelling | Vanier, Eric Verfasser aut Advanced MySQL 8 discover the full potential of MySQL and ensure high performance of your database Eric Vanier, Birju Shah, Tejaswi Malepati Birmingham ; Mumbai Packt 2019 1 Online-Ressource (vi, 267 Seiten) txt rdacontent c rdamedia cr rdacarrier MySQL data dictionary structure in MySQL 8.0 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 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 MySQL (Electronic resource) MySQL (Electronic resource) fast SQL (Computer program language) Database management Relational databases Database management fast Relational databases fast SQL (Computer program language) fast MySQL 8.0 (DE-588)1193210577 gnd rswk-swf MySQL 8.0 (DE-588)1193210577 s DE-604 Shah, Birju Verfasser aut Malepati, Tejaswi Verfasser aut Erscheint auch als Druck-Ausgabe 978-1-78883-444-5 |
| spellingShingle | Vanier, Eric Shah, Birju Malepati, Tejaswi Advanced MySQL 8 discover the full potential of MySQL and ensure high performance of your database 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 MySQL (Electronic resource) MySQL (Electronic resource) fast SQL (Computer program language) Database management Relational databases Database management fast Relational databases fast SQL (Computer program language) fast MySQL 8.0 (DE-588)1193210577 gnd |
| subject_GND | (DE-588)1193210577 |
| title | Advanced MySQL 8 discover the full potential of MySQL and ensure high performance of your database |
| title_auth | Advanced MySQL 8 discover the full potential of MySQL and ensure high performance of your database |
| title_exact_search | Advanced MySQL 8 discover the full potential of MySQL and ensure high performance of your database |
| title_full | Advanced MySQL 8 discover the full potential of MySQL and ensure high performance of your database Eric Vanier, Birju Shah, Tejaswi Malepati |
| title_fullStr | Advanced MySQL 8 discover the full potential of MySQL and ensure high performance of your database Eric Vanier, Birju Shah, Tejaswi Malepati |
| title_full_unstemmed | Advanced MySQL 8 discover the full potential of MySQL and ensure high performance of your database Eric Vanier, Birju Shah, Tejaswi Malepati |
| title_short | Advanced MySQL 8 |
| title_sort | advanced mysql 8 discover the full potential of mysql and ensure high performance of your database |
| title_sub | discover the full potential of MySQL and ensure high performance of your database |
| topic | MySQL (Electronic resource) MySQL (Electronic resource) fast SQL (Computer program language) Database management Relational databases Database management fast Relational databases fast SQL (Computer program language) fast MySQL 8.0 (DE-588)1193210577 gnd |
| topic_facet | MySQL (Electronic resource) SQL (Computer program language) Database management Relational databases MySQL 8.0 |
| work_keys_str_mv | AT vaniereric advancedmysql8discoverthefullpotentialofmysqlandensurehighperformanceofyourdatabase AT shahbirju advancedmysql8discoverthefullpotentialofmysqlandensurehighperformanceofyourdatabase AT malepatitejaswi advancedmysql8discoverthefullpotentialofmysqlandensurehighperformanceofyourdatabase |