vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/multi-output/updatesharded-output.txt (about) 1 ---------------------------------------------------------------------- 2 update user set nickname='alice' where id=1 3 4 1 ks_sharded/-40: begin 5 1 ks_sharded/-40: update `user` set nickname = 'alice' where id = 1 limit 10001 6 1 ks_sharded/-40: commit 7 8 ---------------------------------------------------------------------- 9 update user set nickname='alice' where name='alice' 10 11 1 ks_sharded/40-80: begin 12 1 ks_sharded/40-80: select `name`, user_id from name_user_map where `name` in ('alice') limit 10001 for update 13 2 ks_sharded/-40: begin 14 2 ks_sharded/-40: update `user` set nickname = 'alice' where `name` = 'alice' limit 10001 15 3 ks_sharded/40-80: commit 16 4 ks_sharded/-40: commit 17 18 ---------------------------------------------------------------------- 19 update user set pet='fido' where id=1 20 21 1 ks_sharded/-40: begin 22 1 ks_sharded/-40: update `user` set pet = 'fido' where id = 1 limit 10001 23 1 ks_sharded/-40: commit 24 25 ---------------------------------------------------------------------- 26 update user set name='alicia' where id=1 27 28 1 ks_sharded/-40: begin 29 1 ks_sharded/-40: select id, `name`, `name` = 'alicia' from `user` where id = 1 limit 10001 for update 30 2 ks_sharded/40-80: begin 31 2 ks_sharded/40-80: delete from name_user_map where `name` = 'name_val_2' and user_id = 1 limit 10001 32 3 ks_sharded/c0-: begin 33 3 ks_sharded/c0-: insert into name_user_map(`name`, user_id) values ('alicia', 1) 34 4 ks_sharded/-40: update `user` set `name` = 'alicia' where id = 1 limit 10001 35 5 ks_sharded/-40: commit 36 6 ks_sharded/40-80: commit 37 7 ks_sharded/c0-: commit 38 39 ---------------------------------------------------------------------- 40 update user set name='alicia' where name='alice' 41 42 1 ks_sharded/40-80: begin 43 1 ks_sharded/40-80: select `name`, user_id from name_user_map where `name` in ('alice') limit 10001 for update 44 2 ks_sharded/-40: begin 45 2 ks_sharded/-40: select id, `name`, `name` = 'alicia' from `user` where `name` = 'alice' limit 10001 for update 46 3 ks_sharded/40-80: delete from name_user_map where `name` = 'name_val_2' and user_id = 1 limit 10001 47 4 ks_sharded/c0-: begin 48 4 ks_sharded/c0-: insert into name_user_map(`name`, user_id) values ('alicia', 1) 49 5 ks_sharded/-40: update `user` set `name` = 'alicia' where `name` = 'alice' limit 10001 50 6 ks_sharded/40-80: commit 51 7 ks_sharded/-40: commit 52 8 ks_sharded/c0-: commit 53 54 ---------------------------------------------------------------------- 55 update /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ name_info set info='apa' where name != 'hog' 56 57 1 ks_sharded/-40: begin 58 1 ks_sharded/-40: update /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ name_info set info = 'apa' where `name` != 'hog' limit 10001 59 1 ks_sharded/-40: commit 60 1 ks_sharded/40-80: begin 61 1 ks_sharded/40-80: update /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ name_info set info = 'apa' where `name` != 'hog' limit 10001 62 1 ks_sharded/40-80: commit 63 1 ks_sharded/80-c0: begin 64 1 ks_sharded/80-c0: update /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ name_info set info = 'apa' where `name` != 'hog' limit 10001 65 1 ks_sharded/80-c0: commit 66 1 ks_sharded/c0-: begin 67 1 ks_sharded/c0-: update /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ name_info set info = 'apa' where `name` != 'hog' limit 10001 68 1 ks_sharded/c0-: commit 69 70 ---------------------------------------------------------------------- 71 update user set pet='rover' where name='alice' 72 73 1 ks_sharded/40-80: begin 74 1 ks_sharded/40-80: select `name`, user_id from name_user_map where `name` in ('alice') limit 10001 for update 75 2 ks_sharded/-40: begin 76 2 ks_sharded/-40: update `user` set pet = 'rover' where `name` = 'alice' limit 10001 77 3 ks_sharded/40-80: commit 78 4 ks_sharded/-40: commit 79 80 ---------------------------------------------------------------------- 81 begin 82 83 84 ---------------------------------------------------------------------- 85 update user set nickname='alice' where id=1 86 87 1 ks_sharded/-40: begin 88 1 ks_sharded/-40: update `user` set nickname = 'alice' where id = 1 limit 10001 89 90 ---------------------------------------------------------------------- 91 update user set nickname='bob' where id=1 92 93 2 ks_sharded/-40: update `user` set nickname = 'bob' where id = 1 limit 10001 94 95 ---------------------------------------------------------------------- 96 commit 97 98 3 ks_sharded/-40: commit 99 100 ---------------------------------------------------------------------- 101 begin 102 103 104 ---------------------------------------------------------------------- 105 update user set nickname='alice' where id=1 106 107 1 ks_sharded/-40: begin 108 1 ks_sharded/-40: update `user` set nickname = 'alice' where id = 1 limit 10001 109 110 ---------------------------------------------------------------------- 111 update user set nickname='bob' where id=3 112 113 2 ks_sharded/40-80: begin 114 2 ks_sharded/40-80: update `user` set nickname = 'bob' where id = 3 limit 10001 115 116 ---------------------------------------------------------------------- 117 commit 118 119 3 ks_sharded/-40: commit 120 4 ks_sharded/40-80: commit 121 122 ---------------------------------------------------------------------- 123 begin 124 125 126 ---------------------------------------------------------------------- 127 update user set nickname='alice' where id in (1,4) 128 129 1 ks_sharded/-40: begin 130 1 ks_sharded/-40: savepoint x1 131 1 ks_sharded/-40: update `user` set nickname = 'alice' where id in (1, 4) limit 10001 132 1 ks_sharded/c0-: begin 133 1 ks_sharded/c0-: savepoint x1 134 1 ks_sharded/c0-: update `user` set nickname = 'alice' where id in (1, 4) limit 10001 135 136 ---------------------------------------------------------------------- 137 commit 138 139 2 ks_sharded/-40: commit 140 3 ks_sharded/c0-: commit 141 142 ----------------------------------------------------------------------