--number-of-queries参数
首先,该参数限定mysqlslap主线程初始化完成后,所有的、真正的、测试子线程、的累计查询执行次数上限值,是所有测试子线程的累计值
其次,累计次数不能保证是十分精确的,通常指定N,总执行次数就是N,如果没有什么意外抖动的话
然后,特殊的:不指定该参数 or 即该参数的默认值 or 显式设置参数的值为“0”时,它会成为“N=11”,amazing!!!
最后,当你故意指定参数的值为“<0的负数”时,程序会告诉你,“参数无效,它会自动调整为0”,然后看上面的规则,0成为“N=11”,amazing!!!
[mysql@6CU3515V29 ~]$ mysqlslap -h10.1.101.3 -uroot -proot -e innodb -c1 -a -x2 -y2 --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=0 --auto-generate-sql-write-number=1 --auto-generate-sql-load-type=key --number-of-queries=1 --only-print |grep -i select|wc -l mysqlslap: [Warning] Using a password on the command line interface can be insecure. 1 [mysql@6CU3515V29 ~]$ mysqlslap -h10.1.101.3 -uroot -proot -e innodb -c1 -a -x2 -y2 --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=0 --auto-generate-sql-write-number=1 --auto-generate-sql-load-type=key --number-of-queries=2 --only-print |grep -i select|wc -l mysqlslap: [Warning] Using a password on the command line interface can be insecure. 2 ... [mysql@6CU3515V29 ~]$ mysqlslap -h10.1.101.3 -uroot -proot -e innodb -c1 -a -x2 -y2 --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=0 --auto-generate-sql-write-number=1 --auto-generate-sql-load-type=key --number-of-queries=11 --only-print |grep -i select|wc -l mysqlslap: [Warning] Using a password on the command line interface can be insecure. 11 [mysql@6CU3515V29 ~]$ mysqlslap -h10.1.101.3 -uroot -proot -e innodb -c1 -a -x2 -y2 --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=0 --auto-generate-sql-write-number=1 --auto-generate-sql-load-type=key --number-of-queries=12 --only-print |grep -i select|wc -l mysqlslap: [Warning] Using a password on the command line interface can be insecure. 12 [mysql@6CU3515V29 ~]$ mysqlslap -h10.1.101.3 -uroot -proot -e innodb -c1 -a -x2 -y2 --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=0 --auto-generate-sql-write-number=1 --auto-generate-sql-load-type=key --number-of-queries=0 --only-print |grep -i select|wc -l mysqlslap: [Warning] Using a password on the command line interface can be insecure. 11 ... [mysql@6CU3515V29 ~]$ mysqlslap -h10.1.101.3 -uroot -proot -e innodb -c1 -a -x2 -y2 --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=0 --auto-generate-sql-write-number=1 --auto-generate-sql-load-type=key --number-of-queries=-1 --only-print |grep -i select|wc -l mysqlslap: [Warning] Using a password on the command line interface can be insecure. mysqlslap: [Warning] option 'number-of-queries': value -1 adjusted to 0. 11 [mysql@6CU3515V29 ~]$ mysqlslap -h10.1.101.3 -uroot -proot -e innodb -c1 -a -x2 -y2 --auto-generate-sql-add-autoincrement --auto-generate-sql-secondary-indexes=0 --auto-generate-sql-write-number=1 --auto-generate-sql-load-type=key --number-of-queries=-9 --only-print |grep -i select|wc -l mysqlslap: [Warning] Using a password on the command line interface can be insecure. mysqlslap: [Warning] option 'number-of-queries': value -9 adjusted to 0.
-i, --iterations=N参数:测试子线程的重复次数
N默认为1
当N<1时,都会自动调整到默认值1