> Kevin,
>
> How does that explain that with
> --innodb-buffer-pool-size=10GB --innodb_row_cache_mem_pool_size=10GB
>
> I am getting worse throughput then with
> --innodb-buffer-pool-size=5GB --innodb_row_cache_mem_pool_size=5GB
>
> Again, whatever distribution is, I do not expect to see worse results with
> bigger cache.
Hi Vadim,
I think i found the reason why bigger cache cause worse performance.
If you set bigger innodb-buffer-pool-size,accordingly you need set bigger innodb_row_cache_cell_num too.
I use hashtable to store the records , so bigger innodb-buffer-pool-size cause more records to store in the hashtable, and the hashtable is more deeper , it make worse performance.
So set the bigger innodb_row_cache_cell_num can make hashtable shallower, it can make better performance.
> Kevin, buffer- pool-size= 10GB --innodb_ row_cache_ mem_pool_ size=10GB buffer- pool-size= 5GB --innodb_ row_cache_ mem_pool_ size=5GB
>
> How does that explain that with
> --innodb-
>
> I am getting worse throughput then with
> --innodb-
>
> Again, whatever distribution is, I do not expect to see worse results with
> bigger cache.
Hi Vadim,
I think i found the reason why bigger cache cause worse performance. buffer- pool-size, accordingly you need set bigger innodb_ row_cache_ cell_num too. buffer- pool-size cause more records to store in the hashtable, and the hashtable is more deeper , it make worse performance.
If you set bigger innodb-
I use hashtable to store the records , so bigger innodb-
So set the bigger innodb_ row_cache_ cell_num can make hashtable shallower, it can make better performance.