Re: replication and ibdata file size

One possible explanation (possibly not the only one): if you do a massive update on the master, that transaction would need to create many blocks of versioned data. If you roll that transaction back, those blocks will be freed to be reused, but the datafiles won't shrink.

Since that transaction wasn't commited, it won't be written to the binary log, so it won't be executed and rolled back on the slave (that's only true when all tables involved on a transaction are transaction-safe tables).

-- 
Augusto Bott



On 10/30/07, Thomas Raso  wrote:

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


-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com