My name is Mikael Ronstrom and I work for Oracle as
Senior MySQL Architect. I am a member of the LDS
church.
The statements and opinions expressed on this blog are my own and do not necessarily represent those of Oracle Corporation

Tuesday, October 07, 2008

Further development on new partitioning feature

I've been busy with many other things but now I've taken thiswork a step forward and will most likely set-up a preview treeof this feature in a short time.

The new feature adds the possibility to perform partitioningon any type of column also for range and list partitioning(has been possible for KEY partitioning all the time). It alsoadds a new function to the MySQL Server and this function isalso a monotonic function which means it gets a nice treatmentof the partition pruning. This new function is TO_SECONDS whichworks very similarly to TO_DAYS.