Carl, when it runs out of disk space the auto-extend feature prints to the MySQL error log a complaint that disk space has run out, and stops extending the file.
If you do not give it more free disk space, InnoDB behaves as if it would have a fixed size data file. That is, you will get the 'Table is full' errors. But when you give it more disk space, auto-extension continues. I have not tested what happens on those file systems where max file size is 2 GB. If you run on such a file system, best to specify ibdata1:10M:autoextend:max:2000M Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com ----- Original Message ----- From: "Carl McNamee" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 09, 2002 4:53 PM Subject: RE: InnoDB > Heiki, > > I have a question concerning the new auto-extending function (which sounds > really cool by the way!). How does it handle the case where it runs out of > disk space while expanding? Will it gracefully handle this scenerio or will > some sort of recovery be necessary? > > Carl McNamee > Systems Administrator > Billing Concepts > (210) 949-7282 > > > >The auto-extending data file of InnoDB-3.23.50 will solve your problem. No > >need to preallocate tablespace any more. > >Best regards, > > >Heikki Tuuri > >Innobase Oy --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
