My original plan was to dump and take down our 5.0 slave, make backups, then upgrade to Percona 5.5 and enable innodb_file_per_table. I was thwarted when it became apparent that our Ubuntu 9.04 machines aren't compatible with the Percona 5.5 packages -- too old.
I didn't want to leave the database down long enough to do a full system reinstall, and frankly don't have the time today, so I brought it back up on the old 5.0 and didn't set the options. (I seem to recall something weird with that option in 5.0, or maybe it just doesn't work? I don't know.)
Anyway, hopefully sometime Soon(TM) I can find time to upgrade to 10.04 ... of course, 12.04 is coming out very soon. I don't know that I want to trust the first release on our databases, though. That's probably unwise.
no subject
My original plan was to dump and take down our 5.0 slave, make backups, then upgrade to Percona 5.5 and enable innodb_file_per_table. I was thwarted when it became apparent that our Ubuntu 9.04 machines aren't compatible with the Percona 5.5 packages -- too old.
I didn't want to leave the database down long enough to do a full system reinstall, and frankly don't have the time today, so I brought it back up on the old 5.0 and didn't set the options. (I seem to recall something weird with that option in 5.0, or maybe it just doesn't work? I don't know.)
Anyway, hopefully sometime Soon(TM) I can find time to upgrade to 10.04 ... of course, 12.04 is coming out very soon. I don't know that I want to trust the first release on our databases, though. That's probably unwise.