replication and ibdata file size

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

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

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

Thanks all Received on Tue Oct 30 06:43:43 2007