Quote
1) Can one have slightly different indexes on the different partitions?
2) Will it be slower to execute a query which will load data from different partitions and combine them together as opposed to loading data from a single table without partitions?
3) Is MySQL working on adding the Global Index concept to overcome this limitation?
4) Will mysql allow auto incrementing columns in the future which are not forced to be a part of the Primary Key?
1. No. All partitions have the same columns and indexes.
2. Actually, because of partition pruning (
see MySQL Manual), queries on partitioned tables can be significantly
faster than the same queries run on their non-partitioned counterparts. :)
3. I don't know. I haven't heard anything about this, but there's lots I don't hear.
4. I think that, sooner or later, we'll implement sequences or something like them. I have no idea when this might happen, though.
Jon Stephens
MySQL Documentation Team @ Oracle
MySQL Dev Zone
MySQL Server Documentation
Oracle