#!/bin/bash

# Force deterministic CPU behavior for benchmarking
sudo cpupower frequency-set -g performance >/dev/null 2>&1
sudo cpupower frequency-set -u 2700MHz >/dev/null 2>&1
sudo cpupower frequency-set -d 2700MHz >/dev/null 2>&1

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_baseline.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_BASELINE_2 \
  > run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_innodb_doublewrite_off.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_INNODB_DOUBLEWRITE_OFF \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_utf8mb3.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_UTF8MB3 \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_latin1.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_LATIN1 \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_rc_isolation.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_RC_ISOLATION \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_binlog.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_BINLOG \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_rc_isolation_binlog.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_RC_ISOLATION_BINLOG \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_ru_isolation.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_RU_ISOLATION \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_ru_isolation_binlog.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_RU_ISOLATION_BINLOG \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_serializable_isolation.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_SERIALIZABLE_ISOLATION \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_query_cache_type.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_QUERY_CACHE_TYPE \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_general_log.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_GENERAL_LOG \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_innodb_adaptive_hash_index.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_INNODB_ADAPTIVE_HASH_INDEX \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_innodb_flush_log_at_trx_commit_0.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_INNODB_FLUSH_LOG_AT_TRX_COMMIT_0 \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_innodb_flush_log_at_trx_commit_2.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_INNODB_FLUSH_LOG_AT_TRX_COMMIT_2 \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_threadpool.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_THREADPOOL \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_log_slow_query_001.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_LOG_SLOW_QUERY_001 \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_log_slow_query_001_all_all.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_LOG_SLOW_QUERY_001_ALL_ALL \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_binlog_min.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_BINLOG_MIN \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_binlog_noblob.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_BINLOG_NOBLOB \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_binlog_snyc.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_BINLOG_SYNC \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_performance_schema.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_PERFORMANCE_SCHEMA \
  >> run.out 2>&1

sleep 5

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_performance_schema_medium.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_PERFORMANCE_SCHEMA_MED \
  >> run.out 2>&1

perl taf.pl \
  --prop=./properties/mariadb/MDEV39497_test.properties \
  --db-config-file=./database_config_files/mariadb/MDEV39497/MDEV39497_performance_schema_medium.cnf \
  --db-cpu-affinity=0-11 --test-case-tag=MDEV39497_PERFORMANCE_SCHEMA_ALL \
  --exec-sql-file-before-test-setup=/home/jeb/taf-perl/scripts/sql/mariadb//MDEV39497_enable_pfs.sql \
  >> run.out 2>&1