cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Ellis <jbel...@gmail.com>
Subject Re: How to speed up "Waiting for schema agreement" for a single node Cassandra cluster?
Date Tue, 04 Oct 2011 14:19:41 GMT
Truncate is faster than drop + recreate.

On Tue, Oct 4, 2011 at 9:15 AM, Joseph Norton <norton@lovely.email.ne.jp> wrote:
>
> Hello.
>
> For unit test purposes, I have a single node Cassandra cluster.  I need to drop and
re-create several keyspaces between each test iteration.  This process takes approximately
10 seconds for a single node installation.
>
> Can you recommend any tricks or recipes to reduce the time required for such operations
and/or for "Waiting for schema agreement" to complete?
>
> regards,
>
> - Joe N.
>
>
>
>
> $ time ./setupDB.sh
> Deleteing cassandra keyspaces
> Connected to: "Foo" on 127.0.0.1/9160
> ed9c7fc0-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> ee8c36f0-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> eeb14b20-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> Insert data
> Creating cassandra keyspaces
> Connected to: "Foo" on 127.0.0.1/9160
> ef1a6d30-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> Authenticated to keyspace: Bars
> ef4af310-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> ef9bab20-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> efbceec0-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> f00e4310-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> f0589280-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> f0821380-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> f0c44ca0-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> Authenticated to keyspace: Baz
> f121d5f0-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> f1619e10-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> f18b4620-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> Authenticated to keyspace: Buz
> f1debd50-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> f20690a0-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> f25043d0-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> f29a1e10-ee91-11e0-0000-534d24a6e7f7
> Waiting for schema agreement...
> ... schemas agree across the cluster
> Inserting data in cassandra
> Connected to: "Foo" on 127.0.0.1/9160
> Authenticated to keyspace: Boo
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
> Value inserted.
>
> real    0m9.554s
> user    0m2.729s
> sys     0m0.194s
>
>
> Joseph Norton
> norton@alum.mit.edu
>
>
>
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com

Mime
View raw message