Hmm... Maybe disable compaction, since that can block schema changes. Otherwise the big win will be in https://issues.apache.org/jira/browse/CASSANDRA-1391.
On Tue, Oct 4, 2011 at 9:33 AM, Joseph Norton <nor...@lovely.email.ne.jp> wrote: > > I didn't consider using truncate because a set of potentially random Column > Families are created dynamically during the test. > > Are there any configuration knobs that could be adjusted for drop + recreate? > > thanks in advance, > > - Joe N > > > Joseph Norton > nor...@alum.mit.edu > > > > On Oct 4, 2011, at 11:19 PM, Jonathan Ellis wrote: > >> Truncate is faster than drop + recreate. >> >> On Tue, Oct 4, 2011 at 9:15 AM, Joseph Norton <nor...@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 >>> nor...@alum.mit.edu >>> >>> >>> >>> >> >> >> >> -- >> Jonathan Ellis >> Project Chair, Apache Cassandra >> co-founder of DataStax, the source for professional Cassandra support >> http://www.datastax.com > > -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com
