[mythtv-users] How big is your database on disk?
Dave Richardson
mythtv at derdev.com
Fri Apr 22 12:40:04 UTC 2011
On Fri, 22 Apr 2011 13:30:30 +0100, Richard Morton
<richard.e.morton at gmail.com> wrote:
> Do you run the optimize_db script; I have it running as a cronjob, I
> dont know what is the "optimum" interval for running it, I am sure
> weekly would be sufficient. You never know it might help. If you have
> "jumpiness" it maybe your frontend isnt quite up to the job of
> running
> it smoothly.. I tend not to use the on-screen scheduler and use
> mythweb for nearly all scheduling (connecting over SSH &
> portforwarding on my android phone, using the connectbot app, and
> using mythweb remotely when needed).
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
Frontend that I notice it the most on is a Revo 3700, ethernet, and an
SSD.
The kids use the Guide feature from a universal (Harmony) remote.
I do run the optimize tables from mythweb about every 1-2 weeks. It
used to make a lot of difference in pre-/post-optimization disk space
used, but that's probably when I ran it less frequently. No errors
reported by mythweb on the SQL.
I figure there are plenty of other things to check into, I'm not that
worried, just curious at this stage.
I am, however, going to continue watching for anyone who has insight on
further optimizing the queries.
Thanks again
More information about the mythtv-users
mailing list