How to Reduce Table Size in MySQL Aurora Database After Dropping Partitions?

I have created partitions in my MySQL Aurora database and subsequently dropped old partitions. However, despite removing approximately 75% of the data, the table size remains unchanged at 3TB. Can anyone guide me on how to reduce the table size?

Topics: Database
Tags: MySQL Database Amazon Aurora
Language: English

jamshaeed

asked 2 years ago667 views

1 Answer

Newest
Most votes
Most comments

Check out this guide for insights on how to minimize your table size and enhance its efficiency: Optimizing RDS MySQL Storage.

EXPERT

Osvaldo Marte

answered 2 years ago

Relevant content

Partitioning in aurora mysql
Accepted Answer
awslearner0073
asked 3 years ago
Can PostgreSQL table partitions reduce Aurora DBLoadNonCPU and IO:XactSync wait events?
rePost-User-5051556
asked 3 years ago
RDS Aurora MySQL storage scaling is not shrinking deleted tables
Mapendo
asked 2 years ago
Aurora Serverless V2 doesn't drop the database on DROP.
Accepted Answer
Pleblanc
asked 3 years ago
How do I troubleshoot temporary table and storage full issues in Amazon RDS and Aurora MySQL-Compatible?
AWS OFFICIALUpdated a year ago
How do I remove and restore table and column comments on Amazon RDS for MySQL and Amazon Aurora for MySQL?
AWS OFFICIALUpdated 2 years ago
How do I upgrade my Aurora MySQL-Compatible and Aurora PostgreSQL-Compatible global databases?
AWS OFFICIALUpdated 8 months ago
How do I resolve high CPU usage and query slow performance after I upgrade my Amazon RDS for MySQL or Aurora MySQL-Compatible DB instance?
AWS OFFICIALUpdated a year ago
How to convert Database Character Sets to utf8mb4 in AWS RDS/Aurora MySQL
EXPERT
Taylor Chu
published a year ago
How to Track Partition Row Counts Without Lock Contention Using pg_stat_user_tables on Aurora PostgreSQL
SUPPORT ENGINEER
Sakshi_Arya
published a month ago

How to Reduce Table Size in MySQL Aurora Database After Dropping Partitions?

Add your answer

Relevant content