[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