あなたの知らない データベースのロギングの世界 / logging queries

builderscon tokyo 2018 の発表資料です。
https://builderscon.io/tokyo/2018/session/87e13506-2f80-4fae-af9c-2421c7dbb460

※発表後に分かったこと、教えていただいたことにより、発表時の資料から若干の変更を加えています

Transcript

1. Ԟଜߊ߂
   
   (.0
   1FQBCP
   *OD
   
   ೔
   CVJMEFSTDPO
    ͋ͳͨͷ஌Βͳ͍
 σʔλϕʔεͷϩΪϯάͷੈք
2. γχΞΤϯδχΞ Ԟଜߊ߂
   
   !IGN ٕज़෦ϓϥοτϑΥʔϜάϧʔϓ
3. !UONU
   ͞ΜͷηογϣϯʹͰٕͨज़తରࡦͷͭ ʢ%#ϩΪϯάʣʹ͍͓ͭͯ࿩͠·͢ IUUQTTQFBLFSEFDLDPNUONUXIFSFEPXFTUBSUXJUIJOGPSNBUJPOTFDVSJUZ
4. wͳͥ؂͕ࠪॏཁ͔
   w؂ࠪϩάʹٻΊΔ৘ใ
   w؂ࠪϩάΛऔΔํ๏
   w1SPYZ42-
   Λհͨ͠ߏ੒
   w1SPYZ42-
   ͷϋϚΓͲ͜Ζ ຊ೔ͷςʔϚ
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   ͔͜͜Β
   .Z42-
   த৺
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   ͜ͷล͔Β
   1SPYZ42-
   ͷ࿩
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
5. ͳͥ؂͕ࠪॏཁ͔
6. wʮΧϥʔϛʔγϣοϓʯʹ͓͚Δ৘ใྲྀग़ʹؔ ͢Δ͝ใࠂͱ͓࿳ͼ
   w IUUQTQEGQFQBCPDPNEPDVNFOUEQEG
   w IUUQTQEGQFQBCPDPNEPDVNFOUEQEG ൃදܦҢ
7. ͳͥ؂͕ࠪॏཁ͔
   ὎ͳʹ͔ى͖͔ͯΒ͡Ό஗͍
8. ௥੻ՄೳੑʢτϨʔαϏϦςΟʣͷ௿Լ
   ݕ஌ͷ೉қ౓্ঢ
   ճ෮ྗʢ෮چɺࣄۀܧଓʣͷ௿Լ ؂ࠪূ੻ͷෆ଍͕ট͘ϦεΫ
9. Πϯγσϯτͷ࣌ܥྻ ೔࣌ ಺༰ 2018/01/07 (೔) 20:04 ݕ஌ 2018/01/07 (೔) 22:28 Ұ࣍ରԠ׬ྃ 2018/01/08 (݄) 01:33 ӨڹൣғҰ෦ൃ֮ 2018/01/10 (ਫ) 13:34 Өڹൣғ௥Ճൃ֮ 2018/01/10 (ਫ) 15:35 ୈࡾऀػؔʹΑΔௐࠪ։࢝ 2018/01/25 (໦) 11:58 ୈࡾऀػؔʹΑΔௐࠪ׬ྃ 2018/01/26 (ۚ) 07:40 ৘ใެ։ Өڹൣғͷ೺Ѳʹ͕͔͔࣌ؒΓɺ৘ใެ։ͷ஗Εʹܨ͕Δ
10. ʮ཈ࢭɾ཈੍ʯ
    ʮ༧๷ɾ๷ࢭʯ
    ʮݕ஌ɾ௥੻ʯ
    ʮճ෮ɾܧଓʯ ৘ใηΩϡϦςΟରࡦͷڧԽ
11. ʮ཈ࢭɾ཈੍ʯ
    ʮ༧๷ɾ๷ࢭʯ
    ʮݕ஌ɾ௥੻ʯˡຊηογϣϯͷςʔϚ
    ʮճ෮ɾܧଓʯ ৘ใηΩϡϦςΟରࡦͷڧԽ
12. wઌͷΠϯγσϯτͰ͸ɺෆਖ਼ϓϩάϥϜʹΑΔ ͷσʔλϕʔε
    .Z42-
    ΞΫηε͕ൃ֮
    wʮ͍ͭɺ୭͕ɺͲ͜ʹɺͲͷΑ͏ͳΫΤϦΛൃ ߦͨ͠ͷ͔ʯΛه࿥͠ɺ࠶ൃ๷ࢭʹ໾ཱͯΔ ؂ࠪϩάͷڧԽ
13. ؂ࠪϩάʹٻΊΔ৘ใ
14. σʔλϕʔε΁ͷΞΫηε৘ใͳͲΛه࿥͠ɺͲ ͷΑ͏ͳૢ࡞͕ߦΘΕͨͷ͔Λɺ͋ͱ͔ΒͰ΋ ֬ೝͰ͖ΔΑ͏ʹอଘͨ͠΋ͷ σʔλϕʔεͷ؂ࠪϩάͱ͸
15. w42-εςʔτϝϯτʢΫΤϦʣ
    wΫϥΠΞϯτ*1
    wΫϥΠΞϯτϢʔβ
    w઀ଓσʔλϕʔε໊
    w઀ଓઌϗετ໊ ؂ࠪϩάʹඞཁͳ৘ใྫ
16. w%#ʹྲྀΕΔ͢΂ͯͷΫΤϦΛه࿥͍ͨ͠
    w࣮ߦ͞ΕΑ͏ͱࣦͨ͠ഊΫΤϦ౳΋ؚ·ΕΔ ؂ࠪϩάʹඞཁͳཁ݅ "VEJU %# DMJFOU %# DMJFOU
17. 
    ؂ࠪϩάΛऔΔํ๏
18. .Z42-
    ͷઃఆ
    wHFOFSBM@MPH
    ϓϥάΠϯ
    wNZTRMBVEJU
    NDBGFF
    w.BSJB%#
    "VEJU
    1MVHJO
    %#ϓϩΩγ
    w1SPYZ42-
    w.BSJB%#
    .BY4DBMF ͍Ζ͍ΖͳΫΤϦϩάͷऔಘํ๏
19. Ұ൪खܰͳํ๏ɻ%#ɺϢʔβɺϗετɺΫΤϦ ϩά͕
    547
    ܗࣜͰه࿥͞Ε͍ͯΔɻ HFOFSBM@MPH 2018-09-07T16:39:50.949045Z 8 Connect root@localhost on using Socket 2018-09-07T16:39:50.949471Z 8 Query select @@version_comment limit 1 2018-09-07T16:40:13.059736Z 8 Query SELECT * FROM test.t 2018-09-07T16:40:13.762332Z 8 Quit
20. w%#
    ΁ͷΞΫηε͕ܹ͘͠ͳΔͱϩάͷॻ͖ࠐ Έෛՙ͕όΧʹͳΒͳ͘ͳͬͯ͘Δ
    wҰݟ͓खܰͳํ๏͕ͩɺσʔλϕʔεͷσΟε Ϋ
    *0
    ʹӨڹΛٴͿ఺ʹ஫ҙ HFOFSBM@MPH
    ӡ༻্ͷݒ೦఺
21. wࣦഊͨ͠ΫΤϦ͕ه࿥͞Εͳ͍
    wෆਖ਼ͳΫΤϦ͸ඞ࣮ͣߦ͞Ε͏Δ͔ʁ
    w؂ࠪϩά͸ɺෆਖ਼ͳΫΤϦ΋ؚΊͯɺ%#
    Ͱ࣮ ߦ͞ΕΑ͏ͱͨ͢͠΂ͯͷΫΤϦΛه࿥͍ͨ͠ ͷͰཁ݅Λຬͨͤͳ͍ HFOFSBM@MPH
    ؂ࠪͱͯ͠ͷܽ఺
22. 1PTUHSF42-
    Ͱ͸
    MPH@TUBUFNFOU
    
    BMM
    ͱ
    MPH@MJOF@QSFpY
    
    bU
    V
    I
    E
    J
    F`
    ͷΑ ͏ʹ͢Ε͹ه࿥Մೳͱͷ͜ͱ ͪΐͬͱԣಓ
    1PTUHSF42- 2018-09-10 01:14:05 UTC  postgres  172.20.0.1  testdb  idle  00000LOG: statement: SHOW server_version 2018-09-10 01:14:08 UTC  postgres  172.20.0.1  testdb  idle  00000LOG: statement: SELECT * FROM information_schema.tables;
23. wIUUQTHJUIVCDPNNDBGFFNZTRMBVEJU
    w.Z42-
    αʔόϓϥάΠϯΛར༻ͨ͠؂ࠪϩά
    wMJCBVEJU@QMVHJOTP
    Λ
    VTSMJC  NZTRM QMVHJO
    ҎԼʹ഑ஔ͢Δͱར༻Ͱ͖Δ NDBGFFNZTRMBVEJU
24. curl -L 'https://bintray.com/mcafee/mysql-audit- plugin/download_file?file_path=audit-plugin- mysql-5.7-1.1.6-784-linux-x86_64.zip' -o audit- plugin-mysql.zip unzip audit-plugin-mysql.zip cp audit-plugin-mysql-5.7-1.1.6-784/lib/ libaudit_plugin.so /usr/lib/mysql/plugin/ NZTRMBVEJU
    ४උ
25. $ bash ./audit-plugin-mysql-5.7-1.1.6-784/utils/ offset-extract.sh /usr/sbin/mysqld //offsets for: /usr/sbin/mysqld (5.7.23) {"5.7.23","f5943a4e0d10ed18befd36bb32aed8bc", 6992, 7040, 4000, 4520, 72, 2704, 96, 0, 32, 104, 136, 7128, 4392, 2800, 2808, 2812, 536, 0, 0, 6360, 6384, 6368}, NZTRMBVEJU
    Φϑηοτͷܭࢉ
26. --- my.cnf +++ /etc/my.cnf @@ -33,3 +33,7 @@ innodb_log_buffer_size=32M innodb_log_file_size=128M innodb_autoextend_increment=64 + +plugin-load=AUDIT=libaudit_plugin.so +audit_offsets=6992, 7040, 4000, 4520, 72, 2704, 96, 0, 32, 104, 136, 7128, 4392, 2800, 2808, 2812, 536, 0, 0, 6360, 6384, 6368 +audit_json_file=on NZTRMBVEJU
    NZDOG
    ͷઃఆ
27. { "msg-type": "activity", "date": "1501591974035", "thread-id": "1", "query-id": "8508", "user": "", "priv_user": "", "ip": "", "host": "", "cmd": "create_db", "query": "CREATE DATABASE IF NOT EXISTS infra" } NZTRMBVEJU
    ϩά΁ͷग़ྗ WBSMJCNZTRMNZTRMBVEJUKTPO
    Θ͔Γ΍͍͢Α͏੔ܗͯ͠·͢
28. wHFOFSBM@MPH
    ಉ༷ɺϩάͷॻ͖ࠐΈෛՙ
    wΦϑηοτͷܭࢉ͕ΊΜͲ͍͘͞ɻP⒎TFU FYUSBDUTI
    ίϚϯυͷ࣮ߦʹ
    HEC
    NETVN
    NZTRME
    ͷσόοά༻
    TZNCPMT
    ͕ཁΔ NDBGFFNZTRMBVEJU
    ͷݒ೦఺
29. wIUUQTNBSJBECDPNLCFONBSJBEC BCPVUUIFNBSJBECBVEJUQMVHJO
    wNZTRMBVEJU
    ͱಉ͡Α͏ʹ
    TFSWFS@BVEJUTP
    Λ
    VTSMJC  NZTRMQMVHJO
    ҎԼʹ഑ஔ͢Δͱ ར༻Ͱ͖Δ .BSJB%#
    "VEJU
    1MVHJO
30. INSTALL PLUGIN server_audit SONAME 'server_audit.so'; SET GLOBAL server_audit_logging = 'ON'; .BSJB%#
    "VEJU
    1MVHJO
    ४උ
31. 20170807 13:56:47,example.com,root,localhost, 151722,0,CONNECT,,,0 20170807 13:56:47,example.com,root,localhost, 151722,73837,QUERY,,'select @@version_comment limit 1',0 20170807 13:56:47,example.com,root,localhost, 151722,73838,QUERY,,'select @@hostname',0 20170807 13:56:47,example.com,root,localhost, 151722,0,DISCONNECT,,,0 .BSJB%#
    "VEJU
    1MVHJO
    ϩά WBSMJCNZTRMTFSWFS@BVEJUMPH
32. wHFOFSBM@MPH
    ಉ༷ɺϩάͷॻ͖ࠐΈෛՙ
    w.Z42-
    ͸ࠓޙαϙʔτ͞ΕΔͷͰ͠ΐ͏͔ ʢܥͷϓϥάΠϯ͸ແ͔ͬͨʣ .BSJB%#
    "VEJU
    1MVHJO
    ͷݒ೦఺
33. )JHIQFSGPSNBODF
    .Z42-
    QSPYZ
    IUUQTQSPYZTRMDPN
    ΫΤϦͷϩΪϯάҎ֎ʹ΋ ΫΤϦΩϟογϡɺϧʔςΟ ϯάɺϑΝΠΞ΢Υʔϧͳ Ͳ৭ʑͱػೳ͕͋Δ 1SPYZ42-
34. .Z42-
    ͱΫϥΠΞϯτͷؒʹઃஔ͠ɺΫΤϦ Λ஥հ͢Δ 1SPYZ42- 1SPYZ42- %# DMJFOU %# DMJFOU
35. 1SPYZ42-
    Λհͨ͠ߏ੒
36. $ cat -A log/queries.log.00000018 mysql:3306M-~M-`sM-YM-^PKu^E^@M-~M-~uM-YM- ^PKu^E^@M-~)JM-^ETaM-^Ly~^Hhello!!1$ 1SPYZ42-
    ͷϩά͸όΠφϦ IFMMP
    ͱ͍͏ΫΤϦΛ౤༷͛ͨࢠ
37. wIUUQTHJUIVCDPNUBLBJTIJqVFOUQMVHJO QSPYZTRMRVFSZMPH
    w 1SPYZ42-
    ͷϩά͸όΠφϦ
38. wຊ౰͸͜ͷ࿩Λ͔ͨͬͨ͠
    w1SPYZ42-
    ͷམͱ݀͠ʹϋϚΓ·ͬͯͨ͘ͲΓ ண͚ͳ͔ͬͨͷͰɺͦͷ࿩Λ͠·͢
    w1SPYZ42-
    ͷϋϚΓͲ͜Ζͱͯ͠঺հ͠·͕͢ɺ ʮΫϥΠΞϯτͱσʔλϕʔεʹதؒ૚ΛڬΉʯ ͱ͍͏ߏ੒ΛऔΔͱ͖ʹؾʹ͓͖͍ͯͨ͠ͱ͜ ΖͰ΋͋Γ·͢ Մ༻ੑΛଛͶͳ͍ΞʔΩςΫνϟ
39. 1SPYZ42-
    Λհͨ͠ߏ੒ ͱʹ͔͘΍ΔΜͩύλʔϯ server A server B server C ProxySQL ProxySQL ProxySQL DB app app app 0.0.0.0:3306 0.0.0.0:3306 0.0.0.0:3306
40. 1SPYZ42-
    Λհͨ͠ߏ੒ Consul watch ProxySQL Cluster Client Client Client ProxySQL ProxySQL ProxySQL DB db-proxy.service.foo.consul (via Consul DNS Interface) ཧ૝ڷ
41. 1SPYZ42-
    ͷϋϚΓͲ͜Ζ ΫϥΠΞϯτͱσʔλϕʔεʹதؒ૚ΛڬΉߏ੒Λ औΔͱ͖ʹؾʹ͓͖͍ͯͨ͠ͱ͜ΖͰ΋͋Γ·͢
42. Ϣʔβ؅ཧ໰୊
43. w 1SPYZ42-
    ͸όοΫΤϯυͷ%#ʹͭͳ͙ΞΧ΢ϯτ৘ใ Λࣗ෼Ͱอ͍࣋ͯ͠Δ
    w %#ͷ
    NZTRMVTFS
    ͱ
    1SPYZ42-
    ͷ
    NBJONZTRM@VTFST
    ͕ζϨΔͱ໘౗ Ϣʔβ؅ཧ໰୊ ProxySQL (main.mysql_users) Client DB Connect as hello (using *668425423DB5…) *DB5193AF9213… con builders *123456788909… hello *668425423DB5… password username Client Client Connect as builders (using *12345678909…) Connect as con (using *12345678909…) ⭕ ⭕ ❌ *DB5193AF9213… con bbuilders *8425423DB519… hello *668425423DB5… password username ⭕ ❌
44. DIBSTFU
    ໰୊
45. w1SPYZ42-
    ͸
    TLJQDIBSBDUFSTFUDMJFOU IBOETIBLF
    Λαϙʔτͯ͠ͳ͍
    w1SPYZ42-
    ͷ
    EFGBVMU
    DIBSTFU
    ͱ͍͏֓೦΋ ՃΘΓɺ.Z42-
    ͷ
    DIBSTFU
    ͱ
    DMJFOU
    ͷ
    DIBSTFU
    ͱࡾ໾ἧ͍౿Έ
    w݁ՌɺVKJT
    ͱ͔͋ΔͱจࣈԽ͚͢Δ DIBSTFU
    ໰୊
46. wͤɺ4&5
    /".&4
    wجຊతʹ͸ΫϥΠΞϯτͰؤுΔ͔͠ͳͦ͞͏
    w1)1
    ͳΒ
    NZTRM J @TFU@DIBSTFU
    ؔ਺Λ࢖͏౳ DIBSTFU
    ໰୊ΛͳΜͱ͔͢Δ
47. .VMUJQMFYJOH
    ໰୊
48. 1SPYZ42-
    ͸ඪ४Ͱ௨৴ͷଟॏԽʢෳ਺ΫϥΠΞϯτ͔Β ͷ઀ଓΛ·ͱΊΔʣػೳΛఏڙ͍ͯ͠Δ 1SPYZ42-
    .VMUJQMFYJOH ProxySQL Application A DB Client Client Client Client multiplexing client backend proxy
49. -"45@*/4&35@*%
    ؔ਺ͷΑ͏ͳʮηογϣϯதͷ࠷ۙͷ
    */4&35
    ݁ՌʯΛݟΔΑ͏ͳ΋ͷͱ૬ੑ͕ѱ͍ 1SPYZ42-
    .VMUJQMFYJOH ProxySQL Application A DB Client Client Client Client multiplexing client backend proxy
50. mysql> SHOW CREATE TABLE t\G ******************** 1. row ******************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci -"45@*/4&35@*%
51. mysql> INSERT INTO t VALUES (NULL, 'hfm'); mysql> SELECT * FROM t; +----+------+ | id | name | +----+------+ | 1 | hfm | +----+------+ mysql> SELECT LAST_INSERT_ID(); +------------------+ | LAST_INSERT_ID() | +------------------+ | 1 | +------------------+ -"45@*/4&35@*%
52. mysql> INSERT INTO t (name) VALUES ('builders'), ('con'), ('yeah!!'); mysql> SELECT * FROM t; +----+----------+ | id | name | +----+----------+ | 1 | hfm | | 2 | builders | | 3 | con | | 4 | yeah!! | +----+----------+ mysql> SELECT LAST_INSERT_ID(); +------------------+ | LAST_INSERT_ID() | +------------------+ | 2 | +------------------+ -"45@*/4&35@*%
53. ੜ੒͞Εͨ
    *%
    ͸ɺ઀ଓ͝ͱʹαʔόʔ಺ʹอ࣋͞Ε·͢ɻ ͭ·Γɺؔ਺ʹΑͬͯࢦఆ͞ΕͨΫϥΠΞϯτʹฦ͞Εͨ஋ ͸ɺͦͷΫϥΠΞϯτʹΑͬͯ
    "650@*/$3&.&/5
    Χϥ ϜʹӨڹΛ༩͑Δ࠷ۙͷεςʔτϝϯτ༻ʹ࠷ॳʹੜ੒͞Ε ͨ
    "650@*/$3&.&/5
    ஋Ͱ͢ɻ͜ͷ஋͸ɺ΄͔ͷΫϥΠ Ξϯτ͕ಠࣗͷ
    "650@*/$3&.&/5
    ஋Λੜ੒ͨ͠৔߹Ͱ ΋ӨڹΛड͚ΔՄೳੑ͸͋Γ·ͤΜɻ͜ͷಈ࡞ʹΑͬͯɺ֤ ΫϥΠΞϯτ͸΄͔ͷΫϥΠΞϯτͷΞΫςΟϏςΟʔΛؾ ʹ͢Δ͜ͱͳ͘ɺϩοΫ΍τϥϯβΫγϣϯΛ࣮ߦ͠ͳ͍Ͱ ಠࣗͷ
    *%
    ΛऔಘͰ͖·͢ɻ -"45@*/4&35@*% IUUQTEFWNZTRMDPNEPDSFGNBOKBJOGPSNBUJPOGVODUJPOTIUNMGVODUJPO@MBTUJOTFSUJE
54. ੜ੒͞Εͨ
    *%
    ͸ɺ઀ଓ͝ͱʹαʔόʔ಺ʹอ࣋͞Ε·͢ɻ ͭ·Γɺؔ਺ʹΑͬͯࢦఆ͞ΕͨΫϥΠΞϯτʹฦ͞Εͨ஋ ͸ɺͦͷΫϥΠΞϯτʹΑͬͯ
    "650@*/$3&.&/5
    Χϥ ϜʹӨڹΛ༩͑Δ࠷ۙͷεςʔτϝϯτ༻ʹ࠷ॳʹੜ੒͞Ε ͨ
    "650@*/$3&.&/5
    ஋Ͱ͢ɻ͜ͷ஋͸ɺ΄͔ͷΫϥΠ Ξϯτ͕ಠࣗͷ
    "650@*/$3&.&/5
    ஋Λੜ੒ͨ͠৔߹Ͱ ΋ӨڹΛड͚ΔՄೳੑ͸͋Γ·ͤΜɻ͜ͷಈ࡞ʹΑͬͯɺ֤ ΫϥΠΞϯτ͸΄͔ͷΫϥΠΞϯτͷΞΫςΟϏςΟʔΛؾ ʹ͢Δ͜ͱͳ͘ɺϩοΫ΍τϥϯβΫγϣϯΛ࣮ߦ͠ͳ͍Ͱ ಠࣗͷ
    *%
    ΛऔಘͰ͖·͢ɻ -"45@*/4&35@*% IUUQTEFWNZTRMDPNEPDSFGNBOKBJOGPSNBUJPOGVODUJPOTIUNMGVODUJPO@MBTUJOTFSUJE
55. 1SPYZ42-
    .VMUJQMFYJOH ProxySQL Client Client Client INSERT INSERT INSERT SELECT LAST_INSERT_ID()
56. 1SPYZ42-
    .VMUJQMFYJOH ProxySQL Client Client Client INSERT INSERT INSERT SELECT LAST_INSERT_ID() ProxySQL DB INSERT INSERT INSERT SELECT LAST_INSERT_ID()
57. 1SPYZ42-
    .VMUJQMFYJOH ProxySQL Client Client Client INSERT INSERT INSERT SELECT LAST_INSERT_ID() ProxySQL DB INSERT INSERT INSERT SELECT LAST_INSERT_ID() ͜ͷ
    */4&35
    Ͳͷ
    $MJFOU
    ग़਎
58. w.VMUJQMFYJOH
    ͷੈքʹ͓͍ͯΫΤϦ͸ࠞ͟Δ
    wಉ࣌ʹଟ਺ͷΞΫηεͰ༰қʹࠞ͟Δ 1SPYZ42-
    .VMUJQMFYJOH
    ͷ൓ল
59. w.VMUJQMFYJOH
    ͷੈքʹ͓͍ͯΫΤϦ͸ࠞ͟Δ
    wಉ࣌ʹଟ਺ͷΞΫηεͰ༰қʹࠞ͟Δ
    w-"45@*/4&35@*%
    ͕ର৅ͱ͸ผςʔϒϧͷ
    *%
    ͱ͔औ͖ͬͯͪΌ͏
    wJE
    Ͱ͋Δ΂͖ͱ͜Ζ͕
    
    ʹ ͳ͍ͬͯͨΈ͍ͨͳใࠂΛ΋Βͬͯٽ͘ 1SPYZ42-
    .VMUJQMFYJOH
    ͷ൓ল
60. wࣾ಺ͷΠϯςάϨʔγϣϯ؀ڥ΍εςʔδϯά ؀ڥͰݕূͨ͠ͱ͖͸ൃݟͰ͖ͳ͔ͬͨ
    wձࣾͷਓ͔͠৮Βͳ͍؀ڥʹ௿ΞΫηεස౓
    w࠶ݱͰ͖ͳ͍ੋඇ΋ͳ͍ -"45@*/4&35@*%
    ໰୊ͷࠔ೉
61. wNZTRMTMBQ
    ͰେྔͷฒྻΞΫηεΛߦͬͨ
    wฒྻ౓Λ্͛ΔͱίωΫγϣϯ͕ࠞ͟Γ࢝Ίͨ
    w.VMUJQMFYJOH
    ػೳΛΦϑʹͨ͠Β࣏ͬͨ
    5IBOLT
    !L-P8 -"45@*/4&35@*%
    ໰୊ͷ࠶ݱ
62. CREATE TABLE a ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(10), updated BOOLEAN DEFAULT false, PRIMARY KEY (id) ); NZTRMTMBQ INSERT INTO mysqlslap.a (name) VALUES ('hello'); SELECT * FROM mysqlslap.a; ... SELECT * FROM mysqlslap.a; UPDATE a SET updated = true WHERE id = (SELECT LAST_INSERT_ID()); create.sql query.sql
63. mysqlslap \ --host=proxysql_url \ --user=user \ --password=******** \ --delimiter=';' \ --create=create.sql \ --query=query.sql \ --concurrency=100 \ --iteration=1 \ --no-drop NZTRMTMBQ
    ͷίϚϯυྫ
64. NZTRMTMBQ
    ͷ
    JUFSBUJPO
    Λ࢖͏ ͱɺ1SPYZ42-
    Ͱ
    l/P
    EBUBCBTF
    TFMFDUFEz
    Τϥʔʹͳͬͯࢮ͵ɻ
    JUFSBUJPO
    ͔͠ಈ͔ͳ͍ JUFSBUJPOͱ1SPYZ42-૬ੑ໰୊
65. ؂ࠪϩάͷ׆༻ํ๏
    ʢࠓޙͷల๬ʣ
66. wେৎ෉ͳΞΫηεͱ໰୊͋ΔΞΫηεͷफ़ผ
    wͭ·Γෆਖ਼ΫΤϦͷϒϩοΩϯά΍௨ใ ؂ࠪϩάͷ׆༻
67. wෆਖ਼ͷఆٛ͸αʔϏε࣍ୈɺܾΊͷ෦෼΋͋Δ
    wྫ͑͹
    8)&3&
    ۟ͷແ͍
    4&-&$5
    
    ΫΤϦ౳
    wͨͩ͠ɺಠࣗఆٛ͢Δʹ͸ਓखʹݶք͕͋Δ ෆਖ਼ΫΤϦͱ͸
68. ෆਖ਼ͳσʔλΞΫηε༧๷ͷݚڀ IUUQTSBOEQFQBCPDPNQBQFSTJPUQSPDFFEJOHLPNFJQEG
69. w ͳʹ͔ى͖͔ͯΒͰ͸஗͍ͷͰϩά͸͔ͬ͠ΓऔΔ
    w ΫϥΠΞϯτͱ%#ͷؒʹ૚ΛڬΉͱมԽ͕େ͖͍
    w ॿ͚ͯ͘Ε
    w ਐḿ͋Ε͹ϒϩάͳͲͰใࠂ͠·͢ ·ͱΊ