Update Transients Database Optimization to be More Effective
Haven’t been able to confirm how, but the https://wordpress.org/plugins/delete-expired-transients/ plugin sets both Expired and All Transients numbers to zero right after the optimiation runs.
Instead, with WP Rocket, the transients number is higher than zero right after the optimization finished.
Here are some example queires too: https://isabelcastillo.com/function-delete-expired-transients and https://isabelcastillo.com/delete-all-transients-wordpress.
Related ticket: https://secure.helpscout.net/conversation/1610207111/289566/.