[mythtv-users] mysql filling up hard drive

[Scott Moncrieff]

I don't know why I didn't look before but I just looked in Manage Recording
Rules and it is full of 'Record All     Breakfast      News...' rules. I
don't know how many but was holding 'page down' for a good couple of
minutes and still did not get past them. Too many to delete manually I
suspect. Would this be a likely cause! How can I get rid of them without
setting aside a couple of day deleting them one at a time?

On 8 May 2015 at 22:45, Scott Moncrieff <scottcmoncrieff at gmail.com> wrote:

> I would imagine the database is huge, I have been running this system for
> about 7 year now and the current recordings hard drive has more than 2TB of
> data on it. All my wifes and some kids stuff!
>
> I don't think that I have ever added a custom recording rule, other than
> changing a couple of old rules to ignore searching previous recordings  and
> to record all episodes but only for a couple of shows. ie 'Look for
> duplicate in current recordings'
>
> On 8 May 2015 at 22:34, Bill Meek <keemllib at gmail.com> wrote:
>
>> On 05/08/2015 04:26 PM, Scott Moncrieff wrote:
>>
>>> 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?
>>>
>>
>>
>> Yes, it's a bad idea because it wouldn't clear out, for example the
>> recordedseek
>> table.
>>
>> As mentioned before, I don't think this is your problem. You should clean
>> that
>> up, but solve the running out of space issue 1st.
>>
>> I didn't see any response to my question. Have you created any new
>> custom recording rules lately?
>>
>> --
>> Bill
>>
>> _______________________________________________
>> 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/c6eafde8/attachment.html>