MySQL 5.5 Community Server
MySQL 5.6 Community Server
Percona Configuration Wizard
XtraBackup 搭建主从复制
Great Sites on MySQL
Percona
MySQL Performance Blog
Severalnines
推荐管理工具
Sequel Pro
phpMyAdmin
推荐书目
MySQL Cookbook
MySQL 相关项目
MariaDB
Drizzle
参考文档
http://mysql-python.sourceforge.net/MySQLdb.html
tabris17
V2EX  ›  MySQL

Innodb 的 MVCC 已经解决了幻影行问题,为啥 Innodb 的事物默认隔离级别还是“Repeatable reads”?

  •  
  •   tabris17 · Mar 16, 2015 · 3171 views
    This topic created in 4075 days ago, the information mentioned may be changed or developed.
    rt
    Serializable 和 Repeatable reads 的本质区别并非是幻影行的问题吧
    3 replies    2015-03-17 10:12:48 +08:00
    doushini
        1
    doushini  
       Mar 16, 2015 via Android
    之前 可重复读是存在幻影行问题
    tabris17
        2
    tabris17  
    OP
       Mar 17, 2015
    @doushini 哪个之前?5.1之前?
    doushini
        3
    doushini  
       Mar 17, 2015
    @tabris17 Innodb 没出来之前是不行的,innnodb持续非锁定读才解决这个问题
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   5644 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 29ms · UTC 03:39 · PVG 11:39 · LAX 20:39 · JFK 23:39
    ♥ Do have faith in what you're doing.