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.

No Comment

No comments yet

Leave a reply