[Maria-discuss] Galera partitioning question

2018-07-29 Thread Ryan Delgrosso
Greetings all, I am running MariaDB 10.2.16 on CentOS in AWS and am seeing a sporadic cluster partitioning and rejoining issue with seemingly no explicable cause. * I have elements in 3 different AWS availability zones in a single galera cluster * Monitoring logs I see this message: /Jul

Re: [Maria-discuss] How does InnoDB delete rows?

2018-07-29 Thread Pavel Ivanov
If your table uses auto-increment field as primary key, then possibility to reuse the space depends on how many rows you delete. When a page in the clustered index contains too few rows, InnoDB will merge it with an adjacent page, and then this space will become available for reuse by a new page in