[mythtv-users] MythTV mysql database is MUCH slower after upgrading from Ubuntu 14.04 to 16.04

Will Dormann wdormann at gmail.com
Sat Dec 8 01:40:02 UTC 2018


Hi folks,

While my MythTV system is running fine after upgrading to 16.04, I've
noticed one thing that is performing significantly worse:   Searching
for a TV show via MythWeb.

Prior to upgrading to Ubuntu 16.04 (and the mysql version that comes
with it), searching for a show via the search box in mythweb is about an
order of magnitude slower.   That is, it would take probably 10 seconds
or fewer on 14.04, but the same search appears to take over a minute on
16.04.

In the process of upgrading to 16.04, I had to comment out a few mysql
optimizations (due to deprecated features), but I had no clue that any
such optimization would have such a significant effect on performance.

Is it really a mysql optimization that could cause such a drastic change
in performance?   And if so, is there a way to tell what it might be?
Or is there perhaps something else at play here?


Thanks!
-WD


More information about the mythtv-users mailing list