Slide 1
Slide 1 text
"QBDIF%SJMMͰ
ͷճΓͷϩάΛूܭͯ͠ΈΔ
-FU`TUSZUPBHHSFHBUF
JOEJWJEVBMMPHTVTJOH"QBDIF%SJMM
5PLZP"QBDIF%SJMM.FFUVQ
!BDJEMFNPO
Slide 2
Slide 2 text
"CPVU.F
w 1SPHSBNNJOH(PMBOH
1FSM
$
w %#%8).Z42-3FETIJGU
w "QBDIF%SJMMIJTUPSZXFFLT
!BDJEMFNPO
.BTBUPTIJ,BXB[PF
4PGUXBSF&OHJOFFS
BU,":"$*OD
Slide 3
Slide 3 text
"QBDIF%SJMM
w 4DIFNBGSFF42-&OHJOF NPEF
w %JTUSJCVUJPO.PEF
XJUI)BEPPQ
/P42-
$MPVE4UPSBHF
w &NCFEEFE.PEF
XJUI-PDBMpMF +40/
$47
547
147
5SZUIJTUPEBZ
Slide 4
Slide 4 text
8IZ%SJMM
.Z3FBTPO
w 8IFO*OFFEUPJNQSPWFXFCBQQ
QFSGPSNBODFʜ
w *XBOUUPBHHSFHBUFSFTQPOTFUJNF
QFSFOEQPJOUʜ
w %SJMMDPVMESVORVFSZUP+40/
ZFBI
Slide 5
Slide 5 text
2VJDL4UBSU
w 4FF0GpDJBM5VUPSJBM%PDVNFOU
l%SJMMJONJOVUFTz
IUUQTESJMMBQBDIFPSHEPDTESJMMJONJOVUFT
w PS%FWFMPQFST*0#MPH&OUSZBCPVU
"QBDIF%SJMM*NQSFTTJPO
IUUQEFWDMBTTNFUIPEKQDMPVEBXTBQBDIFESJMMpSTUJNQSFTTJPO
w 'PS.BD6TFSVTF)PNFCSFX
SFRVJSFT+%,PSMBUFS
$ brew install apache-drill
Slide 6
Slide 6 text
$POWFSUOHJOYMPH
w 8FVTFl-547zGPSNBUGPSOHJOYMPH
w -547-BCFMFE5BCTFQBSBUFE7BMVFT
IUUQMUTWPSH
w "QBDIF%SJMMEPFTOPUTVQQPSU-547ZFU
TP
DPOWFSUMPHGSPN-547UP+40/
w VTFMUTWJFXDPNNBOE WJBSVCZHFNT
host:217.235.96.155 time:2015-09-14T00:00:00+09:00 method:POST
uri:/api/hunting/challenge protocol:HTTP/1.1 status:200 size:
5790 request_time:0.383 upstream_response_time:0.438 referer:-
user_agent:MyApp/11000 CFNetwork/711.3.18 Darwin/14.0.0 user_id:
76005617 geo:JP
Slide 7
Slide 7 text
%FNP
.MJOFT
.#+40/
Slide 8
Slide 8 text
$VU2VFSZ4USJOH
w (SPVQCZVSJ
CVUVSJDPOUBJOT2VFSZ4USJOHʜ
w 4PMVUJPO
3&(&91@3&1-"$& VSJ
`a
BTQBUI
+------------------------------------------------------------------------------------------------------------+----------+
| uri | maxtime |
+------------------------------------------------------------------------------------------------------------+----------+
| /api/costume/hunting_item/equip | 9.695 |
| /api/hunting/families?hunting_id=4000222&session=XXXXXXXXe937077b8cbc06ad3aec80fe&client_data_version=1329 | 9.273 |
| /api/mypage?os_type=1&platform_type=1&session=XXXXXXXX7968eb69dd20d2bb1aec3943&client_data_version=1329 | 8.316 |
| /api/mypage?os_type=2&platform_type=2&session=XXXXXXXXb63727f12bd2724ab9725885&client_data_version=1329 | 8.279 |
| /api/hunting/families?hunting_id=4026012&session=XXXXXXXX2dc4a6668288c5f4a675f071&client_data_version=1330 | 7.926 |
| /api/hunting/families?hunting_id=4025518&session=XXXXXXXX04634d3293a8c2317454b6a3&client_data_version=1329 | 7.896 |
Slide 9
Slide 9 text
1BSTFUJNFTUSJOH
w UJNF5
w KVTUBTUSJOH
OPUUJNFTUBNQʜ
where `time` > ‘2015-09-14 07:00:00’
EPFTOPUXPSLBTFYQFDUFEʜ
w 4PMVUJPO
50@5*.&45".1 AUJNFA
`ZZZZ..EE5))NNTT;
"4BDDFTT@UJNF
Slide 10
Slide 10 text
%FNP
(3061#:
QFSDFOUJMFBOBMZTJT
Slide 11
Slide 11 text
$PODMVTJPO
w "QBDIF%SJMMJTSFBTPOBCMZGBTU
w 5FNQPSBSZUBCMFJTVTFGVMGPSMPOH
RVFSZ
w $"45JTJNQPSUBOUUPSVORVFSZ
w 4UJMMMJUUMFIBSEUPVTFZFU
SFBE
EPDVNFOUDBSFGVMMZ
Slide 12
Slide 12 text
5IBOLZPV