Re: Cassandra and GPU's...

2015-12-01 Thread Rock Zhang
unsubscribe On Tue, Dec 1, 2015 at 5:55 PM, james anderson wrote: > good morning; > > On 2015-12-01, at 21:53, Steve Robenalt wrote: > > Hi James, > > Yup, the analytics side of database usage is ripe with possibilities, as > the site at your link shows. > > > that case is not the “analytics”,

Re: Help diagnosing performance issue

2015-11-19 Thread rock zhang
unsubscribe. > On Nov 19, 2015, at 3:58 PM, Antoine Bonavita wrote: > > Sebastian, > > I took into account your suggestion and set max_sstable_age_days to 1. > > I left the TTL at 432000 and the gc_grace_seconds at 172800. So, I expect > SSTable older than 7 days to get deleted. Am I right ?

Re: unsubscribe

2015-10-14 Thread rock zhang
unsubscribe > On Oct 14, 2015, at 7:28 AM, Alain RODRIGUEZ wrote: > > From http://cassandra.apache.org/#lists > --> just email user-unsubscr...@cassandra.apache.org > > > > Alain > > 2015-10-14 14:29 GMT+02:0

Node in DL status cannot be removed

2015-10-07 Thread Rock Zhang
Hi All, After I decommission the node, i see the node status is DL and always there, even after i removed the node, anybody knows how to remove it ? Many thanks. ubuntu@ip-172-31-30-145:~$ nodetool status Datacenter: DC1 === Status=Up/Down |/ State=Normal/Leaving/Joining/Moving

Regarding " node tool move "

2015-09-24 Thread Rock Zhang
Hi All, I want to manually move some token from one hostA to host B, i do not fully understand this command, * move- Move node on the token ring to a new token* Say host A has token: (i got it with nodetool info -T) Token : -9096422322933500933 Token :

Re: Cassandra adding node issue (no UJ status)

2015-09-20 Thread Rock Zhang
led" > > When I encounter this issue, I make an attempt to bootstrap the new node > again. If that doesn't help, I run a repair on the new node. > > > On Tue, Sep 15, 2015 at 3:14 AM, Rock Zhang wrote: > >> Hi All, >> >> >> Now I got a probl

Cassandra adding node issue (no UJ status)

2015-09-15 Thread Rock Zhang
Hi All, Now I got a problem everything when add new node, the data is not balance again, just add it as new node. Originally I saw the UJ status, anybody experienced this kind of issue ? I don't know what changed . ubuntu@ip-172-31-15-242:/etc/cassandra$ nodetool status rawdata Datacenter: D

Re: OOM when Adding host

2015-08-10 Thread rock zhang
I logged the open files every 10 mins, last record is : lsof -p $cassadnraPID | wc -l 74728 lsof |wc-l 5887913 # this is a very large number, don't know why. After OOM the open file numbers back to few hundreds (lsof | wc -l ). On Aug 10, 2015, at 9:59 AM, rock zhang wrote:

Re: OOM when Adding host

2015-08-10 Thread rock zhang
My Cassandra version is 2.1.4. Thanks Rock On Aug 10, 2015, at 9:52 AM, rock zhang wrote: > Hi All, > > Currently i have three hosts. The data is not balanced, one is 79G, another > two have 300GB. When I adding a new host, firstly I got "too many open files" > e

OOM when Adding host

2015-08-10 Thread rock zhang
Hi All, Currently i have three hosts. The data is not balanced, one is 79G, another two have 300GB. When I adding a new host, firstly I got "too many open files" error, then i changed file open limit from 100,000 to 1, 000, 000. Then I got OOM error. Should I change the limits to 20, inst

Re: only grant select , but still can modify data

2015-08-06 Thread Rock Zhang
versions are you using? Did you check that the DevCenter connection properties are using the "readonly" account and that any existing connection was closed and re-opened? Did you get the expected result with cqlsh? dan On Mon, Aug 3, 2015 at 7:12 PM, rock zhang wrote: > Hi All,

only grant select , but still can modify data

2015-08-03 Thread rock zhang
Hi All, I want to create a readonly account, so i run the following command following: http://docs.datastax.com/en/cassandra/1.2/cassandra/security/security_config_native_authenticate_t.html CREATE USER readonly WITH PASSWORD '' ; GRANT SELECT ON ALL KEYSPACES TO readonly; Then I login De

if seed is diff on diff nodes, any problem ?

2015-07-25 Thread rock zhang
Hi All, I have 6 node, most of them are using node1 as seed, but I just find out 2 nodes are using node3 as seed, but everything looks fine. Does that mean seed node does not have to be same on all nodes ? Thanks Rock

Re: After clean up, the whole system is down

2015-07-25 Thread rock zhang
I tried to restart , but always get out of memory error. Then I changed to use new seed node, then it works. I guess the possible reason is I run cleanup twice ? I need to run repair to fix some inconsistency issue, right ? Thanks Rock On Jul 25, 2015, at 8:39 AM, rock zhang wrote: >

After clean up, the whole system is down

2015-07-25 Thread rock zhang
) ~[na:1.7.0_80] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_80] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80] On Jul 24, 2015, at 5:10 PM, Robert Coli wrote: > On Fri, Jul 24, 2015 at 5:03 PM, rock zhang wrote: &

Re: Nodetool cleanup takes long time and no progress

2015-07-24 Thread rock zhang
, at 4:58 PM, rock zhang wrote: > Thank you Jeff. I just added one more node, so i want to delete moved tokens. > > ubuntu@ip-172-31-30-145:~$ nodetool compactionstats > pending tasks: 1413 >compaction type keyspace table completed totaluni

Re: Nodetool cleanup takes long time and no progress

2015-07-24 Thread rock zhang
ou trying to clean up space > after issuing a lot of deletes? > > > > > > On 7/24/15, 3:55 PM, "rock zhang" wrote: > >> Hi All, >> >> After I added node, I run node tool cleanup on the old notes , but it takes >> forever, no error mes

Nodetool cleanup takes long time and no progress

2015-07-24 Thread rock zhang
Hi All, After I added node, I run node tool cleanup on the old notes , but it takes forever, no error message, and I don't see space are freed. What should I do ? Repair first ? Thanks Rock