to get an overview of the Redo Log's usage and see where we are in relation to the soft and hard redo log logical capacity: select select concat concat( (variable_value variable_value, , " (" " (", , format_bytes format_bytes( (variable_value variable_value) ), ,")" ")") ) innodb_redo_log_logical_size innodb_redo_log_logical_size, , concat concat( (round round( (count count* *8 8/ /7 7) ), , " (" " (", , format_bytes format_bytes( (round round( (count count* *8 8/ /7 7) )) ), , ")" ")") ) soft_logical_capacity soft_logical_capacity, , concat concat( (round round( (@ @@innodb_redo_log_capacity @innodb_redo_log_capacity* *29.8 29.8/ /32 32) ), , " (" " (", , format_bytes format_bytes( (round round( (@ @@innodb_redo_log_capacity @innodb_redo_log_capacity* *29.8 29.8/ /32 32) )) ) , ,")" ")") ) hard_logical_capacity hard_logical_capacity, , concat concat( (@ @@innodb_redo_log_capacity @innodb_redo_log_capacity, , " (" " (", , format_bytes format_bytes( (@ @@innodb_redo_log_capacity @innodb_redo_log_capacity) ) , ,")" ")") ) redo_log_capacity redo_log_capacity, , concat concat( (round round( (variable_value variable_value / / ( (count count* *8 8/ /7 7) )* *100 100, ,2 2) ), , "%" "%") ) logical_used logical_used, , concat concat( (round round( (variable_value variable_value / / ( (@ @@innodb_redo_log_capacity @innodb_redo_log_capacity* *29.8 29.8/ /32 32) )* *100 100, ,2 2) ), , "%" "%") ) hard_used hard_used from from performance_schema performance_schema. .global_status global_status join join information_schema information_schema. .innodb_metrics innodb_metrics where where variable_name variable_name like like 'innodb_redo_log_logical_size' 'innodb_redo_log_logical_size' and and name name like like 'log_max_modi ed_age_async' 'log_max_modi ed_age_async'; ; Copyright @ 2023 Oracle and/or its affiliates. + +------------------------------+-----------------------+-----------------------+------------------------+--------------+-----------+ ------------------------------+-----------------------+-----------------------+------------------------+--------------+-----------+ | | innodb_redo_log_logical_size innodb_redo_log_logical_size | | soft_logical_capacity soft_logical_capacity | | hard_logical_capacity hard_logical_capacity | | redo_log_capacity redo_log_capacity | | logical_used logical_used | | hard_used hard_used | | + +------------------------------+-----------------------+-----------------------+------------------------+--------------+-----------+ ------------------------------+-----------------------+-----------------------+------------------------+--------------+-----------+ | | 13108224 13108224 ( (12.50 12.50 MiB MiB) ) | | 92892599 92892599 ( (88.59 88.59 MiB MiB) ) | | 97648640 97648640 ( (93.12 93.12 MiB MiB) ) | | 104857600 104857600 ( (100.00 100.00 MiB MiB) ) | | 14.11 14.11% % | | 13.42 13.42% % | | + +------------------------------+-----------------------+-----------------------+------------------------+--------------+-----------+ ------------------------------+-----------------------+-----------------------+------------------------+--------------+-----------+ 1 1 row row in in set set ( (0.0008 0.0008 sec sec) ) 37