Partitioning and views: fuck you, MySQL.