Fun Stuff Coming in MySQL 6

According to someone who is liveblogging The Future Of MySQL, MySQL 6, which is currently in alpha, will have some interesting new features that I’m pretty excited to see:

  • a non-blocking replacement of mysqldump for all engines – InnoDB isn’t blocking because it’s transactional, but MyISAM tables are blocking
  • a new default, transactional storage engine – replacing InnoDB as the default I assume?
  • foreignKeys will be in all storage engines – handy

Lots of neat stuff.