[mythtv-users] Upgraded to Ubuntu 22.04 / MythTV 32 - MythWeb search now abysmally slow

Stephen Worthington stephen_agent at jsw.gen.nz
Fri Sep 29 11:57:52 UTC 2023

On Fri, 29 Sep 2023 07:48:08 -0400, you wrote:

>On 9/28/23 5:35 PM, Will Dormann wrote:
>> However, one thing that I noticed is that using mythweb to search for 
>> something (using the search box) is abysmally slow.  mysqld has the CPU 
>> pegged, and my web browser has been spinning for about 15 MINUTES and 
>> counting, and it's still going.
>Ok, so after noticing that even just displaying the channel listing page 
>was ridiculously slow, I figured it out.
>After the upgrade, I merely needed to run the optimize_mythdb.pl script 
>again.  I have this on a weekly cron job, so perhaps eventually it would 
>have sorted itself out on its own.
>I'm not exactly sure why upgrading mysql versions (as part of the Ubuntu 
>22.04 upgrade) would have affected anything related to database 
>optimization.  But it's back to normal now!

My guess would be that for some reason some indexes were not created
properly when the upgrade happened - maybe the format of the index
files was changed in the new version?

More information about the mythtv-users mailing list