From: Alex
Date: March 4 2013 6:02am
Subject: Binlog sizing
List-Archive: http://lists.mysql.com/cluster/8501
Message-Id: <1362376948343-4655181.post@n4.nabble.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello,

I am using NDB 7.1.22 and binlog format is mixed.

So I wonder how to calculate the binlog writing speed (Mbytes/s) at a
specific traffic.

Now I have two formula as below,
1) writing speed = row-data-size * throughput * ratio 
     ratio may be 1.2, 1.3, or 1.5
2) writing speed = (row-data-size + binlog-overhead) * throughput

which one is better?
do you know how to calculate RATIO or binlog-overhead?

Thanks

Alex 



--
View this message in context: http://mysql-cluster.1050023.n4.nabble.com/Binlog-sizing-tp4655181.html
Sent from the MySQL - Cluster mailing list archive at Nabble.com.