[mythtv-users] Bad mysql performance -- huge oldrecorded -- joins without index

[Håkon Alstadheim]

Den 09. juni 2016 01:11, skrev Håkon Alstadheim:
> Can't seem to get mythweb to speak english at the moment, below are
> the stats you are talking about in Norwegian I believe, after I
> deleted oldrecorded from 2001 until june 2013. I also deleted 6 * 365
> entries of two daily news-shows, and some other low-hanging-fruit.
> phpMyAdmin now says 27 377 rows in oldrecorded. I know I have some
> recorded files missing, I usually try running a "find orphans" at
> least once a year.
>
>
>     Opptaksstatistikk
>
> Antall sendinger: (= number of broadcasts)
>     1678
> Antall episoder: (= number of episodes )
>     26827
> Første opptak: (= first recording)
>     Saturday June 1st, 2013
> Siste opptak: (= last recording )
>     Wednesday June 8th, 2016
> Total kjøretid: (= total running time )
>     3 år 7 dager 22 t 11 minutter
> Totalt tatt opp: (= total recorded )
>     2 år 23 dager 2 t 36 minutter
> Prosent av tiden brukt til å ta opp:
>     68%
>
>
I just realized you mentioned this report as well:
Sendinger 	
	Kanaler
Tittel 	Tatt opp 	Siste opptak 	# 	Tittel 	Tatt opp 	Siste opptak
Kveldsnytt 	1010 	June 8 2016 	1 	NRK Super / NRK3 	7660 	June 8 2016
Kulturhuset 	956 	June 8 2016 	2 	NRK1 Midtnytt 	7625 	June 8 2016
Nyhetsmorgen i P2 (Manuelt opptak) 	723 	June 8 2016 	3 	NRK2 	4925
June 8 2016
Kulturnytt P2 Morgen (Manuelt opptak) 	713 	June 8 2016 	4 	NRK P2
4658 	June 8 2016
Dagsnytt atten 	687 	June 8 2016 	5 	NRK P3 	869 	June 3 2016
Nyhetslunsj 	664 	June 8 2016 	6 	NRK P1 Trøndelag 	669 	June 4 2016
Supernytt 	580 	June 8 2016 	7 	NRK Alltid Nyheter 	208 	April 29 2016
Her og nå 	524 	April 1 2016 	8 	NRK Gull 	112 	April 8 2016
Sauen Shaun 	419 	June 7 2016 	9 	NRK Folkemusikk 	60 	December 21 2014
DJ Friendly 	406 	January 9 2016 	10 	NRK mP3 	32 	June 5 2016


Only news-shows on the top 8, and that is after I removed a couple. Then
Shaun the Sheep at number 9 :-)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160609/d50ab8d8/attachment.html>