[mythtv-users] ramfs for mysql

[Brent Bolin]

On Wed, Dec 21, 2011 at 1:56 PM, Dan Wilga
<mythtv-users2 at dwilga-linux1.amherst.edu> wrote:
> On 12/21/11 2:04 PM, Josu Lazkano wrote:
>> Hello all. I am having some playback problems on LiveTV
>> (mythpreviewgen). I try to change the recordings file system (XFS,
>> EXT3, EXT4...), but I got little stops.
>>
>> I read about to move the mysql files to ramfs, I have 3GB of memory
>> (2x2GB, 1GB for nvidia card).
>>
>> Before start to break my system I want to know if this will help to
>> the playback problems. I have problem on program guide change watching
>> LiveTV.
>>
>> Anyone using ramfs for mysql? Any recomendation?
>>
> IMHO, if you have RAM to spare, it makes more sense to throw it at MySQL
> directly by tuning the parameters in mysql.conf. Using ramfs or tmpfs,
> you have to worry about data loss during an unexpected reboot, unless
> you also do MySQL replication to non-volatile storage.
>
> --
> Dan Wilga                                                        "Ook."
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users

I do a nightly mythtv backup.  And mysql dump every 4 hours