Alchemy speed in the cloud

[Jak Sprats]

I set up two ec2 m1.large instances and ran the "test" table benchmark
from one m1.large(client) to another(server).

The command "./redisql-benchmark -h 10.212.122.31 -n 1000000 -r
1000000 -c 200 -T"
Runs 200 concurrent connections and tests 1Million INSERT/SELECT/
UPDATE/DELETEs and then tests redis' SET/GET/DELs for a control group.

The speeds are faster than mysql on bare metal ... and I think these
two instance on ec2 were not located close to another (i.e. many racks
between them), so numbers can be higher if you get lucky w/ your
instances ...

[ec2-user@ip-10-243-110-79 JakSprats-Redisql-a3e3bfc]$ ./redisql-
benchmark -h 10.212.122.31 -n 1000000 -r 1000000 -c 200 -T
test_insert_test_table
====== INSERT TEST ======
1000075 requests completed in 29.77 seconds
200 parallel clients
3 bytes payload
keep alive: 1

0.01% <= 2 milliseconds
1.36% <= 3 milliseconds
52.16% <= 4 milliseconds
87.40% <= 5 milliseconds
89.11% <= 6 milliseconds
89.79% <= 7 milliseconds
90.08% <= 8 milliseconds
90.26% <= 9 milliseconds
90.33% <= 10 milliseconds
90.42% <= 11 milliseconds
90.55% <= 12 milliseconds
90.85% <= 13 milliseconds
92.43% <= 14 milliseconds
94.07% <= 15 milliseconds
94.51% <= 16 milliseconds
94.74% <= 17 milliseconds
94.97% <= 18 milliseconds
95.15% <= 19 milliseconds
95.26% <= 20 milliseconds
95.38% <= 21 milliseconds
95.51% <= 22 milliseconds
95.83% <= 23 milliseconds
98.06% <= 24 milliseconds
99.44% <= 25 milliseconds
99.75% <= 26 milliseconds
99.82% <= 27 milliseconds
99.88% <= 28 milliseconds
99.91% <= 29 milliseconds
99.92% <= 30 milliseconds
99.94% <= 31 milliseconds
99.95% <= 32 milliseconds
99.96% <= 33 milliseconds
99.98% <= 34 milliseconds
99.99% <= 35 milliseconds
99.99% <= 39 milliseconds
99.99% <= 40 milliseconds
99.99% <= 204 milliseconds
100.00% <= 205 milliseconds
100.00% <= 206 milliseconds
100.00% <= 207 milliseconds
100.00% <= 208 milliseconds
100.00% <= 209 milliseconds
100.00% <= 213 milliseconds
33587.74 requests per second

test_select_test_table
====== SELECT TEST ======
1000025 requests completed in 30.90 seconds
200 parallel clients
3 bytes payload
keep alive: 1

0.03% <= 2 milliseconds
2.78% <= 3 milliseconds
40.21% <= 4 milliseconds
72.24% <= 5 milliseconds
83.29% <= 6 milliseconds
86.90% <= 7 milliseconds
88.05% <= 8 milliseconds
88.62% <= 9 milliseconds
89.00% <= 10 milliseconds
89.40% <= 11 milliseconds
89.99% <= 12 milliseconds
90.93% <= 13 milliseconds
92.56% <= 14 milliseconds
94.42% <= 15 milliseconds
95.65% <= 16 milliseconds
96.26% <= 17 milliseconds
96.71% <= 18 milliseconds
97.12% <= 19 milliseconds
97.40% <= 20 milliseconds
97.65% <= 21 milliseconds
97.92% <= 22 milliseconds
98.35% <= 23 milliseconds
98.90% <= 24 milliseconds
99.41% <= 25 milliseconds
99.70% <= 26 milliseconds
99.85% <= 27 milliseconds
99.91% <= 28 milliseconds
99.93% <= 29 milliseconds
99.95% <= 30 milliseconds
99.98% <= 31 milliseconds
99.98% <= 32 milliseconds
99.99% <= 42 milliseconds
99.99% <= 43 milliseconds
100.00% <= 44 milliseconds
100.00% <= 45 milliseconds
32366.41 requests per second

test_update_test_table
====== UPDATE TEST ======
1000001 requests completed in 32.56 seconds
200 parallel clients
3 bytes payload
keep alive: 1

0.01% <= 2 milliseconds
1.47% <= 3 milliseconds
28.85% <= 4 milliseconds
66.51% <= 5 milliseconds
80.78% <= 6 milliseconds
85.86% <= 7 milliseconds
87.61% <= 8 milliseconds
88.42% <= 9 milliseconds
88.97% <= 10 milliseconds
89.37% <= 11 milliseconds
89.82% <= 12 milliseconds
90.67% <= 13 milliseconds
91.93% <= 14 milliseconds
93.38% <= 15 milliseconds
94.48% <= 16 milliseconds
95.36% <= 17 milliseconds
95.85% <= 18 milliseconds
96.20% <= 19 milliseconds
96.52% <= 20 milliseconds
96.85% <= 21 milliseconds
97.20% <= 22 milliseconds
97.58% <= 23 milliseconds
98.18% <= 24 milliseconds
98.88% <= 25 milliseconds
99.38% <= 26 milliseconds
99.69% <= 27 milliseconds
99.86% <= 28 milliseconds
99.96% <= 29 milliseconds
100.00% <= 30 milliseconds
100.00% <= 31 milliseconds
30715.39 requests per second

test_delete_test_table
====== DELETE TEST ======
1000011 requests completed in 30.10 seconds
200 parallel clients
3 bytes payload
keep alive: 1

0.03% <= 2 milliseconds
4.36% <= 3 milliseconds
49.44% <= 4 milliseconds
76.19% <= 5 milliseconds
84.78% <= 6 milliseconds
87.53% <= 7 milliseconds
88.34% <= 8 milliseconds
88.74% <= 9 milliseconds
89.11% <= 10 milliseconds
89.44% <= 11 milliseconds
90.08% <= 12 milliseconds
91.18% <= 13 milliseconds
92.78% <= 14 milliseconds
94.50% <= 15 milliseconds
95.54% <= 16 milliseconds
96.19% <= 17 milliseconds
96.65% <= 18 milliseconds
97.02% <= 19 milliseconds
97.36% <= 20 milliseconds
97.69% <= 21 milliseconds
97.99% <= 22 milliseconds
98.33% <= 23 milliseconds
98.87% <= 24 milliseconds
99.41% <= 25 milliseconds
99.63% <= 26 milliseconds
99.70% <= 27 milliseconds
99.77% <= 28 milliseconds
99.81% <= 29 milliseconds
99.86% <= 30 milliseconds
99.91% <= 31 milliseconds
99.92% <= 32 milliseconds
99.94% <= 33 milliseconds
99.94% <= 34 milliseconds
99.95% <= 35 milliseconds
99.96% <= 36 milliseconds
99.96% <= 37 milliseconds
99.96% <= 44 milliseconds
99.96% <= 45 milliseconds
99.97% <= 46 milliseconds
99.98% <= 47 milliseconds
99.98% <= 48 milliseconds
99.99% <= 66 milliseconds
100.00% <= 67 milliseconds
100.00% <= 68 milliseconds
100.00% <= 214 milliseconds
100.00% <= 215 milliseconds
100.00% <= 216 milliseconds
33219.64 requests per second

denorm_set_for_compare_w_test_table
====== SET DENORM ======
1000038 requests completed in 28.00 seconds
200 parallel clients
8 bytes payload
keep alive: 1

0.00% <= 1 milliseconds
0.33% <= 2 milliseconds
19.45% <= 3 milliseconds
57.56% <= 4 milliseconds
74.69% <= 5 milliseconds
83.86% <= 6 milliseconds
88.03% <= 7 milliseconds
89.35% <= 8 milliseconds
89.90% <= 9 milliseconds
90.39% <= 10 milliseconds
90.96% <= 11 milliseconds
91.91% <= 12 milliseconds
93.47% <= 13 milliseconds
95.19% <= 14 milliseconds
96.30% <= 15 milliseconds
97.08% <= 16 milliseconds
97.47% <= 17 milliseconds
97.80% <= 18 milliseconds
98.11% <= 19 milliseconds
98.36% <= 20 milliseconds
98.53% <= 21 milliseconds
98.80% <= 22 milliseconds
99.10% <= 23 milliseconds
99.37% <= 24 milliseconds
99.51% <= 25 milliseconds
99.60% <= 26 milliseconds
99.66% <= 27 milliseconds
99.70% <= 28 milliseconds
99.74% <= 29 milliseconds
99.76% <= 30 milliseconds
99.78% <= 31 milliseconds
99.79% <= 32 milliseconds
99.79% <= 33 milliseconds
99.82% <= 34 milliseconds
99.86% <= 35 milliseconds
99.88% <= 36 milliseconds
99.88% <= 37 milliseconds
99.89% <= 38 milliseconds
99.90% <= 39 milliseconds
99.90% <= 40 milliseconds
99.91% <= 43 milliseconds
99.91% <= 44 milliseconds
99.91% <= 45 milliseconds
99.93% <= 46 milliseconds
99.95% <= 47 milliseconds
99.95% <= 48 milliseconds
99.95% <= 49 milliseconds
99.96% <= 52 milliseconds
99.97% <= 53 milliseconds
99.97% <= 54 milliseconds
99.98% <= 56 milliseconds
99.98% <= 57 milliseconds
99.98% <= 58 milliseconds
99.99% <= 59 milliseconds
100.00% <= 60 milliseconds
100.00% <= 209 milliseconds
100.00% <= 210 milliseconds
100.00% <= 220 milliseconds
100.00% <= 221 milliseconds
100.00% <= 222 milliseconds
100.00% <= 226 milliseconds
100.00% <= 227 milliseconds
100.00% <= 228 milliseconds
100.00% <= 229 milliseconds
100.00% <= 230 milliseconds
100.00% <= 231 milliseconds
35713.09 requests per second

====== GET DENORM ======
1000063 requests completed in 26.05 seconds
200 parallel clients
3 bytes payload
keep alive: 1

0.00% <= 1 milliseconds
0.68% <= 2 milliseconds
22.32% <= 3 milliseconds
67.52% <= 4 milliseconds
82.82% <= 5 milliseconds
88.81% <= 6 milliseconds
90.46% <= 7 milliseconds
90.90% <= 8 milliseconds
91.23% <= 9 milliseconds
91.55% <= 10 milliseconds
91.96% <= 11 milliseconds
92.76% <= 12 milliseconds
94.30% <= 13 milliseconds
95.85% <= 14 milliseconds
96.67% <= 15 milliseconds
97.20% <= 16 milliseconds
97.51% <= 17 milliseconds
97.70% <= 18 milliseconds
97.92% <= 19 milliseconds
98.14% <= 20 milliseconds
98.35% <= 21 milliseconds
98.61% <= 22 milliseconds
99.11% <= 23 milliseconds
99.64% <= 24 milliseconds
99.83% <= 25 milliseconds
99.90% <= 26 milliseconds
99.93% <= 27 milliseconds
99.95% <= 28 milliseconds
99.95% <= 29 milliseconds
99.95% <= 30 milliseconds
99.95% <= 32 milliseconds
99.97% <= 33 milliseconds
99.99% <= 34 milliseconds
99.99% <= 35 milliseconds
100.00% <= 206 milliseconds
100.00% <= 207 milliseconds
38391.61 requests per second

====== DEL DENORM ======
1000056 requests completed in 25.99 seconds
200 parallel clients
3 bytes payload
keep alive: 1

0.01% <= 1 milliseconds
0.84% <= 2 milliseconds
25.19% <= 3 milliseconds
69.71% <= 4 milliseconds
82.52% <= 5 milliseconds
88.22% <= 6 milliseconds
89.84% <= 7 milliseconds
90.38% <= 8 milliseconds
90.79% <= 9 milliseconds
91.21% <= 10 milliseconds
91.73% <= 11 milliseconds
92.77% <= 12 milliseconds
94.57% <= 13 milliseconds
96.07% <= 14 milliseconds
96.99% <= 15 milliseconds
97.51% <= 16 milliseconds
97.88% <= 17 milliseconds
98.16% <= 18 milliseconds
98.31% <= 19 milliseconds
98.52% <= 20 milliseconds
98.64% <= 21 milliseconds
98.82% <= 22 milliseconds
99.19% <= 23 milliseconds
99.49% <= 24 milliseconds
99.65% <= 25 milliseconds
99.74% <= 26 milliseconds
99.78% <= 27 milliseconds
99.81% <= 28 milliseconds
99.82% <= 29 milliseconds
99.83% <= 30 milliseconds
99.83% <= 31 milliseconds
99.85% <= 32 milliseconds
99.86% <= 33 milliseconds
99.87% <= 34 milliseconds
99.87% <= 36 milliseconds
99.89% <= 37 milliseconds
99.90% <= 38 milliseconds
99.91% <= 39 milliseconds
99.91% <= 42 milliseconds
99.94% <= 43 milliseconds
99.94% <= 44 milliseconds
99.95% <= 65 milliseconds
99.96% <= 66 milliseconds
99.97% <= 67 milliseconds
99.97% <= 68 milliseconds
99.98% <= 69 milliseconds
99.98% <= 70 milliseconds
99.99% <= 71 milliseconds
99.99% <= 204 milliseconds
99.99% <= 205 milliseconds
99.99% <= 206 milliseconds
99.99% <= 207 milliseconds
99.99% <= 208 milliseconds
100.00% <= 210 milliseconds
100.00% <= 211 milliseconds
100.00% <= 212 milliseconds
100.00% <= 213 milliseconds
100.00% <= 220 milliseconds
38482.93 requests per second

[Jak Sprats]

Some notes on these tests

2 INSTANCES
"Basic 64-bit Amazon Linux AMI 1.0 "
Large mq.large 7.5GB
Security Grop must allow tcp on port 6379

[Jak Sprats]

FIRST Download Alchemy
wget --no-check-certificate https://github.com/JakSprats/Redisql/tarball/master

# install necessary libs
sudo yum -y install gcc gcc-c++ autoconf automake readline-devel

# extract and make Alchemy
tar xvfz JakSprats-Redisql*.tar.gz
(cd JakSprats-Redisql*;
make linux;
)

#SERVER
cd JakSprats-Redisql*;
./redisql-server

On Dec 2, 2:10 pm, Jak Sprats <jakspr...@gmail.com> wrote:

[Jak Sprats]

2 INSTANCES
"Basic 64-bit Amazon Linux AMI 1.0 "
Large mq.large 7.5GB
Security Grop must allow tcp on port 6379

Not sure if this got posted, sometimes google groups is slow showing
posts ...

On Dec 16, 3:17 am, Jak Sprats <jakspr...@gmail.com> wrote:
>  FIRST Download Alchemy
> wget --no-check-certificatehttps://github.com/JakSprats/Redisql/tarball/master

> ...
>
> read more »