Hi,
For all who are interested to have any early look at the partitioning features coming out in
5.1 they are now available in the new 5.1 tree that is publically available now.
Most of the syntactical "sugar" that will be in 5.1 is already there, what will mostly change
in the future is
- optimisations, particularly of management commands
- enabling some small things currently not implemented
- possibly one or two small new features that are very much sought for
and bug fixes of course
The more early testers the more useful the feature will become.
Documentation of partitioning is currently ongoing so most of the current documentation one
can find by reading previous posts on this forum, very soon documentation will be part of the
MySQL manual.
For those interested at taking a look at the source code most changes are found in the files:
ha_partition.cc and .h /* A new handler for partitioned tables */
sql_partition.cc /* Lots of support code for partitioned tables */
sql_table.cc /* Some management of partitioning starts out from here */
sql_yacc.yy /* The new syntax for partitioning */
ha_ndbcluster.cc /* A few changes to also enable user-defined partitions for MySQL Cluster */
in mysql-test/t you will find a set of test cases for partitioning that also shows a bit how the syntax
looks like:
partition*.test and ndb_partition*.test
Rgrds Mikael
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com