Re: [Maria-discuss] gtid_slave_pos row count

[Kristian Nielsen]

"Reinis Rozitis"  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
happens?

> 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.

 - Kristian.

___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

[Maria-discuss] Step-by-Step Tutorial: How to Setup Your Own e-Commerce Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) in Amazon AWS Cloud

[Turritopsis Dohrnii Teo En Ming]

Good morning from Singapore,


You can read my step-by-step tutorial on How to Setup Your Own e-Commerce 
Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) 
in Amazon AWS Cloud at any one of my two redundant blogs. My blogs were 
configured in RAID 1 mirroring array.


https://tdtemcerts.wordpress.com/2018/09/29/step-by-step-tutorial-how-to-setup-your-own-e-commerce-online-store-using-woocommerce-3-4-5-wordpress-4-9-8-and-centos-1805-lamp-in-amazon-aws-cloud/


https://tdtemcerts.blogspot.com/2018/09/step-by-step-tutorial-how-to-setup-your.html


Thanks for reading! If there are any mistakes, please do let me know!





===BEGIN SIGNATURE===

Turritopsis Dohrnii Teo En Ming's Academic Qualifications as at 30 Oct 2017

[1] https://tdtemcerts.wordpress.com/

[2] http://tdtemcerts.blogspot.sg/

[3] 
https://www.scribd.com/user/270125049/Teo-En-Ming

===END SIGNATURE===
___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp

[Maria-discuss] gtid_slave_pos row count

[Reinis Rozitis]

Hi,
before considering this as a bug wanted to ask in mailing list:

I know that gtid_slave_pos table can have multiple entries, but (at least on 
10.3.9 but maybe also earlier (just noticed now)) while running:

slave_parallel_threads = 20
slave_parallel_mode = optimistic

the table starts to grow continuously:

MariaDB [mysql]> select count(*) from gtid_slave_pos;
+--+
| count(*) |
+--+
|  5577268 |
+--+
1 row in set (1.553 sec)


If I switch back to conservative mode it never goes above 2-3 rows even with 
the same 20 threads.

Same happens also with gtid_pos_auto_engines - when in conservative each engine 
table has several records, once I switch to optimistic the gtid tables just 
grow.

Is there something wrong with the purger? 
(something similar like in https://jira.mariadb.org/browse/MDEV-12147  ? )


rr


___
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp