MySQL 5.6: Improvements
Very detailed list of MySQL 5.6 improvements from Peter Zaitsev, CEO of Percona.
A few to name:
- Optimized row based replication
- Replication utilities for failover and admin
- Improved EXPLAIN (e.g. explain for UPDATE/DELETE queries)
- Explicit partition selection in queries (e.g. SELECT * FROM employees PARTITION (p0, p2);)
- Full text search index for Innodb
- Microsecond TIME precision
Although MySQL 5.6 is still development release, I think it is not too long before it becomes GA.