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

ISUCON大反省会

takashabe
November 26, 2015

 ISUCON大反省会

社内のISUCON大反省会で話した資料です。

takashabe

November 26, 2015
Tweet

More Decks by takashabe

Other Decks in Technology

Transcript

  1. WebΞϓϦέʔγϣϯͷߏ੒ཁૉ • OS • RHELܥ, Debianܥ • ݴޠ • Perl,

    Ruby, PHP, Python, go, Scala, Java, Node.js • ϛυϧ΢ΣΞ • MySQL, PostgreSQL, Redis, Memcached • Nginx, Apache, Varnish • ϋʔυ΢ΣΞ • Mem, HDD, SSD
  2. աڈ໰Λղ͘ • MySQL͔ΒRedisʹࡌͤସ͑ • ΦϯϝϞϦ • Apache͔ΒNginxʹࡌͤସ͑ • ΠϕϯτۦಈͰܰྔ •

    ΫΤϦνϡʔχϯά • indexΛషΔ, index͕࢖ΘΕΔΑ͏ʹҙࣝ • MySQL, Nginxͷύϥϝʔλνϡʔχϯά • ΩϟογϡΛ૿΍͢ • ίʔυ্ͷνϡʔχϯά • ৑௕ͳϧʔϓͷഉআͳͲͳͲ
  3. ISUCON5ͷ༧બ • ࣄલʹ෼͔͍ͬͯͨ͜ͱ • ग़৔νʔϜ270͘Β͍ • Ubuntu • Perl, Ruby,

    PHP, Python, go, Scala, Java, Node.js͕༻ҙ͞ΕΔ༧ఆ • Node.js͸४උ͕ؒʹ߹Θͣμϝͩͬͨ • Πϯϑϥ͸GCP(ϕʔεΠϝʔδ͕༻ҙ͞Ε͍ͯΔͷͰ֤ࣗ༻ҙ)
  4. ϘτϧωοΫͷ௵͠ํ • ݪҼʹΑΔ͕… • N+1ΫΤϦ • ϧʔϓ಺Ͱ౎౓ΫΤϦΛ౤͍͛ͯΔ • joinͳͲͰ1ΫΤϦͰࡁ·ͤΔΑ͏ʹ͢Δ •

    ΫΤϦࣗମ͕ॏ͍ • औಘ͢ΔσʔλΛݮΒ͢ • LIMIT OFFSETͳΫΤϦΛwhereͰߜΓࠐΉͳͲ