[mythtv-users] One step forward, two steps back - Frontends not woring properly

[Damian]

On 02/05/2016 02:22, Roger Siddons wrote:
> On 02/05/16 01:29, Bill Meek wrote:
>> On 05/01/2016 06:42 PM, Damian wrote:
>>>
>>> So, does anyone have any more tips?
>>
>> Sure, stop the frontend, restart it from the command line like this:
>>
>>      mythfrontend --logpath /tmp --quiet
>>
>> Go the the screen that's failing, then exit the frontend as you
>> normally would.
>>
>> Pastebin the log found in /tmp. Folks here can see if anything
>> sticks out.
>>
>> (oops, and put the link to the pastebin here)
>>
>
> After that, could you post the result of:
>
> mythfrontend -v database | grep Took | head -10
I did this for both remote frontends ...

fe1
$ mythfrontend -v database | grep Took | head -10
2016-05-02 16:32:15.007248 I  MSqlQuery::exec(DBManager0) SELECT data 
FROM settings WHERE value = 'backendserverip' AND hostname = 'liva' <<<< 
Took 1ms, Returned 1 row(s)
2016-05-02 16:32:15.010011 I  MSqlQuery::exec(DBManager0) SELECT data 
FROM settings WHERE value = 'backendserverip6' AND hostname = 'liva' 
<<<< Took 1ms, Returned 1 row(s)
2016-05-02 16:32:15.072997 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'language' AND hostname = 'liva' <<<< Took 
1ms, Returned 0 row(s)
2016-05-02 16:32:15.074910 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'language' AND hostname IS NULL <<<< Took 
1ms, Returned 1 row(s)
2016-05-02 16:32:15.076934 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'country' AND hostname = 'liva' <<<< Took 
1ms, Returned 0 row(s)
2016-05-02 16:32:15.079291 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'country' AND hostname IS NULL <<<< Took 
1ms, Returned 1 row(s)
2016-05-02 16:32:15.081968 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'country' AND hostname = 'liva' <<<< Took 
1ms, Returned 0 row(s)
2016-05-02 16:32:15.094829 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'country' AND hostname IS NULL <<<< Took 
12ms, Returned 1 row(s)
2016-05-02 16:32:15.098762 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'freqtable' AND hostname = 'liva' <<<< Took 
2ms, Returned 0 row(s)
2016-05-02 16:32:15.100652 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'freqtable' AND hostname IS NULL <<<< Took 
0ms, Returned 1 row(s)

fe2
$ mythfrontend -v database | grep Took | head -10
2016-05-02 16:21:13.763638 I  MSqlQuery::exec(DBManager0) SELECT data 
FROM settings WHERE value = 'backendserverip' AND hostname = 
'kids-linux' <<<< Took 1ms, Returned 1 row(s)
2016-05-02 16:21:13.766008 I  MSqlQuery::exec(DBManager0) SELECT data 
FROM settings WHERE value = 'backendserverip6' AND hostname = 
'kids-linux' <<<< Took 1ms, Returned 1 row(s)
2016-05-02 16:21:13.827770 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'language' AND hostname = 'kids-linux' <<<< 
Took 1ms, Returned 0 row(s)
2016-05-02 16:21:13.830011 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'language' AND hostname IS NULL <<<< Took 
1ms, Returned 1 row(s)
2016-05-02 16:21:13.832262 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'country' AND hostname = 'kids-linux' <<<< 
Took 1ms, Returned 0 row(s)
2016-05-02 16:21:13.834495 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'country' AND hostname IS NULL <<<< Took 
1ms, Returned 1 row(s)
2016-05-02 16:21:13.837981 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'country' AND hostname = 'kids-linux' <<<< 
Took 1ms, Returned 0 row(s)
2016-05-02 16:21:13.839963 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'country' AND hostname IS NULL <<<< Took 
1ms, Returned 1 row(s)
2016-05-02 16:21:13.841960 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'freqtable' AND hostname = 'kids-linux' <<<< 
Took 1ms, Returned 0 row(s)
2016-05-02 16:21:13.843958 I  MSqlQuery::exec(DBManager2) SELECT data 
FROM settings WHERE value = 'freqtable' AND hostname IS NULL <<<< Took 
1ms, Returned 1 row(s)


>
> The database queries should only take 1ms but I had a frontend that 
> was taking 200ms per query. But that one was so slow to start it 
> couldn't even initialise the screen.
>
>
> BTW. After modifying the MySQL config files I presume you have been 
> restarting MySQL
>
> systemctl restart mysql.service
> or
> sudo service mysql restart
As someone who's not confident enough to be sure that I've restarted the 
right thing, or done it correctly, I tend to just reboot whenever I've 
changed something significant. :-)