Mysql
From Chaehyun
(Difference between revisions)
Xlos (Talk | contribs)
(Created page with "* 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/inno...")
Newer edit →
(Created page with "* 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/inno...")
Newer edit →
Revision as of 13:58, 14 June 2011
- 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 시킨다.