According to the Percona article MySQL checkpoint age may freeze it: https://www.percona.com/blog/2011/04/04/innodb-flushing-theory-and-solutions/
How can I calculate it? How can I ensure that innodb_log_file_size of 134 mb is enough for me or I need to increase it?
This is the section LOG from SHOW ENGINE INNODB STATUS, but what is the correct formula? ( and how do I get megabytes to compare with innodb_log_file_size )
--- LOG --- Log sequence number 26361002986468 Log buffer assigned up to 26361002986468 Log buffer completed up to 26361002986148 Log written up to 26361002986148 Log flushed up to 26361002902700 Added dirty pages up to 26361002986148 Pages flushed up to 26360959010673 Last checkpoint at 26360958543063 7934296064 log i/o's done, 669.00 log i/o's/second
P.S We are thinking should we increase innodb_capacity_io from default 200 to, lets say, 500 or 1000. ( we have enough iops available )