#taf.profiler_enabled=true #taf.profiler_opts=-a -e cpu-clock --call-graph fp #taf.profiler_start_delay=240 #taf.profiler_duration=30 #taf.profiler_ts_duration_unit=min #taf.profiler_generate_report=true #taf.profiler_generate_flamegraph=true #taf.exec_script_file_after_db_start="/home/jeb/taf-perl/scripts/getMemUsage.sh mariadbd" #taf.exec_script_file_before_run_iter="/home/jeb/taf-perl/scripts/getMemUsage.sh mariadbd" #taf.exec_script_file_after_run_iter="/home/jeb/taf-perl/scripts/getMemUsage.sh mariadbd" #taf.exec_sql_file_after_test_setup=/home/jeb/taf-perl/scripts/innodb.sql #taf.exec_sql_file_after_run_iter=/home/jeb/taf-perl/scripts/innodb.sql #taf.exec_sql_file_after_test_setup=/home/jeb/taf-perl/scripts/perf_schema.sql #taf.exec_sql_file_after_run_iter=/home/jeb/taf-perl/scripts/perf_schema.sql #taf.exec_sql_file_after_run_iter=/home/jeb/taf-perl/scripts/handler_cpu.sql #taf.exec_sql_file_after_run_iter=/home/jeb/taf-perl/scripts/stage_and_wait.sql # Action TAF should perform. taf.action=init-start-db-run-tests # Report plugins (text, csv, json, chart_html) taf.report_plugin=taf_res_raw_text.pm,text.pm,chart_and_test_info_results_tables_html.pm # Comment about why this run is being executed taf.comments="TPROC-C test suite without restore between iterations" ############################################################################# # TEST EXECUTION SETTINGS ############################################################################# # Duration of TPROC-C run in minutes taf.duration=5 # Number of iterations per thread count taf.iterations=3 # Test suite to load taf.test_suite=hammerdb-tprocc # Test type (adhoc, investigation, production, rerun, release) taf.test_type=adhoc # Test case from test suite (hammerdb-tprocc supports only tpcc) taf.tests=tprocc # Thread counts to run taf.threads=10,50,100,200,400 taf.threads=400,200,100,50,10 #taf.threads=200 # HammerDB warmup duration in minutes taf.warmup_duration=2 ############################################################################# # TIMING CONTROLS ############################################################################# # Sleep X seconds after test setup. #taf.sleep_after_test_setup=60 # Sleep X seconds after test run. #taf.sleep_after_test_run=60 # Turns on CPU-based rest detection for the DB process. taf.db_process_rest_enable=true # CPU percent at or below this value counts as "rest". taf.db_process_rest_low=6 # CPU percent at or above this value resets the rest counter (DB not idle). taf.db_process_rest_high=20 ############################################################################# # DATABASE SETTINGS # # These settings control how TAF connects to the MariaDB server for this run. # Any value left commented out will fall back to: # 1. TAF defaults # 2. auto-populated values (special null handling) # 3. command-line overrides ############################################################################# # Path to the MariaDB configuration file to feed into mariadbd. # This must be a valid MariaDB config file. taf.db_config_file=/home/jeb/taf-perl/database_config_files/mariadb_cache.cnf hammerdb_tprocc.timeprofile=false # Optional: directory where the MariaDB software has been unpacked. # If omitted, TAF attempts to auto-detect the install directory. # taf.db_software_install_dir=/home/jeb/taf-perl/database_software_installs/mariadb-12.3.0-linux-systemd-x86_64/ # Whether to connect using a UNIX socket instead of TCP. # true = use socket # false = use TCP (default) taf.db_clients_use_unix_socket=true # Optional: explicit socket path for MySQL connections. # Only needed when using UNIX socket mode. # taf.db_socket=/home/jeb/taf-perl/tmp/mariadb.sock # # Optional overrides for database connection parameters. # Uncomment only if you need to override TAF defaults. # taf.database=test # taf.engine=INNODB # taf.db_user_pass=MariadbPass_@123 # taf.db_user=mariadb_tester # taf.host=localhost # taf.db_socket=/home/jeb/taf-perl/tmp/mysql.sock ############################################################################# # HAMMERDB-TPROCC TEST SUITE SETTINGS # # These settings apply ONLY to the HammerDB-TPROCC test suite. # They control: # - warehouse count # - database type for TCL generation # - checksum behavior # - which HammerDB reports to include # # These override the defaults in hammerdb_tprocc_default.properties. ############################################################################# # Number of warehouses to create and load hammerdb_tprocc.number_of_warehouses=100 # Database type for TCL configuration hammerdb_tprocc.db_type=maria # Checksum after setup hammerdb_tprocc.checksum_after_setup=true # Checksum after each run hammerdb_tprocc.checksum_after_run=true # HammerDB reports per iteration # Reports are found in iterations sub results directory # JSON report options hammerdb_tprocc.include_json_tcount=false hammerdb_tprocc.include_json_timing=false hammerdb_tprocc.include_json_result=false hammerdb_tprocc.include_json_metrics=false # HTML report options hammerdb_tprocc.include_html_tcount=false hammerdb_tprocc.include_html_timing=false hammerdb_tprocc.include_html_result=false hammerdb_tprocc.include_html_metrics=false ##### TAF Debug ##### taf.tools_debug=true taf.verbose=true