Tom Brown wrote:
> hmm i'm not entirely sure i fancy adding another data file on the fly -
> Can you give me a brief run down about how you would go about this?
My collegue the sysadmin usually takes care of keeping the databases
happy. But AFAIK it's a matter of modifying the setting in the .cnf file
and restarting MySQL. I wouldn't let a process do the editing in the
.cnf though, but you may trigger alerts automagically.
> another option would be for me to create the 100gig as 2 25 gig files
> from the off - Do you know how well these would compress? Do you know
> what they are 'filled' with so when it comes to backup they will
> compress down to virtually nothing?
I wouldn't use the InnoDB datafiles in a backup. They are use server
wide for storing InnoDB data. You can use a MySQL dump or the InnoDB hot
backup tool to backup the data easily.
Regards, Jigal.
