redo日志的设置

1.redo 使用量的计算

select * from sys.metrics where variable_name in ('log_lsn_current','log_lsn_last_checkpoint')

used=log_lsn_current-log_lsn_last_checkpoint

used%=used/(innodb_log_file_size*innodb_log_files_in_group)*100%

 

2.每分钟日志产生量

pager grep  sequence

show engine innodb status\G select sleep(60);show engine innodb status\G