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 Options:

--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.

Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Table Of Contents

Previous topic

tcpdump plugin

Next topic

Known Issues

This Page



© Copyright 2011-2013 Percona Ireland Ltd.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.1.3.
This documentation is developed in Launchpad as part of the Percona Playback source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>