Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-12374

Too low performance ~200TPS for single ODBC client

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Information Provided
    • Affects Version/s: 2.7.5
    • Fix Version/s: None
    • Component/s: clients, odbc
    • Labels:
      None
    • 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.

      Description

      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

        Attachments

        1. my-config-zstan.xml
          2 kB
          Stanilovsky Evgeny
        2. odbcsample
          46 kB
          Stanilovsky Evgeny
        3. screenshot-1.png
          35 kB
          swy
        4. ignite-logs-config-source-20191129.zip
          8.77 MB
          swy
        5. ignite-logs-config-source-20191128.zip
          539 kB
          swy
        6. ignite-9bb53f34.0.log
          267 kB
          swy
        7. snapshot-1574845275597.nps
          12 kB
          swy
        8. threaddump-1574845414243.tdump
          114 kB
          swy
        9. threaddump-1573207804944.tdump
          119 kB
          swy
        10. profiling03.png
          74 kB
          swy
        11. profling02.png
          83 kB
          swy
        12. profiling01.png
          110 kB
          swy
        13. odbcsample.allchar.rebind.cc
          16 kB
          swy
        14. values.yaml
          10 kB
          swy
        15. odbcsample.cc
          15 kB
          swy

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              yow swy
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: