RediSQL benchmarks

benchamark1

Last login: Tue Apr 17 20:40:55 2018 from 90.41.4.210
ubuntu@ip-172-31-14-12:~$ 
ubuntu@ip-172-31-14-12:~$ 
ubuntu@ip-172-31-14-12:~$ cd redis-4.0.9/src/
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-cli 
127.0.0.1:6379> REDISQL.CREATE_DB DB
OK
127.0.0.1:6379> REDISQL.EXEC DB "create table test(a int, b int);"
1) DONE
2) (integer) 0
127.0.0.1:6379> REDISQL.CREATE_STATEMENT DB insert "insert into test values(?1, ?2);"
OK
127.0.0.1:6379> REDISQL.EXEC_STATEMENT DB insert 1 2
1) DONE
2) (integer) 1
127.0.0.1:6379> 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark PING
====== PING ======
  100000 requests completed in 0.87 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

99.95% <= 1 milliseconds
99.99% <= 2 milliseconds
100.00% <= 2 milliseconds
114547.53 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark REDISQL.EXEC_STATEMENT DB insert 1 3
====== REDISQL.EXEC_STATEMENT DB insert 1 3 ======
  100000 requests completed in 1.54 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

93.45% <= 1 milliseconds
99.95% <= 2 milliseconds
99.95% <= 4 milliseconds
99.97% <= 5 milliseconds
100.00% <= 5 milliseconds
64724.92 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 200 REDISQL.EXEC_STATEMENT DB insert 1 3                                               
====== REDISQL.EXEC_STATEMENT DB insert 1 3 ======
  100000 requests completed in 1.73 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
15.53% <= 2 milliseconds
64.01% <= 3 milliseconds
90.37% <= 4 milliseconds
96.68% <= 5 milliseconds
98.95% <= 6 milliseconds
99.67% <= 7 milliseconds
99.80% <= 9 milliseconds
99.82% <= 10 milliseconds
99.85% <= 11 milliseconds
99.91% <= 12 milliseconds
99.97% <= 13 milliseconds
100.00% <= 13 milliseconds
57703.40 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 200 -n 1000000 REDISQL.EXEC_STATEMENT DB insert 1 3                                    
====== REDISQL.EXEC_STATEMENT DB insert 1 3 ======
  1000000 requests completed in 15.37 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.04% <= 1 milliseconds
26.78% <= 2 milliseconds
77.97% <= 3 milliseconds
95.92% <= 4 milliseconds
99.03% <= 5 milliseconds
99.79% <= 6 milliseconds
99.97% <= 7 milliseconds
99.99% <= 8 milliseconds
100.00% <= 9 milliseconds
100.00% <= 9 milliseconds
65070.28 requests per second



ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 200 -n 10000000 REDISQL.EXEC_STATEMENT DB insert 1 3                                   
====== REDISQL.EXEC_STATEMENT DB insert 1 3 ======
  10000000 requests completed in 154.46 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.04% <= 1 milliseconds
21.81% <= 2 milliseconds
75.39% <= 3 milliseconds
95.88% <= 4 milliseconds
98.86% <= 5 milliseconds
99.68% <= 6 milliseconds
99.91% <= 7 milliseconds
99.96% <= 8 milliseconds
99.97% <= 9 milliseconds
99.98% <= 10 milliseconds
99.99% <= 11 milliseconds
99.99% <= 12 milliseconds
100.00% <= 13 milliseconds
100.00% <= 14 milliseconds
100.00% <= 15 milliseconds
100.00% <= 21 milliseconds
100.00% <= 22 milliseconds
100.00% <= 23 milliseconds
100.00% <= 24 milliseconds
100.00% <= 25 milliseconds
100.00% <= 25 milliseconds
64741.26 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-cli 
127.0.0.1:6379> REDISQL.CREATE_DB DB2
OK
127.0.0.1:6379> REDISQL.EXEC DB2 "create table test(a int, b int);"
1) DONE
2) (integer) 0
127.0.0.1:6379> REDISQL.CREATE_STATEMENT DB2 insert "insert into test values(?1, ?2);"
OK
127.0.0.1:6379> 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 200 -n 10000000 REDISQL.EXEC_STATEMENT DB2 insert 1 3                                  
====== REDISQL.EXEC_STATEMENT DB2 insert 1 3 ======
  10000000 requests completed in 293.94 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
0.44% <= 2 milliseconds
1.22% <= 3 milliseconds
6.74% <= 4 milliseconds
41.45% <= 5 milliseconds
69.83% <= 6 milliseconds
92.69% <= 7 milliseconds
98.08% <= 8 milliseconds
98.89% <= 9 milliseconds
99.22% <= 10 milliseconds
99.45% <= 11 milliseconds
99.61% <= 12 milliseconds
99.73% <= 13 milliseconds
99.82% <= 14 milliseconds
99.87% <= 15 milliseconds
99.90% <= 16 milliseconds
99.93% <= 17 milliseconds
99.95% <= 18 milliseconds
99.96% <= 19 milliseconds
99.97% <= 20 milliseconds
99.98% <= 21 milliseconds
99.98% <= 22 milliseconds
99.98% <= 23 milliseconds
99.98% <= 24 milliseconds
99.99% <= 25 milliseconds
99.99% <= 26 milliseconds
99.99% <= 27 milliseconds
99.99% <= 28 milliseconds
100.00% <= 29 milliseconds
100.00% <= 30 milliseconds
100.00% <= 31 milliseconds
100.00% <= 34 milliseconds
100.00% <= 35 milliseconds
100.00% <= 37 milliseconds
100.00% <= 40 milliseconds
100.00% <= 44 milliseconds
100.00% <= 45 milliseconds
100.00% <= 46 milliseconds
100.00% <= 49 milliseconds
100.00% <= 54 milliseconds
100.00% <= 54 milliseconds
34020.32 requests per second




ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 200 -n 10000
00 -P 10 REDISQL.EXEC_STATEMENT DB2 insert 1 3                             
====== REDISQL.EXEC_STATEMENT DB2 insert 1 3 ======
99.75% <= 13 milliseconds
  1000000 requests completed in 28.61 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
0.79% <= 2 milliseconds
3.49% <= 3 milliseconds
11.11% <= 4 milliseconds
19.90% <= 5 milliseconds
26.45% <= 6 milliseconds
28.23% <= 7 milliseconds
40.40% <= 8 milliseconds
61.97% <= 9 milliseconds
79.84% <= 10 milliseconds
95.23% <= 11 milliseconds
99.55% <= 12 milliseconds
99.87% <= 14 milliseconds
99.93% <= 15 milliseconds
99.94% <= 16 milliseconds
99.94% <= 20 milliseconds
99.97% <= 21 milliseconds
100.00% <= 21 milliseconds
34957.70 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 200 -n 1000000 -P 10 REDISQL.EXEC_STATEMENT DB insert 1 3                              
====== REDISQL.EXEC_STATEMENT DB insert 1 3 ======
  1000000 requests completed in 13.77 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
0.48% <= 2 milliseconds
20.95% <= 3 milliseconds
69.67% <= 4 milliseconds
99.32% <= 5 milliseconds
99.72% <= 6 milliseconds
99.79% <= 7 milliseconds
99.83% <= 8 milliseconds
99.85% <= 9 milliseconds
99.86% <= 10 milliseconds
99.89% <= 11 milliseconds
99.93% <= 12 milliseconds
99.96% <= 13 milliseconds
100.00% <= 14 milliseconds
100.00% <= 14 milliseconds
72642.74 requests per second



ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 200 -n 1000000 -P 100 REDISQL.EXEC_STATEMENT DB insert 1 3                             
====== REDISQL.EXEC_STATEMENT DB insert 1 3 ======
  1000000 requests completed in 13.43 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
0.14% <= 2 milliseconds
10.46% <= 3 milliseconds
56.08% <= 4 milliseconds
97.10% <= 5 milliseconds
97.43% <= 6 milliseconds
97.79% <= 7 milliseconds
97.95% <= 13 milliseconds
98.58% <= 14 milliseconds
99.38% <= 15 milliseconds
99.78% <= 16 milliseconds
100.00% <= 16 milliseconds
74471.25 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 100 -n 10000
00 -P 10 REDISQL.EXEC_STATEMENT DB insert 1 3                              
====== REDISQL.EXEC_STATEMENT DB insert 1 3 ======
  1000000 requests completed in 11.90 seconds
  100 parallel clients
  3 bytes payload
  keep alive: 1

4.95% <= 1 milliseconds
91.61% <= 2 milliseconds
99.66% <= 3 milliseconds
99.91% <= 4 milliseconds
99.94% <= 5 milliseconds
99.96% <= 6 milliseconds
100.00% <= 6 milliseconds
84005.38 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-cli 
127.0.0.1:6379> REDISQL.CREATE_STATEMENT DB insert_triple "insert into test values(?1, ?2), (?2+3,?1-5), (?1*?2, ?2*6);"
OK
127.0.0.1:6379> 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 100 -n 1000000 -P 10 REDISQL.EXEC_STATEMENT DB insert_triple 4 8
====== REDISQL.EXEC_STATEMENT DB insert_triple 4 8 ======
  1000000 requests completed in 11.64 seconds
  100 parallel clients
  3 bytes payload
  keep alive: 1

5.61% <= 1 milliseconds
95.90% <= 2 milliseconds
99.70% <= 3 milliseconds
99.93% <= 4 milliseconds
99.94% <= 5 milliseconds
99.99% <= 6 milliseconds
100.00% <= 6 milliseconds
85881.14 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 100 -n 10000
00 REDISQL.EXEC_STATEMENT DB insert_triple 4 8                             
====== REDISQL.EXEC_STATEMENT DB insert_triple 4 8 ======
  1000000 requests completed in 13.91 seconds
  100 parallel clients
  3 bytes payload
  keep alive: 1

44.27% <= 1 milliseconds
94.83% <= 2 milliseconds
99.90% <= 3 milliseconds
99.99% <= 4 milliseconds
99.99% <= 9 milliseconds
99.99% <= 10 milliseconds
100.00% <= 11 milliseconds
100.00% <= 11 milliseconds
71875.23 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 100 -n 1000000 REDISQL.EXEC_STATEMENT DB insert 4 8                                    
====== REDISQL.EXEC_STATEMENT DB insert 4 8 ======
  1000000 requests completed in 15.60 seconds
  100 parallel clients
  3 bytes payload
  keep alive: 1

23.96% <= 1 milliseconds
91.62% <= 2 milliseconds
99.73% <= 3 milliseconds
100.00% <= 4 milliseconds
100.00% <= 4 milliseconds
64114.89 requests per second

benchmark2

Last login: Tue Apr 17 20:41:15 2018 from 90.41.4.210
ubuntu@ip-172-31-14-12:~$ 
ubuntu@ip-172-31-14-12:~$ cd redis-4.0.9/src/
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-cli 
127.0.0.1:6379> REDISQL.CREATE_DB DB1
OK
127.0.0.1:6379> REDISQL.EXEC DB1 "create table test(a int, b int);"
1) DONE
2) (integer) 0
127.0.0.1:6379> REDISQL.CREATE_STATEMENT DB1 insert "insert into test values(?1, ?2);"
OK
127.0.0.1:6379> 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ 
ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 200 -n 10000000 REDISQL.EXEC_STATEMENT DB1 insert 1 3                                
====== REDISQL.EXEC_STATEMENT DB1 insert 1 3 ======
  10000000 requests completed in 293.82 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
0.18% <= 2 milliseconds
0.96% <= 3 milliseconds
6.95% <= 4 milliseconds
40.97% <= 5 milliseconds
69.63% <= 6 milliseconds
92.66% <= 7 milliseconds
98.08% <= 8 milliseconds
98.88% <= 9 milliseconds
99.21% <= 10 milliseconds
99.45% <= 11 milliseconds
99.61% <= 12 milliseconds
99.73% <= 13 milliseconds
99.82% <= 14 milliseconds
99.87% <= 15 milliseconds
99.90% <= 16 milliseconds
99.93% <= 17 milliseconds
99.95% <= 18 milliseconds
99.96% <= 19 milliseconds
99.97% <= 20 milliseconds
99.98% <= 21 milliseconds
99.98% <= 22 milliseconds
99.98% <= 23 milliseconds
99.99% <= 24 milliseconds
99.99% <= 25 milliseconds
99.99% <= 26 milliseconds
99.99% <= 27 milliseconds
99.99% <= 28 milliseconds
100.00% <= 29 milliseconds
100.00% <= 30 milliseconds
100.00% <= 32 milliseconds
100.00% <= 33 milliseconds
100.00% <= 34 milliseconds
100.00% <= 36 milliseconds
100.00% <= 37 milliseconds
100.00% <= 38 milliseconds
100.00% <= 39 milliseconds
100.00% <= 40 milliseconds
100.00% <= 41 milliseconds
100.00% <= 42 milliseconds
100.00% <= 43 milliseconds
100.00% <= 44 milliseconds
34034.56 requests per second

ubuntu@ip-172-31-14-12:~/redis-4.0.9/src$ ./redis-benchmark -c 200 -n 1000
000 -P 10 REDISQL.EXEC_STATEMENT DB1 insert 1 3                           
====== REDISQL.EXEC_STATEMENT DB1 insert 1 3 ======
  1000000 requests completed in 28.57 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
0.28% <= 2 milliseconds
3.83% <= 3 milliseconds
11.07% <= 4 milliseconds
18.97% <= 5 milliseconds
25.42% <= 6 milliseconds
28.33% <= 7 milliseconds
43.94% <= 8 milliseconds
64.93% <= 9 milliseconds
81.13% <= 10 milliseconds
95.91% <= 11 milliseconds
99.59% <= 12 milliseconds
99.80% <= 13 milliseconds
99.81% <= 14 milliseconds
99.87% <= 15 milliseconds
99.90% <= 16 milliseconds
99.94% <= 18 milliseconds
99.99% <= 19 milliseconds
100.00% <= 19 milliseconds
35006.65 requests per second