ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "swy (Jira)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-12374) Too low performance ~200TPS for single ODBC client
Date Wed, 27 Nov 2019 04:04:00 GMT

    [ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16983154#comment-16983154
] 

swy commented on IGNITE-12374:
------------------------------

[~isapego] I have post in user list as well but not helpful. I did profiling as well

Ignite server hotspot during the run, seems like there are locks in Ignite consume most of
the time. means expect Multi instnace to perform?


 !profiling01.png! 

threadump(please refer to attachment for complete dump),

"client-connector-#157" - Thread t@194

   java.lang.Thread.State: WAITING
        at sun.misc.Unsafe.park(Native Method)
        - parking to wait for <46ac352c> (a java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject)
        at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
        at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:2039)
        at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:442)
        at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:1074)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1134)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
   Locked ownable synchronizers:
        - None

 !profling02.png! 


>From application profling, most of the time consumed by Ignite sql execution which looks
normal to me. Any advice?

 !profiling03.png! 

 [^threaddump-1573207804944.tdump] 




> Too low performance ~200TPS for single ODBC client
> --------------------------------------------------
>
>                 Key: IGNITE-12374
>                 URL: https://issues.apache.org/jira/browse/IGNITE-12374
>             Project: Ignite
>          Issue Type: Improvement
>          Components: clients, odbc
>    Affects Versions: 2.7.5
>         Environment: Ignite server run on top of Kubernetes, with 2 server nodes, persistence
enabled. Both CPU and RAM at server/client server is sufficient according to system reports.
>            Reporter: swy
>            Priority: Major
>         Attachments: odbcsample.allchar.rebind.cc, odbcsample.cc, profiling01.png, profiling03.png,
profling02.png, threaddump-1573207804944.tdump, values.yaml
>
>
> Hi, in our test ignite performance with ODBC connection is too bad to proceed with product
integration. It is about ~200 TPS, each transaction with select+update operation.
> Please refer to attach sample program. It is just a simple test case. 
> Based on the profiling most of the time consumed by sql execution. Please advice if the
application did not do the right thing.
> Thank you.
> local ignite server, but the result same to remote container Ignite deployment too.
> cat /etc/apache-ignite/my-config.xml
> <?xml version="1.0" encoding="UTF-8"?>
> <beans xmlns="http://www.springframework.org/schema/beans"
>        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>        xsi:schemaLocation="http://www.springframework.org/schema/beans
>         http://www.springframework.org/schema/beans/spring-beans.xsd">
>     <bean id="ignite.cfg" class="org.apache.ignite.configuration.IgniteConfiguration">
>         <property name="clientConnectorConfiguration">
>             <bean class="org.apache.ignite.configuration.ClientConnectorConfiguration"/>
>         </property>
>         <property name="binaryConfiguration">
>             <bean class="org.apache.ignite.configuration.BinaryConfiguration">
>                 <property name="compactFooter" value="false"/>
>                 <property name="idMapper">
>                     <bean class="org.apache.ignite.binary.BinaryBasicIdMapper">
>                         <property name="lowerCase" value="true"/>
>                     </bean>
>                 </property>
>             </bean>
>         </property>
>     </bean>
> </beans>
> g++ -I/usr/include -I./ignite/binary/include -I./ignite/common/include -I./ignite/common/os/linux/include
-I./ignite/common/os/win/include -I./ignite/core/include -I./ignite/jni/include odbcsample.cc
-o odbcsample -lodbc -L./ignite-libs/libignite.so -L./ignite-libs/libignite-odbc.so



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message