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

Reply via email to