[mythtv-users] slow mythfilldatabase

[David Newman]

MythTV Version : v31.0-v31.0 on Ubuntu 20 LTS, mysql 8.0.22

Greetings. After upgrading from Ubuntu 18 LTS to 20 LTS,
mythfilldatabase takes 45-60 minutes to run, sometimes more. It
previously took less than three minutes, and the system didn't have this
problem when upgrading from Ubuntu 16 LTS to 18 LTS.

The mythtv project had a page on MySQL tuning:

https://www.mythtv.org/wiki/Tune_MySQL

but it's really about MySQL 5.x and several lines of the suggested
config file need to be commented out for MySQL 8 to start. And...even
with that config, mythfilldatabase still runs slowly.

I'm a functional illiterate in MySQL and don't really know where to
begin with troubleshooting.

Thanks in advance for any clues on getting mythfilldatabase to run
faster again.

dn


# Contents of /etc/mysql/conf.d/mythtv.cnf
# MySQL 8 won't start if any of the commented lines are un-commented

[mysqld]
# Customized config for MythTV baseline

bind-address=0.0.0.0
skip-external-locking
key_buffer_size		= 64M
tmp_table_size		= 32M
# table_cache            	= 256
# query_cache_limit	= 3M ***
# query_cache_size        = 32M ***


# Set Base Innodb Specific settings here
innodb_flush_method		= O_DIRECT
innodb_file_per_table		= 1
# innodb_file_format		= barracuda
innodb_max_dirty_pages_pct 	= 90
innodb_lock_wait_timeout 	= 20
innodb_flush_log_at_trx_commit 	= 2
# innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size 	= 128M
innodb_thread_concurrency 	= 8

# Logging Options
log-queries-not-using-indexes
log_error
long_query_time 	= 5
# log_slow_queries	= /var/log/mysql/mysql-slow.log
general_log_file        = /var/log/mysql/mysql.log
general_log             = 1
log_error               = /var/log/mysql/error.log
binlog_do_db		= include_database_name