vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/multi-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
     6  1 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
    13  1 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 id, `name` from `user` where id = 1 limit 10001 for update
    20  2 ks_sharded/40-80: begin
    21  2 ks_sharded/40-80: delete from name_user_map where `name` = 'name_val_2' and user_id = 1 limit 10001
    22  3 ks_sharded/-40: delete from `user` where id = 1 limit 10001
    23  4 ks_sharded/-40: commit
    24  5 ks_sharded/40-80: commit
    25  
    26  ----------------------------------------------------------------------
    27  delete from user where name='billy'
    28  
    29  1 ks_sharded/c0-: begin
    30  1 ks_sharded/c0-: select `name`, user_id from name_user_map where `name` in ('billy') limit 10001 for update
    31  2 ks_sharded/-40: begin
    32  2 ks_sharded/-40: select id, `name` from `user` where `name` = 'billy' limit 10001 for update
    33  3 ks_sharded/40-80: begin
    34  3 ks_sharded/40-80: delete from name_user_map where `name` = 'name_val_2' and user_id = 1 limit 10001
    35  4 ks_sharded/-40: delete from `user` where `name` = 'billy' limit 10001
    36  5 ks_sharded/c0-: commit
    37  6 ks_sharded/-40: commit
    38  7 ks_sharded/40-80: commit
    39  
    40  ----------------------------------------------------------------------
    41  delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra='abc'
    42  
    43  1 ks_sharded/-40: begin
    44  1 ks_sharded/-40: delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra = 'abc' limit 10001
    45  1 ks_sharded/-40: commit
    46  1 ks_sharded/40-80: begin
    47  1 ks_sharded/40-80: delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra = 'abc' limit 10001
    48  1 ks_sharded/40-80: commit
    49  1 ks_sharded/80-c0: begin
    50  1 ks_sharded/80-c0: delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra = 'abc' limit 10001
    51  1 ks_sharded/80-c0: commit
    52  1 ks_sharded/c0-: begin
    53  1 ks_sharded/c0-: delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra = 'abc' limit 10001
    54  1 ks_sharded/c0-: commit
    55  
    56  ----------------------------------------------------------------------
    57  delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from `ks_sharded[-]`.music_extra where extra='abc' LIMIT 10
    58  
    59  1 ks_sharded/-40: delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra = 'abc' limit 10
    60  1 ks_sharded/40-80: delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra = 'abc' limit 10
    61  1 ks_sharded/80-c0: delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra = 'abc' limit 10
    62  1 ks_sharded/c0-: delete /*vt+ MULTI_SHARD_AUTOCOMMIT=1 */ from music_extra where extra = 'abc' limit 10
    63  
    64  ----------------------------------------------------------------------