DBIx::Latency Kansai.pm #15

Introduce my work about latency checker.

Transcript

1. %#*Y
   
   -BUFODZ
   ,BOTBJQN
    JE
   Z@VVLJ
   
   !Z@VVLJ@
2. 1FSM 8FC4FSWJDF
   
   2JJUB 33%5PPM
   
   3BXJTI 1MBDL
   
   .JEEMFXBSF
   
   (JU4UBUVT $1"/ɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹ 7JN
   1MVHJOɹɹɹɹɹɹɹɹɹɹɹɹɹɹɹ ɹ VOJUFQFSMNPEVMF QFSMMPDBMMJCQBUI
3. %#*ͱ03.
   ͷ࿩ %#*Y$MBTT
   %#*Y-JUF
   %#*Y4LJOOZ
   5FOH
   
4. 03.
   ࢖͏ͱ஗͍ ಺෦ͰCMFTT͢Δ͔Β஗͍ 42-Ϩϕϧͷνϡʔχϯά೉͍͠ FUD
5. ͲΕ͘Β͍஗͍ ࣮ߦ࣌ؒ͸Կඵ
6. ࣗ෼ͷ؀ڥʹ͓͚Δ ࣮ߦ͕࣌ؒ஌Γ͍ͨ ‣
   %#*ͱ03.पΓͷ਺஋ײ֮Λཆ͏ ‣
   ࣮ߦ࣌ؒͱ͍͏ࢦඪ͸ɼଞͷཁૉͱൺֱ ͠΍͍͢
   ϨεϙϯελΠϜͳͲʣ ‣
   ࣗ෼ͷ؀ڥͰखૣ͘ϕϯνϚʔΫ͕ͱΕ Δͱ͏Ε͍͠
7. %#*Y
   
   -BUFODZ +VTU
   *EFB
8. %#*Y
   
   -BUFODZ ‣
   %#*·ͨ͸֤छ03.͔Βඪ४తͳσʔληοτʹର͠ ͯඪ४తͳ42-Λ౤͛ͨͱ͖ͷϕϯνϚʔΫΛ࣮ߦ ‣
   ͍Ζ͍Ζͳύλʔϯʹରͯ͠σʔληοταΠζΛม Խͤͨ͞ͱ͖ͷ࣮ߦ࣌ؒ ‣
   %#*Y-BUFODZ1MVHJO5FOH
   ͷΑ͏ͳϓϥάΠϯͷ ࢓૊ΈʹΑΓɼରԠ͢Δ03.Λ؆୯ʹ૿΍ͤΔ
9. *OUFSGBDF 1000 rows Teng search return itr 1.1210442 ms 1000 rows Teng search return array 10.8468533 ms 1000 rows Teng search suppress_row_objects 4.2021275 ms 1000 rows Teng search_named return itr 1.3949871 ms 1000 rows Teng search_named return array 10.7347965 ms 1000 rows Teng search_named suppress_row_objects 4.8708916 ms 10000 rows Teng search return itr 8.9581013 ms 10000 rows Teng search return array 111.0289097 ms 10000 rows Teng search suppress_row_objects 44.4309711 ms ECJYMBUFODZQM
   XJUI NZTRMzECJNZTRMMBUFODZIPTUOBNFMPDBMIPTUz
   UFOH
10. *OTJEF ‣
    VTFS
    UBCMF ‣
    CFODINBSL
    DPEF $3&"5&
    5"#-&
    *'
    /05
    &9*454
    VTFS
    
    
    JE
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    */5
    6/4*(/&%
    /05
    /6--
    "650@*/$3&.&/5
    
    OBNF
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    7"3$)"3 
    /05
    /6--
    %&'"6-5
    
    
    VSM
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    7"3$)"3 
    /05
    /6--
    %&'"6-5
    
    
    QSPpMF@JNBHF@VSM
    7"3$)"3 
    /05
    /6--
    %&'"6-5
    
    
    EFTDSJQUJPO
    
    
    
    
    
    
    
    
    7"3$)"3 
    /05
    /6--
    %&'"6-5
    
    
    13*."3:
    ,&:
    JE
    
    6/*26&
    OBNF
    &/(*/&*OOP%#
    %&'"6-5
    $)"34&5VUG
    
    
    GPS
    NZ
    OVN
    RX 
    
    
    
    
    \
    
    
    
    
    
    
    
    ECJOTFSU@UFTUTFU OVN 
    
    
    
    
    
    
    
    ECDBDIF@UFTUTFU
    
    
    
    
    
    
    
    \
    
    
    
    
    
    
    
    
    
    
    
    TFU@UJNFS
    
    
    
    
    
    
    
    
    
    
    
    NZ
    !SPXT
    
    UFOHTFBSDI VTFS 
    
    
    
    
    
    
    
    
    
    
    
    QSJOUG
    E
    SPXT
    5FOH
    TFBSDI
    SFUVSO
    BSSBZ
    G
    NTaO
    OVN
    HFU@UJNFS
    
    
    
    
    
    
    
    ^
    
    
    
    
    
    
    
    ECDMFBOVQ@UBCMFT
    
    
    ^
11. %#*
    ͱ
    5FOH
    ͷൺֱ          -BUFODZ
    NT UIF
    OVNCFS
    PG
    SPXT %#*
    GFUDIBMM@IBTISFG %#*
    GFUDIBMM@BSSBZSFG %#*
    GFUDIBMM@BSSBZSFG \^ 5FOH
    TFBSDI 5FOH
    TFBSDI@OBNFE 5FOH
    TFBSDI
    < SBX> 5FOH
    TFBSDI@OBNFE
    < SBX> 4&-&$5
    
    '30.
    VTFS DBI Teng
12. ‣
    3PXΫϥεͰϥοϓ͢Δͱɼϥοϓ͠ͳ͍΋ͷͱൺ΂ ͯഒҎ্஗͍ ‣
    3PXΫϥεͰϥοϓ͠ͳ͚Ε͹ɼ%#*ͱ͞΄Ͳ͔ΘΒ ͳ͍ %JTDVTTJPO          -BUFODZ
    NT UIF
    OVNCFS
    PG
    SPXT
13. 'VUVSF
    8PSL ‣
    ࣮ߦ࣌ؒҎ֎ͷࢦඪͱͯ͠ϝϞϦ࢖༻ྔ͕͋ΔͱΑ͍ ‣
    ϓϥάΠϯΛ%4-ͬΆ͘ॻ͖͍ͨ ‣
    ΋ͬͱΑ໊͍લۭؒ
14. IUUQTHJUIVCDPNZVVLJ%#*Y-BUFODZ 5IBOLT