oltp: Convert pack to makepkg

The rt of makepkg:
/result/makepkg/oltp-debian-x86_64-2019-05-14.cgz/lkp-opteron1/debian-x86_64-2019-05-14.cgz/x86_64-rhel-7.6/gcc-7/5f9e832c137075045d15cd6899ab0505cfb2ca4b/0

The rt of test:
yangx@inn:~$ cat /result/oltp/performance-100%-600s-1000000-ucode=0xb000036/lkp-bdw-ex2/debian-x86_64-2019-05-14.cgz/x86_64-rhel-7.6/gcc-7/0ecfebd2b52404ae0c54a878c872bb93363ada36/2/oltp.json
{
  "oltp.read": [
    134822646
  ],
  "oltp.other": [
    19260378
  ],
  "oltp.transactions": [
    9630189
  ],
  "oltp.transactions/s": [
    16049.32
  ],
  "oltp.queries": [
    154083024
  ],
  "oltp.queries/s": [
    256789.13
  ],
  "oltp.latency_min_ms": [
    1.55
  ],
  "oltp.latency_avg_ms": [
    9.97
  ],
  "oltp.latency_max_ms": [
    93.7
  ],
  "oltp.latency_95th_ms": [
    13.95
  ],
  "oltp.latency_sum_ms": [
    95977852.83
  ],
  "oltp.thread_events_stddev%": [
    0.329463938596043
  ]
}

Signed-off-by: Xiao Yang <xiaox.yang@intel.com>
Signed-off-by: Philip Li <philip.li@intel.com>

4 files changed, 5 insertions, 4 deletions

diff --git a/pkg/oltp b/pkg/oltp
new file mode 120000
index 00000000..a6f8719d
--- /dev/null
+++ b/pkg/oltp
@@ -0,0 +1 @@
+sysbench
\ No newline at end of file
diff --git a/pkg/sysbench/PKGBUILD b/pkg/sysbench/PKGBUILD
index c3fc4452..cf6019a1 100644
--- a/pkg/sysbench/PKGBUILD
+++ b/pkg/sysbench/PKGBUILD
@@ -11,7 +11,9 @@ md5sums=('SKIP')
 build() {
   cd "$srcdir/$pkgname"
   ./autogen.sh
-  ./configure --prefix=/usr
+  # running oltp by sysbench may get "Illegal instruction"
+  # error on some arches so avoid it by --without-gcc-arch
+  ./configure --prefix=/usr --without-gcc-arch
   make
 }
 
diff --git a/setup/setup-oltp b/setup/setup-oltp
index 8222ee9e..fd8de7c6 100755
--- a/setup/setup-oltp
+++ b/setup/setup-oltp
@@ -12,7 +12,6 @@
 
 [ -n "$runtime" ] || runtime=600
 [ -n "$table_size" ] && arg_table_size="--table-size=$table_size"
-export PATH=$BENCHMARK_ROOT/$testcase/sysbench/usr/local/bin:$PATH
 
 args="\
 	--mysql-user=root\
diff --git a/tests/run b/tests/run
index 41f29911..b28a8126 100755
--- a/tests/run
+++ b/tests/run
@@ -1,7 +1,6 @@
 #!/bin/sh
 
-export PATH=$BENCHMARK_ROOT/$testcase/sysbench/usr/local/bin:$PATH
 prog=$(basename "$0")
 
-cd $BENCHMARK_ROOT/$testcase/sysbench/usr/local/share/sysbench
+cd /usr/share/sysbench
 sh "$TMP_RESULT_ROOT/run.$prog"