[mythtv-users] upgrading MySQL
ylee at pobox.com
Sat Apr 4 06:42:56 UTC 2009
Boleslaw Ciesielski <bolek-mythtv at curl.com> says:
> 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.
When I asked about using this option I was warned against it
almost exactly two years ago, in fact); if you differ on the subject
I'd appreciate hearing your thoughts.
I still backup using a script similar to what I mention in the thread,
although only every six hours and the unresponsive period is only a
fraction of the ~100 seconds (including compression) of elapsed time.
Frontend/backend: P4 3.0GHz, 1.5TB software RAID 5 array
Backend: Quad-core Xeon 1.6GHz, 6.6TB sw RAID 6
Video inputs: Four high-definition over FireWire/OTA
Accessories: 47" 1080p LCD, 5.1 digital, and MX-600
More information about the mythtv-users