ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Jay <841519...@qq.com>
Subject insert so slow via JDBC thin driver
Date Thu, 14 Dec 2017 09:02:28 GMT
Hello, I am a new Ignite leaner. I want to insert 50,000,000 rows into a
table. Here,i got a problem.
When one host and one sever node, the speed of insert is about 2,000,000 per
minute,  the usage of cpu is 30-40%; however two hosts and two sever nodes,
about 100,000 per minute,and the usage of cpu is only 5%. It's so slow,what
can i do to improve the performance? Thanks.

my default-config.xml:
   <bean class="org.apache.ignite.configuration.IgniteConfiguration">
		<property name="peerClassLoadingEnabled" value="true"/>
		<property name="clientMode" value="false"/>
		<property name="memoryConfiguration">
				<property name="defaultMemoryPolicySize" value="19327352832"/>
				<property name="concurrencyLevel" value="16"/>
				<property name="pageSize" value="4096"/>
		<property name="cacheConfiguration">
					<property name="name" value="*"/>
					<property name="cacheMode" value="PARTITIONED"/>
					<property name="queryParallelism" value="4"/>
                    <property name="atomicityMode" value="ATOMIC"/>
                    <property name="backups" value="0"/>
					<property name="writeThrough" value="false"/>
				    <property name="readThrough" value="false"/>
				    <property name="writeBehindEnabled" value="false"/>
					<property name="rebalanceBatchSize" value="#{256L * 1024 * 1024}"/>
					<property name="rebalanceThrottle" value="0"/>
					<property name="rebalanceThreadPoolSize" value="8"/>
					<property name="copyOnRead" value="false"/>
        <property name="discoverySpi">
                <property name="ipFinder">
						<property name="addresses">

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

View raw message