SQL used to calculate MySQL log size based on current usage and compare to actual size

Calculate innodb log activity

SELECT variable_value into @start 
from information_schema.global_status 
where variable_name = 'innodb_lsn_current';

SELECT sleep(60); 

SELECT variable_value into @end 
from information_schema.global_status
where variable_name = 'innodb_lsn_current'; 

SELECT ROUND( ((@end-@start)/1024/1024)*60, 2) INTO @calculatedSize 
FROM dual;

SELECT variable_value/1024/1024 INTO @currentSize 
FROM information_schema.global_variables 
WHERE variable_name = 'innodb_log_file_size';

SELECT @currentSize AS CurrentLogSize
, @calculatedSize AS CalcualtedLogSize
, ROUND( ((@calculatedSize - @currentSize)/@CurrentSize) * 100, 2) AS Delta
FROM dual;