Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of paulrbrown@gmail.com
 designates 74.125.83.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=content-type:mime-version:subject:from:in-reply-to:date
         :content-transfer-encoding:message-id:references:to:x-mailer;
        b=m4Q4R9LrjqXZLqf7zZyisAjhwAvu6DJ1T1hGEz3Fn8EHpbLYFjJ0z7A28MO9Xhb3zX
         dgwLCf8zVxZyP1gAO/NkH/E+BOcwRNbSBt1rzJQ3bny90TeXvwwdbI6IRvXNpG3zsoy/
         wJ/0tM+mMCnr8H8MQlMpABKFIX2tWKP5x7sSw=
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1078)
Subject: Re: cassandra instability
From: Paul Brown <paulrbrown@gmail.com>
In-Reply-To: <h2v815edeff1004161050h85a89630u463812c5f3d90d48@mail.gmail.com>
Date: Fri, 16 Apr 2010 10:58:43 -0700
Content-Transfer-Encoding: quoted-printable
Message-Id: <1F4A6075-0D59-47E5-A594-CBB9A84A2BD4@gmail.com>
References: <h2v815edeff1004161050h85a89630u463812c5f3d90d48@mail.gmail.com>
To: user@cassandra.apache.org


On Apr 16, 2010, at 10:50 AM, Lee Parker wrote:
> [...]
> I am trying to migrate data from mysql into the cluster using the =
following methodology:
> 1. get 500 rows (12 columns each) from mysql
> 2. build a batch_mutate to insert these rows into one CF (1 row =3D 1 =
row )
> 3. build a second batch_mutate to insert an index of those rows into a =
second CF ( 1 row =3D 1 column )
> 4. loop around and do it again until all data has migrated.

If you have row caching turned on and are putting a lot of data in each =
row, you might be causing the memory issues.  Maybe turn row caching =
off?

-- Paul