TPC-Council / HammerDB

HammerDB Database Load Testing and Benchmarking Tool
http://www.hammerdb.com
GNU General Public License v3.0
545 stars 115 forks source link

Add optional purge and write back for MariaDB TPROC-C #642

Closed sm-shaw closed 7 months ago

sm-shaw commented 8 months ago

Only compatible with MariaDB 10.7.1 and above where purge_threads are dynamic. Functionality is not possible to add to MySQL at the present time as innodb_purge_threads is a read only variable and functionality is dependent on setting purge_threads temporarily to a high value to accelerate the purge process.

In the CLI the time for purge and write back with require a higher setting of keepalive_time. Plan to add a gdset command to set generic dict settings dynamically rather than only through XML to achieve this.

Tested for both sync and async options

purge purge2

abondvt89 commented 7 months ago

Merging after reviews and approval of the three members of the code maintenance team.