1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
|
#!/bin/sh -e
# SysBench is a modular, cross-platform and multi-threaded benchmark tool.
# Current features allow to test the following system parameters:
# * file I/O performance
# * scheduler performance
# * memory allocation and transfer speed
# * POSIX threads implementation performance
# * database server performance
# shellcheck disable=SC1091
. ../../lib/sh-test-lib
OUTPUT="$(pwd)/output"
RESULT_FILE="${OUTPUT}/result.txt"
export RESULT_FILE
SKIP_INSTALL="false"
# sysbench test parameters.
NUM_THREADS="1"
# TESTS="cpu memory threads mutex fileio oltp"
TESTS="cpu memory threads mutex fileio"
usage() {
echo "usage: $0 [-n <num-threads>] [-t <test>] [-s <true|false>] 1>&2"
exit 1
}
while getopts ":n:t:s:" opt; do
case "${opt}" in
n) NUM_THREADS="${OPTARG}" ;;
t) TESTS="${OPTARG}" ;;
s) SKIP_INSTALL="${OPTARG}" ;;
*) usage ;;
esac
done
install_sysbench() {
git clone https://github.com/akopytov/sysbench
cd sysbench
git checkout 0.4
./autogen.sh
if echo "${TESTS}" | grep "oltp"; then
./configure
else
./configure --without-mysql
fi
make install
cd ../
}
! check_root && error_msg "Please run this script as root."
[ -d "${OUTPUT}" ] && mv "${OUTPUT}" "${OUTPUT}_$(date +%Y%m%d%H%M%S)"
mkdir -p "${OUTPUT}"
cd "${OUTPUT}"
# Test installation.
if [ "${SKIP_INSTALL}" = "true" ] || [ "${SKIP_INSTALL}" = "True" ]; then
info_msg "sysbench installation skipped"
else
dist_name
# shellcheck disable=SC2154
case "${dist}" in
debian|ubuntu)
install_deps "git build-essential automake libtool"
if echo "${TESTS}" | grep "oltp"; then
install_deps "libmysqlclient-dev mysql-server"
systemctl start mysql
fi
install_sysbench
;;
fedora|centos)
install_deps "git gcc make automake libtool"
if echo "${TESTS}" | grep "oltp"; then
install_deps "mysql-devel mariadb-server mariadb"
systemctl start mariadb
fi
install_sysbench
;;
oe-rpb)
# Assume all dependent packages are already installed.
install_sysbench
;;
*)
warn_msg "Unsupported distro: ${dist}! Package installation skipped!"
;;
esac
fi
# Verify test installation.
sysbench --version
general_parser() {
ms=$(grep -m 1 "total time" "${logfile}" | awk '{print substr($NF,1,length($NF)-1)}')
add_metric "${tc}-total-time" "pass" "${ms}" "s"
ms=$(grep "total number of events" "${logfile}" | awk '{print $NF}')
add_metric "${tc}-total-number-of-events" "pass" "${ms}" "times"
ms=$(grep "total time taken by event execution" "${logfile}" | awk '{print $NF}')
add_metric "${tc}-total-time-taken-by-event-execution" "pass" "${ms}" "s"
for i in min avg max approx; do
ms=$(grep -m 1 "$i" "${logfile}" | awk '{print substr($NF,1,length($NF)-2)}')
add_metric "${tc}-response-time-$i" "pass" "${ms}" "ms"
done
ms=$(grep "events (avg/stddev)" "${logfile}" | awk '{print $NF}')
add_metric "${tc}-events-avg/stddev" "pass" "${ms}" "times"
ms=$(grep "execution time (avg/stddev)" "${logfile}" | awk '{print $NF}')
add_metric "${tc}-execution-time-avg/stddev" "pass" "${ms}" "s"
}
# Test run.
for tc in ${TESTS}; do
echo
info_msg "Running sysbench ${tc} test..."
logfile="${OUTPUT}/sysbench-${tc}.txt"
case "${tc}" in
cpu|threads|mutex)
sysbench --num-threads="${NUM_THREADS}" --test="${tc}" run | tee "${logfile}"
general_parser
;;
memory)
sysbench --num-threads="${NUM_THREADS}" --test=memory run | tee "${logfile}"
general_parser
ms=$(grep "Operations" "${logfile}" | awk '{print substr($4,2)}')
add_metric "${tc}-ops" "pass" "${ms}" "ops"
ms=$(grep "transferred" "${logfile}" | awk '{print substr($4, 2)}')
units=$(grep "transferred" "${logfile}" | awk '{print substr($5,1,length($NF)-1)}')
add_metric "${tc}-transfer" "pass" "${ms}" "${units}"
;;
fileio)
mkdir fileio && cd fileio
for mode in seqwr seqrewr seqrd rndrd rndwr rndrw; do
tc="fileio-${mode}"
logfile="${OUTPUT}/sysbench-${tc}.txt"
sync
echo 3 > /proc/sys/vm/drop_caches
sleep 5
sysbench --num-threads="${NUM_THREADS}" --test=fileio --file-total-size=2G --file-test-mode="${mode}" prepare
# --file-extra-flags=direct is needed when file size is smaller then RAM.
sysbench --num-threads="${NUM_THREADS}" --test=fileio --file-extra-flags=direct --file-total-size=2G --file-test-mode="${mode}" run | tee "${logfile}"
sysbench --num-threads="${NUM_THREADS}" --test=fileio --file-total-size=2G --file-test-mode="${mode}" cleanup
general_parser
ms=$(grep "transferred" "${logfile}" | awk '{print substr($NF, 2,(length($NF)-8))}')
units=$(grep "transferred" "${logfile}" | awk '{print substr($NF,(length($NF)-6),6)}')
add_metric "${tc}-transfer" "pass" "${ms}" "${units}"
ms=$(grep "Requests/sec" "${logfile}" | awk '{print $1}')
add_metric "${tc}-ops" "pass" "${ms}" "ops"
done
cd ../
;;
oltp)
# Use the same passwd as lamp and lemp tests.
mysqladmin -u root password lxmptest > /dev/null 2>&1 || true
# Delete sysbench in case it exists.
mysql --user='root' --password='lxmptest' -e 'DROP DATABASE sysbench' > /dev/null 2>&1 || true
# Create sysbench database.
mysql --user="root" --password="lxmptest" -e "CREATE DATABASE sysbench"
sysbench --num-threads="${NUM_THREADS}" --test=oltp --db-driver=mysql --oltp-table-size=1000000 --mysql-db=sysbench --mysql-user=root --mysql-password=lxmptest prepare
sysbench --num-threads="${NUM_THREADS}" --test=oltp --db-driver=mysql --oltp-table-size=1000000 --mysql-db=sysbench --mysql-user=root --mysql-password=lxmptest run | tee "${logfile}"
# Parse test log.
general_parser
for i in "read" write other total; do
ms=$(grep "${i}:" "${logfile}" | awk '{print $NF}')
add_metric "${tc}-${i}-queries" "pass" "${ms}" "queries"
done
for i in transactions deadlocks "read/write requests" "other operations"; do
ms=$(grep "${i}:" sysbench-oltp.txt | awk '{print substr($(NF-2),2)}')
i=$(echo "$i" | sed 's/ /-/g')
add_metric "${tc}-${i}" "pass" "${ms}" "ops"
done
# cleanup
mysql --user='root' --password='lxmptest' -e 'DROP DATABASE sysbench'
;;
esac
done
|
