>From the InnoDB manual:
Dropping a table or deleting all rows from it is guaranteed to release the space
to other users, but remember that deleted rows can be physically removed only in
a purge operation after they are no longer needed in transaction rollback or
consistent read.
Perhaps that help
Yes, I saw that before...My filesize was limited to 2GB before, but now with
a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB data file
now, right?
So something's wrong... as I said before, I have successfully created a 9GB
file on this machine before, so the filesystem isn't to b
://www.mysql.com
-Original Message-
From: Gurupartap Davis <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Saturday, February 09, 2002 2:32 AM
Subject: Re: InnoDB File Size
>Yes, I saw that before...My filesize was limited t
Hi!
>From http://www.innodb.com/ibman.html :
MySQL/InnoDB-3.23.44, November 2, 2001
You can define foreign key constraints on InnoDB tables. An example: FOREIGN
KEY (col1) REFERENCES table2(col2).
You can create > 4 GB data files in those file systems that allow it.
Thus > 4 G files
://www.mysql.com
-Original Message-
From: Gurupartap Davis <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Saturday, February 09, 2002 2:32 AM
Subject: Re: InnoDB File Size
>Yes, I saw that before...My filesize was limited t
On Friday 08 February 2002 16:32, Gurupartap Davis wrote:
> Yes, I saw that before...My filesize was limited to 2GB before, but now
> with a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB
> data file now, right?
>
> So something's wrong... as I said before, I have successfully crea
Yes, I saw that before...My filesize was limited to 2GB before, but now with
a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB data file
now, right?
So something's wrong... as I said before, I have successfully created a 9GB
file on this machine before, so the filesystem isn't to b
Hi!
>From http://www.innodb.com/ibman.html :
MySQL/InnoDB-3.23.44, November 2, 2001
You can define foreign key constraints on InnoDB tables. An example: FOREIGN
KEY (col1) REFERENCES table2(col2).
You can create > 4 GB data files in those file systems that allow it.
Thus > 4 G files
Hi,
> how much of the 600MB actually is used at the moment
I'm sure there'a a better way to do it, but this one works:
mysql> show table status like 'your_innodb_table' \G
...
Comment: InnoDB free: 3739648 kB
Best Regards,
Sasa
-