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
1Â year, 2Â months agoDhanushka
1Â year, 5Â months agoDhanushka
1Â year, 5Â months agomarklv
1Â year ago