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
