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 |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_on1086057392 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 190216s2019 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d TEFOD |d CHVBK |d OCLCO |d TEFOD |d UKAHL |d OCLCF |d OCLCQ |d OCLCO |d OCLCQ |d N$T |d NLW |d K6U |d UKMGB |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 015 | |a GBC213289 |2 bnb | ||
| 016 | 7 | |a 019253743 |2 Uk | |
| 020 | |a 9781788833790 |q (electronic bk.) | ||
| 020 | |a 1788833791 |q (electronic bk.) | ||
| 020 | |z 9781788834445 |q (print) | ||
| 029 | 1 | |a AU@ |b 000065065749 | |
| 029 | 1 | |a CHNEW |b 001040242 | |
| 029 | 1 | |a CHVBK |b 559039050 | |
| 029 | 1 | |a UKMGB |b 019253743 | |
| 029 | 1 | |a AU@ |b 000068892055 | |
| 035 | |a (OCoLC)1086057392 | ||
| 037 | |a 2E66399E-BA0F-4818-9C74-4CE171B8A6E7 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.73.S67 |b V36 2019eb | |
| 082 | 0 | 4 | |a 005.756 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Vanier, Eric, |e author. | |
| 245 | 1 | 0 | |a Advanced MySQL 8 : |b Discover the Full Potential of MySQL and Ensure High Performance of Your Database. |
| 246 | 3 | |a Advanced MySQL eight | |
| 260 | |a Birmingham : |b Packt Publishing Ltd, |c 2019. | ||
| 300 | |a 1 online resource (280 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |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 | |
| 500 | |a MySQL data dictionary structure 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. | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a MySQL (Electronic resource) |
| 630 | 0 | 7 | |a MySQL (Electronic resource) |2 fast |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Relational databases. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a Programming & scripting languages: general. |2 bicssc | |
| 650 | 7 | |a Databases. |2 bicssc | |
| 650 | 7 | |a Data capture & analysis. |2 bicssc | |
| 650 | 7 | |a Computers |x Database Management |x General. |2 bisacsh | |
| 650 | 7 | |a Computers |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a Computers |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 700 | 1 | |a Shah, Birju, |e author. | |
| 700 | 1 | |a Malepati, Tejaswi, |e author. | |
| 758 | |i has work: |a Advanced MySQL 8 (Work) |1 https://id.oclc.org/worldcat/entity/E39PD3bM83d6YHgCXdMgxjv7Md |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Vanier, Eric. |t Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database. |d Birmingham : Packt Publishing Ltd, ©2019 |z 9781788834445 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=5675584 |z Texto completo |
| 938 | |a Askews and Holts Library Services |b ASKH |n BDZ0039650243 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL5675584 | ||
| 938 | |a EBSCOhost |b EBSC |n 2018967 | ||
| 994 | |a 92 |b IZTAP | ||