Skip to Main Content
Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency
book

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

by Y V Ravi Kumar, Arun Kumar Samayam, Naresh Kumar Miryala
May 2024
Intermediate to advanced content levelIntermediate to advanced
750 pages
12h 29m
English
Apress
Content preview from 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 Kumar1  , Arun Kumar Samayam2 and Naresh Kumar Miryala3
(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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Hands-On MySQL Administration

Hands-On MySQL Administration

Arunjith Aravindan, Jeyaram Ayyalusamy
PostgreSQL 16 Administration Cookbook

PostgreSQL 16 Administration Cookbook

Gianni Ciolli, Boriss Mejías, Jimmy Angelakos, Vibhor Kumar, Simon Riggs

Publisher Resources

ISBN: 9798868802522Purchase LinkPublisher Website