results.txt

bench_lua.sh

#!/bin/bash

NUM=1000000

. ./bash_functions.sh

$RECONF

taskset -c 1 ./redisql-benchmark -n $NUM -r $NUM -c 200 -JS
taskset -c 1 ./redisql-benchmark -n $NUM -r $NUM -c 200 -JG
taskset -c 1 ./redisql-benchmark -n $NUM -r $NUM -c 200 -LS
taskset -c 1 ./redisql-benchmark -n $NUM -r $NUM -c 200 -LG

taskset -c 1 ./redisql-benchmark -n $NUM -r $NUM -c 200 -LSS
taskset -c 1 ./redisql-benchmark -n $NUM -r $NUM -c 200 -LSG

examples.calls

# CLI = ./redisql-cli
# $CLI LUA "return member_session_add(000100000001, 'sess_000100000001', 10, '[[session data]]');";
OK
# $CLI LUA "return get_member_session_data('sess_000100000001');"
"[[session data]]"
# sleep 10; $CLI LUA "return get_member_session_data('sess_000100000001');"
""

helper.lua (relevant)

function member_session_add(user_id, session_id, ttl, data)
  incr( "num_logins:"   .. user_id);
  set(  "last_login:"   .. user_id, os.time());
  setex("session_data:" .. user_id, ttl, data);
  return setex(session_id, ttl, 'member=' .. user_id);
end

function get_member_session_data(session_id)
  stype = get(session_id)
  if (stype and string.sub(stype, 1, 6) == 'member') then
    user_id = string.sub(stype, 8);
    return get("session_data:" .. user_id);
  else
    return "";
  end
end

Redisql Lua benchmarking

====== SET ======
  1000006 requests completed in 11.14 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

6.03% <= 1 milliseconds
74.08% <= 2 milliseconds
98.22% <= 3 milliseconds
99.67% <= 4 milliseconds
99.85% <= 5 milliseconds
99.92% <= 6 milliseconds
99.99% <= 7 milliseconds
99.99% <= 8 milliseconds
100.00% <= 9 milliseconds
100.00% <= 11 milliseconds
89783.27 requests per second

====== GET ======
  1000001 requests completed in 10.75 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

1.78% <= 1 milliseconds
84.31% <= 2 milliseconds
99.28% <= 3 milliseconds
99.95% <= 4 milliseconds
99.95% <= 5 milliseconds
99.97% <= 6 milliseconds
99.98% <= 7 milliseconds
99.99% <= 8 milliseconds
100.00% <= 9 milliseconds
100.00% <= 10 milliseconds
100.00% <= 11 milliseconds
92997.39 requests per second

lua_SET_test
====== LUA SET TEST ======
  1000001 requests completed in 19.64 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
0.10% <= 2 milliseconds
27.92% <= 3 milliseconds
88.25% <= 4 milliseconds
95.99% <= 5 milliseconds
99.62% <= 6 milliseconds
99.78% <= 7 milliseconds
99.88% <= 8 milliseconds
99.89% <= 9 milliseconds
99.91% <= 10 milliseconds
99.94% <= 11 milliseconds
99.95% <= 14 milliseconds
99.95% <= 15 milliseconds
99.96% <= 16 milliseconds
99.96% <= 17 milliseconds
99.97% <= 27 milliseconds
99.97% <= 28 milliseconds
99.97% <= 29 milliseconds
99.98% <= 30 milliseconds
99.98% <= 32 milliseconds
99.98% <= 33 milliseconds
99.98% <= 179 milliseconds
99.98% <= 180 milliseconds
99.98% <= 181 milliseconds
99.99% <= 182 milliseconds
100.00% <= 183 milliseconds
100.00% <= 184 milliseconds
100.00% <= 185 milliseconds
50913.95 requests per second

lua_GET_test
====== LUA GET TEST ======
  1000006 requests completed in 18.11 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
0.01% <= 2 milliseconds
44.01% <= 3 milliseconds
95.18% <= 4 milliseconds
98.95% <= 5 milliseconds
99.96% <= 6 milliseconds
99.99% <= 7 milliseconds
100.00% <= 8 milliseconds
100.00% <= 9 milliseconds
55218.44 requests per second

lua_SESSION_SET_test
====== LUA SET SESSION TEST ======
  1000001 requests completed in 39.75 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
0.00% <= 2 milliseconds
0.01% <= 3 milliseconds
0.31% <= 4 milliseconds
3.56% <= 5 milliseconds
17.28% <= 6 milliseconds
35.46% <= 7 milliseconds
75.82% <= 8 milliseconds
86.88% <= 9 milliseconds
92.62% <= 10 milliseconds
96.54% <= 11 milliseconds
98.84% <= 12 milliseconds
99.55% <= 13 milliseconds
99.82% <= 14 milliseconds
99.90% <= 15 milliseconds
99.92% <= 16 milliseconds
99.93% <= 17 milliseconds
99.94% <= 18 milliseconds
99.95% <= 19 milliseconds
99.95% <= 20 milliseconds
99.95% <= 21 milliseconds
99.96% <= 23 milliseconds
99.96% <= 24 milliseconds
99.96% <= 25 milliseconds
99.96% <= 28 milliseconds
99.97% <= 29 milliseconds
99.97% <= 30 milliseconds
99.98% <= 31 milliseconds
99.98% <= 32 milliseconds
99.98% <= 52 milliseconds
99.99% <= 53 milliseconds
99.99% <= 54 milliseconds
99.99% <= 56 milliseconds
100.00% <= 57 milliseconds
100.00% <= 58 milliseconds
25155.99 requests per second

lua_SESSION_GET_test
====== LUA GET SESSION TEST ======
  1000008 requests completed in 23.57 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 2 milliseconds
1.36% <= 3 milliseconds
45.50% <= 4 milliseconds
88.71% <= 5 milliseconds
94.29% <= 6 milliseconds
99.42% <= 7 milliseconds
99.84% <= 8 milliseconds
99.98% <= 9 milliseconds
100.00% <= 10 milliseconds
100.00% <= 11 milliseconds
42436.16 requests per second

using_LuaJIT

lua_SET_test
====== LUA SET TEST ======
  1000002 requests completed in 16.76 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
8.92% <= 2 milliseconds
65.72% <= 3 milliseconds
91.61% <= 4 milliseconds
99.49% <= 5 milliseconds
99.73% <= 6 milliseconds
99.88% <= 7 milliseconds
99.91% <= 8 milliseconds
99.93% <= 9 milliseconds
99.95% <= 10 milliseconds
99.96% <= 11 milliseconds
99.97% <= 12 milliseconds
99.98% <= 13 milliseconds
99.98% <= 14 milliseconds
99.99% <= 15 milliseconds
100.00% <= 16 milliseconds
100.00% <= 17 milliseconds
59648.20 requests per second

lua_GET_test
====== LUA GET TEST ======
  1000024 requests completed in 15.56 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 1 milliseconds
15.40% <= 2 milliseconds
77.30% <= 3 milliseconds
96.52% <= 4 milliseconds
99.88% <= 5 milliseconds
99.93% <= 6 milliseconds
99.98% <= 7 milliseconds
100.00% <= 8 milliseconds
100.00% <= 9 milliseconds
64252.38 requests per second

lua_SESSION_SET_test
====== LUA SET SESSION TEST ======
  1000003 requests completed in 34.04 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.00% <= 2 milliseconds
0.06% <= 3 milliseconds
1.50% <= 4 milliseconds
12.05% <= 5 milliseconds
58.75% <= 6 milliseconds
77.73% <= 7 milliseconds
85.59% <= 8 milliseconds
92.37% <= 9 milliseconds
96.76% <= 10 milliseconds
98.57% <= 11 milliseconds
99.22% <= 12 milliseconds
99.56% <= 13 milliseconds
99.71% <= 14 milliseconds
99.77% <= 15 milliseconds
99.81% <= 16 milliseconds
99.83% <= 17 milliseconds
99.85% <= 18 milliseconds
99.87% <= 19 milliseconds
99.87% <= 20 milliseconds
99.87% <= 21 milliseconds
99.88% <= 22 milliseconds
99.89% <= 23 milliseconds
99.90% <= 24 milliseconds
99.90% <= 25 milliseconds
99.91% <= 26 milliseconds
99.92% <= 27 milliseconds
99.94% <= 28 milliseconds
99.95% <= 29 milliseconds
99.96% <= 30 milliseconds
99.96% <= 31 milliseconds
99.96% <= 32 milliseconds
99.97% <= 33 milliseconds
99.97% <= 34 milliseconds
99.98% <= 35 milliseconds
99.98% <= 36 milliseconds
99.98% <= 37 milliseconds
99.98% <= 48 milliseconds
99.98% <= 49 milliseconds
99.98% <= 50 milliseconds
99.99% <= 51 milliseconds
99.99% <= 52 milliseconds
99.99% <= 53 milliseconds
100.00% <= 54 milliseconds
100.00% <= 55 milliseconds
100.00% <= 56 milliseconds
29373.84 requests per second

lua_SESSION_GET_test
====== LUA GET SESSION TEST ======
  1000002 requests completed in 19.37 seconds
  200 parallel clients
  3 bytes payload
  keep alive: 1

0.10% <= 2 milliseconds
38.14% <= 3 milliseconds
79.83% <= 4 milliseconds
95.65% <= 5 milliseconds
99.72% <= 6 milliseconds
99.83% <= 7 milliseconds
99.95% <= 8 milliseconds
99.96% <= 9 milliseconds
99.97% <= 10 milliseconds
99.98% <= 11 milliseconds
99.98% <= 12 milliseconds
99.99% <= 13 milliseconds
99.99% <= 14 milliseconds
100.00% <= 15 milliseconds
100.00% <= 16 milliseconds
100.00% <= 17 milliseconds
100.00% <= 18 milliseconds
100.00% <= 19 milliseconds
51637.00 requests per second