--- 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]