Specification | Table Size (table_size) | Total Tables (tables) |
2-core 16 GB MEM | 25000 | 250 |
4-core 16 GB MEM | 25000 | 250 |
2-core 32 GB MEM | 25000 | 250 |
8-core 32 GB MEM | 25000 | 250 |
8-core 64 GB MEM | 25000 | 250 |
16-core 64 GB MEM | 25000 | 250 |
16-core 96 GB MEM | 25000 | 250 |
16-core 128 GB MEM | 25000 | 250 |
32-core 128 GB MEM | 25000 | 250 |
32-core 256 GB MEM | 25000 | 250 |
64-core 256 GB MEM | 25000 | 250 |
table_size
and tables
corresponding to the test scenario. Specific parameters are as described below:sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_write_only prepare## Prepare datasysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --threads=192 --percentile=95 --report-interval=1 oltp_write_only run## Run the workloadsysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_write_only cleanup## Clear the data
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only prepare## Prepare datasysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --threads=512 --percentile=95 --range_selects=0 --skip-trx=1 --report-interval=1 oltp_read_only run## Run the workloadsysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only cleanup## Clear the data
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only prepare## Prepare datasysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --threads=512 --percentile=95 --skip-trx=1 --report-interval=1 oltp_read_only run## Run the workloadsysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only cleanup## Clear the data
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write run## Prepare datasysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --range_selects=0 --threads=XXX --percentile=95 --report-interval=1 oltp_read_write run## Run the workloadsysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write cleanup## Clear the data
sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write run## Prepare datasysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --threads=XXX --percentile=95 --report-interval=1 oltp_read_write run## Run the workloadsysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write cleanup## Clear the data
Specification | Table Size (table_size) | Total Tables (tables) |
2-core 16 GB MEM | 800000 | 150 |
4-core 16 GB MEM | 800000 | 300 |
4-core 32 GB MEM | 800000 | 300 |
8-core 32 GB MEM | 800000 | 300 |
8-core 64 GB MEM | 800000 | 450 |
16-core 64 GB MEM | 800000 | 450 |
16-core 96 GB MEM | 800000 | 600 |
16-core 128 GB MEM | 5000000 | 300 |
32-core 128 GB MEM | 5000000 | 300 |
32-core 256 GB MEM | 5000000 | 400 |
64-core 256 GB MEM | 6000000 | 450 |
table_size
and tables
in the commands.Specification | Table Size (table_size) | Total Tables (tables) |
2-core 16 GB MEM | 4000000000 | 1 |
4-core 16 GB MEM | 4000000000 | 1 |
4-core 32 GB MEM | 4000000000 | 1 |
8-core 32 GB MEM | 4000000000 | 1 |
8-core 64 GB MEM | 4000000000 | 1 |
16-core 64 GB MEM | 4000000000 | 1 |
16-core 96 GB MEM | 4000000000 | 1 |
16-core 128 GB MEM | 4000000000 | 1 |
32-core 128 GB MEM | 4000000000 | 1 |
32-core 256 GB MEM | 4000000000 | 1 |
64-core 256 GB MEM | 4000000000 | 1 |
table_size
and tables
in the commands.
Was this page helpful?