Lawrence, if you use MySQL-4.1.1, and specify
innodb_file_per_table in my.cnf, then InnoDB places each table into its own .ibd file. That is a way to free the disk space to the OS if you drop a table. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Lawrence Smith" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, January 30, 2004 12:59 AM Subject: Re: Shrinking innodb datafiles? > --- Jeff Mathis <[EMAIL PROTECTED]> wrote: > > someone will no doubt echo what I'm about to say. > > InnoDB files are created at startup. the files use > > all the disk you > > allocate to them in your my.cnf startup file. > > > > If you want smaller InnoDB files, specify a smaller > > file size in your > > my.cnf file, but I have a feeling thats not what you > > want to do... > > I have the default my.cnf , which creates a 10MB file > and IIRC default extension of 8MB (this is on a > devel machine BTW). I have a couple of DBs with > parsely populated tables, and loaded a test database > with a lot of data which would account for the vast > size of the file. I thought dropping the DB would > free up space but this doesn't seem to be the case. > > I suppose the workaround would be to dump and recreate > all databases. > > Thx > > > ===== > http://www.explanation-guide.info > > ________________________________________________________________________ > BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 http://btyahoo.yahoo.co.uk > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]