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