| lists.openwall.net | lists / announce owl-users owl-dev john-users john-dev passwdqc-users yescrypt popa3d-users / oss-security kernel-hardening musl sabotage tlsify passwords / crypt-dev xvendor / Bugtraq Full-Disclosure linux-kernel linux-netdev linux-ext4 linux-hardening linux-cve-announce PHC | |
|
Open Source and information security mailing list archives
| ||
|
Message-Id: <1348876126-28792-5-git-send-email-daniel.santos@pobox.com>
Date: Fri, 28 Sep 2012 18:48:46 -0500
From: Daniel Santos <daniel.santos@...ox.com>
To: LKML <linux-kernel@...r.kernel.org>,
Akinobu Mita <akinobu.mita@...il.com>,
Andrea Arcangeli <aarcange@...hat.com>,
Andrew Morton <akpm@...ux-foundation.org>,
Daniel Santos <daniel.santos@...ox.com>,
David Woodhouse <David.Woodhouse@...el.com>,
"H. Peter Anvin" <hpa@...or.com>, Ingo Molnar <mingo@...e.hu>,
John Stultz <john.stultz@...aro.org>,
linux-doc@...r.kernel.org, Michel Lespinasse <walken@...gle.com>,
"Paul E. McKenney" <paul.mckenney@...aro.org>,
Paul Gortmaker <paul.gortmaker@...driver.com>,
Pavel Pisa <pisa@....felk.cvut.cz>,
Peter Zijlstra <a.p.zijlstra@...llo.nl>,
Rik van Riel <riel@...hat.com>, Rob Landley <rob@...dley.net>
Subject: [PATCH v6 10/10] selftest: report generation script for test results
A script that uses sqlite to load test results and generates a report
showing differences in performance per compiler used.
Signed-off-by: Daniel Santos <daniel.santos@...ox.com>
---
tools/testing/selftests/grbtree/user/gen_report.sh | 129 ++++++++++++++++++++
1 files changed, 129 insertions(+), 0 deletions(-)
create mode 100755 tools/testing/selftests/grbtree/user/gen_report.sh
diff --git a/tools/testing/selftests/grbtree/user/gen_report.sh b/tools/testing/selftests/grbtree/user/gen_report.sh
new file mode 100755
index 0000000..a0ab88a
--- /dev/null
+++ b/tools/testing/selftests/grbtree/user/gen_report.sh
@@ -0,0 +1,129 @@
+#!/bin/bash
+
+dbfile=results.$$.db
+datafile=runtest.out
+
+die() {
+ echo "ERROR${@:+": "}$@" 1>&2
+ exit -1
+}
+
+find_sqlite() {
+ for suffix in "" 4 3; do
+ which sqlite${suffix} 2> /dev/null && return 0
+ done
+ return 1
+}
+
+sqlite=$(find_sqlite) || die "failed to find sqlite"
+
+${sqlite} "${dbfile}" << asdf
+/* .echo on */
+.headers on
+create table if not exists grbtest_result (
+ compiler varchar(255),
+ key_type varchar(255),
+ payload int,
+ userland tinyint,
+ use_generic tinyint,
+ use_leftmost tinyint,
+ use_rightmost tinyint,
+ use_count tinyint,
+ unique_keys tinyint,
+ insert_replaces tinyint,
+ debug tinyint,
+ debug_validate tinyint,
+ arch varchar(255),
+ arch_flags varchar(255),
+ processor varchar(255),
+ cc varchar(255),
+ cflags varchar(255),
+ test tinyint,
+ in_seed bigint,
+ seed bigint,
+ key_mask int,
+ object_count int,
+ pool_count int,
+ reps bigint,
+ node_size int,
+ object_size int,
+ pool_size int,
+ insertions bigint,
+ insertion_time bigint,
+ evictions bigint,
+ deletions bigint,
+ deletion_time bigint
+);
+.separator |
+.import ${datafile} grbtest_result
+/* .mode column */
+select distinct
+ key_type,
+ payload,
+ userland,
+ use_leftmost,
+ use_rightmost,
+ use_count,
+ unique_keys,
+ insert_replaces,
+ debug,
+ debug_validate,
+ arch,
+ arch_flags,
+ processor,
+ cc,
+ test,
+ in_seed,
+ seed,
+ key_mask,
+ object_count,
+ pool_count,
+ reps,
+ node_size,
+ object_size,
+ pool_size,
+ insertions,
+ evictions,
+ deletions
+from grbtest_result;
+
+select distinct
+ a.compiler as 'Compiler',
+ a.key_type,
+ a.payload,
+ a.userland,
+ (case when a.use_leftmost then 'L' else '.' end) ||
+ (case when a.use_rightmost then 'R' else '.' end) ||
+ (case when a.use_count then 'C' else '.' end) ||
+ (case when a.unique_keys then 'U' else '.' end) ||
+ (case when a.insert_replaces then 'I' else '.' end) ||
+ (case when a.debug then 'D' else '.' end) ||
+ (case when a.debug_validate then 'V' else '.' end)
+ as config,
+ a.insertion_time as 'Generic Insert Time',
+ b.insertion_time as 'Hand-Coded Insert Time',
+ 1.0 * a.insertion_time / b.insertion_time - 1.0 as 'Insert Diff',
+ a.deletion_time as 'Generic Delete Time',
+ b.deletion_time as 'Hand-Coded Delete Time',
+ 1.0 * a.deletion_time / b.deletion_time - 1.0 as 'Delete Diff'
+from
+ grbtest_result as a inner join grbtest_result as b on (
+ a.compiler = b.compiler
+ AND a.key_type = b.key_type
+ AND a.payload = b.payload
+ AND a.userland = b.userland
+ AND a.use_leftmost = b.use_leftmost
+ AND a.use_rightmost = b.use_rightmost
+ AND a.use_count = b.use_count
+ AND a.unique_keys = b.unique_keys
+ AND a.insert_replaces = b.insert_replaces
+ AND a.debug = b.debug
+ AND a.debug_validate = b.debug_validate
+ )
+where
+ a.use_generic == 1
+ and b.use_generic = 0;
+asdf
+
+rm "${dbfile}"
+
--
1.7.3.4
--
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
the body of a message to majordomo@...r.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html
Please read the FAQ at http://www.tux.org/lkml/
Powered by blists - more mailing lists