[mythtv-users] Mythfilldatabase taking FOREVER

[Larry Kennedy]

On Wed, Jun 15, 2022 at 12:01 PM Gary Buhrmaster <gary.buhrmaster at gmail.com>
wrote:

> 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?




> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220618/993965e9/attachment.htm>