Skip to content

Instantly share code, notes, and snippets.

@dotmanila

dotmanila/dsync-benchmark.txt

Created September 28, 2017 14:32
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 dotmanila/d794f739ae88967f8417bb569e98546d to your computer and use it in GitHub Desktop.
Save dotmanila/d794f739ae88967f8417bb569e98546d to your computer and use it in GitHub Desktop.
Download ZIP
O_DSYNC Benchmark on GCE with Percona Server
Raw
dsync-benchmark.txt
env SANDBOX_BINARY=/home/jervin/mysql make_sandbox 5.7.190 -- \
--upper_directory=/mysql-ext4/msb --my_clause=innodb_buffer_pool_size=38G \
--my_clause=innodb_log_file_size=536870912 --my_clause=innodb_flush_method=O_DIRECT \
--my_clause=bind-address=0.0.0.0 --my_clause=skip_name_resolve=1 \
--my_clause=thread_cache_size=48 --my_clause=performance_schema=off \
--my_clause=max_allowed_packet=33554432 --my_clause=innodb_page_cleaners=8 \
--my_clause=innodb_lru_scan_depth=2048 --my_clause=innodb_io_capacity=5000 \
--my_clause=innodb_io_capacity_max=10000 --my_clause=innodb_flushing_avg_loops=5 \
--my_clause=innodb_flush_neighbors=2 --my_clause=innodb_buffer_pool_instances=8
sysbench --db-driver=mysql --mysql-user=msandbox --mysql-password=msandbox \
--mysql-db=test --mysql-host=10.128.0.4 --mysql-port=57190 --tables=8 \
--table-size=60000000 --auto-inc=off --threads=8 --time=1800 \
--rand-type=pareto oltp_read_write run
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment