[mythtv-users] Mythfilldatabase taking FOREVER

Stephen Worthington stephen_agent at jsw.gen.nz
Sat Jun 18 16:02:52 UTC 2022

On Sat, 18 Jun 2022 09:18:48 -0400, you wrote:

>On Wed, Jun 15, 2022 at 12:01 PM Gary Buhrmaster <gary.buhrmaster at gmail.com>
>> On Tue, Jun 14, 2022 at 8:44 PM Larry Kennedy <lunchtimelarry at gmail.com>
>> wrote:
>> >
>> >
>> >
>> > On Mon, Jun 13, 2022 at 10:35 PM Gary Buhrmaster <
>> gary.buhrmaster at gmail.com> wrote:
>> >>
>> >> On Tue, Jun 14, 2022 at 1:52 AM Larry Kennedy <lunchtimelarry at gmail.com>
>> wrote:
>> >>
>> >> > On second look, queries are slow too.  Select from Person can take
>> upwards of 400ms:
>> >>
>> >> When was the last time you performed a key distribution
>> >> analysis and stored the statistics for use by the query
>> >> optimizer?
>> >
>> >
>> > Gary, I've got the optimize_mythdb script set up to run periodically.
>> So, it ran very recently.
>> >
>> Then something else very basic is wrong with your
>> database setup, as a select from people using a
>> where person should be (essentially) instantaneous.
>> After performing the recommendations that the
>> mysqltuner script suggests, and if a select from
>> people is still slow, run an explain on that select
>> to see what the query plan is (and, perhaps, turn
>> on slow query logging for your db server).
>It was becoming apparent that nothing I tweaked was changing the result, so
>I decided to stand up a new database to see.  Since I have a docker
>platform at hand, I installed a mariadb container and loaded the
>mythconverg database dump into that new database.  Now, MFDB runs quickly!
>It took 30 minutes the first time since it was behind a couple of days (I
>assume that's why), and subsequent runs are just a few minutes.  Woo Hoo!
>While I decide whether to leave the database on this new remote (container)
>host, or delete/reinstall mariadb and move it back to the same host as the
>backend, I changed the config.xml to reference the new database host.
>Mythtv itself is able to find the database, but mythweb cannot.  I've
>looked all around and I can't find the setting that tells mythweb to look
>for the database on the new host. I checked the /etc/apache2 settings, as
>well as /var/www/html/mythweb, found what looks like the right settings,
>but nothing is working.
>Where is the mythweb database config located?

I have never tried to use mythweb with a different database server,
but I think the database stuff is a function of php, rather than
apache2 itself.  So somewhere like /etc/php/7.4/php.ini might be the
right place.

More information about the mythtv-users mailing list