[mythtv] [mythtv-commits] Ticket #2782: automatic simultaneous

[Martin Ebourne]

On Sat, 09 Dec 2006 13:57:22 +0200, osma ahvenlampi wrote:
> But if mysql's buffer flushes are delayed a bit due to recording
> buffer flushes, nothing is lost - and mysql writes much less. That's
> why I suggested the recorder might benefit from being less nice. Also,
> btw, might be a good reason to recommend (or even try to create)
> innodb tables instead of myisam -- innodb is better at writing through
> buffers.

I wouldn't recommend using innodb instead of myisam for mythtv. I tried
it for my sins, and it was somewhat unsuccessful.

The worst problem was the filemarkup table. The select at the start of
watching a video to retrieve all of the seek positions was so much
slower that the 30s timeout for the video playback to start was kicking
in and I couldn't watch a whole bunch of videos.

Cheers,

Martin.