mysql 6.0

原文来自: http://mysqldba.blogspot.com/2007/04/mysql-60.html

mysql 5.2 is now mysql 6.0:

6.0 is basically the falcon release with subquery optimizer additions.

6.1 Online backup, more subquery optimizations, foreign keys for main engines, and more performance diagnostics.

Online Backup Detail:

  • Cross Engine Support

  • Non-blocking for DML, ie. INSERT UPDATE not blocking

  • Blocking on DDL still

  • SQL command driven

  • Full server database and point in time recovery
  • Nitro Engine:

  • Extreme insertion rates
  • Linear CPU rates

    PBXT

  • In beta
  • Not ACID complient but sort - of
  • Very fast rollbacks
  • Very few config tweaks

    MYSQL Enterprise (Paid use Server)


    • Support, Server, and tools
      • Monitoring Tools:

      • New Replication monitoring

      • New Backup Management

      • Possible problem SQL events monitoring

      • MYSQL Workbench, follow up to dbdesigner

  • 技术相关: