[mythtv-users] Mythfilldatabase taking FOREVER

[Gary Buhrmaster]

On Sat, Jun 18, 2022 at 1:20 PM Larry Kennedy <lunchtimelarry at gmail.com> wrote:

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

Tends to support the conclusion that your issues
were database (configuration) related.  The need
for tuning for adequate performance is, as I recall,
one of the reasons that some MythTV elders at
one point proposed embedding the database
into the app and configuring it specifically for
MythTV (only) for default installs.

> Where is the mythweb database config located?

Look inside your web server conf for settings such as:

   db_server "localhost"

the actual location and syntax will vary depending
on your choice of web server.

And, of course, you may need to be sure your
GRANTs are appropriate.