Re: 'Autoextend' datafile - Mysql-Max-4.1.14 - Linux

[Jigal van Hemert]

From: "Tom Brown" <tom.brown@stripped>
(...)
> starting at say 1GB and then 'extending' to 25GB. So is it possible for
> all datafiles, rather than just the last one, be 'autoextending'

The short answer: no.

http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states:
" The autoextend attribute and those following can be used only for the last
data file in the innodb_data_file_path line. autoextend is available
starting from MySQL 3.23.50 and 4.0.2. "

You could use two methods to manage the increasing need for space in your
situation:

1) Use fixed sizes and keep track of the free space.
Use SHOW TABLE STATUS LIKE '<tablename>'; and use the `Comment` column which
shows you something like "InnoDB free: 5278720 kB". If this number gets too
low, modify your config file and add an extra datafile.

2) Use an autoextend file and make it fixed size if it gets too large.
http://dev.mysql.com/doc/refman/4.1/en/adding-and-removing.html tells you
that you can change an autoextend datafile to a fixed size file by getting
the size, rounding it to the closest multiple of 1024 x 1024 bytes (1MB),
changing the settings in the configuration file in such a way that the
autoextend file is now fixed to the size you calculated and that you added a
new autoextend file.

Regards, Jigal.