Re: QUORUM writes, QUORUM reads -- and eventual consistency

2012-08-24 Thread Derek Williams
to, when 2 were required to guarantee consistency. The intent to do a quorum write is not the same as actually doing one. -- Derek Williams

Re: force gc?

2012-09-02 Thread Derek Williams
looked into it too much, but I think forcing a major compaction when using leveled strategy doesn't have the same effect as with size tiered. -- Derek Williams

Re: Option for ordering columns by timestamp in CF

2012-10-12 Thread Derek Williams
-- Tyler Hobbs DataStax http://datastax.com/ -- Derek Williams

Re: Pagination

2012-11-27 Thread Derek Williams
)) Probably more efficient but generally page numbers go backwards ie page 1 has newest content so this would complicate things when writing data and cause load if logic was included to reorganise page numbers etc. Cheers Sam http://Newsarc.net -- Derek Williams

Re: CQL3 Blob Value Literal?

2013-01-10 Thread Derek Williams
) and at the DataStax 1.2 docs. As for why I'd want such a thing, I just wanted to initialize some test values for a blob column with cqlsh. Thanks! -- Derek Williams

Re: LCS not removing rows with all TTL expired columns

2013-01-17 Thread Derek Williams
** ** ** ** ** ** ** ** -- Derek Williams signature-logo29.pngsignature-best-employer-logo4823.png

Re: LCS not removing rows with all TTL expired columns

2013-01-22 Thread Derek Williams
, Derek Williams de...@fyrie.net wrote: When you ran this test, is that the exact schema you used? I'm not seeing where you are setting gc_grace to 0 (although I could just be blind, it happens). On Thu, Jan 17, 2013 at 5:01 PM, Bryan Talbot btal...@aeriagames.comwrote: I'm able to reproduce

Re: Is this how to read the output of nodetool cfhistograms?

2013-01-23 Thread Derek Williams
0 0 -- Derek Williams

Re: Cassandra pending compaction tasks keeps increasing

2013-01-24 Thread Derek Williams
finishes. We only have one CF and right now the number of SSTable is around 15000, write latency is still under 0.1ms. Anything needs to be concerned? Or anything I can do to reduce the number of pending compaction? Thanks. -Wei -- Derek Williams

Re: astyanax connection ring describe discovery

2013-01-25 Thread Derek Williams
are you using? For now, we had ot add all nodes ot the seeds list instead so it distributes amongst all nodes. Thanks, Dean -- Derek Williams

Re: Cassandra pending compaction tasks keeps increasing

2013-01-28 Thread Derek Williams
at 400K? Maybe try that first. Thanks. -Wei - Original Message - From: Derek Williams de...@fyrie.net To: user@cassandra.apache.org, Wei Zhu wz1...@yahoo.com Sent: Thursday, January 24, 2013 11:06:00 PM Subject: Re: Cassandra pending compaction tasks keeps increasing Increasing

Re: Cassandra pending compaction tasks keeps increasing

2013-02-01 Thread Derek Williams
On 29/01/2013, at 8:59 AM, Derek Williams de...@fyrie.net wrote: I could be wrong about this, but when repair is run, it isn't just values that are streamed between nodes, it's entire sstables. This causes a lot of duplicate data to be written which was already correct on the node, which

Re: how to read only from local DC without LOCAL_QUORUM?

2013-02-25 Thread Derek Williams
, but RF:3 is not acceptable for us. Can we force somehow cassandra not to lookup keys in remote CD? Thanks for your answers! -- Derek Williams

Re: Question regarding multi datacenter and LOCAL_QUORUM

2013-03-20 Thread Derek Williams
behavior for the get_slice requests. This is observed throughout the log. ** ** Thanks much ** ** ** ** ** ** -- Derek Williams

Re: Question regarding multi datacenter and LOCAL_QUORUM

2013-03-20 Thread Derek Williams
...@genesyslab.comwrote: Further information, in AZ1, when 143, 145, and 146 are up, all goes well. But when, say 143, fails, the client receives a TIMEOUT failure – even though 145 and 146 are up. ** ** *From:* Derek Williams [mailto:de...@fyrie.net] *Sent:* Wednesday, March 20, 2013 11:50 AM

Re: cassandra performance

2013-03-24 Thread Derek Williams
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: Setting column to null

2012-06-12 Thread Derek Williams
support. My only other wishlist item is the ability to set the timestamp, ttl, and consistency level using prepared statements. -- Derek Williams

Re: select count(*) returns 10000

2012-06-12 Thread Derek Williams
or written to be relied upon by any person as advice. Moon Capital does not waive confidentiality or privilege as a result of this email. -- Derek Williams

Re: Supercolumn behavior on writes

2012-06-13 Thread Derek Williams
this way as it is more predictable, but of course others will have a different opinion. -- Derek Williams

Re: composite key

2012-06-22 Thread Derek Williams
partitioner to store the rows in order, but that is not recommended because you wont get even distribution throughout our cluster. I think your best bet though is just use the master_id for your row key, and then use composite columns that begin with the client_id. -- Derek Williams

Re: Dynamic CF

2012-07-06 Thread Derek Williams
. See my earlier post on the subject: http://www.mail-archive.com/user@cassandra.apache.org/msg23160.html You can have a dynamic table with CQL3, you just can't have a table with a mix of dynamic/nondynamic columns. -- Derek Williams

RE: Dynamic CF

2012-07-06 Thread Derek Williams
a table with even more rows; I wanted wide rows so the reads and writes would be more efficient. ** ** *From:* Derek Williams [mailto:de...@fyrie.net] *Sent:* Friday, July 06, 2012 4:58 PM *To:* user@cassandra.apache.org *Subject:* Re: Dynamic CF ** ** On Fri, Jul 6, 2012 at 2

RE: Dynamic CF

2012-07-06 Thread Derek Williams
To clarify, I haven't tested it with compact storage, but it will only use the first part of the primary key without compact storage. On Jul 6, 2012 4:50 PM, Derek Williams de...@fyrie.net wrote: Actually, my solution only makes a row for each unique value of the first part of the primary key

Re: help using org.apache.cassandra.cql3

2012-07-10 Thread Derek Williams
just contains server classes. Everything you need should be in org.apache.cassandra.thrift. To use cql3 I just use the client methods 'execute_cql_query', 'prepare_cql_query' and 'execute_prepared_cql_query', after setting cql version to '3.0.0'. -- Derek Williams

Re: Cassandra 1.0 row deletion

2012-08-16 Thread Derek Williams
, then it wont be deleted. More info here: http://wiki.apache.org/cassandra/DistributedDeletes -- Derek Williams

Re: hector or astyanax

2013-05-05 Thread Derek Williams
-- Derek Williams

Re: hector or astyanax

2013-05-05 Thread Derek Williams
a driver that with multiplex *should be* faster in *some* cases. However I have never seen any evidence to back up this theory anecdotal or otherwise. In fact https://github.com/pchalamet/cassandra-sharp/pull/24 On Sun, May 5, 2013 at 4:09 PM, Derek Williams de...@fyrie.net wrote: The binary

Re: hector or astyanax

2013-05-06 Thread Derek Williams
@cassandra.apache.org Date: Sunday, May 5, 2013 5:27 PM To: cassandra users user@cassandra.apache.orgmailto: user@cassandra.apache.orgmailto:user@cassandra.apache.orgmailto: user@cassandra.apache.org Subject: Re: hector or astyanax On Sun, May 5, 2013 at 1:09 PM, Derek Williams de...@fyrie.netmailto

Re: Uneven effective ownership

2013-11-13 Thread Derek Williams
% 113427455640312821154458202477256070485 1.1.1.6 eu-west 1c Up Normal 75.39 GB 16.67% 141784319550391026443072753096570088105 What am I missing here? TIA, Katriel -- Derek Williams