Re: InnoDB file size...

2003-06-20 Thread Becoming Digital
>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

Re: InnoDB File Size

2002-02-12 Thread Gurupartap Davis
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

Re: InnoDB File Size

2002-02-12 Thread Heikki Tuuri
://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

Re: InnoDB File Size

2002-02-11 Thread Heikki Tuuri
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

Re: InnoDB File Size

2002-02-09 Thread Heikki Tuuri
://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

Re: InnoDB File Size

2002-02-08 Thread Kyle Hayes
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

Re: InnoDB File Size

2002-02-08 Thread Gurupartap Davis
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

Re: InnoDB File Size

2002-02-07 Thread Heikki Tuuri
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

Re: innodb file size usage

2001-10-30 Thread Aleksandar Bradaric
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 -