I need help!
I'm making some testing with innodb tables and there're some issues I
don't understand.
I created a small tablespace of 10M:
innodb_data_file_path = ibdata1:10M;
Then I created this simple database:
CREATE DATABASE trace_db;
use trace_db;
CREATE TABLE chromatogram (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
trace MEDIUMBLOB NOT NULL,
PRIMARY KEY (id),
) TYPE=INNODB;
Then I wrote a little Perl script to fill this table:
my $fileName = "A03_017.ab1.bz2";
for (my $i = 1; $i <= $max; $i++) {
my $query = qq {insert into chromatogram set trace =
LOAD_FILE("$fileName")};
$dbh->do($query) || die;
}
Here is the problem: Although the size of the file is 63Kb, I can do
only a maximum of 84 insertions (which represent a total of 5.3M).
After that, I get the error message that the table is full.
Command "show table status" gives me a data_length of 5.9M which is
only 59% of the total tablespace allocated.
I want to have a database containing hundreds thousand of those files.
I can't obviously afford to loose 41% of my tablespace.
Can someone explain to me those numbers and what should I do to
optimize my disk space.
Thank you very much
Vincent
---------------------------------------------------------------------
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
