Question : I have innodb_file_per_table set and just today my ibdata1 file jumped from 59M to 323M after I made […]
Tag: ibdata
ib_logfile0 and ib_logfile1 got deleted
Question : After restoring from a percona-xtrabackup without a preparation step, ib_logfile0 and ib_logfile1 were not present in the restore […]
I have multiple ibdata files : What should I do with them?
Question : I have 3 different ibdata files on disk. What is the difference between them? Can I remove some […]
Recovering from removal of ibdata1 [duplicate]
Question : This question already has an answer here: Recover MySQL database from data folder without ibdata1 from ibd files […]
Purge old records from mysql ibdata1 file
Question : Is it possible to purge old records from an ibdata1 file without taking down the database attached to […]
MariaDB: how to reduce ibdata file size
Question : I found that My MariaDB’s ibdata file keep increasing. So, I’ve searched for this, and found that innodb_file_per_table […]
Two MySQL Server accessing same database over NFS
Question : I want to run two separate MySQL instances on two separate machines, but using same data directory over […]
Purge old records from mysql ibdata1 file
Question : Is it possible to purge old records from an ibdata1 file without taking down the database attached to […]
I have multiple ibdata files : What should I do with them?
Question : I have 3 different ibdata files on disk. What is the difference between them? Can I remove some […]
ibdata1 grows exponentially when innodb_file_per_table is configured
Question : I Have installed a MySQL Cluster with InnoDB (innodb_file_per_table enabled subsequently), but since I switched to innodb_file_per_table, the […]