ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stanilovsky Evgeny (Jira)" <j...@apache.org>
Subject [jira] [Comment Edited] (IGNITE-12374) Too low performance ~200TPS for single ODBC client
Date Tue, 03 Dec 2019 07:28:00 GMT

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

Stanilovsky Evgeny edited comment on IGNITE-12374 at 12/3/19 7:27 AM:
----------------------------------------------------------------------

simple tuning give me perf boost:
===================================================
NumPartial: 50
NumCompleteRec: 2000
TolRec: 100000
Duration: 53 seconds
TPS: 1887
===================================================
what i do: 
1. change your config, will attach it (my-config-zstan.xml)
2. simple GC tuning: ignite.sh changing : 

{code:java}
if [ $version -eq 8 ] ; then
    JVM_OPTS="\
        -Xmx4g -Xmx4g -XX:+UseG1GC \
         ${JVM_OPTS}"
{code}

i hope its enough for u ?
further steps : remove bigdecimal, use index only with long or some simple types, tune your
network (my servers are all bare with real 10G network), ones more read perf tuning documentation.
is it ok ?


was (Author: zstan):
simple tuning give me perf boost:
===================================================
NumPartial: 50
NumCompleteRec: 2000
TolRec: 100000
Duration: 53 seconds
TPS: 1887
===================================================
what i do: 
1. change your config, will attach it (my-config-zstan.xml)
2. simple GC tuning: ignite.sh changing : 

{code:java}
if [ $version -eq 8 ] ; then
    JVM_OPTS="\
        -Xmx4g -Xmx4g -XX:+UseG1GC \
         ${JVM_OPTS}"
{code}

i hope its enough for u ?

> 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,
my-config-zstan.xml, odbcsample, odbcsample.allchar.rebind.cc, odbcsample.cc, profiling01.png,
profiling03.png, profling02.png, screenshot-1.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)

Mime
View raw message