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

[Improve] frontend processor refactor #2646

Closed
dcy10000 opened this issue May 13, 2021 · 1 comment · Fixed by #2609
Closed

[Improve] frontend processor refactor #2646

dcy10000 opened this issue May 13, 2021 · 1 comment · Fixed by #2609
Assignees
Milestone

Comments

@dcy10000
Copy link
Member

dcy10000 commented May 13, 2021

  • dble version:<=3.21.02

In the current frontend executor architecture of dble, Dble isn't friendly to some scenes.

  • defect:
  1. When using the RwSplitUser, the time to use the LOAD DATA will increase with frontend processor threads count ( correspond to the config processorExecutor) increases. When the thread count increases, CPU consumption will also increase. In addition, the ShardingUser is not affected by this because of special treatment.
  2. doesn't support MariaDB client with useBatchMultiSend option enabled. Although requests are delivered in order, the order of response is not guaranteed.
  3. Any other scenes that send a lot of packets in a round trip, may affect performance. When the thread count increases, CPU consumption will also increase.
  • modification:
  1. support response order. fix defect-2.
  2. adjust thread scheduling to ensure fairness and reduce useless waste of resources. fix defect-1 defect-3.
@dcy10000 dcy10000 self-assigned this May 13, 2021
@dcy10000
Copy link
Member Author

dcy10000 commented May 13, 2021

LOAD DATA example

-Dprocessor=1
-DprocessorExecutor=10
mysql> load data local  infile '/opt/test.txt' into table test character SET 'utf8' fields terminated by ' ' lines terminated by '\n';
Query OK, 1000000 rows affected (3.19 sec)
Records: 1000000  Deleted: 0  Skipped: 0  Warnings: 0

-Dprocessor=1
-DprocessorExecutor=20
mysql> load data local  infile '/opt/test.txt' into table test character SET 'utf8' fields terminated by ' ' lines terminated by '\n';
Query OK, 1000000 rows affected (5.95 sec)
Records: 1000000  Deleted: 0  Skipped: 0  Warnings: 0

-Dprocessor=1
-DprocessorExecutor=40
mysql> load data local  infile '/opt/test.txt' into table test character SET 'utf8' fields terminated by ' ' lines terminated by '\n';
Query OK, 1000000 rows affected (6.00 sec)
Records: 1000000  Deleted: 0  Skipped: 0  Warnings: 0

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.

3 participants