You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@shardingsphere.apache.org by Willem Jiang <wi...@gmail.com> on 2019/02/01 02:46:26 UTC
Re: Saga transaction performance test with Sharding-JDBC
If the test machine is a physical machine, we may need consider the
performance reduction if there is a RPC call across the network.
Willem Jiang
Twitter: willemjiang
Weibo: 姜宁willem
On Thu, Jan 31, 2019 at 9:15 PM tsubasaotl <ts...@qq.com> wrote:
>
> 1. The test environment is a physical machine not a VM machines. MySQLs and Sharding-jdbc both runs in it.
> 2. The `local` means local transaction[1] in ShradingSphere
>
> [1] https://shardingsphere.apache.org/document/current/en/features/transaction/local-transaction/
>
> ------------------
> Yi Yang (Sion)
> Apache ShardingSphere contributor
>
>
>
>
>
> ------------------ Original ------------------
> From: "Willem Jiang"<wi...@gmail.com>;
> Date: Thu, Jan 31, 2019 08:53 PM
> To: "dev"<de...@servicecomb.apache.org>;
> Cc: "dev"<de...@shardingsphere.apache.org>;
> Subject: Re: Saga transaction performance test with Sharding-JDBC
>
>
>
> Hi Sion,
>
> Thanks for the information. I just have a quick question for the test
> environment and result.
> 1. You mentioned the test environment has 256cores and 300+G RAM , I
> want to know how many boxes (VM machines) are used in this test.
> 2. what's the meaning of local in the test result, does it mean local
> transaction?
>
>
>
> Willem Jiang
>
> Twitter: willemjiang
> Weibo: 姜宁willem
>
> On Thu, Jan 31, 2019 at 8:30 PM tsubasaotl <ts...@qq.com> wrote:
> >
> > Hi, everyone.
> >
> >
> > New performance test has completed.
> > In new performance test, we test one logic SQL which routes to two database in one transaction.
> > And test result comes from test environment which 256cores and 300+G RAM
> > The connection pool size, thread pool size of Sharding-JDBC all are 200.
> > ---------------------- result for test environment ---------------------
> > | Tx Type |Average response(ms)| TPS |
> > | No Tx | 13 |13555|
> > | saga | 15 |12726|
> > | local | 16 |11761|
> > | xa | 27 | 7197 |
> > | saga with persistence | 41 | 4700 |
> > | xa with persistence | 60 | 3322 |
> >
> >
> >
> > ------------------
> > Yi Yang (Sion)
> > Apache ShardingSphere contributor
> >
> >
> >
> >
> > ------------------ Original ------------------
> > From: "新道场开张了"<ts...@qq.com>;
> > Date: Fri, Jan 4, 2019 04:24 PM
> > To: "dev"<de...@servicecomb.apache.org>;
> > Cc: "dev"<de...@shardingsphere.apache.org>;
> > Subject: Re: Saga transaction performance test with Sharding-JDBC
> >
> >
> >
> > I am modifying the integration way of ShardingSphere and saga-actuator,
> > and the next performance test will be performed after the modification is completed.
> >
> >
> > ------------------ Original ------------------
> > From: "Willem Jiang"<wi...@gmail.com>;
> > Date: Fri, Jan 4, 2019 04:10 PM
> > To: "dev"<de...@servicecomb.apache.org>;
> >
> > Subject: Re: Saga transaction performance test with Sharding-JDBC
> >
> >
> >
> > Any updated about this performance test?
> >
> > Willem Jiang
> >
> > Twitter: willemjiang
> > Weibo: 姜宁willem
> >
> > On Tue, Dec 25, 2018 at 4:31 PM 新道场开张了 <ts...@qq.com> wrote:
> > >
> > > XA use Atomikos as default.
> > >
> > >
> > > The test run with
> > > repo: https://github.com/cherrylzhao/sharding-sphere-example/tree/dev-performance
> > > module: sharding-jdbc-example --> spring-boot-nodep-example --> spring-boot-nodep-mybatis-example
> > > class: io.shardingsphere.example.spring.boot.mybatis.nodep.SpringBootStarterTransactionExample
> > >
> > >
> > > ------------------ Original ------------------
> > > From: "Zheng Feng"<zh...@gmail.com>;
> > > Date: Tue, Dec 25, 2018 04:05 PM
> > > To: "dev"<de...@servicecomb.apache.org>;
> > >
> > > Subject: Re: Saga transaction performance test with Sharding-JDBC
> > >
> > >
> > >
> > > Thanks for sharing these performance tests and is it possible to share the
> > > source codes if you are happy to open these tests ?
> > > In term of the XA tests, I think the default transaction manager is
> > > Atomikos ? I'm interested with running with the Narayana [1]
> > >
> > > So it could be very useful to share the source codes with the community !
> > > Thanks,
> > >
> > > Zheng Feng
> > >
> > > [1] https://github.com/zhfeng/narayana-sharding-sphere
> > >
> > > 新道场开张了 <ts...@qq.com> 于2018年12月25日周二 上午10:51写道:
> > >
> > > > Saga Tx is slower than No Tx.
> > > > TPS of saga is 1700 and No Tx is 2000 in test environment.
> > > >
> > > >
> > > > About the load and memory usage, we will record in next performance.
> > > >
> > > >
> > > >
> > > >
> > > > ------------------ Original ------------------
> > > > From: "Zhang Yonglun"<zh...@apache.org>;
> > > > Date: Mon, Dec 24, 2018 08:56 PM
> > > > To: "dev"<de...@shardingsphere.apache.org>;
> > > > Cc: "dev"<de...@servicecomb.apache.org>;
> > > > Subject: Re: Saga transaction performance test with Sharding-JDBC
> > > >
> > > >
> > > >
> > > > Impressive!
> > > > I am focused on the performance issue of ShardingSphere for a long time,
> > > > and have done a little saga work before. But I still can't understand why
> > > > saga Tx faster than No Tx. Is there something I missed?
> > > >
> > > > BTW, I noticed that second nice machine, and wonder what's the load and
> > > > memory usage on it when testing.
> > > >
> > > >
> > > > 新道场开张了 <ts...@qq.com> 于2018年12月24日周一 下午6:28写道:
> > > >
> > > > > Hi, everyone.
> > > > >
> > > > >
> > > > > The feature of saga transaction in ShardingSphere has been basically
> > > > > completed
> > > > > by integrating servicecomb-saga-actuator.
> > > > > Recently, we used Sharding-JDBC to test the performance of Saga
> > > > > transactions.
> > > > >
> > > > >
> > > > > There are results for two kinds of environments.
> > > > >
> > > > >
> > > > > First result comes from local environment which including 2 cores and 16G
> > > > > RAM
> > > > > The connection pool size, thread pool size of saga-actuator and thread
> > > > > pool size of Sharding-JDBC all are 50.
> > > > >
> > > > >
> > > > > ---------------- result for local environment ----------------
> > > > > |Tx Type|Thread Number|Average response(ms)| TPS |
> > > > > | No Tx | 50 | 337 | 140 |
> > > > > | saga | 50 | 395 | 120 |
> > > > > | local | 50 | 323 |143|
> > > > > | xa | 50 | 301 |154|
> > > > > | No Tx | 100 | 605 | 158 |
> > > > > | saga | 100 | 789 | 120 |
> > > > >
> > > > > ---------------- result for local environment ----------------
> > > > >
> > > > >
> > > > > Second result comes from test environment which 256cores and 300+G RAM
> > > > > The connection pool size, thread pool size of saga-actuator and thread
> > > > > pool size of Sharding-JDBC all are 200.
> > > > >
> > > > >
> > > > > ---------------- result for test environment ----------------
> > > > > |Tx Type|Thread Number|Average response(ms)| TPS |
> > > > > | No Tx | 200 | 95 |2002|
> > > > > | saga | 200 | 351 |1700|
> > > > >
> > > > > | local | 200 | 64 |2868|
> > > > > | xa | 200 | 98 |2012|
> > > > > ---------------- result for test environment ----------------
> > > > >
> > > > >
> > > > > And I do echo test with emptyTransport which do not execute SQL in saga,
> > > > > the result is TPS 457 in local and 3200 in test environment.
> > > > >
> > > > >
> > > > > if saga do persistence to log file, the TPS of saga will nose dive to 70
> > > > > in local and 600+ in test environment
> > > >
> > > >
> > > >
> > > > --
> > > > Zhang Yonglun
> > > > Apache ShardingSphere
Re: Saga transaction performance test with Sharding-JDBC
Posted by 赵俊 <zh...@jd.com>.
It’s right, but sharding-sphere now is aim to ensure the transaction of after sharding, not the Microservices.
So rpc calls not exist now.
> On Feb 1, 2019, at 10:46 AM, Willem Jiang <wi...@gmail.com> wrote:
>
> If the test machine is a physical machine, we may need consider the
> performance reduction if there is a RPC call across the network.
>
>
> Willem Jiang
>
> Twitter: willemjiang
> Weibo: 姜宁willem
>
> On Thu, Jan 31, 2019 at 9:15 PM tsubasaotl <ts...@qq.com> wrote:
>>
>> 1. The test environment is a physical machine not a VM machines. MySQLs and Sharding-jdbc both runs in it.
>> 2. The `local` means local transaction[1] in ShradingSphere
>>
>> [1] https://shardingsphere.apache.org/document/current/en/features/transaction/local-transaction/
>>
>> ------------------
>> Yi Yang (Sion)
>> Apache ShardingSphere contributor
>>
>>
>>
>>
>>
>> ------------------ Original ------------------
>> From: "Willem Jiang"<wi...@gmail.com>;
>> Date: Thu, Jan 31, 2019 08:53 PM
>> To: "dev"<de...@servicecomb.apache.org>;
>> Cc: "dev"<de...@shardingsphere.apache.org>;
>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>
>>
>>
>> Hi Sion,
>>
>> Thanks for the information. I just have a quick question for the test
>> environment and result.
>> 1. You mentioned the test environment has 256cores and 300+G RAM , I
>> want to know how many boxes (VM machines) are used in this test.
>> 2. what's the meaning of local in the test result, does it mean local
>> transaction?
>>
>>
>>
>> Willem Jiang
>>
>> Twitter: willemjiang
>> Weibo: 姜宁willem
>>
>> On Thu, Jan 31, 2019 at 8:30 PM tsubasaotl <ts...@qq.com> wrote:
>>>
>>> Hi, everyone.
>>>
>>>
>>> New performance test has completed.
>>> In new performance test, we test one logic SQL which routes to two database in one transaction.
>>> And test result comes from test environment which 256cores and 300+G RAM
>>> The connection pool size, thread pool size of Sharding-JDBC all are 200.
>>> ---------------------- result for test environment ---------------------
>>> | Tx Type |Average response(ms)| TPS |
>>> | No Tx | 13 |13555|
>>> | saga | 15 |12726|
>>> | local | 16 |11761|
>>> | xa | 27 | 7197 |
>>> | saga with persistence | 41 | 4700 |
>>> | xa with persistence | 60 | 3322 |
>>>
>>>
>>>
>>> ------------------
>>> Yi Yang (Sion)
>>> Apache ShardingSphere contributor
>>>
>>>
>>>
>>>
>>> ------------------ Original ------------------
>>> From: "新道场开张了"<ts...@qq.com>;
>>> Date: Fri, Jan 4, 2019 04:24 PM
>>> To: "dev"<de...@servicecomb.apache.org>;
>>> Cc: "dev"<de...@shardingsphere.apache.org>;
>>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>>
>>>
>>>
>>> I am modifying the integration way of ShardingSphere and saga-actuator,
>>> and the next performance test will be performed after the modification is completed.
>>>
>>>
>>> ------------------ Original ------------------
>>> From: "Willem Jiang"<wi...@gmail.com>;
>>> Date: Fri, Jan 4, 2019 04:10 PM
>>> To: "dev"<de...@servicecomb.apache.org>;
>>>
>>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>>
>>>
>>>
>>> Any updated about this performance test?
>>>
>>> Willem Jiang
>>>
>>> Twitter: willemjiang
>>> Weibo: 姜宁willem
>>>
>>> On Tue, Dec 25, 2018 at 4:31 PM 新道场开张了 <ts...@qq.com> wrote:
>>>>
>>>> XA use Atomikos as default.
>>>>
>>>>
>>>> The test run with
>>>> repo: https://github.com/cherrylzhao/sharding-sphere-example/tree/dev-performance
>>>> module: sharding-jdbc-example --> spring-boot-nodep-example --> spring-boot-nodep-mybatis-example
>>>> class: io.shardingsphere.example.spring.boot.mybatis.nodep.SpringBootStarterTransactionExample
>>>>
>>>>
>>>> ------------------ Original ------------------
>>>> From: "Zheng Feng"<zh...@gmail.com>;
>>>> Date: Tue, Dec 25, 2018 04:05 PM
>>>> To: "dev"<de...@servicecomb.apache.org>;
>>>>
>>>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>>>
>>>>
>>>>
>>>> Thanks for sharing these performance tests and is it possible to share the
>>>> source codes if you are happy to open these tests ?
>>>> In term of the XA tests, I think the default transaction manager is
>>>> Atomikos ? I'm interested with running with the Narayana [1]
>>>>
>>>> So it could be very useful to share the source codes with the community !
>>>> Thanks,
>>>>
>>>> Zheng Feng
>>>>
>>>> [1] https://github.com/zhfeng/narayana-sharding-sphere
>>>>
>>>> 新道场开张了 <ts...@qq.com> 于2018年12月25日周二 上午10:51写道:
>>>>
>>>>> Saga Tx is slower than No Tx.
>>>>> TPS of saga is 1700 and No Tx is 2000 in test environment.
>>>>>
>>>>>
>>>>> About the load and memory usage, we will record in next performance.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ------------------ Original ------------------
>>>>> From: "Zhang Yonglun"<zh...@apache.org>;
>>>>> Date: Mon, Dec 24, 2018 08:56 PM
>>>>> To: "dev"<de...@shardingsphere.apache.org>;
>>>>> Cc: "dev"<de...@servicecomb.apache.org>;
>>>>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>>>>
>>>>>
>>>>>
>>>>> Impressive!
>>>>> I am focused on the performance issue of ShardingSphere for a long time,
>>>>> and have done a little saga work before. But I still can't understand why
>>>>> saga Tx faster than No Tx. Is there something I missed?
>>>>>
>>>>> BTW, I noticed that second nice machine, and wonder what's the load and
>>>>> memory usage on it when testing.
>>>>>
>>>>>
>>>>> 新道场开张了 <ts...@qq.com> 于2018年12月24日周一 下午6:28写道:
>>>>>
>>>>>> Hi, everyone.
>>>>>>
>>>>>>
>>>>>> The feature of saga transaction in ShardingSphere has been basically
>>>>>> completed
>>>>>> by integrating servicecomb-saga-actuator.
>>>>>> Recently, we used Sharding-JDBC to test the performance of Saga
>>>>>> transactions.
>>>>>>
>>>>>>
>>>>>> There are results for two kinds of environments.
>>>>>>
>>>>>>
>>>>>> First result comes from local environment which including 2 cores and 16G
>>>>>> RAM
>>>>>> The connection pool size, thread pool size of saga-actuator and thread
>>>>>> pool size of Sharding-JDBC all are 50.
>>>>>>
>>>>>>
>>>>>> ---------------- result for local environment ----------------
>>>>>> |Tx Type|Thread Number|Average response(ms)| TPS |
>>>>>> | No Tx | 50 | 337 | 140 |
>>>>>> | saga | 50 | 395 | 120 |
>>>>>> | local | 50 | 323 |143|
>>>>>> | xa | 50 | 301 |154|
>>>>>> | No Tx | 100 | 605 | 158 |
>>>>>> | saga | 100 | 789 | 120 |
>>>>>>
>>>>>> ---------------- result for local environment ----------------
>>>>>>
>>>>>>
>>>>>> Second result comes from test environment which 256cores and 300+G RAM
>>>>>> The connection pool size, thread pool size of saga-actuator and thread
>>>>>> pool size of Sharding-JDBC all are 200.
>>>>>>
>>>>>>
>>>>>> ---------------- result for test environment ----------------
>>>>>> |Tx Type|Thread Number|Average response(ms)| TPS |
>>>>>> | No Tx | 200 | 95 |2002|
>>>>>> | saga | 200 | 351 |1700|
>>>>>>
>>>>>> | local | 200 | 64 |2868|
>>>>>> | xa | 200 | 98 |2012|
>>>>>> ---------------- result for test environment ----------------
>>>>>>
>>>>>>
>>>>>> And I do echo test with emptyTransport which do not execute SQL in saga,
>>>>>> the result is TPS 457 in local and 3200 in test environment.
>>>>>>
>>>>>>
>>>>>> if saga do persistence to log file, the TPS of saga will nose dive to 70
>>>>>> in local and 600+ in test environment
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Zhang Yonglun
>>>>> Apache ShardingSphere
Re: Saga transaction performance test with Sharding-JDBC
Posted by 赵俊 <zh...@jd.com>.
It’s right, but sharding-sphere now is aim to ensure the transaction of after sharding, not the Microservices.
So rpc calls not exist now.
> On Feb 1, 2019, at 10:46 AM, Willem Jiang <wi...@gmail.com> wrote:
>
> If the test machine is a physical machine, we may need consider the
> performance reduction if there is a RPC call across the network.
>
>
> Willem Jiang
>
> Twitter: willemjiang
> Weibo: 姜宁willem
>
> On Thu, Jan 31, 2019 at 9:15 PM tsubasaotl <ts...@qq.com> wrote:
>>
>> 1. The test environment is a physical machine not a VM machines. MySQLs and Sharding-jdbc both runs in it.
>> 2. The `local` means local transaction[1] in ShradingSphere
>>
>> [1] https://shardingsphere.apache.org/document/current/en/features/transaction/local-transaction/
>>
>> ------------------
>> Yi Yang (Sion)
>> Apache ShardingSphere contributor
>>
>>
>>
>>
>>
>> ------------------ Original ------------------
>> From: "Willem Jiang"<wi...@gmail.com>;
>> Date: Thu, Jan 31, 2019 08:53 PM
>> To: "dev"<de...@servicecomb.apache.org>;
>> Cc: "dev"<de...@shardingsphere.apache.org>;
>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>
>>
>>
>> Hi Sion,
>>
>> Thanks for the information. I just have a quick question for the test
>> environment and result.
>> 1. You mentioned the test environment has 256cores and 300+G RAM , I
>> want to know how many boxes (VM machines) are used in this test.
>> 2. what's the meaning of local in the test result, does it mean local
>> transaction?
>>
>>
>>
>> Willem Jiang
>>
>> Twitter: willemjiang
>> Weibo: 姜宁willem
>>
>> On Thu, Jan 31, 2019 at 8:30 PM tsubasaotl <ts...@qq.com> wrote:
>>>
>>> Hi, everyone.
>>>
>>>
>>> New performance test has completed.
>>> In new performance test, we test one logic SQL which routes to two database in one transaction.
>>> And test result comes from test environment which 256cores and 300+G RAM
>>> The connection pool size, thread pool size of Sharding-JDBC all are 200.
>>> ---------------------- result for test environment ---------------------
>>> | Tx Type |Average response(ms)| TPS |
>>> | No Tx | 13 |13555|
>>> | saga | 15 |12726|
>>> | local | 16 |11761|
>>> | xa | 27 | 7197 |
>>> | saga with persistence | 41 | 4700 |
>>> | xa with persistence | 60 | 3322 |
>>>
>>>
>>>
>>> ------------------
>>> Yi Yang (Sion)
>>> Apache ShardingSphere contributor
>>>
>>>
>>>
>>>
>>> ------------------ Original ------------------
>>> From: "新道场开张了"<ts...@qq.com>;
>>> Date: Fri, Jan 4, 2019 04:24 PM
>>> To: "dev"<de...@servicecomb.apache.org>;
>>> Cc: "dev"<de...@shardingsphere.apache.org>;
>>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>>
>>>
>>>
>>> I am modifying the integration way of ShardingSphere and saga-actuator,
>>> and the next performance test will be performed after the modification is completed.
>>>
>>>
>>> ------------------ Original ------------------
>>> From: "Willem Jiang"<wi...@gmail.com>;
>>> Date: Fri, Jan 4, 2019 04:10 PM
>>> To: "dev"<de...@servicecomb.apache.org>;
>>>
>>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>>
>>>
>>>
>>> Any updated about this performance test?
>>>
>>> Willem Jiang
>>>
>>> Twitter: willemjiang
>>> Weibo: 姜宁willem
>>>
>>> On Tue, Dec 25, 2018 at 4:31 PM 新道场开张了 <ts...@qq.com> wrote:
>>>>
>>>> XA use Atomikos as default.
>>>>
>>>>
>>>> The test run with
>>>> repo: https://github.com/cherrylzhao/sharding-sphere-example/tree/dev-performance
>>>> module: sharding-jdbc-example --> spring-boot-nodep-example --> spring-boot-nodep-mybatis-example
>>>> class: io.shardingsphere.example.spring.boot.mybatis.nodep.SpringBootStarterTransactionExample
>>>>
>>>>
>>>> ------------------ Original ------------------
>>>> From: "Zheng Feng"<zh...@gmail.com>;
>>>> Date: Tue, Dec 25, 2018 04:05 PM
>>>> To: "dev"<de...@servicecomb.apache.org>;
>>>>
>>>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>>>
>>>>
>>>>
>>>> Thanks for sharing these performance tests and is it possible to share the
>>>> source codes if you are happy to open these tests ?
>>>> In term of the XA tests, I think the default transaction manager is
>>>> Atomikos ? I'm interested with running with the Narayana [1]
>>>>
>>>> So it could be very useful to share the source codes with the community !
>>>> Thanks,
>>>>
>>>> Zheng Feng
>>>>
>>>> [1] https://github.com/zhfeng/narayana-sharding-sphere
>>>>
>>>> 新道场开张了 <ts...@qq.com> 于2018年12月25日周二 上午10:51写道:
>>>>
>>>>> Saga Tx is slower than No Tx.
>>>>> TPS of saga is 1700 and No Tx is 2000 in test environment.
>>>>>
>>>>>
>>>>> About the load and memory usage, we will record in next performance.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> ------------------ Original ------------------
>>>>> From: "Zhang Yonglun"<zh...@apache.org>;
>>>>> Date: Mon, Dec 24, 2018 08:56 PM
>>>>> To: "dev"<de...@shardingsphere.apache.org>;
>>>>> Cc: "dev"<de...@servicecomb.apache.org>;
>>>>> Subject: Re: Saga transaction performance test with Sharding-JDBC
>>>>>
>>>>>
>>>>>
>>>>> Impressive!
>>>>> I am focused on the performance issue of ShardingSphere for a long time,
>>>>> and have done a little saga work before. But I still can't understand why
>>>>> saga Tx faster than No Tx. Is there something I missed?
>>>>>
>>>>> BTW, I noticed that second nice machine, and wonder what's the load and
>>>>> memory usage on it when testing.
>>>>>
>>>>>
>>>>> 新道场开张了 <ts...@qq.com> 于2018年12月24日周一 下午6:28写道:
>>>>>
>>>>>> Hi, everyone.
>>>>>>
>>>>>>
>>>>>> The feature of saga transaction in ShardingSphere has been basically
>>>>>> completed
>>>>>> by integrating servicecomb-saga-actuator.
>>>>>> Recently, we used Sharding-JDBC to test the performance of Saga
>>>>>> transactions.
>>>>>>
>>>>>>
>>>>>> There are results for two kinds of environments.
>>>>>>
>>>>>>
>>>>>> First result comes from local environment which including 2 cores and 16G
>>>>>> RAM
>>>>>> The connection pool size, thread pool size of saga-actuator and thread
>>>>>> pool size of Sharding-JDBC all are 50.
>>>>>>
>>>>>>
>>>>>> ---------------- result for local environment ----------------
>>>>>> |Tx Type|Thread Number|Average response(ms)| TPS |
>>>>>> | No Tx | 50 | 337 | 140 |
>>>>>> | saga | 50 | 395 | 120 |
>>>>>> | local | 50 | 323 |143|
>>>>>> | xa | 50 | 301 |154|
>>>>>> | No Tx | 100 | 605 | 158 |
>>>>>> | saga | 100 | 789 | 120 |
>>>>>>
>>>>>> ---------------- result for local environment ----------------
>>>>>>
>>>>>>
>>>>>> Second result comes from test environment which 256cores and 300+G RAM
>>>>>> The connection pool size, thread pool size of saga-actuator and thread
>>>>>> pool size of Sharding-JDBC all are 200.
>>>>>>
>>>>>>
>>>>>> ---------------- result for test environment ----------------
>>>>>> |Tx Type|Thread Number|Average response(ms)| TPS |
>>>>>> | No Tx | 200 | 95 |2002|
>>>>>> | saga | 200 | 351 |1700|
>>>>>>
>>>>>> | local | 200 | 64 |2868|
>>>>>> | xa | 200 | 98 |2012|
>>>>>> ---------------- result for test environment ----------------
>>>>>>
>>>>>>
>>>>>> And I do echo test with emptyTransport which do not execute SQL in saga,
>>>>>> the result is TPS 457 in local and 3200 in test environment.
>>>>>>
>>>>>>
>>>>>> if saga do persistence to log file, the TPS of saga will nose dive to 70
>>>>>> in local and 600+ in test environment
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Zhang Yonglun
>>>>> Apache ShardingSphere