SEARCH
TOOLBOX
LANGUAGES
Mysql

Mysql

From Chaehyun

Revision as of 13:58, 14 June 2011 by Xlos (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
  • mysql innodb status
    • History list length 1616091 ??

innoDB perge 관련

  • my.cnf
  • innodb_max_purge_lag = 8192
    • http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html
    • purge 작업이 지체되었을 때, 얼마나 기다릴 것인지 조절하는 설정
    • 기본은 0임. (delay 없음)
    • 값이 있을 때는, ((purge_lag/innodb_max_purge_lag)×10)–5 milliseconds 만큼, insert, update, delete 작업을 delay 시킨다.
Retrieved from "http://chaehyun.kr/w/Mysql"