List:Cluster« Previous MessageNext Message »
From:Alex Date:March 1 2013 7:59am
Subject:binlog sizing
View as plain text  
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-tp4655176.html
Sent from the MySQL - Cluster mailing list archive at Nabble.com.
Thread
binlog sizingAlex1 Mar
  • Re: binlog sizingAlex4 Mar