Just wanted to reply with an update using landsverka 's update to the part.pl script. I took a percona backup of my (formerly bloated) mysql db and then ran the new version of the script. I can confirm that after about 5 minutes on a RAID10 SSD configuration I now have the proper number of partitions...