Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
O_DSYNC Benchmark on GCE with Percona Server
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
You can’t perform that action at this time.