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.