summaryrefslogtreecommitdiffstats
path: root/server/sql
diff options
context:
space:
mode:
authorDavid Sommerseth <davids@redhat.com>2010-03-31 16:30:04 +0200
committerDavid Sommerseth <davids@redhat.com>2010-03-31 16:30:04 +0200
commit4c980bcc2be81d0d46f1b2541a72fd8662b705ac (patch)
tree5f19fbbb574e1c49290ae011d69860e5a524a1e2 /server/sql
parentf09865830aec3861dd98c4859e76b76498040c2d (diff)
downloadrteval-4c980bcc2be81d0d46f1b2541a72fd8662b705ac.tar.gz
rteval-4c980bcc2be81d0d46f1b2541a72fd8662b705ac.tar.xz
rteval-4c980bcc2be81d0d46f1b2541a72fd8662b705ac.zip
Added basic info for more CPU topology info
Have not yet implemented extraction new cpu_topology tags, but the summary of this information will go into the num_cpu_cores and num_cpu_sockets fields in the database. Right now it only takes the /rteval/hardware/cpu_cores and puts it into num_cpu_cores
Diffstat (limited to 'server/sql')
-rw-r--r--server/sql/delta-1.1_1.2.sql2
-rw-r--r--server/sql/rteval-1.2.sql8
2 files changed, 7 insertions, 3 deletions
diff --git a/server/sql/delta-1.1_1.2.sql b/server/sql/delta-1.1_1.2.sql
index fc7e1c4..7ee8c5d 100644
--- a/server/sql/delta-1.1_1.2.sql
+++ b/server/sql/delta-1.1_1.2.sql
@@ -3,4 +3,6 @@
UPDATE rteval_info SET value = '1.2' WHERE key = 'sql_schema_ver';
ALTER TABLE rtevalruns ADD COLUMN distro VARCHAR(128);
+ALTER TABLE rtevalruns_details ADD COLUMN num_cpu_cores INTEGER;
+ALTER TABLE rtevalruns_details ADD COLUMN num_cpu_sockets INTEGER;
ALTER TABLE rtevalruns_details ADD COLUMN numa_nodes INTEGER;
diff --git a/server/sql/rteval-1.2.sql b/server/sql/rteval-1.2.sql
index 3e38a19..6512364 100644
--- a/server/sql/rteval-1.2.sql
+++ b/server/sql/rteval-1.2.sql
@@ -126,9 +126,11 @@ CREATE DATABASE rteval ENCODING 'utf-8';
-- /rteval/loads and /rteval/cyclictest/command_line
--
CREATE TABLE rtevalruns_details (
- rterid INTEGER REFERENCES rtevalruns(rterid) NOT NULL,
- numa_nodes INTEGER,
- xmldata xml NOT NULL,
+ rterid INTEGER REFERENCES rtevalruns(rterid) NOT NULL,
+ num_cpu_cores INTEGER,
+ num_cpu_sockets INTEGER,
+ numa_nodes INTEGER,
+ xmldata xml NOT NULL,
PRIMARY KEY(rterid)
);
GRANT INSERT ON rtevalruns_details TO rtevparser;