Test procedures

1.create myisam table like the followings.
-- without partition
CREATE TABLE `t1` (
  `a` int(11) NOT NULL,
  PRIMARY KEY (`a`)
) ENGINE=MyISAM;
-- with 1024 partition
CREATE TABLE `t1` (
  `a` int(11) NOT NULL,
  PRIMARY KEY (`a`)
) ENGINE=MyISAM
 PARTITION BY KEY (`a`)
PARTITIONS 1024;

2.insert a record
INSERT INTO t1 VALUES (1);

3.execute mysqlslap like the followings
mysqlslap --no-defaults --user=root --socket=/mysql/mariadb-gprof/mysql.sock --engine=myisam --concurrency=10 --iterations=3000 --create-schema=test --query="SELECT sql_no_cache * FROM t1 WHERE a = 1"


mysqlslap results
-- without partition
Benchmark
        Running for engine myisam
        Average number of seconds to run all queries: 0.007 seconds
        Minimum number of seconds to run all queries: 0.006 seconds
        Maximum number of seconds to run all queries: 0.029 seconds
        Number of clients running queries: 10
        Average number of queries per client: 1
-- with 1024 partition
Benchmark
        Running for engine myisam
        Average number of seconds to run all queries: 0.197 seconds
        Minimum number of seconds to run all queries: 0.177 seconds
        Maximum number of seconds to run all queries: 1.703 seconds
        Number of clients running queries: 10
        Average number of queries per client: 1