Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 98180 invoked from network); 2 Sep 2010 07:09:15 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 2 Sep 2010 07:09:15 -0000 Received: (qmail 11366 invoked by uid 500); 2 Sep 2010 07:09:14 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 11127 invoked by uid 500); 2 Sep 2010 07:09:11 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 11119 invoked by uid 99); 2 Sep 2010 07:09:10 -0000 Received: from Unknown (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Sep 2010 07:09:10 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of justus.thorvaldsson@svenskaspel.se designates 62.20.83.49 as permitted sender) Received: from [62.20.83.49] (HELO piff.svenskaspel.se) (62.20.83.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Sep 2010 07:08:47 +0000 Received: from rsbgchs01.ad.spel.se (Not Verified[172.23.1.94]) by piff.svenskaspel.se with MailMarshal (v6,8,2,9371) (using TLS: SSLv23) id ; Thu, 02 Sep 2010 09:07:14 +0200 Received: from RSBGMBS01.ad.spel.se ([172.23.1.91]) by rsbgchs01.ad.spel.se ([172.23.1.94]) with mapi; Thu, 2 Sep 2010 09:08:26 +0200 From: Thorvaldsson Justus To: "'user@cassandra.apache.org'" Date: Thu, 2 Sep 2010 09:08:25 +0200 Subject: SV: about insert benchmark Thread-Topic: about insert benchmark Thread-Index: ActKbGe+mvxpuqn3RGOOXnR7MCiohwAAQv2Q Message-ID: <0ABFAD1D323E3C4DA9A7D542DC99F714AA1C333520@RSBGMBS01.ad.spel.se> References: In-Reply-To: Accept-Language: en-US, sv-SE Content-Language: sv-SE X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US, sv-SE Content-Type: multipart/alternative; boundary="_000_0ABFAD1D323E3C4DA9A7D542DC99F714AA1C333520RSBGMBS01adsp_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_0ABFAD1D323E3C4DA9A7D542DC99F714AA1C333520RSBGMBS01adsp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Batchmutate insert? Can be package size that differ if not nr threads sendi= ng data to Cassandra nodes. Fr=E5n: ChingShen [mailto:chingshenchen@gmail.com] Skickat: den 2 september 2010 08:59 Till: user@cassandra.apache.org =C4mne: Re: about insert benchmark Hi Daniel, I have 4 nodes in my cluster, and run a benchmark on node A in Java. P.S. Replication =3D 3 Shen On Thu, Sep 2, 2010 at 2:49 PM, vineet daniel > wrote: Hi Ching You are inserting using php,perl,python,java or ? and is cassandra installe= d locally or on a network system and is it a single system or you have a cl= uster of nodes. I know I've asked you many questions but the answers will h= elp immensely to assess the results. Anyways congrats on getting better results :-) . _______________________________________ Regards Vineet Daniel +918106217121 _______________________________________ Let your email find you.... On Thu, Sep 2, 2010 at 11:39 AM, ChingShen > wrote: Hi all, I run a benchmark with my own code and found that the 100000 inserts perf= ormance is better than others, Why? Can anyone explain it? Thanks. Partitioner =3D OPP CL =3D ONE =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 1000 records insert one:201 ms insert per:0.201 ms insert thput:4975.1245 ops/sec =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 10000 records insert one:1950 ms insert per:0.195 ms insert thput:5128.205 ops/sec =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 100000 records insert one:15576 ms insert per:0.15576 ms insert thput:6420.134 ops/sec =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 500000 records insert one:82177 ms insert per:0.164354 ms insert thput:6084.4272 ops/sec Shen --_000_0ABFAD1D323E3C4DA9A7D542DC99F714AA1C333520RSBGMBS01adsp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Batchmutate insert? Can be package size that differ if not n= r threads sending data to Cassandra nodes.

 

Fr=E5n: ChingShen [mailto:chingshenchen@gmail.com]
Skickat: den 2 september 2010 08:59
Till: user@cassandra.apache.org
=C4mne: Re: about insert benchmark

 

Hi Daniel,

   I have 4 nodes in my cluster, and run a benchmark on node A in Java.
  P.S. Replication =3D 3

Shen

On Thu, Sep 2, 2010 at 2:49 PM, vineet daniel <vineetdaniel@gmail.com> wrote= :

Hi Ching

You are inserting using php,perl,python,java or ? and is cassandra installe= d locally or on a network system and is it a single system or you have a clus= ter of nodes. I know I've asked you many questions but the answers will help immensely to assess the results.

Anyways congrats on getting better results :-) .


_______________________________________
Regards
Vineet Daniel
+918106217121
_______________________________________

Let your email find you....

On Thu, Sep 2, 2010 at 11:39 AM, ChingShen <chingshenchen@gma= il.com> wrote:

Hi all,

  I run a benchmark with my own code and found that the 100000 inserts performance is better than others, Why?
 Can anyone explain it?

Thanks.

Partitioner =3D OPP
CL =3D ONE
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
1000 records
insert one:201 ms
insert per:0.201 ms
insert thput:4975.1245 ops/sec
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
10000 records
insert one:1950 ms
insert per:0.195 ms
insert thput:5128.205 ops/sec
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
100000 records
insert one:15576 ms
insert per:0.15576 ms
insert thput:6420.134 ops/sec
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
500000 records
insert one:82177 ms
insert per:0.164354 ms
insert thput:6084.4272 ops/sec

Shen

 

 

--_000_0ABFAD1D323E3C4DA9A7D542DC99F714AA1C333520RSBGMBS01adsp_--