I am trying to repeat the problem on Linux. I run latest MariaDB 5.2 and 5.3, compiled with compile-pentium-max.
I'm using sysbench with this lua file:
== tests/db/_select_one.lua ==
pathtest = string.match(test, "(.*/)") or ""
dofile(pathtest .. "common.lua")
function thread_init(thread_id)
set_vars()
end
function event(thread_id)
rs = db_query("select 1")
end
== EOF ==
and I run sysbench with:
./sysbench --test=./tests/db/_select_one.lua --db-driver=mysql --mysql-user=root --mysql-socket=/tmp/mysql.sock --max-requests=100000 run
I am trying to repeat the problem on Linux. I run latest MariaDB 5.2 and 5.3, compiled with compile- pentium- max.
I'm using sysbench with this lua file: _select_ one.lua ==
== tests/db/
pathtest = string.match(test, "(.*/)") or ""
dofile(pathtest .. "common.lua")
function thread_ init(thread_ id)
set_vars()
end
function event(thread_id)
rs = db_query("select 1")
end
== EOF ==
and I run sysbench with: ./tests/ db/_select_ one.lua --db-driver=mysql --mysql-user=root --mysql- socket= /tmp/mysql. sock --max-requests= 100000 run
./sysbench --test=
My results from two runs are:
== 5.2 ==
...
response time:
min: 0.08ms
avg: 0.09ms
max: 1.27ms
approx. 95 percentile: 0.09ms
...
response time:
min: 0.04ms
avg: 0.09ms
max: 1.22ms
approx. 95 percentile: 0.09ms
== 5.3 ==
...
response time:
min: 0.04ms
avg: 0.09ms
max: 1.32ms
approx. 95 percentile: 0.10ms
...
response time:
min: 0.04ms
avg: 0.09ms
max: 1.54ms
approx. 95 percentile: 0.10ms