mysql 6.0

Submitted by yejr on 周六, 2007/04/28 - 20:50

原文来自： 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

    • 技术相关: