Upgrade to Pro — share decks privately, control downloads, hide ads and more …

2012-04-19-mysql-casual-vol3.pdf

Akira Maeda
April 19, 2012
8.5k

 2012-04-19-mysql-casual-vol3.pdf

Akira Maeda

April 19, 2012
Tweet

Transcript

  1. ࣗݾ঺հ • @glidenote(άϥΠυϊʔτ) • લా ষ / Akira Maeda •

    paperboy&co. ͷΠϯϑϥΤϯδχΞ • http://blog.glidenote.com/ • ࣾ಺ҰͷλʔϛφϧڰɻԿͰ΋CUIɻ • MySQLͷϨϕϧ˒ˑˑˑˑˑˑˑˑˑ • ϖύϘMySQL࢛ఱԦͷதͰ࠷ऑ 12೥4݄19೔໦༵೔
  2. ઃఆϑΝΠϧlogmon.confͷॻ͖ํ :/var/lib/mysql/err.log ←؂ࢹର৅ͷϩά (Error_code: 1100) ←؂ࢹର৅ͷจࣈྻ mk-slave-restart -uhoge --error-numbers 1100

    --verbose - pxxxx >> /var/lib/mysql/skip_query.log ←จࣈྻΛൃݟͨ͠ͱ͖࣮ߦ ͢ΔίϚϯυ 3ߦ͕جຊηοτ ࠓճͷઃఆྫ :؂ࢹର৅ͷϩά (؂ࢹର৅ͷจࣈྻ) จࣈྻΛൃݟͨ͠ͱ͖࣮ߦ͢ΔίϚϯυ(࣮ߦίϚϯυߦ͸ෳ਺ߦՄ) 12೥4݄19೔໦༵೔