I have changed to stored procedures:

but it seems that there is no great improvements on Aurora RDS, in the past when I seen a big improvement was because we was on standard Mysql not Aurora and there the improvement was significant. But now Aurora already optimize a lot the disk access with their own disk infrastructure so there there is almost no difference. I think that the "wait/io/redo_log_flush" is simple attached from "Performance insights" to the latest executed query but that does not mean that the problem is that query, the "problem" is the total stored procedure with high traffic.

so in the end I think it still a good idea to remove the unused values but is beneficial only for standard Mysql and not for Aurora Mysql

Thank you for the update