Heikki, thanks for the reply, will note.
Just to confirm if I understand the situation correctly: innodb datafiles cannot be reduced in size to reclaim spaced freed by deleted data? (That'd probably explain why I had a hard time finding ISPs offering innodb-enabled MySQL). Lawrence Smith --- Heikki Tuuri <[EMAIL PROTECTED]> wrote: > 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. ________________________________________________________________________ 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]