> On Mon, 14 May 2012 01:24:17 -0000, "Kevin.Huang" <email address hidden>
> wrote:
> > 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.
>
> I suggest perhaps having a sensible default calculation for it, maybe
> 1000/GB of row cache? does that seems sensible?
>
> --
> Stewart Smith
Hi Stewart,
Innodb_row_cache_cell_num 's value depended on the size of the record which be cached by row cache.
The smaller record need more innodb_row_cache_cell_num for high performance, so i make it can be configured.
> On Mon, 14 May 2012 01:24:17 -0000, "Kevin.Huang" <email address hidden> row_cache_ cell_num is 10000. buffer- pool-size= 5GB row_cache_ mem_pool_ size=5GB --innodb_ row_cache_ cell_num= 10000 buffer- pool-size= 10GB --innodb_ row_cache_ mem_pool_ size=10GB row_cache_ cell_num= 20000
> wrote:
> > The default value of innodb_
> > You can set --innodb-
> --innodb_
> > and set --innodb-
> --innodb_
> > for test.
>
> I suggest perhaps having a sensible default calculation for it, maybe
> 1000/GB of row cache? does that seems sensible?
>
> --
> Stewart Smith
Hi Stewart,
Innodb_ row_cache_ cell_num 's value depended on the size of the record which be cached by row cache. row_cache_ cell_num for high performance, so i make it can be configured.
The smaller record need more innodb_