From user-return-23222-archive-asf-public=cust-asf.ponee.io@ignite.apache.org  Thu Nov 29 00:24:29 2018
Return-Path: <user-return-23222-archive-asf-public=cust-asf.ponee.io@ignite.apache.org>
X-Original-To: archive-asf-public@cust-asf.ponee.io
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by mx-eu-01.ponee.io (Postfix) with SMTP id 5CC4A180658
	for <archive-asf-public@cust-asf.ponee.io>; Thu, 29 Nov 2018 00:24:29 +0100 (CET)
Received: (qmail 94701 invoked by uid 500); 28 Nov 2018 23:24:28 -0000
Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@ignite.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@ignite.apache.org>
List-Post: <mailto:user@ignite.apache.org>
List-Id: <user.ignite.apache.org>
Reply-To: user@ignite.apache.org
Delivered-To: mailing list user@ignite.apache.org
Received: (qmail 94691 invoked by uid 99); 28 Nov 2018 23:24:28 -0000
Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Nov 2018 23:24:28 +0000
Received: from localhost (localhost [127.0.0.1])
	by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id D92C6C76BB
	for <user@ignite.apache.org>; Wed, 28 Nov 2018 23:24:27 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 3.173
X-Spam-Level: ***
X-Spam-Status: No, score=3.173 tagged_above=-999 required=6.31
	tests=[DKIM_ADSP_CUSTOM_MED=0.001, FORGED_GMAIL_RCVD=1,
	KAM_SHORT=0.001, NML_ADSP_CUSTOM_MED=1.2, RCVD_IN_DNSWL_NONE=-0.0001,
	SPF_HELO_PASS=-0.001, SPF_SOFTFAIL=0.972] autolearn=disabled
Received: from mx1-lw-eu.apache.org ([10.40.0.8])
	by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024)
	with ESMTP id hyeNKPSAjB8y for <user@ignite.apache.org>;
	Wed, 28 Nov 2018 23:24:26 +0000 (UTC)
Received: from n6.nabble.com (n6.nabble.com [162.255.23.37])
	by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id C358760ED9
	for <user@ignite.apache.org>; Wed, 28 Nov 2018 22:56:17 +0000 (UTC)
Received: from n6.nabble.com (localhost [127.0.0.1])
	by n6.nabble.com (Postfix) with ESMTP id 108EBAC0C098
	for <user@ignite.apache.org>; Wed, 28 Nov 2018 15:56:17 -0700 (MST)
Date: Wed, 28 Nov 2018 15:56:17 -0700 (MST)
From: yongjec <yongjec@gmail.com>
To: user@ignite.apache.org
Message-ID: <1543445777065-0.post@n6.nabble.com>
In-Reply-To: <1543445119917-0.post@n6.nabble.com>
References: <1543445119917-0.post@n6.nabble.com>
Subject: Re: Slow select distinct query on primary key
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Here is my Ignite server configuration.

<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="grid.cfg"
class="org.apache.ignite.configuration.IgniteConfiguration">

        
        <property name="dataStorageConfiguration">
            <bean
class="org.apache.ignite.configuration.DataStorageConfiguration">
                
                <property name="defaultDataRegionConfiguration">
                    <bean
class="org.apache.ignite.configuration.DataRegionConfiguration">
                        <property name="name" value="Default_Region"/>
                        
                        <property name="maxSize" value="#{48L * 1024 * 1024
* 1024}"/>
                        
                        <property name="metricsEnabled" value="true"/>
                    </bean>
                </property>
            </bean>
        </property>

        
        <property name="peerClassLoadingEnabled" value="true"/>

        <property name="discoverySpi">
            <bean
class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi">
                <property name="ipFinder">
                    <bean
class="org.apache.ignite.spi.discovery.tcp.ipfinder.vm.TcpDiscoveryVmIpFinder">
                        <property name="addresses">
                            <list>
                                <value>127.0.0.1:47500..47509</value>
                            </list>
                        </property>
                    </bean>
                </property>
            </bean>
        </property>

        <property name="communicationSpi">
            <bean
class="org.apache.ignite.spi.communication.tcp.TcpCommunicationSpi">
                <property name="messageQueueLimit" value="256"/>
            </bean>
        </property>

        
    </bean>
</beans>


And here are my JVM heap flags.

ignite.sh -J-Xms8g -J-Xmx16g
/home/ansible/ignite/apache-ignite-fabric-2.6.0-bin/config/poc1.xml




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/