Journal of East China Normal University(Natural Sc ›› 2019, Vol. 2019 ›› Issue (5): 190-202.doi: 10.3969/j.issn.1000-5641.2019.05.016

• Data Management Techniques In the New Era • Previous Articles    

Woodpecker+: Customized workload performance evaluation based on data characteristics

ZHANG Tao, ZHANG Xiao-lei, LI Yu-ming, ZHANG Chun-xi, ZHANG Rong   

  1. School of Data Science and Engineering, East China Normal Univeristy, Shanghai 200062, China
  • Received:2019-07-28 Online:2019-09-25 Published:2019-10-11

Abstract: There are a number of performance testing tools, like Sysbench and OLTPBench, that can be used to benchmark the testing of database performance. However, because the standard benchmark workload is fixed and application scenarios for users are not always representative, it is impossible to accurately determine system performance. Moreover, if users are required to use a high-level programming language to implement a test workload separately for each application, this will undoubtedly introduce a substantial amount of repetitive work, resulting in inefficient testing. To address these issues, this paper designs and implements a user-defined performance test workload tool. The main benefits of this tool can be summarized as follows:It is easy to use and expandable; it provides a test definition language (TDL) for efficient construction of test cases; and it offers flexible control for mixed execution of transactions, data access distribution, lightweight and granular statistical information collection and analysis, and support for multiple mainstream DBMSs and other databases that provide database access interfaces. We highlight the tool's features through a detailed set of customized workload experiments running on the mainstream DBMS.

Key words: database, performance test, customized workload

CLC Number: