When (and how) to move an InnoDB table outside the shared tablespace
In my last post, “
Read more
22
Aug
2014
21
Aug
2014
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
20
Aug
2013
Why is the ibdata1 file continuously growing in MySQL?
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 […]