is there any createifmissing in bechbase for mariadb?

[minsky922]

hello, i run benchbase below option: java -jar benchbase.jar -b tpcc -c config/mariadb/sample_tpcc_config.xml --create=true --load=true --execute=true

[ERROR] 2025-06-27 16:59:19,488 [main] com.oltpbenchmark.DBWorkload main - Unexpected error when creating benchmark database tables. java.sql.SQLSyntaxErrorException: (conn=12) Unknown database 'benchbase'

even if i create database benchbase,

[ERROR] 2025-06-27 17:18:19,380 [Thread-0] com.oltpbenchmark.util.ThreadUtil run - Exception in Loader Thread with message: [no table found with name [item]]; will count down latch with count 2 and then exit :(

i can read the code of benchbase and findout what does the table 'item' look like and manually create 'item' table, but is there any option for createifmissing for when benchbase start?

[bpkroth]

Hi, no, the database generally needs to be created first by the root user and granted permissions to someone else so that the benchmark itself doesn't require full permissions.

Once that's done table creation and loading may or may not use CREAT IF MISSING depending on what the target engine supports and whether --execute load/create options are provided.

Hope that helps!