List:Replication« Previous MessageNext Message »
From:Thomas Raso Date:October 30 2007 10:42am
Subject:replication and ibdata file size
View as plain text  
Hi all,

on a replication architecture, with the same server, the same Mysql version
(4.1.21) and the same configuration, the same database.

I have a difference between two ibdata file size

innodb_data_file_path=ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M;ibdata5:2000M;ibdata6:2000M;ibdata7:500M:autoextend

on the master :
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:40 ibdata1
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:39 ibdata2
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:39 ibdata3
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:39 ibdata4
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:39 ibdata5
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:36 ibdata6
-rw-rw----    1 mysql    mysql         22G Oct 30 11:40 ibdata7

on the slave

-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:40 ibdata1
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:40 ibdata2
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:40 ibdata3
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:40 ibdata4
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:40 ibdata5
-rw-rw----    1 mysql    mysql        2.0G Oct 30 11:40 ibdata6
-rw-rw----    1 mysql    mysql         15G Oct 30 11:40 ibdata7

The difference is over 7Go !!!

Is there anybody who has got any explanation about this ???

Thanks all

Thread
replication and ibdata file sizeThomas Raso30 Oct