[mythtv-users] Mythfilldatabase taking FOREVER

[Larry Kennedy]

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




_______________________________________________
> 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/20220614/832239ec/attachment.htm>