Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup --optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?
marklv
9Â months, 2Â weeks agoDhanushka
1Â year agoDhanushka
1Â year agomarklv
7Â months, 4Â weeks ago