1
by brian
clean slate |
1 |
# Can't run test of external client with embedded server
|
2 |
||
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
3 |
# Added SELECT 1; to stop client timeouts failing this test
|
4 |
||
5 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=20 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --commit=100 |
|
6 |
SELECT 1; |
|
7 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=20 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --commit=100 |
|
8 |
SELECT 1; |
|
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
9 |
--exec $DRIZZLE_SLAP --only-print --iterations=20 --query="select * from t1" --create="CREATE TABLE t1 (id int, name varchar(64)); INSERT INTO t1 VALUES (1, 'This is a test')" --delimiter=";" |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
10 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
11 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=20 --query="select * from t1" --create="CREATE TABLE t1 (id int, name varchar(64)); INSERT INTO t1 VALUES (1, 'This is a test')" --delimiter=";" --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
12 |
SELECT 1; |
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
13 |
--exec $DRIZZLE_SLAP --only-print --delimiter=";" --query="select * from t1;select * from t2" --create="CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); INSERT INTO t1 VALUES (1, 'This is a test'); insert into t2 values ('test', 'test2')" --engine="MEMORY,myisam" |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
14 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
15 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=20 --delimiter=";" --query="select * from t1;select * from t2" --create="CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); INSERT INTO t1 VALUES (1, 'This is a test'); insert into t2 values ('test', 'test2')" --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
16 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
17 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=20 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --create-schema=test_env --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
18 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
19 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=20 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --create-schema=test_env --auto-generate-sql-add-autoincrement --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
20 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
21 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
22 |
SELECT 1; |
319.1.1
by Grant Limberg
renamed all instances of MYSQL_ to DRIZZLE_ |
23 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
24 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
25 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=read --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
26 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
27 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
28 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
29 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=mixed --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
30 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
31 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-guid-primary --auto-generate-sql-load-type=update |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
32 |
SELECT 1; |
910.4.15
by Stewart Smith
is possible to get deadlock in a drizzleslap test case, we just remove the --commit instead |
33 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-guid-primary --auto-generate-sql-load-type=update --auto-generate-sql-execute-number=5 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
34 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
35 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-guid-primary --auto-generate-sql-load-type=key --auto-generate-sql-execute-number=5 --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
36 |
SELECT 1; |
319.1.1
by Grant Limberg
renamed all instances of MYSQL_ to DRIZZLE_ |
37 |
#--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-guid-primary --auto-generate-sql-load-type=key --auto-generate-sql-execute-number=5 --auto-generate-sql-secondary-indexes=3
|
38 |
||
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
39 |
--exec $DRIZZLE_SLAP --only-print --delimiter=";" --query="select * from t1;select * from t2" --create="CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); INSERT INTO t1 VALUES (1, 'This is a test'); insert into t2 values ('test', 'test2')" --engine="MEMORY,myisam" --post-query="SHOW TABLES" --pre-query="SHOW TABLES"; |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
40 |
SELECT 1; |
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
41 |
--exec $DRIZZLE_SLAP --only-print --delimiter=";" --query="select * from t1;select * from t2" --create="CREATE TABLE t1 (id int, name varchar(64)); create table t2(foo1 varchar(32), foo2 varchar(32)); INSERT INTO t1 VALUES (1, 'This is a test'); insert into t2 values ('test', 'test2')" --engine="MEMORY,myisam" --post-query="SHOW TABLES" --pre-query="SHOW TABLES" --number-of-queries=6 --commit=1; |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
42 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
43 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --detach=2 --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
44 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
45 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --timer-length=10 --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
46 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
47 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --timer-length=1 --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
48 |
SELECT 1; |
1531.2.7
by Vijay Samuel
updated slap |
49 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --delayed-start=1234 --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
50 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
51 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --number-blob-cols=2:1024/2048 --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
52 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
53 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --number-blob-cols=1:8197 --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
54 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
55 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --number-blob-cols=1:1024 --auto-generate-sql-select-columns="charcol1, blobcol1" --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
56 |
SELECT 1; |
1
by brian
clean slate |
57 |
# All this is really doing is making sure nothing crashes, there is no way
|
58 |
# to test the actual output (all non-deterministic)
|
|
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
59 |
--exec $DRIZZLE_SLAP --silent --auto-generate-sql --label="This is a test" --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
60 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
61 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --number-blob-cols=1:1024 --auto-generate-sql-select-columns="charcol1, blobcol1" --set-random-seed=2 --commit=100 |
1912.2.1
by Andrew Hutchings
Keep dtr client connection alive during lengthy drizzleslap tests (made longer when using valgrind) |
62 |
SELECT 1; |
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
63 |
--exec $DRIZZLE_SLAP --silent --concurrency=5 --iterations=1 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write,read --number-blob-cols=1:1024 --auto-generate-sql-select-columns="charcol1, blobcol1" --commit=100 |
1
by brian
clean slate |
64 |
|
373.1.9
by Monty Taylor
Added back mysqlslap as drizzleslap. Also made it C++ and removed DYNAMIC_STRING. |
65 |
CREATE SCHEMA drizzleslap; |
1
by brian
clean slate |
66 |
|
373.1.9
by Monty Taylor
Added back mysqlslap as drizzleslap. Also made it C++ and removed DYNAMIC_STRING. |
67 |
CREATE TABLE drizzleslap.t1 (id int, name varchar(64)); |
1
by brian
clean slate |
68 |
|
910.4.14
by Stewart Smith
Add --commit=100 to several drizzleslap runs in drizzleslap.test to dramatically reduce the number of fsync()s when running the test. |
69 |
--exec $DRIZZLE_SLAP --silent --iterations=20 --query="select * from t1" --query="INSERT INTO t1 VALUES (1, 'This is a test');" --delimiter=";" --commit=100 |
1
by brian
clean slate |
70 |
|
373.1.9
by Monty Taylor
Added back mysqlslap as drizzleslap. Also made it C++ and removed DYNAMIC_STRING. |
71 |
SELECT count(*) from drizzleslap.t1; |
1
by brian
clean slate |
72 |
|
520.1.18
by Brian Aker
A bunch more test fixes. |
73 |
drop table drizzleslap.t1; |
74 |
drop schema drizzleslap; |
|
75 |
||
1
by brian
clean slate |
76 |
# Now we will test to make sure we can destory the data if it happens to be
|
77 |
# in our way.
|
|
78 |
#
|
|
961.1.1
by Brian Aker
Increase slap test for more threads. |
79 |
|
80 |
# Concurrency
|
|
961.1.5
by Brian Aker
Test Mac can't handle the 128 connections for concurrency test. |
81 |
--exec $DRIZZLE_SLAP --silent --concurrency=32 --iterations=20 --number-int-cols=2 --number-char-cols=3 --auto-generate-sql --commit=100 |