HappenLee opened a new pull request, #46232:
URL: https://github.com/apache/doris/pull/46232

   cherry-pick #45414
   
   before:
   ```
    mysqlslap -hd3 -uroot -P9130  --create-schema=test_db2 -c 10 -i 500 -q 
"SELECT count(k) FROM sbtest1_dup WHERE k BETWEEN 4850578 AND 8454295 OR k 
BETWEEN 8776291 AND 29749077;"
   Benchmark
        Average number of seconds to run all queries: 0.041 seconds
        Minimum number of seconds to run all queries: 0.037 seconds
        Maximum number of seconds to run all queries: 0.115 seconds
        Number of clients running queries: 10
        Average number of queries per client: 1
   ```
   
   after:
   ```
   mysqlslap -hd3 -uroot -P9030  --create-schema=test_db -c 10 -i 500 -q 
"SELECT count(k) FROM sbtest1 WHERE k BETWEEN 4850578 AND 8454295 OR k BETWEEN 
8776291 AND 29749077;"
   Benchmark
        Average number of seconds to run all queries: 0.029 seconds
        Minimum number of seconds to run all queries: 0.027 seconds
        Maximum number of seconds to run all queries: 0.034 seconds
        Number of clients running queries: 10
        Average number of queries per client: 1
   ```
   
   ### What problem does this PR solve?
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: 
https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should 
merge into -->
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to