Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.11
-
None
Description
Hi Team,
We have a MariaDB Replication Setup and on the same we had created a database.
Inside the database we have created a table in which we are performing CRUD Operations.
And we had observed that the table size on Maria DB1 is around 1-2 GB while size on Maria DB2 is around 250-300GB and it keeps on increasing.
We have also found that data-free variable from output of show table status command keeps on increasing.
When we take backup of that table & restore it again then the size gets decreased & then after some time it gets increased.
Please suggest the way forward.
is the table definition identical?
I mean, show create table on both nodes.
Is the data identical? Like, CHECKSUM TABLE, the same?
How did you bootstrap the slave, where did it get the initial table from? Was it an empty slave and everything, including CREATE TABLE was replicated or did you restore it from a backup?