How to reduce the load on the ssd with daily random dumps?

Question

MySQL

The database is stored on a separate SSD, the size of the database is about 300 GB for 500 tables. New records are added to 60% of tables every day. New tables are created periodically.

There is a general database dump for a date in the past. I want to dump new data once a day. Those. not the entire database, but only the data that was added during the day.
They are easy to select via "where year=2022 and month=3 and day=14".

But I'm worried that with such a dump:

mysqldump -uroot -p123 -q -n -t --skip-comments --compact  --no-autocommit --where="year=2022 and month=3 and day=14" test > c:/dailyDump.sql

the server scans the entire database every time, including tables in which there is no new data and never will be. In addition, new daily data in any table is about 2% of the size of the entire table.
Those. every day an additional -300 GB of resource from the SSD will go away.

Is it possible to somehow programmatically reduce the load on the SSD, with daily dumps?

Answer 1

Well, I don’t care about reading SSD .. let it read
secondly - disks are a consumable. put in a raid, 1 dead - change. if you never know both died - backup)

Answer 2

Break the tables into partitions, for example, by day.

Answer 3

incremental backup