sejima

$ 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

sejima

$ 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

sejima

$ 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

sejima

$ for i in {1..4}; do mysql -e "alter table sbtest$i row_format=compressed key_block_size=8;" -D sbtest_zip; done

sejima

$ ./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

sejima

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"/>

sejima

$ 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.
$

sejima

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

sejima

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%]

sejima

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