Percona Playback Option Reference
This page documents the command-line options for the percona-playback.
Options
-
--help
This option displays a help screen and exits.
-
--version
This option displays the percona-playback version and copyright notice and then exits.
-
--loop N
Do the whole run N times.
Database Options:
-
--db-plugin=NAME
This options tells percona-playback which database plugin to use.
-
--dispatcher-plugin=DISPATCHER
Dispatcher plugin used to replay queries.
-
--input-plugin=NAME
This options tells percona-playback which input plugin to use.
-
--queue-depth[=#]
Queue depth for DB executor (thread). The larger this number is the greater the played-back workload can deviate from the original workload as some connections may be up to queue-depth behind. If no values is specified default is 1.
-
--session-init-query
This query will be executed just after each connect to database
libdrizzle Client Options:
-
--libdrizzle-host=HOST
Hostname of MySQL/Drizzle server
-
--libdrizzle-username=USERNAME
Username to connect to MySQL/Drizzle
-
--libdrizzle-password=PASSWORD
Password for MySQL/Drizzle user
-
--libdrizzle-schema=SCHEMA
Schema to connect to
-
--libdrizzle-port=PORT
Port number the server is listening on
MySQL Client Options:
-
--mysql-host=HOST
Hostname of MySQL server
-
--mysql-port=PORT
MySQL port number
-
--mysql-username=USERNAME
Username to connect to MySQL
-
--mysql-password=PASSWORD
Password for MySQL user
-
--mysql-schema=SCHEMA
MySQL Schema to connect to
Query Log Options:
-
--query-log-file=FILNAME
Query log file that’s going to be used.
-
--query-log-read-count=[#]
Query log file read count (how many times to read query log file). If no value is specified default is 1.
-
--query-log-set-timestamp
By default, query SET TIMESTAMP=XX; that the MySQL slow query log always includes is skipped. This may cause some subsequent queries to fail, depending on the workload. If the --run-set-timestamp option is enabled, these queries are run as well.
-
--query-log-preserve-query-time
This option ensures that each query takes at least Query_time (from slow query log) to execute.
Simple Report Options:
-
--show-per-connection-query-count
Display the number of queries executed for each connection.
-
--tcpdump-file=FILNAME
Tcpdump file name.
-
--tcpdump-port=PORT
Tcpdump port (default 3306).
-
--tcpdump-mode=MODE
The mode of tcpdump plugin (fast|accurate), in ‘fast’ mode the plugin executes queries as fast as it can whereas in ‘accurate’ mode the plugin preserves queries execution time and pauses between queries (default FAST).
Threads-pool Options:
-
--thread-pool-threads-count=[#]
The number of threads in thread pool. If this options is omitted the number of threads equals to hardware concurrency.
