I'm working on migrating an bunch of MyISAM tables over to InnoDB. For
development we want to use a fixed amount of space. So I have specified
10 100MB files in my.cnf. I started replicating data over but what I
can't tell is how much space I have left. Running show innodb status\G
shows a lot of stuff but I can't find anything that clearly says "X"
bytes stored or how much space might be left.

Is there anything in particular I'm missing? Actually better question,
where should I be looking?

Gary

> -----Original Message-----
> From: Gary W. Smith [mailto:gary@primeexalia.com]
> Sent: Wednesday, February 14, 2007 8:01 PM
> To: mysql@lists.mysql.com
> Subject: InnoDB fixed file size, how much is left?
>
> I'm working on migrating an bunch of MyISAM tables over to InnoDB.
For
> development we want to use a fixed amount of space. So I have
> specified
> 10 100MB files in my.cnf. I started replicating data over but what I
> can't tell is how much space I have left. Running show innodb
status\G
> shows a lot of stuff but I can't find anything that clearly says "X"
> bytes stored or how much space might be left.
>
> Is there anything in particular I'm missing? Actually better
question,
> where should I be looking?
>
> Gary

Maybe I should think a little less harder on the problem. I put
innodb_file_per_table in the config so the 10 100mb files are currently
ununsed.

For what you described... you will not get a fixed size...

If you have set file_per_table flag in my.cnf you might want to know
that the .ibd files in the database directory are by default
auto-extending... so those files WILL grow... along with your data...

The shared tablespaces that you talked about (10 * 100MB) are still
used by InnoDB for transactions and foreign keys reference (at least
these two things)...
Although I don't get why would you use 10 files of 100MB... why not 20
of 50MB... unless they are on different disks and partitions... I
don't understand...

I would personally go with at most 2 files arround 500MB... keeping in
mind that you have file_per_table on !!!

How big transactions are you expecting... how many clients are you expecting ?
Answers to these questions can help you tweak the server...

-- -- -- -- -- -- -- -- -- -- -- -- -- --
Gabriel PREDA
Senior Web Developer