maria-discuss team mailing list archive
Mailing list archive
Re: gtid_slave_pos row count
"Reinis Rozitis" <r@xxxxxxx>
Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx>
Sat, 29 Sep 2018 07:42:14 +0200
<firstname.lastname@example.org> (Reinis Rozitis's message of "Sat, 29 Sep 2018 00:38:26 +0300")
Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux)
"Reinis Rozitis" <r@xxxxxxx> writes:
> the table starts to grow continuously:
> MariaDB [mysql]> select count(*) from gtid_slave_pos;
> | count(*) |
> | 5577268 |
> 1 row in set (1.553 sec)
That definitely look bad. As you say, there can be multiple rows in the
table, but it should be the same order of magnitude as
@@slave_parallel_threads, not millions.
Do you have any errors in the error log about failure to delete rows?
Anything else special to your setup that might be causing this?
Can you share the contents of the mysql.gtid_slave_pos table when this
> Is there something wrong with the purger?
> (something similar like in https://jira.mariadb.org/browse/MDEV-12147 ? )
That bug is rather different - the row count in the table is not growing,
but number of unpurged rows is.