I wrote an article in www.stackoverflow.com about how to convert absolutely every InnoDB table to .ibd and permanently shrink the ibdata1 file
http://stackoverflow.com/questions/3927690/howto-clean-a-mysql-innodb-storage-engine/4056261#4056261 Enjoy !!! Rolando A. Edwards MySQL DBA (SCMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -----Original Message----- From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Friday, February 11, 2011 12:53 PM To: mysql@lists.mysql.com Subject: Converting INNODB to file-per-table? 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 :::: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=redwa...@logicworks.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
