Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to use hammerdb for benchmark testing in MySQL. Many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something from this article.

Root@master / usr/local/HammerDB-2.23]

# pwd

/ usr/local/hammerora-2.6

[root@master / usr/local/HammerDB-2.23]

# cat config.xml

Xml version= "1.0" encoding= "utf-8"? >

...

Grant all on tpcc.* to hammerdb@'%' identified by 'hammerdb'

Root@master / usr/local/HammerDB-2.23]

# cd / usr/local/HammerDB-2.23/

Use tpcc

: 9l

Show processlist

.

| | 7302 | hammerdb | 10.10.30.14Query 44195 | tpcc | Query | 0 | closing tables | COMMIT |

| | 7303 | hammerdb | 10.10.30.14Sleep 44196 | tpcc | Sleep | 0 | | NULL |

| | 7304 | hammerdb | 10.10.30.14Query 44197 | tpcc | Query | 0 | query end | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, | |

| | 7305 | hammerdb | 10.10.30.14Query 44198 | tpcc | Query | 0 | updating | UPDATE order_line SET ol_delivery_d = timestamp |

WHERE ol_o_id = d_no_o_id AND ol_d_id = d_d_id AND

O |

| | 7306 | hammerdb | 10.10.30.14Query 44199 | tpcc | Query | 0 | optimizing | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, slack _ |

| | 7307 | hammerdb | 10.10.30.14Sleep 44200 | tpcc | Sleep | 0 | | NULL |

| | 7308 | hammerdb | 10.10.30.14Query 44201 | tpcc | Query | 0 | NULL | COMMIT |

+- -+

131 rows in set (0.00 sec)

At this point, we need to check the value of tpm by clicking the button shown in the following figure

Then, from the window shown below, you can wait for dozens of seconds to see the value, and then you can see the graph, which can be used to find the performance jitter problem more intuitively.

If you want to terminate the test and the tpm statistical output, you can click the two buttons shown in the following figure (the first for terminating the benchmark and the second for terminating the tpm statistical output)

After reading the above, do you have any further understanding of how to use hammerdb for benchmarking in MySQL? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.