vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/twopc-output/insertsharded-output.txt (about) 1 ---------------------------------------------------------------------- 2 insert into user (id, name) values(1, 'alice') 3 4 1 ks_sharded/40-80: begin 5 1 ks_sharded/40-80: insert into name_user_map(name, user_id) values ('alice', 1) /* vtgate:: keyspace_id:475e26c086f437f36bd72ecd883504a7 */ 6 2 ks_sharded/-40: begin 7 2 ks_sharded/-40: insert into user(id, name) values (1, 'alice') /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 8 3 ks_sharded/40-80: begin 9 3 ks_sharded/40-80: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392387046738470', 1, 1515392387090538997) 10 3 ks_sharded/40-80: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:40-80:1515392387046738470', 1, 'ks_sharded', '-40') 11 3 ks_sharded/40-80: commit 12 4 ks_sharded/-40: begin 13 4 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:40-80:1515392387046738470', 1, 1515392387101086738) 14 4 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:40-80:1515392387046738470', 1, 'insert into user(id, name) values (1, \'alice\') /* vtgate:: keyspace_id:166b40b44aba4bd6 */') 15 4 ks_sharded/-40: commit 16 5 ks_sharded/40-80: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:40-80:1515392387046738470' and state = 1 17 5 ks_sharded/40-80: commit 18 6 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:40-80:1515392387046738470' 19 6 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:40-80:1515392387046738470' 20 6 ks_sharded/-40: commit 21 7 ks_sharded/40-80: begin 22 7 ks_sharded/40-80: delete from `_vt`.dt_state where dtid = 'ks_sharded:40-80:1515392387046738470' 23 7 ks_sharded/40-80: delete from `_vt`.dt_participant where dtid = 'ks_sharded:40-80:1515392387046738470' 24 7 ks_sharded/40-80: commit 25 26 ---------------------------------------------------------------------- 27 insert into user (id, name) values(2, 'bob') 28 29 1 ks_sharded/c0-: begin 30 1 ks_sharded/c0-: insert into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */ 31 2 ks_sharded/-40: begin 32 2 ks_sharded/-40: insert into user(id, name) values (2, 'bob') /* vtgate:: keyspace_id:06e7ea22ce92708f */ 33 3 ks_sharded/c0-: begin 34 3 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859424', 1, 1515392387171740872) 35 3 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859424', 1, 'ks_sharded', '-40') 36 3 ks_sharded/c0-: commit 37 4 ks_sharded/-40: begin 38 4 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859424', 1, 1515392387182475610) 39 4 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859424', 1, 'insert into user(id, name) values (2, \'bob\') /* vtgate:: keyspace_id:06e7ea22ce92708f */') 40 4 ks_sharded/-40: commit 41 5 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859424' and state = 1 42 5 ks_sharded/c0-: commit 43 6 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859424' 44 6 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859424' 45 6 ks_sharded/-40: commit 46 7 ks_sharded/c0-: begin 47 7 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859424' 48 7 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859424' 49 7 ks_sharded/c0-: commit 50 51 ---------------------------------------------------------------------- 52 insert ignore into user (id, name) values(2, 'bob') 53 54 1 ks_sharded/c0-: begin 55 1 ks_sharded/c0-: insert ignore into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */ 56 2 ks_sharded/c0-: select name from name_user_map where name = 'bob' and user_id = 2 limit 10001 57 3 ks_sharded/-40: begin 58 3 ks_sharded/-40: insert ignore into user(id, name) values (2, 'bob') /* vtgate:: keyspace_id:06e7ea22ce92708f */ 59 4 ks_sharded/c0-: begin 60 4 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859427', 1, 1515392387263209422) 61 4 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859427', 1, 'ks_sharded', '-40') 62 4 ks_sharded/c0-: commit 63 5 ks_sharded/-40: begin 64 5 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859427', 1, 1515392387274980027) 65 5 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859427', 1, 'insert ignore into user(id, name) values (2, \'bob\') /* vtgate:: keyspace_id:06e7ea22ce92708f */') 66 5 ks_sharded/-40: commit 67 6 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859427' and state = 1 68 6 ks_sharded/c0-: commit 69 7 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859427' 70 7 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859427' 71 7 ks_sharded/-40: commit 72 8 ks_sharded/c0-: begin 73 8 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859427' 74 8 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859427' 75 8 ks_sharded/c0-: commit 76 77 ---------------------------------------------------------------------- 78 insert ignore into user (id, name, nickname) values(2, 'bob', 'bob') 79 80 1 ks_sharded/c0-: begin 81 1 ks_sharded/c0-: insert ignore into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */ 82 2 ks_sharded/c0-: select name from name_user_map where name = 'bob' and user_id = 2 limit 10001 83 3 ks_sharded/-40: begin 84 3 ks_sharded/-40: insert ignore into user(id, name, nickname) values (2, 'bob', 'bob') /* vtgate:: keyspace_id:06e7ea22ce92708f */ 85 4 ks_sharded/c0-: begin 86 4 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859430', 1, 1515392387360777113) 87 4 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859430', 1, 'ks_sharded', '-40') 88 4 ks_sharded/c0-: commit 89 5 ks_sharded/-40: begin 90 5 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859430', 1, 1515392387372890757) 91 5 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859430', 1, 'insert ignore into user(id, name, nickname) values (2, \'bob\', \'bob\') /* vtgate:: keyspace_id:06e7ea22ce92708f */') 92 5 ks_sharded/-40: commit 93 6 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859430' and state = 1 94 6 ks_sharded/c0-: commit 95 7 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859430' 96 7 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859430' 97 7 ks_sharded/-40: commit 98 8 ks_sharded/c0-: begin 99 8 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859430' 100 8 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859430' 101 8 ks_sharded/c0-: commit 102 103 ---------------------------------------------------------------------- 104 insert into user (id, name, nickname) values(2, 'bob', 'bobby') on duplicate key update nickname='bobby' 105 106 1 ks_sharded/c0-: begin 107 1 ks_sharded/c0-: insert ignore into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */ 108 2 ks_sharded/c0-: select name from name_user_map where name = 'bob' and user_id = 2 limit 10001 109 3 ks_sharded/-40: begin 110 3 ks_sharded/-40: insert into user(id, name, nickname) values (2, 'bob', 'bobby') on duplicate key update nickname = 'bobby' /* vtgate:: keyspace_id:06e7ea22ce92708f */ 111 4 ks_sharded/c0-: begin 112 4 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859433', 1, 1515392387454561857) 113 4 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859433', 1, 'ks_sharded', '-40') 114 4 ks_sharded/c0-: commit 115 5 ks_sharded/-40: begin 116 5 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859433', 1, 1515392387467658995) 117 5 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859433', 1, 'insert into user(id, name, nickname) values (2, \'bob\', \'bobby\') on duplicate key update nickname = \'bobby\' /* vtgate:: keyspace_id:06e7ea22ce92708f */') 118 5 ks_sharded/-40: commit 119 6 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859433' and state = 1 120 6 ks_sharded/c0-: commit 121 7 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859433' 122 7 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859433' 123 7 ks_sharded/-40: commit 124 8 ks_sharded/c0-: begin 125 8 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859433' 126 8 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859433' 127 8 ks_sharded/c0-: commit 128 129 ---------------------------------------------------------------------- 130 insert into user (id, name, nickname, address) values(2, 'bob', 'bobby', '123 main st') on duplicate key update nickname=values(nickname), address=values(address) 131 132 1 ks_sharded/c0-: begin 133 1 ks_sharded/c0-: insert ignore into name_user_map(name, user_id) values ('bob', 2) /* vtgate:: keyspace_id:da8a82595aa28154c17717955ffeed8b */ 134 2 ks_sharded/c0-: select name from name_user_map where name = 'bob' and user_id = 2 limit 10001 135 3 ks_sharded/-40: begin 136 3 ks_sharded/-40: insert into user(id, name, nickname, address) values (2, 'bob', 'bobby', '123 main st') on duplicate key update nickname = values(nickname), address = values(address) /* vtgate:: keyspace_id:06e7ea22ce92708f */ 137 3 ks_sharded/-40: select count(*) from `_vt`.redo_state where time_created < 1515392382546684649 138 3 ks_sharded/-40: select dtid, time_created from `_vt`.dt_state where time_created < 1515392386546990720 139 4 ks_sharded/c0-: begin 140 4 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859436', 1, 1515392387549507151) 141 4 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392387053859436', 1, 'ks_sharded', '-40') 142 4 ks_sharded/c0-: commit 143 4 ks_sharded/c0-: select count(*) from `_vt`.redo_state where time_created < 1515392382555938983 144 4 ks_sharded/c0-: select dtid, time_created from `_vt`.dt_state where time_created < 1515392386556481105 145 5 ks_sharded/-40: begin 146 5 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392387053859436', 1, 1515392387561241013) 147 5 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392387053859436', 1, 'insert into user(id, name, nickname, address) values (2, \'bob\', \'bobby\', \'123 main st\') on duplicate key update nickname = values(nickname), address = values(address) /* vtgate:: keyspace_id:06e7ea22ce92708f */') 148 5 ks_sharded/-40: commit 149 6 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392387053859436' and state = 1 150 6 ks_sharded/c0-: commit 151 7 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392387053859436' 152 7 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392387053859436' 153 7 ks_sharded/-40: commit 154 8 ks_sharded/c0-: begin 155 8 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392387053859436' 156 8 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392387053859436' 157 8 ks_sharded/c0-: commit 158 159 ----------------------------------------------------------------------