devopsbenchmarkingquery-performancepercona

Run multiple clients at once

I'm using the Percona Query Playback tool and I want to run multiple clients at once

This is the sample command

/usr/local/bin/percona-playback --queue-depth 99999 --mysql-max-retries 0 --mysql-host somehost.xxx.com --mysql-username xxx --mysql-password xxxx --mysql-schema xxx --query-log-file some_slow_log.log

I want to be able to run that 30x concurrently. What tool/framework/library should I look at?

Solution

  • If you are running on the terminal. Run the for loop.

    for run in {1..30}
do
  command &
done

    & to run the process in the background, so you can continue to use the shell and do not have to wait until the script is finished

    for run in {1..30}
do
/usr/local/bin/percona-playback --queue-depth 99999 --mysql-max-retries 0 --mysql-host somehost.xxx.com --mysql-username xxx --mysql-password xxxx --mysql-schema xxx --query-log-file some_slow_log.log &
done