Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Advanced MySQL 8

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

Arrow left icon
Product type Paperback
Published in Jan 2019
Publisher
ISBN-13 9781788834445
Length 286 pages
Edition 1st Edition
Languages
Tools
Arrow right icon
Authors (3):
Arrow left icon
Birju Shah Birju Shah
Author Profile Icon Birju Shah
Birju Shah
Eric Vanier Eric Vanier
Author Profile Icon Eric Vanier
Eric Vanier
Tejaswi Malepati Tejaswi Malepati
Author Profile Icon Tejaswi Malepati
Tejaswi Malepati
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

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

Advanced Data Techniques for Large Queries

In the previous chapters, we learned how to use indexes, and execution plans, and looked at the best way to analyze a table structure. In this chapter, we will be learning how to analyze and optimize large MySQL queries, and look at some tips and techniques.

We all know that a full scan on a huge table will impact your database performance, and we will learn how to avoid it. We will also review the new MySQL 8.0 partition features and improvements.

This chapter will cover the following:

  • The most important variables are full scan indicators
  • Partitioning a table:
    • Overview of partitioning in MySQL 8.0
    • Partitioning types available
    • Horizontally partitioning your data
    • Managing partitions:
      • Option #1: RANGE partitioning
      • Option #2: LIST partitioning
      • Option #3: HASH partitioning
      • Option #4: KEY partitioning
  • Using partitions:
    • Partition pruning...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
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
Renews at AU $24.99/month. Cancel anytime