benchDBReport: benchDBReport

Description Usage Arguments

Description

Uploads benchmarking/profiling results to a database. This function tries to connect to a MySQL or SQLite database using provided information. If connection is sucessfull, data frames BM and META from .BenchEnv environment to the database tables BENCHMARKS and META. These tables should exist in the provided database. The BENCHMARKS table can be created by using:

CREATE TABLE "BENCHMARKS" ( `runId` VARCHAR(18) NOT NULL, `systemId` VARCHAR(32) NOT NULL, `file` VARCHAR(64) NOT NULL, `version` VARCHAR(32) NOT NULL, `process` VARCHAR(16) NOT NULL, `start_time` DECIMAL NOT NULL, `end_time` DECIMAL NOT NULL, `duration` DECIMAL NOT NULL, `runs` INTEGER NOT NULL, PRIMARY KEY(runId,process,end_time) )

and for META table use:

CREATE TABLE META ( systemId VARCHAR(32), variable VARCHAR(32), value VARCHAR(32), PRIMARY KEY(systemId,variable))

Usage

1
benchDBReport(usr, pwd, host_loc, conn_str, db_name, con_type, bench_log, warn_log)

Arguments

usr

database usrname. Default is NULL.

pwd

database password. Default is NULL.

host_loc

IP address of the MySQL server. Default is NULL.

conn_str

a complete connection string (eg jdbc:mysql:127.0.0.1:36/myDatabase). Default is NULL.

db_name

database name. Default is NULL.

con_type

type of database (currently only mysql and sqlite supported)

bench_log

filename to use to store message/warning/errors. Default is "benchmark.log"

warn_log

level of logging to use (choose from -1, "INFO", "WARN", "STOP". Default value is -1.


psolaimani/benchmaRk documentation built on May 26, 2019, 11:30 a.m.