[mythtv-users] mysql filling up hard drive

[Scott Moncrieff]

I will have a look at mysqltuner but Is it likely that something is is
wrong with the database? There are a large number of errors in the log
trying to delete recordings that are not there. I have had a look at the
drive that the recordings are stored on and these are all  files that have
been watched and then deleted. Obviously still present in the database. The
thumb nails for all the video files are still present on the drive though
but the recordings are long gone.

Would manually deleting all of these entries from the 'recored' table be a
bad idea?


On 8 May 2015 at 21:01, Simon Hobson <linux at thehobsons.co.uk> wrote:

> Dan Wilga <mythtv-users2 at dwilga-linux1.amherst.edu> wrote:
>
> > If you have not already tuned MySQL, you should look into the settings
> available in /etc/my.cnf. The most relevant ones in your case would
> probably be tmp_table_size and max_heap_table_size which, for MyISAM
> tables, should probably be identical. I use a value of 500M for each, which
> means large queries that cannot be satisfied by other caching methods can
> take up to 500 Mb before having to be written to disk.
> >
> > If you have enough free RAM, you could set tmpdir to /dev/shm/, but this
> is a less efficient way of doing the same thing.
>
> I would also suggest running mysqltuner.pl - it generally gives pretty
> good information on how your current settings can be changes to suit your
> load. You'll enjoy spending a few hours going through the manual working
> out how the settings interact and what they do - then tweak, restart MySQL
> and wait to build up fresh stats.
>
> It does take some effort, but I can assure that a bit of tuning can really
> really improve your system. I forget the details now, but IIRC my system
> used to be quite sluggish (especially when rescheduling after after
> recording rule change), but after tuning would reschedule in a fraction of
> the time and normally before MythWeb redrew the upcoming recordings page.
>
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150508/d8921db3/attachment.html>