Thursday, September 07, 2006

MySQL Partitioning

Bill asked me to look into the new paritioning features with MySQL 5.1. I have to say this has to be one of the best features I've seen added to MySQL in a long time. Check it out:

http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitions.html


Finally the admin has some kick-ass control over how the data is split across files and disks. And it makes pruning old data super-easy.