mysqlslap — A Load Emulation Client The number of times to run the tests. Read options from the named login path in the  .mylogin.cnf  login path file. A “login path”  is an option group containing options that specify which MySQL server to connect to and which account to authenticate as. To create or modify a login path file, use the  mysql_config_editor  utility. See Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility” . For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . Prevent  mysqlslap  from dropping any schema it creates during the test run. Do not read any option files. If program startup fails due to reading unknown options from an option file, --no-defaults  can be used to prevent them from being read. The exception is that the  .mylogin.cnf  file is read in all cases, if it exists. This permits passwords to be specified in a safer way than on the command line even when  --no-defaults  is used. To create .mylogin.cnf , use the  mysql_config_editor  utility. See Section 4.6.7, “mysql_config_editor — MySQL Configuration Utility” . For additional information about this and other option-file options, see Section 4.2.2.3, “Command-Line Options that Affect Option-File Handling” . The number of  VARCHAR  columns to use if  --auto-generate-sql  is specified. The number of  INT  columns to use if  --auto-generate-sql  is specified. Limit each client to approximately this many queries. Query counting takes into account the statement delimiter. For example, if you invoke  mysqlslap  as follows, the  ;  delimiter is recognized so that each instance of the query string counts as two queries. As a result, 5 rows (not 10) are inserted. Do not connect to databases.  mysqlslap  only prints what it would have done. 548 • --only-print • --number-of-queries= N • --number-int-cols= N ,  -y  N • --number-char-cols= N ,  -x  N • --no-defaults • --no-drop • --login-path= name mysqlslap --delimiter=";" --number-of-queries=10 --query="use test;insert into t values(null)"