Your experience seems limited.

https://dev.mysql.com/doc/refman/8.4/en/partitioning-types.h...