mysqlslap Scripts for Testing Insert Performance in MySQL WITH and WITHOUT primary keys

insert_perf_mysql_primary_key.sh

mysqlslap --create-schema="tests" \
          --concurrency=4 \
          --query="insert into test_inserts_with_primary_key select null id, md5(rand()) text_field_1, md5(rand()) text_field_2, curdate() - interval round(rand() * 200) day created_at" \n 
          --number-of-queries=10000000 \
          --iterations=1 \
          -uroot -p
          
mysqlslap --create-schema="tests" \
          --concurrency=4 \
          --query="insert into test_inserts_with_primary_key select 10129 id, md5(rand()) text_field_1, md5(rand()) text_field_2, curdate() - interval round(rand() * 200) day created_at" \n 
          --number-of-queries=10000000 \
          --iterations=1 \
          -uroot -p

Can you please post DDL for the tables?