{"id":1333,"date":"2023-03-23T19:02:04","date_gmt":"2023-03-23T19:02:04","guid":{"rendered":"https:\/\/www.hammerdb.com\/blog\/?p=1333"},"modified":"2023-03-25T17:37:41","modified_gmt":"2023-03-25T17:37:41","slug":"hammerdb-v4-7-new-features-pt1-transaction-counter-and-cpu-metrics","status":"publish","type":"post","link":"https:\/\/www.hammerdb.com\/blog\/uncategorized\/hammerdb-v4-7-new-features-pt1-transaction-counter-and-cpu-metrics\/","title":{"rendered":"HammerDB v4.7 New Features Pt1: Transaction Counter and CPU Metrics"},"content":{"rendered":"<p>In HammerDB v4.7 the Transaction Counter and CPU Metrics have been updated on both Windows and Linux to use a package called <a href=\"http:\/\/chiselapp.com\/user\/rene\/repository\/tkpath\/index\">tkpath<\/a> enabling more advanced graphic features using the GPU where available.\u00a0 This gives the transaction counter,<\/p>\n<p><a href=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112106.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1338\" src=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112106.png\" alt=\"\" width=\"964\" height=\"528\" srcset=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112106.png 964w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112106-300x164.png 300w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112106-768x421.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>and CPU metrics,<\/p>\n<p><a href=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112447.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1339\" src=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112447.png\" alt=\"\" width=\"964\" height=\"528\" srcset=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112447.png 964w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112447-300x164.png 300w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-02-112447-768x421.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>a more updated look and feel, whilst maintaining the previous lightweight impact of the graphical code.<\/p>\n<p>On Linux HammerDB GUI requires <a class=\"link\" href=\"https:\/\/www.cairographics.org\/\" target=\"_top\" rel=\"noopener\">Cairo Graphics<\/a> installed to support this functionality. On all Linux systems tested Cairo Graphics was already installed, however if not it can be installed as follows:<\/p>\n<p>Ubuntu:<\/p>\n<p class=\"programlisting\"><div class=\"dm-code-snippet dark default  dm-normal-version\" style=\"background-color:#abb8c3;\" snippet-height=\"\">\n\t\t\t<div class=\"control-language\">\n                <div class=\"dm-buttons\">\n                    <div class=\"dm-buttons-left\">\n                        <div class=\"dm-button-snippet red-button\"><\/div>\n                        <div class=\"dm-button-snippet orange-button\"><\/div>\n                        <div class=\"dm-button-snippet green-button\"><\/div>\n                    <\/div>\n                    <div class=\"dm-buttons-right\">\n                        <a id=\"dm-copy-raw-code\">\n                        <span class=\"dm-copy-text\">Copy Code<\/span>\n                        <span class=\"dm-copy-confirmed\" style=\"display:none\">Copied<\/span>\n                        <span class=\"dm-error-message\" style=\"display:none\">Use a different Browser<\/span><\/a>\n                    <\/div>\n                <\/div>\n                <pre class=\"no-line-numbers\"><code id=\"dm-code-raw\" class=\"no-wrap language-php\"><\/p>\n<pre class=\"dm-pre-admin-side\">sudo apt-get install libcairo2-dev<\/pre>\n<p class=\"programlisting\"><\/code><\/pre>\n\t\t\t<\/div>\n        <\/div><\/p>\n<p>Red Hat:<\/p>\n<p class=\"programlisting\"><div class=\"dm-code-snippet dark default  dm-normal-version\" style=\"background-color:#abb8c3;\" snippet-height=\"\">\n\t\t\t<div class=\"control-language\">\n                <div class=\"dm-buttons\">\n                    <div class=\"dm-buttons-left\">\n                        <div class=\"dm-button-snippet red-button\"><\/div>\n                        <div class=\"dm-button-snippet orange-button\"><\/div>\n                        <div class=\"dm-button-snippet green-button\"><\/div>\n                    <\/div>\n                    <div class=\"dm-buttons-right\">\n                        <a id=\"dm-copy-raw-code\">\n                        <span class=\"dm-copy-text\">Copy Code<\/span>\n                        <span class=\"dm-copy-confirmed\" style=\"display:none\">Copied<\/span>\n                        <span class=\"dm-error-message\" style=\"display:none\">Use a different Browser<\/span><\/a>\n                    <\/div>\n                <\/div>\n                <pre class=\"no-line-numbers\"><code id=\"dm-code-raw\" class=\"no-wrap language-php\"><\/p>\n<pre class=\"dm-pre-admin-side\">yum install cairo-devel<\/pre>\n<p class=\"programlisting\"><\/code><\/pre>\n\t\t\t<\/div>\n        <\/div><\/p>\n<p>The transaction counter can be dragged out from the tab in the notebook as shown previously to display in a separate window, or left in the main window as shown below:<\/p>\n<p><a href=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/win1-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1340\" src=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/win1-1-1024x847.png\" alt=\"\" width=\"525\" height=\"434\" srcset=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/win1-1-1024x847.png 1024w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/win1-1-300x248.png 300w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/win1-1-768x635.png 768w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/win1-1.png 1222w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/a><\/p>\n<p>The embedded counter will now also resize when the main window is resized, so when doing demos and filling the screen with HammerDB, the transaction counter will now fill the available space.<\/p>\n<p><a href=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/resize.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-1341\" src=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/resize-1024x659.png\" alt=\"\" width=\"525\" height=\"338\" srcset=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/resize-1024x659.png 1024w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/resize-300x193.png 300w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/resize-768x494.png 768w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/resize.png 1362w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/><\/a><\/p>\n<p>The previous ribbon type effect has been deprecated for a more updated look. However, if there is a desire to maintain the previous graph, it can be enabled in the XML configuration file before HammerDB is started by setting the value tc_graph_ribbon to true from the default of false.<\/p>\n<div class=\"dm-code-snippet dark default  dm-normal-version\" style=\"background-color:#abb8c3;\" snippet-height=\"\">\n\t\t\t<div class=\"control-language\">\n                <div class=\"dm-buttons\">\n                    <div class=\"dm-buttons-left\">\n                        <div class=\"dm-button-snippet red-button\"><\/div>\n                        <div class=\"dm-button-snippet orange-button\"><\/div>\n                        <div class=\"dm-button-snippet green-button\"><\/div>\n                    <\/div>\n                    <div class=\"dm-buttons-right\">\n                        <a id=\"dm-copy-raw-code\">\n                        <span class=\"dm-copy-text\">Copy Code<\/span>\n                        <span class=\"dm-copy-confirmed\" style=\"display:none\">Copied<\/span>\n                        <span class=\"dm-error-message\" style=\"display:none\">Use a different Browser<\/span><\/a>\n                    <\/div>\n                <\/div>\n                <pre class=\"no-line-numbers\"><code id=\"dm-code-raw\" class=\"no-wrap language-php\"><\/p>\n<pre class=\"dm-pre-admin-side\">&lt;transaction_counter&gt; \r\n&lt;settings&gt; \r\n&lt;tc_refresh_rate&gt;10&lt;\/tc_refresh_rate&gt; \r\n&lt;tc_log_to_temp&gt;0&lt;\/tc_log_to_temp&gt; \r\n&lt;tc_unique_log_name&gt;0&lt;\/tc_unique_log_name&gt; \r\n&lt;tc_log_timestamps&gt;0&lt;\/tc_log_timestamps&gt; \r\n&lt;tc_graph_ribbon&gt;true&lt;\/tc_graph_ribbon&gt; \r\n&lt;\/settings&gt; \r\n&lt;\/transaction_counter&gt;<\/pre>\n<p><\/code><\/pre>\n\t\t\t<\/div>\n        <\/div>\n<p>Note that the XML must be set before the first start, as after this point the parameters are stored in the SQLite files and therefore it will be necessary to remove\/refresh the SQLite parameter files to pick up any subsequent changes. When this is done, the previous ribbon effect is shown, although updated to use tkpath features such as antialiasing.<\/p>\n<p><a href=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/ribbon.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1342\" src=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/ribbon.png\" alt=\"\" width=\"815\" height=\"676\" srcset=\"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/ribbon.png 815w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/ribbon-300x249.png 300w, https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2023\/03\/ribbon-768x637.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In HammerDB v4.7 the Transaction Counter and CPU Metrics have been updated on both Windows and Linux to use a package called tkpath enabling more advanced graphic features using the GPU where available.\u00a0 This gives the transaction counter, and CPU metrics, a more updated look and feel, whilst maintaining the previous lightweight impact of the &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.hammerdb.com\/blog\/uncategorized\/hammerdb-v4-7-new-features-pt1-transaction-counter-and-cpu-metrics\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;HammerDB v4.7 New Features Pt1: Transaction Counter and CPU Metrics&#8221;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"ppma_author":[5],"class_list":["post-1333","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"authors":[{"term_id":5,"user_id":2,"is_guest":0,"slug":"hammerdb","display_name":"HammerDB","avatar_url":{"url":"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2018\/10\/logo-white.png","url2x":"https:\/\/www.hammerdb.com\/blog\/wp-content\/uploads\/2018\/10\/logo-white.png"},"author_category":"","user_url":"http:\/\/www.hammerdb.com","last_name":"","first_name":"","job_title":"","description":""}],"_links":{"self":[{"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/posts\/1333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/comments?post=1333"}],"version-history":[{"count":9,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/posts\/1333\/revisions"}],"predecessor-version":[{"id":1337,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/posts\/1333\/revisions\/1337"}],"wp:attachment":[{"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/media?parent=1333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/categories?post=1333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/tags?post=1333"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.hammerdb.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=1333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}