Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of guillermo.barbero@spotbros.com
 designates 209.85.212.182 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CABsaHTP0NFzyvC+buK1ynU1w9q=-mfkMLO9MOoL4738fvLRurA@mail.gmail.com>
References: 
 <CANquPrAythHaZeb4oP3NmdDphsCwR_sUWm=j0geqPGYPP5-Jpw@mail.gmail.com>
 <CAPmnz8FuNNWFojmsD=j208gwH+qupg2K8CuUiVxu6jrsrhpMNg@mail.gmail.com>
 <CABsaHTM1Z7hc2GojzeGRi6+A8c5CTqOm-0nm3RYf+Zd_PaeGEg@mail.gmail.com>
 <CANquPrBjWRJ9b84y6Pm7SsBX-gkEj9kQY=-7vVTR-b7vBZ=YDQ@mail.gmail.com>
 <CAPmnz8Hsgud4f7iBPD05O=G4dqcvZmy8H3xj=H=jPQzWxfJaYg@mail.gmail.com>
 <CA+VSrLrFQxkioP3tQo_dAZXxzO4E25-Yb-e0nkZYMXkzSBLbRQ@mail.gmail.com>
 <CANquPrDrpEtfBy=q9pjmgBA48Kc3OGca+tR48UUwxQpxAfhcww@mail.gmail.com>
 <CABsaHTP0NFzyvC+buK1ynU1w9q=-mfkMLO9MOoL4738fvLRurA@mail.gmail.com>
From: Guillermo Barbero <guillermo.barbero@spotbros.com>
Date: Fri, 1 Feb 2013 12:04:15 +0100
Message-ID: 
 <CANquPrAe6tDaGM7f=mKQmiFB+b50CSStaq8910F17g=VnBC+Pw@mail.gmail.com>
Subject: Re: too many warnings of Heap is full
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

> What is the cardinality like on these indexes? Can you provide the
> schema creation for these two column families?

This is the schema of the CFs:

create column family CF_users
                with comparator = UTF8Type
                and column_metadata =
                [
                        {column_name: userSBCode, validation_class:
UTF8Type, index_type: KEYS},
                        {column_name: userEmail, validation_class:
UTF8Type, index_type: KEYS},
                        {column_name: userName, validation_class: UTF8Type},
                        {column_name: userLastName, validation_class: UTF8Type},
                        {column_name: userOwnPhoneKey,
validation_class: UTF8Type, index_type: KEYS},
                        {column_name: userOwnPhone,
validation_class: UTF8Type, index_type: KEYS},
                        {column_name: userPasswordMD5,
validation_class: UTF8Type},
                        {column_name: userDOB, validation_class: UTF8Type},
                        {column_name: userGender, validation_class: UTF8Type},
                        {column_name: userProfilePicMD5,
validation_class: UTF8Type},
                        {column_name: userAbout, validation_class: UTF8Type},
                        {column_name: userLastSession,
validation_class: UTF8Type}
                        {column_name: userMasterKey, validation_class: UTF8Type}
                ];

create column family CF_SBMessages
                with comparator = UTF8Type
                and column_metadata =
                [

                        {column_name: SBMessageId, validation_class:
UTF8Type, index_type: KEYS},
                        {column_name: fromSBCode, validation_class:
UTF8Type, index_type: KEYS},
                        {column_name: SBMessageDate, validation_class:
UTF8Type, index_type: KEYS},
                        {column_name: SBMessageType, validation_class:
UTF8Type},
                        {column_name: SBMessageText, validation_class:
UTF8Type},
                        {column_name: SBMessageAttachments,
validation_class: UTF8Type},
                ];


I've read about the importance of keeping the cardinality of the
secondary indexes low (great article at
http://pkghosh.wordpress.com/2011/03/02/cassandra-secondary-index-patterns/),
and I'm afraid that we did completely the opposite (we did consider
the secondary indexes as alternate indexes).
I guess here is some work to do to create other CFs to store these
secondary indexes.

Anyway, I still don't understand why did appear these peaks (by the
way, last night there wasn't any)