mysqlslap — A Load Emulation Client Add a GUID-based primary key to automatically generated tables. Specify the test load type. The permissible values are  read  (scan tables),  write  (insert into tables), key  (read primary keys),  update  (update primary keys), or  mixed  (half inserts, half scanning selects). The default is  mixed . Specify how many secondary indexes to add to automatically generated tables. By default, none are added. How many different queries to generate for automatic tests. For example, if you run a  key  test that performs 1000 selects, you can use this option with a value of 1000 to run 1000 unique queries, or with a value of 50 to perform 50 different selects. The default is 10. How many different queries to generate for  --auto-generate-sql-write-number . The default is 10. How many row inserts to perform. The default is 100. How many statements to execute before committing. The default is 0 (no commits are done). Compress all information sent between the client and the server if possible. See Section 4.2.8, “Connection Compression Control” . As of MySQL 8.0.18, this option is deprecated. Expect it to be removed in a future version of MySQL. See Configuring Legacy Connection Compression. The permitted compression algorithms for connections to the server. The available algorithms are the same as for the  protocol_compression_algorithms  system variable. The default value is uncompressed . For more information, see Section 4.2.8, “Connection Compression Control” . This option was added in MySQL 8.0.18. The number of parallel clients to simulate. The file or string containing the statement to use for creating the table. 545 • --auto-generate-sql-guid-primary • --auto-generate-sql-load-type= type • --auto-generate-sql-secondary-indexes= N • --auto-generate-sql-unique-query-number= N • --auto-generate-sql-unique-write-number= N • --auto-generate-sql-write-number= N • --commit= N • --compress ,  -C • --compression-algorithms= value • --concurrency= N ,  -c  N • --create= value