#############################################################################
# InnoDB Benchmark Properties -- TidesDB/InnoDB
#
# Created: June 2026
# Version: 1.0
#
# This file is part of the Test Automation Framework (TAF).
# Copyright (c) 2025-2026 MariaDB Foundation and Jonathan "jeb" Miller
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 or later of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1335 
#
# Licensed under the GNU General Public License, version 2 or later (GPLv2+).
# See https://www.gnu.org/licenses/ for details.
#
# PURPOSE:
#     Run sysbench-lua OLTP workloads against MariaDB 12.2.2 using InnoDB.
#     Paired with benchmark_tidesdb.properties for engine comparison.
#
# USAGE:
#     # Build sysbench client (one-time):
#     perl taf.pl --prop=./properties/mariadb/beta/sysbench_tidesdb_compare_innodb_write.properties \
#         --action=setup-client
#
#     # Run the full benchmark:
#     perl taf.pl --prop=./properties/mariadb/beta/sysbench_tidesdb_compare_innodb_write.properties
#
#############################################################################

# MAIN PROPERTIES

# Storage engine InnoDB?TidesDB
taf.db_engine=Innodb
#taf.db_engine=TidesDB

# MariaDB config file InnoDB?TidesDB
taf.db_config_file=./database_config_files/mariadb/innodb_compare.cnf
#taf.db_config_file=./database_config_files/mariadb/tides_compare.cnf

# RW does not uses, only WO has MODIFIABLE abilities 
sysbench_lua.oltp_index_updates    = 3
sysbench_lua.oltp_non_index_updates= 3
sysbench_lua.oltp_del_ins          = 3

# Ignore retry 1180
sysbench_lua.ignore_errors=1180

# All tests start fresh
taf.test_setup_mode=per_test

#############################################################################
# TAF SETTINGS (GLOBAL)
#############################################################################

## Action: initialize DB, start server, run tests, stop server
taf.action=init-start-db-run-tests

# Skip the running-DB-process check
taf.ignore_running_db_process=false

# Run description
taf.comments="OLTP benchmark for TidesDB vs InnoDB"

# Host
taf.host=localhost

#############################################################################
# TEST EXECUTION SETTINGS
#############################################################################

# Duration per thread-count iteration (seconds)
taf.duration=1800

# Number of iterations per thread count
taf.iterations=3

# Test suite
taf.test_suite=sysbench-lua

# Run type
taf.test_type=adhoc

# Workloads to run
taf.tests=OLTP_RW,OLTP_WO_MODIFIABLE,UPDATE_KEY,UPDATE_NO_KEY,INSERT,DELETE
taf.tests=UPDATE_KEY,UPDATE_NO_KEY


# Thread counts to sweep
taf.threads=32,64,128,256,512
taf.threads=512

# Warmup
taf.warmup_duration=200
taf.warmup_threads=128

#############################################################################
# TIMING CONTROLS
#############################################################################

taf.db_process_rest_enable=true
taf.db_process_rest_low=6
taf.db_process_rest_high=20

#############################################################################
# REPORT GENERATION
#############################################################################

taf.report_plugin=taf_res_raw_text.pm,text.pm,chart_and_test_info_results_tables_html.pm

#############################################################################
# DATABASE SETTINGS
#############################################################################

# Connect via UNIX socket
taf.db_clients_use_unix_socket=true

# Database data directory
taf.db_data_dir=/data/data/

# MariaDB installation directory 
taf.db_software_install_dir=/data/tides_build/mariadb


#############################################################################
# SYSBENCH-LUA SETTINGS
#############################################################################

# MariaDB connector
sysbench_lua.db_driver=mariadb

# Table configuration
sysbench_lua.number_of_rows=1000000
sysbench_lua.number_of_tables=8

# Intermediate results (2 = detailed per-second output)
sysbench_lua.intermediate_result=2

#############################################################################
# SYSBENCH DEBUG
#############################################################################

sysbench_lua.debug_sysbench=false

# TAF debug
taf.tools_debug=true
taf.verbose=true