Tag - ibdata1

A closer look at the MySQL ibdata1 disk space issue and big tables

A recurring and very common customer issue seen here at the Percona Support team involves how to make the ibdata1 file “shrink” within MySQL. I can only imagine there’s a degree of regret by some of the InnoDB architects on their design decisions regarding disk-space management by the shared tablespace* because this has been a […]

Read more

Why is the ibdata1 file continuously growing in MySQL?

ibdata1 file

We often receive this question about the ibdata1 file in MySQL at Percona Support.
The panic starts when the monitoring server sends an alert about the storage of the MySQL server – saying that the disk is about to get filled.
After some research, you realize that most of the disk space is used by the […]

Read more