At 15:12 -0500 12/14/05, Nathan Gross wrote:
Hi;
A while ago, I changed most of my myisam based tables over to innodb. Fine.
A while later, I noticed and implemented the option to keep the
files separate.
Now, weeks later, I still have a huge, 7 gig ibdata1, plus many *.ibd files.
Can I delete ibdata1? What worries me is that when I have new inserts
into the db, the os timestamp of ibdata1 is in-sync (fresh) with the
ibd files.
Yes, you need the ibdata1 file. That's where InnoDB keeps its data
dictionary, regardless of whether you use *.ibd files. If you want to
shrink it, you could mysqldump all of your InnoDB tables. Then remove
them all, reconfigure the shared tablespace (ibdata1) to have a smaller
size, and then reload the dump file.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
