This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ egrep 'Last time.*locked' sbtest_zip.txt | sort | uniq -c | |
1 Last time read locked in file btr0cur.cc line 3592 | |
1 Last time read locked in file btr0cur.cc line 3702 | |
3 Last time read locked in file btr0cur.cc line 3720 | |
78459 Last time read locked in file btr0cur.cc line 545 | |
27 Last time read locked in file btr0cur.cc line 822 | |
2 Last time read locked in file btr0sea.cc line 1094 | |
1 Last time read locked in file btr0sea.cc line 1331 | |
18 Last time read locked in file btr0sea.cc line 907 | |
2 Last time read locked in file buf0flu.cc line 1056 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ for i in 1 2 3; do ./sysbench --test=${SYSBENCH_DIR}/tests/db/oltp.lua --db-driver=mysql --oltp-tables-count=4 --oltp-table-size=4000000 --num-threads=100 --mysql-db=sbtest_zip --mysql-socket=/tmp/mysql.sock run --max-time=300 --max-requests=0; done |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ for i in {1..1000}; do mysql -e 'show engine innodb status\G' | sed -n '/SEMAPHORES/,/Spin rounds per wait/p'; sleep 1; done | tee sbtest_zip.txt |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ for i in {1..4}; do mysql -e "alter table sbtest$i row_format=compressed key_block_size=8;" -D sbtest_zip; done |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ ./sysbench --test=${SYSBENCH_DIR}/tests/db/parallel_prepare.lua --db-driver=mysql --oltp-tables-count=4 --oltp-table-size=4000000 --num-threads=4 --mysql-db=sbtest_zip --mysql-socket=/tmp/mysql.sock run |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Xeon E5-2630 v3:~/uperf-1.0.4/src$ head -n 20 uperf*.xml | |
==> uperf1000.xml <== | |
<?xml version="1.0"?> | |
<profile name="TCP_1000"> | |
<group nthreads="256"> | |
<transaction iterations="1"> | |
<flowop type="connect" options="remotehost=${REMOTE_ADDR} protocol=tcp tcp_nodelay"/> | |
</transaction> | |
<transaction duration="300"> | |
<flowop type="write" options="size=1000 non_blocking"/> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ grep -n -C2 lpthread configure | |
1764-CFLAGS="${CFLAGS=}" | |
1765-#UPERF_LIBS="${UPERF_LIBS=}" | |
1766:UPERF_LIBS="$UPERF_LIBS -lpthread -lrt -lm" | |
1767- | |
1768-# Checks for programs. | |
$ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Xeon E5-2630L v3:~$ for i in {0..15}; do sudo /usr/bin/cpufreq-set -g userspace -c $i; done | |
Xeon E5-2630L v3:~$ for i in {0..15}; do sudo /usr/bin/cpufreq-set -f 1200 -c $i; done | |
Xeon E5-2630L v3:~$ for i in 1 2; do perf stat -e cycles,instructions,cache-references,cache-misses,stalled-cycles-frontend,stalled-cycles-backend,LLC-loads,LLC-load-misses ./test$i; sleep 3; done | |
16777216 | |
Performance counter stats for './test1': | |
8881000836 cycles | |
20213556068 instructions # 2.28 insns per cycle | |
4419790 cache-references |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Xeon L5630:~$ for i in {0..7}; do sudo /usr/bin/cpufreq-set -g userspace -c $i; done | |
Xeon L5630:~$ for i in {0..7}; do sudo /usr/bin/cpufreq-set -f 1600 -c $i; done | |
Xeon L5630:~$ for i in 1 2; do perf stat -e cycles,instructions,cache-references,cache-misses,stalled-cycles-frontend,stalled-cycles-backend,LLC-loads,LLC-load-misses ./test$i; sleep 3; done | |
16777216 | |
Performance counter stats for './test1': | |
12364612599 cycles [50.03%] | |
20176026807 instructions # 1.63 insns per cycle | |
# 0.34 stalled cycles per insn [62.54%] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Xeon E5-2630L v3:~$ for i in 1 2; do perf stat -e cycles,instructions,cache-references,cache-misses,stalled-cycles-frontend,stalled-cycles-backend,LLC-loads,LLC-load-misses ./test$i; sleep 3; done | |
16777216 | |
Performance counter stats for './test1': | |
8694304425 cycles | |
20208045634 instructions # 2.32 insns per cycle | |
4404223 cache-references | |
188371 cache-misses # 4.277 % of all cache refs | |
<not supported> stalled-cycles-frontend |
NewerOlder