Skip to content

广播表和分库分表查询问题 #1

@adonis2014

Description

@adonis2014

广播表a,分库不分表 tb_goods 拆分字段 member_id
数据库 icdb0,icdb1
icdb0 表 广播表 a
image
表 tb_goods
image

icdb1 表 tb_goods
image

explain
select * from a,tb_goods as b where a.id=b.id and b.member_id=35

+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+
| GROUP_NAME | SQL | PARAMS |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+
| MYSQL_ICDB_01 | Join
leftColumns:[A.ID]
rightColumns:[B.MEMBER_ID]
type:inner join
strategy:NEST_LOOP_JOIN
executeOn:MYSQL_ICDB_01
left:
Query from A as A
tableName:a
executeOn:MYSQL_ICDB_00
right:
Query from TB_GOODS as B
resultFilter:TB_GOODS.MEMBER_ID = 35
tableName:tb_goods
executeOn:MYSQL_ICDB_01
| NULL |
+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+
1 row in set (0.19 sec)

理论上应该 下推到 MYSQL_ICDB_01
执行 sql的,怎么会在 icdb0上查询a ,在icdb1上查询tb_goods, 然后再在tddl上join的呢

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions