Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Advanced MySQL 8 Discover the full potential of MySQL and ensure high performance of your database

Product type Paperback

Published in Jan 2019

Publisher

ISBN-13 9781788834445

Length 286 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Database Administration

Authors (3):

Birju Shah

Eric Vanier

Tejaswi Malepati

View More author details

Table of Contents (13) Chapters

Preface

1. Introduction FREE CHAPTER

2. MySQL 8's New Features

3. Indexing Your Data for High Performance

4. Advanced Data Techniques for Large Queries

5. MySQL Data Dictionary in MySQL 8.0

6. MySQL Server Settings

7. Group Replication in MySQL 8.0

8. InnoDB Cluster in MySQL 8.0

9. Monitoring Your Large Distributed Databases

10. Authentication and Security Management with MySQL 8.0

11. Advanced MySQL Performance Tips and Techniques

12. Other Books You May Enjoy

Leave a review - let other readers know what you think

A quick look at the features removed from MySQL 8.0

It is important to note that the following items are obsolete and have been removed in MySQL 8.0. When messages are displayed for alternatives, applications must be updated to use them and the following is only a short list of all removed items. I invite you to visit MySQL website for more details:

The information_schema_stats configuration has been replaced by information_schema_stats_expiry.
InnoDB system views have been replaced:

The query cache has been removed, including FLUSH QUERY CACHE and RESET QUERY CACHE.
Two MySQL storage engines currently provide native partition support: InnoDB and NDB. Of these, only InnoDB is supported by MySQL 8.0. Any attempt to create partitioned tables in MySQL 8.0 using another storage engine will fail.
In MySQL 8.0, the data_locks table and sys schema views contain separate schema name...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (3)

Vanier

Eric Vanier is one of the few DBAs worldwide specializing in MySQL performance, and is an expert with large architectures such as those for Air Miles, Cogeco, McGill University, Bombardier Aerospace, and many more. As a senior DBA and instructor for 18 years, he has a track record in performance and troubleshooting on dozens of high-profile MySQL systems, including complex cluster environments.

See other products by Vanier

Malepati

Tejaswi Malepati is the Cassandra Tech Lead for Target. He has been instrumental in designing and building custom Cassandra integrations, including a web-based SQL interface and data validation frameworks between Oracle and Cassandra. Tejaswi earned a master's degree in computer science from the University of New Mexico, and a bachelor's degree in electronics and communication from Jawaharlal Nehru Technological University in India. He is passionate about identifying and analyzing data patterns in datasets using R, Python, Spark, Cassandra, and MySQL.

See other products by Malepati

Shah

Snehal Shah has extensive experience in implementing enterprise web applications using J2EE technologies. He is the co-founder of Techforce Infotech where he has worked on various J2EE based solutions, various open source product customizations, and worked on business expansion. He was also involved in building a team and finalizing the technology path for the organization. At his previous employer, CIGNEX Datamatics, he rolled out numerous Alfresco deployments worldwide in the areas of document management, web content management, and Share. He has also worked on application-based Liferay and Moodle products. Prior to CIGNEX, he has worked on various J2EE-based solutions using cutting edge technologies. He has worked with clients in education, legal, and marketing domains across the world. He has worked on defining architecture for various projects, which involves multiple product integrations. In his previous organizations, he was involved in deciding the technology path of the organization and was also involved in various internal technical training. He holds a Bachelors Degree in Computer Engineering from Deemed University, DDIT India. He has also worked as a Technical Reviewer for the books Alfresco 3 Cookbook and Alfresco Share.

See other products by Shah