Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency

© Y V Ravi Kumar, Arun Kumar Samayam, Naresh Kumar Miryala 2024

Y. V. Ravi Kumar et al.Mastering MySQL Administrationhttps://doi.org/10.1007/979-8-8688-0252-2_4

4. MySQL Tablespace Management and Partitioning

Y V Ravi Kumar¹  , Arun Kumar Samayam² and Naresh Kumar Miryala³

(1)

Irving, TX, USA

(2)

Dallas, TX, USA

(3)

Tracy, CA, USA

 

Introduction

In this chapter, we will discuss tablespace and partitioning. Partitioning divides a large dataset into smaller manageable subsets, usually called partitions. Partitions can be stored, managed, and accessed separately, improving the database's scalability, availability, and performance.

Before partitioning, there is guidance on physical data storage once we have the concept of tablespaces, which are logical representations ...