> I have MySQL 4.1.12 running on a MacOS X 10.4.1 development > setup where I often load a 1Gb db and later on drop > it/reload/generally make a mess. I just noticed that though > the database is holding only > 4 small records totalling less than 1k, my ibdata1 file is > sitting at over 800Mb. I'm guessing that some time in the > past deleted data has not been purged from the innodb file. > How can I do this manually? Can I force InnoDB to rebuild the > file? 'SHOW INNODB STATUS' doesn't show any open transactions.
Data isn't purged when records are deleted from the DB. It will be overwritten when needed. Resizing the data-files takes to much time to be done on every delete. Resize the files like mentioned here: http://www.mysql.com/news-and-events/newsletter/2003-05/a0000000170.html Regards, TomH -- PROSOFT EDV-Loesungen GmbH & Co. KG http://www.proSoft.org St.-Kassians-Platz 6, D-93047 Regensburg [EMAIL PROTECTED] Geschaeftsfuehrer: Axel-Wilhelm Wegmann phone: +49 941 / 78 88 7-121 AG Regensburg HRA 6608 USt.183/68311 cellphone: +49 171 / 40 54 777 -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
