Tag - innodb_ibuf_max_size

Why is the ibdata1 file continuously growing in MySQL?

ibdata1 file

We often receive this question about the ibdata1 file in MySQL at Percona Server to avoid becoming too large. For example, you can set a maximum size for change buffer with innodb_ibuf_max_size or store the doublewrite buffer on a separate file with innodb_doublewrite_file.
In MySQL 5.6 you can also create external UNDO tablespaces so they […]

Read more