[mythtv] extremly slow mythfilldatabase in 0.28

[Torbjorn Jansson]

On 2016-07-14 23:25, Gary Buhrmaster wrote:
> On Thu, Jul 14, 2016 at 9:05 PM, Torbjorn Jansson
> <torbjorn.jansson at mbox200.swipnet.se> wrote:
>
>> a full refresh takes of my two cards take somewhere between 1 and 2 hours
>> and i'm not joking.
>
> It is a bit hard to say with the information you have
> provided (time says little), but check your database
> configuration(s).  mfdb will perform a lot of database
> operations and a poorly tuned database can result
> in slow operations.  Depending on how you installed
> (or upgraded) to 0.28, the configurations may have
> changed between releases.  There are some tuning
> tips on the wiki.
>
> Alternatively, you likely need to provide a link to
> the verbose logging from manually running mfdb
> to let people look at the logs.

any preferred log level ?
if not i'll just post the -v all output but i have a feeling  this is 
going to be extremely large.

file so far after about 5 minutes is 10mb of text ;-)
not so sure anyone wants to look at that log file.
i bet the file will be at least 10 times that, possibly more.

a quick look at the log file shows loads of stuff like:

-----------
2016-07-15 19:37:48.011744 I [2007/2017] SystemSignalManager 
referencecounter.cpp:145 (DecrRef) - (0x1e8e4f0)::DecrRef() -> 1
2016-07-15 19:37:48.011879 I [2007/2007] CoreContext 
referencecounter.cpp:145 (DecrRef) - (0x1e8e4f0)::DecrRef() -> 0
2016-07-15 19:37:48.013595 I [2007/2007] CoreContext 
mythsystemunix.cpp:948 (Fork) - Managed child (PID: 7412) has started! * 
command=/usr/local/share/mythtv/metadata/Television/ttvdb.py -v, timeout=0
2016-07-15 19:37:48.013614 I [2007/2007] CoreContext 
referencecounter.cpp:114 (IncrRef) - (0x1e6cf10)::IncrRef() -> 2
2016-07-15 19:37:48.134163 I [2007/2016] SystemManager 
mythsystemunix.cpp:354 (run) - Managed child (PID: 7412) has exited! 
command=/usr/local/share/mythtv/metadata/Television/ttvdb.py -v, 
status=0, result=0
2016-07-15 19:37:48.162009 I [2007/2017] SystemSignalManager 
referencecounter.cpp:145 (DecrRef) - (0x1e6cf10)::DecrRef() -> 1
2016-07-15 19:37:48.162141 I [2007/2007] CoreContext 
referencecounter.cpp:145 (DecrRef) - (0x1e6cf10)::DecrRef() -> 0
2016-07-15 19:37:48.163825 I [2007/2007] CoreContext 
mythsystemunix.cpp:948 (Fork) - Managed child (PID: 7415) has started! * 
command=/usr/local/share/mythtv/metadata/Television/ttvdb.py -v, timeout=0
2016-07-15 19:37:48.163845 I [2007/2007] CoreContext 
referencecounter.cpp:114 (IncrRef) - (0x1e6cf10)::IncrRef() -> 2
2016-07-15 19:37:48.284366 I [2007/2016] SystemManager 
mythsystemunix.cpp:354 (run) - Managed child (PID: 7415) has exited! 
command=/usr/local/share/mythtv/metadata/Television/ttvdb.py -v, 
status=0, result=0
2016-07-15 19:37:48.312245 I [2007/2017] SystemSignalManager 
referencecounter.cpp:145 (DecrRef) - (0x1e6cf10)::DecrRef() -> 1
2016-07-15 19:37:48.312367 I [2007/2007] CoreContext 
referencecounter.cpp:145 (DecrRef) - (0x1e6cf10)::DecrRef() -> 0
2016-07-15 19:37:48.313855 I [2007/2007] CoreContext 
mythsystemunix.cpp:948 (Fork) - Managed child (PID: 7418) has started! * 
command=/usr/local/share/mythtv/metadata/Television/ttvdb.py -v, timeout=0
2016-07-15 19:37:48.313876 I [2007/2007] CoreContext 
referencecounter.cpp:114 (IncrRef) - (0x1e8d430)::IncrRef() -> 2
2016-07-15 19:37:48.434780 I [2007/2016] SystemManager 
mythsystemunix.cpp:354 (run) - Managed child (PID: 7418) has exited! 
command=/usr/local/share/mythtv/metadata/Television/ttvdb.py -v, 
status=0, result=0
2016-07-15 19:37:48.462556 I [2007/2017] SystemSignalManager 
referencecounter.cpp:145 (DecrRef) - (0x1e8d430)::DecrRef() -> 1
2016-07-15 19:37:48.462667 I [2007/2007] CoreContext 
referencecounter.cpp:145 (DecrRef) - (0x1e8d430)::DecrRef() -> 0
2
-----------

not sure it is relevant or not.