[mythtv-users] upgrading MySQL
Boleslaw Ciesielski
bolek-mythtv at curl.com
Fri Apr 3 20:14:15 UTC 2009
David Brodbeck wrote:
> The main reason you see people doing binary backups is speed. On a large
> database running mysqldump can take tens of minutes, and during that time
> all the tables are write-locked, effectively making the database unusable
> until the backup is complete.
If you convert your database to InnoDB then you can use
mysqldump --single-transaction --skip-lock-tables
which does not lock any tables but still dumps consistent state.
Are there any reasons not to use InnoDB for mythconverg? I tried that
and did notice any negative effects.
Bolek
More information about the mythtv-users
mailing list