V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member  Sign In
andybest
V2EX  ›  问与答

[Mysql.InnoDB] 你生产环境中innodb_flush_log_at_trx_commit的值是多少?

  •  
  •   andybest · Jul 19, 2013 · 5908 views
    This topic created in 4675 days ago, the information mentioned may be changed or developed.
    因我需要较为频繁的写,如果修改为1会不会极大的降低性能?
    有在生产环境使用默认值1的吗?

    测试方法:
    mysql> SHOW GLOBAL VARIABLES LIKE 'innodb_flush_log%';

    所有回复都会被感谢!感谢 :)
    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1109 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 31ms · UTC 18:01 · PVG 02:01 · LAX 11:01 · JFK 14:01
    ♥ Do have faith in what you're doing.