{"id":14,"date":"2018-10-05T16:29:00","date_gmt":"2018-10-05T16:29:00","guid":{"rendered":""},"modified":"2018-12-10T14:29:23","modified_gmt":"2018-12-10T14:29:23","slug":"hammerdb-command-line-build-and-test-examples","status":"publish","type":"post","link":"https:\/\/www.hammerdb.com\/blog\/uncategorized\/hammerdb-command-line-build-and-test-examples\/","title":{"rendered":"HammerDB command line build and test examples"},"content":{"rendered":"

With the HammerDB command line its very easy to script the schema build and automated test so that if you don’t have a GUI or don’t want to use one you can still access all of the HammerDB functionality. The following example is with MySQL on Linux but can easily apply to any database you choose.<\/p>\n

Firstly if you don’t have MySQL installed copy the client library to your home directory<\/span><\/p>\n

\n
$ ls -l libmysqlclient.so.20\r\n-rw-r--r-- 1 mysql mysql 4237408 Apr 23 09:21 libmysqlclient.so.20<\/pre>\n
and add it to your path<\/div>\n
$ export LD_LIBRARY_PATH=\/home\/intel:$LD_LIBRARY_PATH<\/pre>\n
The CLI command librarycheck will verify if the library can be loaded.<\/div>\n
$ .\/hammerdbcli\r\nHammerDB CLI v3.1\r\nCopyright (C) 2003-2018 Steve Shaw\r\nType \"help\" for a list of commands\r\nThe xml is well-formed, applying configuration\r\nhammerdb>librarycheck\r\n...\r\nChecking database library for MySQL\r\nSuccess ... loaded library mysqltcl for MySQL\r\n...<\/pre>\n
Using a text editor create a script with your configuration, such as follows. Note that in this example the build is going to be run on the database server itself.<\/div>\n
$ more schemabuild.tcl\r\n#!\/bin\/tclsh\r\nputs \"SETTING CONFIGURATION\"\r\ndbset db mysql\r\ndiset connection mysql_host 127.0.0.1\r\ndiset connection mysql_port 3306\r\ndiset tpcc mysql_count_ware 800\r\ndiset tpcc mysql_partition true\r\ndiset tpcc mysql_num_vu 64\r\ndiset tpcc mysql_storage_engine innodb\r\nprint dict\r\nbuildschema<\/pre>\n
Then run the hammerdb CLI and type source schemabuild.tcl – hammerdb will then run the build you specified.<\/div>\n
$ .\/hammerdbcli\r\nHammerDB CLI v3.1\r\nCopyright (C) 2003-2018 Steve Shaw\r\nType \"help\" for a list of commands\r\nThe xml is well-formed, applying configuration\r\nhammerdb>source schemabuild.tcl<\/pre>\n
To run the test you can configure a script to automate a sequence of tests just like the autopilot feature in the GUI. This example runs tests from 1 right through to 104 virtual users. Note in this case the driver is now being run from a client system (remember to install the client library and check that it loads here as well) and logtotemp is set so that all of the output is captured to a file.<\/div>\n
$ more mysqlrun.tcl\r\n#!\/bin\/tclsh\r\nproc runtimer { seconds } {\r\nset x 0\r\nset timerstop 0\r\nwhile {!$timerstop} {\r\nincr x\r\nafter 1000\r\n\u00a0 if { ![ expr {$x % 60} ] } {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 set y [ expr $x \/ 60 ]\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 puts \"Timer: $y minutes elapsed\"\r\n\u00a0 }\r\nupdate\r\nif {\u00a0 [ vucomplete ] || $x eq $seconds } { set timerstop 1 }\r\n\u00a0\u00a0\u00a0 }\r\nreturn\r\n}\r\nputs \"SETTING CONFIGURATION\"\r\ndbset db mysql\r\ndiset connection mysql_host 192.168.1.1\r\ndiset connection mysql_port 3306\r\ndiset tpcc mysql_driver timed\r\ndiset tpcc my_rampup 2\r\ndiset tpcc my_duration 5\r\nvuset logtotemp 1\r\nloadscript\r\nputs \"SEQUENCE STARTED\"\r\nforeach z { 1 2 4 8 12 16 20 24 28 32 36 40 44 48 52 56 60 64 68 72 76 80 84 88 92 96 100 104 } {\r\nputs \"$z VU TEST\"\r\nvuset vu $z\r\nvucreate\r\nvurun\r\nruntimer 600\r\nvudestroy\r\nafter 5000\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\r\nputs \"TEST SEQUENCE COMPLETE\"<\/pre>\n
<\/div>\n
Then as above run the script, it will now run the script unattended executing the sequence of tests.<\/div>\n
$ .\/hammerdbcli\r\nHammerDB CLI v3.1\r\nCopyright (C) 2003-2018 Steve Shaw\r\nType \"help\" for a list of commands\r\nThe xml is well-formed, applying configuration\r\nhammerdb>source mysqlrun.tcl<\/pre>\n
That’s all you need to build a schema and run a sequence of tests with HammerDB without the GUI.<\/div>\n<\/div>\n