vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/twopc-output/deletesharded-output.txt (about) 1 ---------------------------------------------------------------------- 2 delete from music_extra where id=1 3 4 1 ks_sharded/-40: begin 5 1 ks_sharded/-40: delete from music_extra where id = 1 limit 10001 /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 6 2 ks_sharded/-40: commit 7 8 ---------------------------------------------------------------------- 9 delete from music_extra where id=1 and extra='abc' 10 11 1 ks_sharded/-40: begin 12 1 ks_sharded/-40: delete from music_extra where id = 1 and extra = 'abc' limit 10001 /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 13 2 ks_sharded/-40: commit 14 15 ---------------------------------------------------------------------- 16 delete from user where id=1 17 18 1 ks_sharded/-40: begin 19 1 ks_sharded/-40: select name from user where id = 1 limit 10001 for update 20 2 ks_sharded/80-c0: begin 21 2 ks_sharded/80-c0: delete from name_user_map where name = 'name_val_2' and user_id = 1 limit 10001 /* vtgate:: keyspace_id:73004f940e97faf0a1b54ec5586a090e */ 22 3 ks_sharded/-40: delete from user where id = 1 limit 10001 /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 23 4 ks_sharded/-40: begin 24 4 ks_sharded/-40: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:-40:1515392388787015722', 1, 1515392388898391433) 25 4 ks_sharded/-40: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:-40:1515392388787015722', 1, 'ks_sharded', '80-c0') 26 4 ks_sharded/-40: commit 27 5 ks_sharded/80-c0: begin 28 5 ks_sharded/80-c0: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:-40:1515392388787015722', 1, 1515392388909259045) 29 5 ks_sharded/80-c0: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:-40:1515392388787015722', 1, 'delete from name_user_map where (name = \'name_val_1\' and user_id = 1) /* vtgate:: keyspace_id:a6e89b54b129c33051b76db219595660 */') 30 5 ks_sharded/80-c0: commit 31 6 ks_sharded/-40: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:-40:1515392388787015722' and state = 1 32 6 ks_sharded/-40: commit 33 7 ks_sharded/80-c0: delete from `_vt`.redo_state where dtid = 'ks_sharded:-40:1515392388787015722' 34 7 ks_sharded/80-c0: delete from `_vt`.redo_statement where dtid = 'ks_sharded:-40:1515392388787015722' 35 7 ks_sharded/80-c0: commit 36 8 ks_sharded/-40: begin 37 8 ks_sharded/-40: delete from `_vt`.dt_state where dtid = 'ks_sharded:-40:1515392388787015722' 38 8 ks_sharded/-40: delete from `_vt`.dt_participant where dtid = 'ks_sharded:-40:1515392388787015722' 39 8 ks_sharded/-40: commit 40 41 ---------------------------------------------------------------------- 42 delete from user where name='billy' 43 44 1 ks_sharded/c0-: begin 45 1 ks_sharded/c0-: select name, user_id from name_user_map where name in ('billy') limit 10001 46 2 ks_sharded/-40: begin 47 2 ks_sharded/-40: select name from user where name = 'billy' limit 10001 for update 48 3 ks_sharded/80-c0: begin 49 3 ks_sharded/80-c0: delete from name_user_map where (name = 'name_val_1' and user_id = 1) /* vtgate:: keyspace_id:a6e89b54b129c33051b76db219595660 */ 50 4 ks_sharded/-40: select id from user where name = 'billy' limit 10001 for update /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 51 4 ks_sharded/-40: delete from user where id in (1) /* vtgate:: keyspace_id:166b40b44aba4bd6 */ 52 5 ks_sharded/c0-: begin 53 5 ks_sharded/c0-: insert into `_vt`.dt_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392388798209886', 1, 1515392389009197532) 54 5 ks_sharded/c0-: insert into `_vt`.dt_participant(dtid, id, keyspace, shard) values ('ks_sharded:c0-:1515392388798209886', 1, 'ks_sharded', '-40'), ('ks_sharded:c0-:1515392388798209886', 2, 'ks_sharded', '80-c0') 55 5 ks_sharded/c0-: commit 56 6 ks_sharded/-40: begin 57 6 ks_sharded/-40: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392388798209886', 1, 1515392389021902468) 58 6 ks_sharded/-40: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392388798209886', 1, 'delete from user where id in (1) /* vtgate:: keyspace_id:166b40b44aba4bd6 */') 59 6 ks_sharded/-40: commit 60 6 ks_sharded/80-c0: begin 61 6 ks_sharded/80-c0: insert into `_vt`.redo_state(dtid, state, time_created) values ('ks_sharded:c0-:1515392388798209886', 1, 1515392389021902697) 62 6 ks_sharded/80-c0: insert into `_vt`.redo_statement(dtid, id, statement) values ('ks_sharded:c0-:1515392388798209886', 1, 'delete from name_user_map where (name = \'name_val_1\' and user_id = 1) /* vtgate:: keyspace_id:a6e89b54b129c33051b76db219595660 */') 63 6 ks_sharded/80-c0: commit 64 7 ks_sharded/c0-: update `_vt`.dt_state set state = 2 where dtid = 'ks_sharded:c0-:1515392388798209886' and state = 1 65 7 ks_sharded/c0-: commit 66 8 ks_sharded/-40: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392388798209886' 67 8 ks_sharded/-40: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392388798209886' 68 8 ks_sharded/-40: commit 69 8 ks_sharded/80-c0: delete from `_vt`.redo_state where dtid = 'ks_sharded:c0-:1515392388798209886' 70 8 ks_sharded/80-c0: delete from `_vt`.redo_statement where dtid = 'ks_sharded:c0-:1515392388798209886' 71 8 ks_sharded/80-c0: commit 72 9 ks_sharded/c0-: begin 73 9 ks_sharded/c0-: delete from `_vt`.dt_state where dtid = 'ks_sharded:c0-:1515392388798209886' 74 9 ks_sharded/c0-: delete from `_vt`.dt_participant where dtid = 'ks_sharded:c0-:1515392388798209886' 75 9 ks_sharded/c0-: commit 76 77 ----------------------------------------------------------------------