You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by 张刚 <zh...@gmail.com> on 2013/03/24 10:15:49 UTC
cassandra performance
Hello,
I am new to Cassandra.I do some test on a single machine. I install
Cassandra with a binary tarball distribution.
I create a CF to store the data that get from MySQL. The CF has the same
fields as the table in MySQL. So it looks like a table.
I do the same select from the CF in Cassandra and the table in MySQL,and I
find the processing time of MySQL is better than Cassandra.
So,I wander what are the advantages of Cassandra compare MySQL and how to
improve the performance of Cassandra.
Is this the right way to use Cassandra.
Re: cassandra performance
Posted by 张刚 <zh...@gmail.com>.
For example,each row represent a job record,it has fields like
"user","site","CPUTime","datasize","JobType"...
The fields in CF is fixed,just like a table.The query like this "select
CPUTime,User,site from CF(or tablename) where user=xxx and Jobtype=xxx"
Best regards
2013/3/24 cem <ca...@gmail.com>
> Hi,
>
> Could you provide some other details about your schema design and queries?
> It is very hard to tell anything.
>
> Regards,
> Cem
>
>
> On Sun, Mar 24, 2013 at 12:40 PM, dong.yajun <do...@gmail.com> wrote:
>
>> Hello,
>>
>> I'd suggest you to take look at the difference between Nosql and RDMS.
>>
>> Best,
>>
>> On Sun, Mar 24, 2013 at 5:15 PM, 张刚 <zh...@gmail.com> wrote:
>>
>>> Hello,
>>> I am new to Cassandra.I do some test on a single machine. I install
>>> Cassandra with a binary tarball distribution.
>>> I create a CF to store the data that get from MySQL. The CF has the same
>>> fields as the table in MySQL. So it looks like a table.
>>> I do the same select from the CF in Cassandra and the table in MySQL,and
>>> I find the processing time of MySQL is better than Cassandra.
>>> So,I wander what are the advantages of Cassandra compare MySQL and how
>>> to improve the performance of Cassandra.
>>> Is this the right way to use Cassandra.
>>>
>>>
>>
>>
>> --
>> *Ric Dong*
>>
>>
>
Re: cassandra performance
Posted by cem <ca...@gmail.com>.
Hi,
Could you provide some other details about your schema design and queries?
It is very hard to tell anything.
Regards,
Cem
On Sun, Mar 24, 2013 at 12:40 PM, dong.yajun <do...@gmail.com> wrote:
> Hello,
>
> I'd suggest you to take look at the difference between Nosql and RDMS.
>
> Best,
>
> On Sun, Mar 24, 2013 at 5:15 PM, 张刚 <zh...@gmail.com> wrote:
>
>> Hello,
>> I am new to Cassandra.I do some test on a single machine. I install
>> Cassandra with a binary tarball distribution.
>> I create a CF to store the data that get from MySQL. The CF has the same
>> fields as the table in MySQL. So it looks like a table.
>> I do the same select from the CF in Cassandra and the table in MySQL,and
>> I find the processing time of MySQL is better than Cassandra.
>> So,I wander what are the advantages of Cassandra compare MySQL and how to
>> improve the performance of Cassandra.
>> Is this the right way to use Cassandra.
>>
>>
>
>
> --
> *Ric Dong*
>
>
Re: cassandra performance
Posted by "dong.yajun" <do...@gmail.com>.
Hello,
I'd suggest you to take look at the difference between Nosql and RDMS.
Best,
On Sun, Mar 24, 2013 at 5:15 PM, 张刚 <zh...@gmail.com> wrote:
> Hello,
> I am new to Cassandra.I do some test on a single machine. I install
> Cassandra with a binary tarball distribution.
> I create a CF to store the data that get from MySQL. The CF has the same
> fields as the table in MySQL. So it looks like a table.
> I do the same select from the CF in Cassandra and the table in MySQL,and I
> find the processing time of MySQL is better than Cassandra.
> So,I wander what are the advantages of Cassandra compare MySQL and how to
> improve the performance of Cassandra.
> Is this the right way to use Cassandra.
>
>
--
*Ric Dong*
Re: cassandra performance
Posted by aaron morton <aa...@thelastpickle.com>.
> "select CPUTime,User,site from CF(or tablename) where user=xxx and Jobtype=xxx"
Even thought cassandra has tables and looks like a RDBMS it's not.
Queries with multiple secondary index clauses will not perform as well as those with none.
There is plenty of documentation here http://www.datastax.com/docs , start with the help on data modelling to get an idea of how Cassandra is different.
Cheers
-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand
@aaronmorton
http://www.thelastpickle.com
-----------------
Aaron Morton
Freelance Cassandra Consultant
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 25/03/2013, at 4:32 AM, Derek Williams <de...@fyrie.net> wrote:
> Biggest advantage of Cassandra is it's ability to scale linearly as more nodes are added and it's ability to handle node failures.
>
> Also to get the maximum performance from Cassandra you need to be making multiple requests in parallel.
>
>
> On Sun, Mar 24, 2013 at 3:15 AM, 张刚 <zh...@gmail.com> wrote:
> Hello,
> I am new to Cassandra.I do some test on a single machine. I install Cassandra with a binary tarball distribution.
> I create a CF to store the data that get from MySQL. The CF has the same fields as the table in MySQL. So it looks like a table.
> I do the same select from the CF in Cassandra and the table in MySQL,and I find the processing time of MySQL is better than Cassandra.
> So,I wander what are the advantages of Cassandra compare MySQL and how to improve the performance of Cassandra.
> Is this the right way to use Cassandra.
>
>
>
>
> --
> Derek Williams
Re: cassandra performance
Posted by Derek Williams <de...@fyrie.net>.
Biggest advantage of Cassandra is it's ability to scale linearly as more
nodes are added and it's ability to handle node failures.
Also to get the maximum performance from Cassandra you need to be making
multiple requests in parallel.
On Sun, Mar 24, 2013 at 3:15 AM, 张刚 <zh...@gmail.com> wrote:
> Hello,
> I am new to Cassandra.I do some test on a single machine. I install
> Cassandra with a binary tarball distribution.
> I create a CF to store the data that get from MySQL. The CF has the same
> fields as the table in MySQL. So it looks like a table.
> I do the same select from the CF in Cassandra and the table in MySQL,and I
> find the processing time of MySQL is better than Cassandra.
> So,I wander what are the advantages of Cassandra compare MySQL and how to
> improve the performance of Cassandra.
> Is this the right way to use Cassandra.
>
>
--
Derek Williams