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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
