skip to content
Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database. Preview this item
ClosePreview this item
Checking...

Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database.

Author: Eric Vanier; Birju Shah; Tejaswi Malepati
Publisher: Birmingham : Packt Publishing Ltd, 2019.
Edition/Format:   eBook : Document : EnglishView all editions and formats
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.
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: 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
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Eric Vanier; Birju Shah; Tejaswi Malepati
ISBN: 9781788833790 1788833791
OCLC Number: 1086057392
Notes: MySQL data dictionary structure in MySQL 8.0
Description: 1 online resource (280 pages)
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
Other Titles: Advanced MySQL eight

Abstract:

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.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.
Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/1086057392> # Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database.
    a schema:MediaObject, schema:CreativeWork, schema:Book ;
    library:oclcnum "1086057392" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/8983659746#Place/birmingham> ; # Birmingham
    rdfs:comment "Warning: This malformed URI has been treated as a string - 'https://img1.od-cdn.com/ImageType-100/6135-1/{2E66399E-BA0F-4818-9C74-4CE171B8A6E7}Img100.jpg'" ;
    schema:about <http://experiment.worldcat.org/entity/work/data/8983659746#CreativeWork/mysql_electronic_resource> ; # MySQL (Electronic resource)
    schema:about <http://dewey.info/class/005.756/e23/> ;
    schema:about <http://experiment.worldcat.org/entity/work/data/8983659746#Topic/database_management> ; # Database management
    schema:about <http://experiment.worldcat.org/entity/work/data/8983659746#Topic/relational_databases> ; # Relational databases
    schema:about <http://experiment.worldcat.org/entity/work/data/8983659746#Topic/sql_computer_program_language> ; # SQL (Computer program language)
    schema:alternateName "Advanced MySQL eight" ;
    schema:author <http://experiment.worldcat.org/entity/work/data/8983659746#Person/vanier_eric> ; # Eric Vanier
    schema:author <http://experiment.worldcat.org/entity/work/data/8983659746#Person/shah_birju> ; # Birju Shah
    schema:author <http://experiment.worldcat.org/entity/work/data/8983659746#Person/malepati_tejaswi> ; # Tejaswi Malepati
    schema:bookFormat schema:EBook ;
    schema:datePublished "2019" ;
    schema:description "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"@en ;
    schema:description "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."@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/8983659746> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <http://worldcat.org/entity/work/data/8983659746#CreativeWork/advanced_mysql_8_discover_the_full_potential_of_mysql_and_ensure_high_performance_of_your_database> ;
    schema:name "Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database."@en ;
    schema:productID "1086057392" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/1086057392#PublicationEvent/birmingham_packt_publishing_ltd_2019> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/8983659746#Agent/packt_publishing_ltd> ; # Packt Publishing Ltd
    schema:url "https://img1.od-cdn.com/ImageType-100/6135-1/{2E66399E-BA0F-4818-9C74-4CE171B8A6E7}Img100.jpg" ;
    schema:url <http://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781788833790> ;
    schema:url <https://www.overdrive.com/search?q=2E66399E-BA0F-4818-9C74-4CE171B8A6E7> ;
    schema:url <https://public.ebookcentral.proquest.com/choice/publicfullrecord.aspx?p=5675584> ;
    schema:url <https://samples.overdrive.com/?crid=2e66399e-ba0f-4818-9c74-4ce171b8a6e7&.epub-sample.overdrive.com> ;
    schema:workExample <http://worldcat.org/isbn/9781788833790> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/1086057392> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/8983659746#Agent/packt_publishing_ltd> # Packt Publishing Ltd
    a bgn:Agent ;
    schema:name "Packt Publishing Ltd" ;
    .

<http://experiment.worldcat.org/entity/work/data/8983659746#CreativeWork/mysql_electronic_resource> # MySQL (Electronic resource)
    a schema:CreativeWork ;
    schema:name "MySQL (Electronic resource)" ;
    .

<http://experiment.worldcat.org/entity/work/data/8983659746#Person/malepati_tejaswi> # Tejaswi Malepati
    a schema:Person ;
    schema:familyName "Malepati" ;
    schema:givenName "Tejaswi" ;
    schema:name "Tejaswi Malepati" ;
    .

<http://experiment.worldcat.org/entity/work/data/8983659746#Person/shah_birju> # Birju Shah
    a schema:Person ;
    schema:familyName "Shah" ;
    schema:givenName "Birju" ;
    schema:name "Birju Shah" ;
    .

<http://experiment.worldcat.org/entity/work/data/8983659746#Person/vanier_eric> # Eric Vanier
    a schema:Person ;
    schema:familyName "Vanier" ;
    schema:givenName "Eric" ;
    schema:name "Eric Vanier" ;
    .

<http://experiment.worldcat.org/entity/work/data/8983659746#Topic/database_management> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/8983659746#Topic/relational_databases> # Relational databases
    a schema:Intangible ;
    schema:name "Relational databases"@en ;
    .

<http://experiment.worldcat.org/entity/work/data/8983659746#Topic/sql_computer_program_language> # SQL (Computer program language)
    a schema:Intangible ;
    schema:name "SQL (Computer program language)"@en ;
    .

<http://worldcat.org/entity/work/data/8983659746#CreativeWork/advanced_mysql_8_discover_the_full_potential_of_mysql_and_ensure_high_performance_of_your_database>
    a schema:CreativeWork ;
    rdfs:label "Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <http://www.worldcat.org/oclc/1086057392> ; # Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database.
    .

<http://worldcat.org/isbn/9781788833790>
    a schema:ProductModel ;
    schema:isbn "1788833791" ;
    schema:isbn "9781788833790" ;
    .

<http://www.worldcat.org/title/-/oclc/1086057392>
    a genont:InformationResource, genont:ContentTypeGenericResource ;
    schema:about <http://www.worldcat.org/oclc/1086057392> ; # Advanced MySQL 8 : Discover the Full Potential of MySQL and Ensure High Performance of Your Database.
    schema:dateModified "2019-08-15" ;
    void:inDataset <http://purl.oclc.org/dataset/WorldCat> ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.