Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Optimize the number of node record rows with JDBC repository in Standalone mode #31372

Closed
zhaojinchao95 opened this issue May 24, 2024 · 1 comment · Fixed by #31377
Closed

Comments

@zhaojinchao95
Copy link
Contributor

zhaojinchao95 commented May 24, 2024

global.yaml:

mode:
  type: Standalone
  repository:
    type: JDBC
    props:
      provider: MySQL
      jdbc_url: jdbc:mysql://localhost:3306/test
      username: root
      password: 123456

DistSQL:

REGISTER STORAGE UNIT ds_0 (
    HOST="127.0.0.1",
    PORT=3306,
    DB="test",
    USER="root",
    PASSWORD="123456"
);

CREATE MASK RULE t_mask (
COLUMNS(
(NAME=phone_number,TYPE(NAME='MASK_FROM_X_TO_Y', PROPERTIES("from-x"=1, "to-y"=2, "replace-char"="*"))),
(NAME=address,TYPE(NAME='MD5'))
));

DROP MASK RULE t_mask;
image

According to the picture above, there are still many remaining node records that have not been cleared.

@wmouren
Copy link
Contributor

wmouren commented May 24, 2024

I want to try

wmouren added a commit to wmouren/shardingsphere that referenced this issue May 24, 2024
wmouren added a commit to wmouren/shardingsphere that referenced this issue May 24, 2024
wmouren added a commit to wmouren/shardingsphere that referenced this issue May 24, 2024
@wmouren wmouren mentioned this issue May 24, 2024
6 tasks
wmouren added a commit to wmouren/shardingsphere that referenced this issue May 24, 2024
zhaojinchao95 pushed a commit that referenced this issue May 26, 2024
* Fix #31372 problem

* Fix #31372 problem

* Fix #31372 problem
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants