Home Sign Up Sign In
› 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
Advertisement
samuel
42.59D
V2EX  ›  MySQL

关于row_lock与性能的疑问

  •   
  •   samuel ·
    samuelduann · Sep 7, 2011 · 6074 views
    This topic created in 5363 days ago, the information mentioned may be changed or developed.
    | Innodb_row_lock_current_waits | 0 |
    | Innodb_row_lock_time | 837095 |
    | Innodb_row_lock_time_avg | 1541 |
    | Innodb_row_lock_time_max | 41545 |
    | Innodb_row_lock_waits | 543 |

    两台mysql配了主从，主是innodb,从是myisam，怀疑它有性能问题（总体并不是特别慢，但是偶尔有一些update操作延迟比较大）

    show GLOBAL STATUS看到上面的信息，请达人们为我解答：

    Innodb_row_lock_time_max是不是决定了最坏情况下的操作延迟？
    Innodb_row_lock_time_avg为1541是不是说明性能已经有问题？
  • row
  • lock
  • innodb
    2 replies  •  1970-01-01 08:00:00 +08:00
    Livid
        1
    Livid  
    MOD
    PRO
       Sep 7, 2011
    MyISAM 不支持 row_lock。
    samuel
        2
    samuel  
    OP
       Sep 7, 2011
    @livid 主还是用的innodb啊
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1404 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 42ms · UTC 17:06 · PVG 01:06 · LAX 10:06 · JFK 13:06
    ♥ Do have faith in what you're doing.