Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

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

2. MySQL 8's New Features FREE CHAPTER

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

Tips and techniques

In this section, I will share the five most popular tips and we will review a real case of a company that is facing a performance problem with a query in MySQL.

The five general rules for your indexes

The five general rules to know when it is appropriate to create an index would be to respond positively to the following questions:

Can you Index each primary key?
Can you Index each foreign or secondary key?
Can you Index each column used in a JOIN clause?
Can you Index each column used in a WHERE?
Can you Index each column used in a GROUP BY clause?
Can you Index each column used in an ORDER BY clause?
Are you going to generate reports?

In other words, indexes become necessary when you plan to use joins...

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 €18.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