[mythtv-users] Mythfilldatabase taking FOREVER

[Mike Perkins]

On 14/06/2022 23:23, Larry Kennedy wrote:
> On Tue, Jun 14, 2022 at 5:10 PM Bill Meek <keemllib at gmail.com> wrote:
> 
>> On 6/14/22 15:46, Larry Kennedy wrote:
>>
>> ...
>>
>> Are there tons of mariadb-bin.XXXXXX file in /var/lib/mysql?
>>
>> With MySQL (I don't know about your case) the option is turned
>> off like this. Required restarting the SQL server.
>>
>> $ cat /etc/mysql/mysql.conf.d/mythconverg.cnf
>> # Disable Binary logging for the mythconverg database. Binary logging
>> # for all databases was off by default prior to MySQL V8.
>> [mysqld]
>> binlog-ignore-db=mythconverg
>>
>>
>> --
>> Bill
>>
> 
> Bill,
> 
> No bin files.   Here is what I have in /var/lib/mysql that is also relevant
> to another question from Mike:
> 
> total 254080
> -rw-rw----  1 mysql mysql         0 Mar 24  2020 multi-master.info
> drwx------  2 mysql mysql      4096 Jun  9  2021 callerid
> drwx------  2 mysql mysql      4096 Jun 30  2021 billboard
> -rw-r--r--  1 root  root          0 Jun  5 15:54 debian-10.3.flag
> drwx------  2 mysql mysql      4096 Jun  7 21:22 mysql
> drwx------  2 mysql mysql      4096 Jun  7 21:22 performance_schema
> -rw-rw----  1 mysql mysql        16 Jun  7 21:22 mysql_upgrade_info
> -rw-rw----  1 mysql mysql     22452 Jun 13 22:07 ib_buffer_pool
> -rw-rw----  1 mysql mysql        52 Jun 13 22:07 aria_log_control
> -rw-rw----  1 mysql mysql     24576 Jun 13 22:07 aria_log.00000001
> -rw-rw----  1 mysql mysql     24576 Jun 13 22:07 tc.log
> drwxr-xr-x  7 mysql mysql      4096 Jun 13 22:07 .
> -rw-rw----  1 mysql mysql  12582912 Jun 14 08:39 ibtmp1
> drwxr-xr-x 80 root  root       4096 Jun 14 16:45 ..
> -rw-rw----  1 mysql mysql  50331648 Jun 14 17:14 ib_logfile1
> drwx------  2 mysql mysql     16384 Jun 14 17:16 mythconverg
> -rw-rw----  1 mysql mysql 146800640 Jun 14 18:17 ibdata1
> -rw-rw----  1 mysql mysql  50331648 Jun 14 18:17 ib_logfile0
> 
> cat /etc/mysql/conf.d/mythconverg.cnf
> # Disable Binary logging for the mythconverg database. Binary logging
> # for all databases was off by default prior to MySQL V8.
> [mysqld]
> binlog-ignore-db=mythconverg
> 
Um, no. I'm speaking of the /cache/ directories, which would be somewhere under .mythtv or possibly 
.xmltv of the user(s) running mfdb.

-- 

Mike Perkins