[mythtv-users] How big is your database?

Niklas Brunlid prefect47 at gmail.com
Sat Dec 3 15:13:32 EST 2005


[root at noYouDont mythconverg]# ls -al --sort=size
total 263544
-rw-rw----  1 mysql mysql 150737964 Dec  3 21:08 recordedmarkup.MYD
-rw-rw----  1 mysql mysql 108397568 Dec  3 21:08 recordedmarkup.MYI
-rw-rw----  1 mysql mysql   2292452 Dec  3 08:58 program.MYD
-rw-rw----  1 mysql mysql    914760 Dec  3 08:57 people.MYD
-rw-rw----  1 mysql mysql    861184 Dec  3 08:58 program.MYI
-rw-rw----  1 mysql mysql    849540 Dec  3 20:13 oldrecorded.MYD
-rw-rw----  1 mysql mysql    661680 Aug 17 22:54 musicmetadata.MYD
...

This is a 2-2.5 year old mythtv database that has survived several updates,
distro changes and server hardware changes.

Amazing how much data you can store from a measly 12 channels. Of course,
this helps a bit:

[root at noYouDont mythconverg]# df
...
/dev/mapper/vgmyth-tv
                     637403136 619287092  18116044  98% /myth/tv

I keep telling myself I will have time to watch all that someday... =)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20051203/62706136/attachment.htm


More information about the mythtv-users mailing list