Manually fill up innoDB file

[Steven Broos]

Hi people,

I have a fast-growing database that uses MySQL/InnoDB. I create auto-extending InnoDB files which grow to max 4GB.

Now a script warns me whenever the file is almost 4GB, so I can add a new one.
Is there any possibility to manually grow the last file to the max-size of 4GB and then add a new auto-extending file ?

Changing the config-file and restarting MySQL doesn't work and give me an error.

I want to do this to keep things clean, so all files are 4GB, and not somewhere between 3.5 and 4GB... I know it's not really necessary.

Creating a NOT autoextending file is not a solution, because the monitoring script uses the file size.
Unless there is another way to easily monitor the used space, but I haven't found a solid solution yet.


Thanks for your thoughts!

Steven