mysql redo查看_mysql redo

查看redo使用情况：

1.show engine innodb

2.select name,count from information_schema.innodb_metrics where name in('log_lsn_current','log_lsn_last_checkpoint);

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

used log=log_lsn_current-log_lsn_last_checkpoint

used%=(used log/total log)*100%

total=innodb_log_file_size*innodb_log_files_in_group

计算每分钟产生的redo

pager grep sequence

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

select (X-Y)/1024/1024 as permin_redo;