Id like some advice regarding MySQL 5 innodb datafile sizes.
I have a DB containing 25 Gb of data (data + indexes), about 60 million rows.
What is best, to have one single datafile, or several? If several is best, whats the best datafile size? (I guess Ill have 100 Gb of data soon).
Can I configure MySQL to create an additional datafile automatically when needed? For example, I would like to have 4 Gb datafiles, and when the last datafile gets full, MySQL creates another 4 Gb datafile automatically. Is that possible?
What is the advantages and disadvantages of having one or several datafiles? Performance, backups?
Im moving this database to a CentOS 5.1 64bit system, 8 Gb RAM, 1 Tb HD.