I am currently working on some experiments and have to deal with some millions of
tuples. As you can imagine indexing is essentiall. However My InnoDB file has grown to
over 3.6G and fragmentation is sometimes a big problem. Additionally the file keeps
its size even after dropping the 'big'
that helps.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: I-A.Kotopoulos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, 20 June, 2003 04:36
Subject: InnoDB file size...
I am currently working on some experiments and have to deal
://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 to 2GB before, but now
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
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 to 2GB before, but now
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
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 created
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
I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB
data files,
but mysql is telling me that the files must be = 4096MB
This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a
reiserfs filesystem...
I don't think there should be such a low limit...I
Hello!
Is there any way to know how much space is used in the innodb data files?
So if I have for example :
innodb_data_file_path = ibdata1:200M;ibdata2:400M;
how much of the 600MB actually is used at the moment
Thx!
Elm
database,sql,query,table
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
12 matches
Mail list logo