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

mysql-freeze

 mysql-freeze

ichirin2501

March 10, 2018
Tweet

More Decks by ichirin2501

Other Decks in Programming

Transcript

  1. ౰࣌ʹ֬ೝग़དྷͨൣғΛྻڍ • ٸʹࢮ͵ • ࢮʹํ͸freeze, MySQLͷϓϩηε͸ੜ͖ͯΔ • mysqladmin pingͳͲͷԠ౴͸ग़དྷΔ •

    Ұ෦σʔλϕʔε΁ͷΫΤϦ͕ฦͬͯ͜ͳ͍ • TCPͷ઀ଓཱ֬͸ग़དྷΔ, TCP keepalive΋ಈ͍ͯΔ • Τϥʔϩάʹ͸Կ΋৘ใ͸ग़ྗ͞Ε͍ͯͳ͍ 
  2. ௐࠪ • Ҏલௐࠪͨ͠ͱ͖ʹεϧʔ͍߲ͯͨ͠໨͕ؾ ʹͳͬͨ • mysql-5.5.49ͷBugs FixedͷҰ෦ • InnoDB: Running

    REPLACE operations on multiple connections resulted in a hang. (Bug #22530768, Bug #79185) 
  3. bug report • ʮInnodb freeze running REPLACE statementsʯhttps://bugs.mysql.com/ bug.php?id=79185 •

    ಈ࡞؀ڥͱݱ৅͕ࠅࣅ͍ͯͨ͠ɻ
 Ͱ΋ɺREPLACEΫΤϦ͸ࠓճͷfreezeࣄ݅ʹ ͓͍ͯҰ౓΋ൃߦ͞Ε͍ͯͳ͍