> Kevin,
>
> command is
> sysbench --test=tests/db/oltp.lua --oltp_tables_count=16 --oltp-table-
> size=$ROWS --rand-init=on --num-threads=$thread --oltp-read-only=off
> --report-interval=10 --rand-type=zipf --rand-zipf-t=0.9 --mysql-
> socket=/var/lib/mysql/mysql.sock --max-time=$RT --max-requests=0 --mysql-
> user=root --percentile=99 run
>
> what value should I use for innodb_row_cache_cell_num ?
Vadim,
The default value of innodb_row_cache_cell_num is 10000.
You can set --innodb-buffer-pool-size=5GB --innodb_row_cache_mem_pool_size=5GB --innodb_row_cache_cell_num=10000
and set --innodb-buffer-pool-size=10GB --innodb_row_cache_mem_pool_size=10GB --innodb_row_cache_cell_num=20000
for test.
> Kevin, tests/db/ oltp.lua --oltp_ tables_ count=16 --oltp-table- $thread --oltp- read-only= off interval= 10 --rand-type=zipf --rand-zipf-t=0.9 --mysql- /var/lib/ mysql/mysql. sock --max-time=$RT --max-requests=0 --mysql- row_cache_ cell_num ?
>
> command is
> sysbench --test=
> size=$ROWS --rand-init=on --num-threads=
> --report-
> socket=
> user=root --percentile=99 run
>
> what value should I use for innodb_
Vadim,
The default value of innodb_ row_cache_ cell_num is 10000. buffer- pool-size= 5GB --innodb_ row_cache_ mem_pool_ size=5GB --innodb_ row_cache_ cell_num= 10000 buffer- pool-size= 10GB --innodb_ row_cache_ mem_pool_ size=10GB --innodb_ row_cache_ cell_num= 20000
You can set --innodb-
and set --innodb-
for test.