[ https://issues.apache.org/jira/browse/IGNITE-12374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16984837#comment-16984837 ]
swy edited comment on IGNITE-12374 at 11/29/19 9:19 AM: -------------------------------------------------------- hi [~zstan], please check attachment ignite-logs-config-source-20191129.zip. It contain all information you need including sample app binary and ./run.sh to execute the test. 1. copy binary "odbcsample" to test dir. 2. copy run.sh to test dir. 3. open run.sh, modity the following for ignite server addr and port. ADDRESS="*localhost*" PORT="*10800*" 4. also point the LD_LIBRARY_PATH to your ignite libraries in run.sh export LD_LIBRARY_PATH=*${PWD}/ignite-libs*:$LD_LIBRARY_PATH for example in our lab ignite-libs dir contain, #./ignite-libs #total 47184 #drwxrwxr-x. 2 user1 user1 4096 Oct 28 11:11 . #drwxrwxr-x. 4 user1 user1 92 Nov 29 03:39 .. #-rw-rw-r--. 1 user1 user1 3093840 Aug 29 11:38 libignite-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 3093840 Aug 29 11:38 libignite-2.7.5.38010.so.0.0.0 #-rw-rw-r--. 1 user1 user1 8833950 Aug 29 11:38 libignite.a #-rw-rw-r--. 1 user1 user1 1697232 Oct 28 11:09 libignite-binary-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 678128 Oct 28 11:09 libignite-common-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 448896 Oct 28 11:08 libignite-jni-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 1255 Aug 29 11:38 libignite.lai #-rw-rw-r--. 1 user1 user1 9115128 Aug 21 18:35 libignite-odbc-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 9115128 Aug 21 18:35 libignite-odbc-2.7.5.38010.so.0.0.0 #-rw-rw-r--. 1 user1 user1 9115128 Aug 21 18:35 libignite-odbc.so #-rw-rw-r--. 1 user1 user1 3093840 Aug 29 11:38 libignite.so 5. you can now just run ./run.sh, it will generate data and test before output performance TPS. If you are interested in how the source code being compile, it is in the run.sh fyr. Let me know if you have issue. Thanks. PS. threaddump-1575017063829.tdump and snapshot generated from window at 16:42 on 29th ignite-9d152e2f.0.log, safepoint.log generated from server at 03:42 on 29th tdump and snapshot is ahead 13 hours was (Author: yow): hi [~zstan], please check attachment ignite-logs-config-source-20191129.zip. It contain all information you need including sample app binary and ./run.sh to execute the test. 1. copy binary "odbcsample" to test dir. 2. copy run.sh to test dir. 3. open run.sh, modity the following for ignite server addr and port. ADDRESS="*localhost*" PORT="*10800*" 4. also point the LD_LIBRARY_PATH to your ignite libraries in run.sh export LD_LIBRARY_PATH=*${PWD}/ignite-libs*:$LD_LIBRARY_PATH for example in our lab ignite-libs dir contain, #./ignite-libs #total 47184 #drwxrwxr-x. 2 user1 user1 4096 Oct 28 11:11 . #drwxrwxr-x. 4 user1 user1 92 Nov 29 03:39 .. #-rw-rw-r--. 1 user1 user1 3093840 Aug 29 11:38 libignite-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 3093840 Aug 29 11:38 libignite-2.7.5.38010.so.0.0.0 #-rw-rw-r--. 1 user1 user1 8833950 Aug 29 11:38 libignite.a #-rw-rw-r--. 1 user1 user1 1697232 Oct 28 11:09 libignite-binary-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 678128 Oct 28 11:09 libignite-common-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 448896 Oct 28 11:08 libignite-jni-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 1255 Aug 29 11:38 libignite.lai #-rw-rw-r--. 1 user1 user1 9115128 Aug 21 18:35 libignite-odbc-2.7.5.38010.so.0 #-rw-rw-r--. 1 user1 user1 9115128 Aug 21 18:35 libignite-odbc-2.7.5.38010.so.0.0.0 #-rw-rw-r--. 1 user1 user1 9115128 Aug 21 18:35 libignite-odbc.so #-rw-rw-r--. 1 user1 user1 3093840 Aug 29 11:38 libignite.so 5. you can now just run ./run.sh, it will generate data and test before output performance TPS. If you are interested in how the source code being compile, it is in the run.sh fyr. Let me know if you have issue. Thanks. > 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: ignite-9bb53f34.0.log, > ignite-logs-config-source-20191128.zip, > ignite-logs-config-source-20191129.zip, odbcsample.allchar.rebind.cc, > odbcsample.cc, profiling01.png, profiling03.png, profling02.png, > snapshot-1574845275597.nps, threaddump-1573207804944.tdump, > threaddump-1574845414243.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)