Shulou(Shulou.com)06/01 Report--

This article mainly introduces "how to install MySQL stress testing tool super smack under LINUX system". In daily operation, I believe many people have doubts about how to install MySQL stress testing tool super smack under LINUX system. Xiaobian consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to install MySQL stress testing tool super smack under LINUX system". Next, please follow the editor to study!

1. Source file download address: http://vegan.net/tony/supersmack/ 2. Installation: note that when compiling, you can copy the corresponding libmysqlclient.so.* to / usr/lib 3. Test:

[root@DB_Backup smacks] # super-smack-d mysql select-key.smack 10 10000

Query Barrel Report for client smacker1

Connect: max=37ms min=0ms avg= 10ms from 10 clients

Query_type num_queries max_time min_time q_per_s

Select_index 200000 00 10148.47 [root@DB_Backup smacks] # super-smack-d mysql update-select.smack 10 1000

Query Barrel Report for client smacker

Connect: max=2ms min=0ms avg= 0ms from 10 clients

Query_type num_queries max_time min_time q_per_s

Select_index 10000 10 4038.90

Update_index 10000 10 4038.90 in the above test results, * 10 represents 10 clients accessing at the same time, and 1000 represents the number of queries per client (in the script, the number of queries is doubled)

* max, min, avg are the maximum, minimum, and average connection time of the client.

* num_queries, max_time and min_time are the total number of requests, and the maximum and minimum query time (in milliseconds)

* q_per_s is the number of requests processed per second

At this point, the study on "how to install the MySQL stress testing tool super smack under the LINUX system" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.