Our incremental backups seem to be filling with instances of ib_logfile1, ib_logfile2, and
ibdata1.
I know that changing a single byte in a single INNODB table causes these files to be
"touched."
I put "innodb_file_per_table" in /etc/my.cnf, but apparently, that only causes new
databases to be "file per table," and it is older databases that are being touched in a
minor way daily, causing gigabytes to be backed up needlessly.
Some time ago, someone posted a way to convert existing INNODB tables to "file per table,"
but I am unable to find that.
Can someone please post that procedure again?
(I also welcome any "you shouldn't be doing it that way" comments, as long as they show a
better way... :-)
This is for a fairly low-volume server, running on a Mac Mini with two 500GB disks.
Thanks!
----------------
In summary, the idea is to give all of the information to help others to judge the value
of your contribution; not just the information that leads to judgement in one particular
direction or another. -- Richard P. Feynman
:::: Jan Steinman, EcoReality Co-op ::::
