{"id":407,"date":"2011-01-24T10:55:57","date_gmt":"2011-01-24T15:55:57","guid":{"rendered":"http:\/\/hstore.cs.brown.edu\/"},"modified":"2012-07-16T11:32:21","modified_gmt":"2012-07-16T15:32:21","slug":"profiling","status":"publish","type":"page","link":"https:\/\/hstore.cs.brown.edu\/documentation\/debugging\/profiling\/","title":{"rendered":"Profiling H-Store using JProfiler"},"content":{"rendered":"<p id=\"top\" \/><div class=\"prevpage\"><B>\u00ab<\/B> <a href=\"https:\/\/hstore.cs.brown.edu\/documentation\/debugging\/output-logs\/\" title=\"Execution Output Logs\">Execution Output Logs<\/a><\/div> <div class=\"nextpage\"><a href=\"https:\/\/hstore.cs.brown.edu\/documentation\/debugging\/transaction-profiling\/\" title=\"Internal Transaction Profiling\">Internal Transaction Profiling<\/a> <B>\u00bb<\/B><\/div><div style=\"clear:both;\"><\/div><\/p>\n<p>These instructions are for profiling the H-Store execution front-end using <a href=\"http:\/\/www.ej-technologies.com\/products\/jprofiler\/overview.html\">JProfiler<\/a> and Eclipse. The following steps are an adaption of the instructions on how <a href=\"\/documentation\/development\/debugging\">Debug H-Store in Eclipse<\/a>. This has been tested on Eclipse 3.5 and 3.7.<\/p>\n<ol>\n<li>Install and Configure the JProfiler plug-in in Eclipse.<\/li>\n<ul>\n<li> You need to replace the <tt>libstdc++<\/tt> library that is included with the JProfiler distribution with the library that is installed on your workstation. <BR\/>\n<pre>cd ${JPROFILER_HOME}\/bin\/linux-x64\r\nmv libstdc++.so.6 ORIG-libstdc++.so.6\r\nln -s \/usr\/lib\/x86_64-linux-gnu\/libstdc++.so.6\r\n<\/pre>\n<\/ul>\n<li>After starting Eclipse, right click on <a href=\"https:\/\/github.com\/apavlo\/h-store\/blob\/master\/src\/frontend\/edu\/brown\/hstore\/HStore.java\">HStore.java<\/a> and select <i>Profile As \u2192 Profile Configurations<\/i>. Create a new profile configuration for <tt>HStore<\/tt> with the following parameters:\n<ul>\n<li> <b>Program Arguments:<\/b>\n<pre>catalog.jar=tpcc.jar\r\nsite.id=0\r\nconf=${HSTORE_HOME}\/properties\/default.properties\r\n<\/pre>\n<\/li>\n<li> <b>VM Arguments:<\/b>\n<pre>-ea\r\n-server\r\n-Xmx2048m\r\n-Xcheck:jni\r\n-Djava.library.path=${HSTORE_HOME}\/obj\/release\/nativelibs:\\\r\n                    ${JPROFILER_HOME}\/bin\/linux-x64:\/usr\/lib\r\n<\/pre>\n<\/li>\n<li> <b>Working Directory:<\/b>\n<pre>${HSTORE_HOME}<\/pre>\n<\/li>\n<li> <b>Environment Variables:<\/b>\n<pre>LD_LIBRARY_PATH \u2192 \/usr\/lib:${env_var:LD_LIBRARY_PATH}<\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<li>Build H-Store and create the TPC-C project catalog:\n<pre>ant <tt class=\"ant-target\">build<\/tt> <tt class=\"ant-target\">hstore-prepare<\/tt> -Dproject=tpcc<\/pre>\n<\/li>\n<li>Execute the <tt>HStoreSite<\/tt> profile target in Eclipse. Once it looks like the process is running (if you enable debugging in log4j, you will see a message that says &#8220;<tt>Starting HStoreSite [site=0]<\/tt>&#8220;).<br \/>\nWait just a few seconds and then launch the <tt class=\"ant-target\">hstore-benchmark<\/tt> command shown below. The <tt class=\"ant-option\">nostart<\/tt> option is a comma-separated list of the sites that will be started externally from the <a href=\"https:\/\/github.com\/apavlo\/h-store\/blob\/master\/tests\/frontend\/edu\/brown\/benchmark\/BenchmarkController.java\">BenchmarkController<\/a> framework:<\/p>\n<pre>ant <tt class=\"ant-target\">hstore-benchmark<\/tt> -Dproject=tpcc -Dnostart=0<\/pre>\n<\/li>\n<\/ol>\n<h2>Adding Triggers<\/h2>\n<p>You can add a trigger that causes JProfiler to only start collecting profile information when the first transaction request arrives from a client. This will avoid adding a lot of additional data just data loading portion of a benchmark run.<\/p>\n<ol>\n<li>After starting JProfiler, go to the <em>Trigger Settings<\/em> panel in the <tt>Session Settings<\/tt>. Click on the <tt>+<\/tt> to add a new trigger.\n<li>In the <tt>Trigger Type<\/tt> dropdown menu, choose <em>Method Invocation<\/em>. Click <em>Next<\/em>.\n<li>Click on the <tt>+<\/tt> and select <em>Search in Configured Class Path<\/em>. This will bring up a tree menu of all of the different packages within H-Store. Navigate to <em>edu \u2192 brown \u2192 hstore<\/em> and select <tt>HStoreSite<\/tt>. Click <em>OK<\/em>. In the next window, select the method <tt>notifyStartWorkload(...)<\/tt>. Click <em>OK<\/em>. When you return back to the original Trigger Wizard window, click <em>Next<\/em>.\n<li>Under <tt>Configure Actions<\/tt>, click on the <tt>+<\/tt> and enable whatever options you would. For example, to record the relevant information for the internal operations of H-Store, select <em>Start Recording<\/em> and then choose all of the options in the next window. You can also choose to reset all of the profiling data as well. Click <em>Finished<\/em> to save the trigger.\n<\/ol>\n<p><div class=\"prevpage\"><B>\u00ab<\/B> <a href=\"https:\/\/hstore.cs.brown.edu\/documentation\/debugging\/output-logs\/\" title=\"Execution Output Logs\">Execution Output Logs<\/a><\/div> <div class=\"nextpage\"><a href=\"https:\/\/hstore.cs.brown.edu\/documentation\/debugging\/transaction-profiling\/\" title=\"Internal Transaction Profiling\">Internal Transaction Profiling<\/a> <B>\u00bb<\/B><\/div><div style=\"clear:both;\"><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>These instructions are for profiling the H-Store execution front-end using JProfiler and Eclipse. The following steps are an adaption of the instructions on how Debug H-Store in Eclipse. This has been tested on Eclipse 3.5 and 3.7. Install and Configure the JProfiler plug-in in Eclipse. You need to replace the libstdc++ library that is included [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":1725,"menu_order":20,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/407"}],"collection":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/comments?post=407"}],"version-history":[{"count":39,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/407\/revisions"}],"predecessor-version":[{"id":1771,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/407\/revisions\/1771"}],"up":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/1725"}],"wp:attachment":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/media?parent=407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}