Skip to content

Instantly share code, notes, and snippets.

@itxx00

itxx00/mysql_bench.sh

Created December 18, 2014 06:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save itxx00/e20e775ec650609932ff to your computer and use it in GitHub Desktop.
Save itxx00/e20e775ec650609932ff to your computer and use it in GitHub Desktop.
Download ZIP
mysql_bench.sh
Raw
mysql_bench.sh
#!/bin/bash
#
sync && sync
case $1 in
select)
echo 3 > /proc/sys/vm/drop_caches
mysqlslap --no-defaults --concurrency=50 --engine=innodb --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=key --auto-generate-sql-write-number=100000 --number-of-queries=300000
echo 3 > /proc/sys/vm/drop_caches
;;
insert)
echo 3 > /proc/sys/vm/drop_caches
mysqlslap --no-defaults --concurrency=50 --engine=innodb --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=write --auto-generate-sql-write-number=100000 --number-of-queries=300000
echo 3 > /proc/sys/vm/drop_caches
;;
update)
echo 3 > /proc/sys/vm/drop_caches
mysqlslap --no-defaults --concurrency=50 --engine=innodb --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=update --auto-generate-sql-write-number=100000 --number-of-queries=300000
echo 3 > /proc/sys/vm/drop_caches
;;
mixed)
echo 3 > /proc/sys/vm/drop_caches
mysqlslap --no-defaults --concurrency=50 --engine=innodb --auto-generate-sql --auto-generate-sql-add-autoincrement --auto-generate-sql-load-type=mixed --auto-generate-sql-write-number=100000 --number-of-queries=300000
echo 3 > /proc/sys/vm/drop_caches
;;
*)
echo "usage: $0 select|insert|update|mixed"
exit 1
;;
esac
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment