Skip to content

Instantly share code, notes, and snippets.

@yicr
Created August 17, 2021 09:20
Show Gist options
  • Save yicr/0ac1d7ac626db6cd7d341806b541ef5d to your computer and use it in GitHub Desktop.
Save yicr/0ac1d7ac626db6cd7d341806b541ef5d to your computer and use it in GitHub Desktop.

標準搭載のmysqlslapを使って負荷テスト。

mysqlslap -u <username> -p -h <hostname> \
--engine=innodb \
--concurrency=300 \
--iterations=30 \
--auto-generate-sql \
--auto-generate-sql-load-type=mixed \
--number-char-cols=30 \
--number-int-cols=20 \
--auto-generate-sql-write-number=100000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment