01.gmon_spider_sel_without_partition mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="SELECT sql_no_cache * FROM t1 WHERE a = 1" Benchmark Running for engine spider Average number of seconds to run all queries: 0.021 seconds Minimum number of seconds to run all queries: 0.017 seconds Maximum number of seconds to run all queries: 0.047 seconds Number of clients running queries: 10 Average number of queries per client: 1 02.gmon_spider_sel_with_1024_partitions_before mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="SELECT sql_no_cache * FROM t1 WHERE a = 1" Benchmark Running for engine spider Average number of seconds to run all queries: 1.219 seconds Minimum number of seconds to run all queries: 1.137 seconds Maximum number of seconds to run all queries: 4.757 seconds Number of clients running queries: 10 Average number of queries per client: 1 03.gmon_spider_sel_with_1024_partitions_after mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="SELECT sql_no_cache * FROM t1 WHERE a = 1" Benchmark Running for engine spider Average number of seconds to run all queries: 0.394 seconds Minimum number of seconds to run all queries: 0.302 seconds Maximum number of seconds to run all queries: 3.823 seconds Number of clients running queries: 10 Average number of queries per client: 1 04.gmon_spider_ins_without_partition mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="INSERT IGNORE INTO t1 VALUES (1)" Benchmark Running for engine spider Average number of seconds to run all queries: 0.017 seconds Minimum number of seconds to run all queries: 0.014 seconds Maximum number of seconds to run all queries: 0.038 seconds Number of clients running queries: 10 Average number of queries per client: 1 05.gmon_spider_ins_with_1024_partitions_before mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="INSERT IGNORE INTO t1 VALUES (1)" Benchmark Running for engine spider Average number of seconds to run all queries: 1.112 seconds Minimum number of seconds to run all queries: 0.987 seconds Maximum number of seconds to run all queries: 4.551 seconds Number of clients running queries: 10 Average number of queries per client: 1 06.gmon_spider_ins_with_1024_partitions_after mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="INSERT IGNORE INTO t1 VALUES (1)" Benchmark Running for engine spider Average number of seconds to run all queries: 0.378 seconds Minimum number of seconds to run all queries: 0.307 seconds Maximum number of seconds to run all queries: 3.851 seconds Number of clients running queries: 10 Average number of queries per client: 1 07.gmon_spider_upd_without_partition mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="UPDATE t1 SET a = 3 WHERE a = 2" Benchmark Running for engine spider Average number of seconds to run all queries: 0.020 seconds Minimum number of seconds to run all queries: 0.016 seconds Maximum number of seconds to run all queries: 0.040 seconds Number of clients running queries: 10 Average number of queries per client: 1 08.gmon_spider_upd_with_1024_partitions_before mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="UPDATE t1 SET a = 3 WHERE a = 2" Benchmark Running for engine spider Average number of seconds to run all queries: 1.193 seconds Minimum number of seconds to run all queries: 1.122 seconds Maximum number of seconds to run all queries: 4.621 seconds Number of clients running queries: 10 Average number of queries per client: 1 09.gmon_spider_upd_with_1024_partitions_after mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="UPDATE t1 SET a = 3 WHERE a = 2" Benchmark Running for engine spider Average number of seconds to run all queries: 0.396 seconds Minimum number of seconds to run all queries: 0.309 seconds Maximum number of seconds to run all queries: 3.869 seconds Number of clients running queries: 10 Average number of queries per client: 1 10.gmon_spider_del_without_partition mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="DELETE FROM t1 WHERE a = 2" Benchmark Running for engine spider Average number of seconds to run all queries: 0.014 seconds Minimum number of seconds to run all queries: 0.012 seconds Maximum number of seconds to run all queries: 0.036 seconds Number of clients running queries: 10 Average number of queries per client: 1 11.gmon_spider_del_with_1024_partitions_before mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="DELETE FROM t1 WHERE a = 2" Benchmark Running for engine spider Average number of seconds to run all queries: 1.191 seconds Minimum number of seconds to run all queries: 1.051 seconds Maximum number of seconds to run all queries: 4.761 seconds Number of clients running queries: 10 Average number of queries per client: 1 12.gmon_spider_del_with_1024_partitions_after mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=spider --concurrency=10 --iterations=300 --create-schema=test2 --query="DELETE FROM t1 WHERE a = 2" Benchmark Running for engine spider Average number of seconds to run all queries: 0.396 seconds Minimum number of seconds to run all queries: 0.312 seconds Maximum number of seconds to run all queries: 4.046 seconds Number of clients running queries: 10 Average number of queries per client: 1