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...
jeff Lawrence Smith wrote:
I have recently dropped a database with a big innodb table in it - but the data file (ibdata1) failed to get smaller. It's pretty big (nearly 2GB) and I'd like to reduce it if possible. Is there any way to do this?
Thx
________________________________________________________________________ BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 http://btyahoo.yahoo.co.uk
-- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6 http://www.predict.com Santa Fe, NM 87505
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
