On 091029, ch huang wrote:
> after i set ndb_index_stat_enable = OFF,is it any use to set
> ndb_index_stat_cache_entries to any un-zero value?
No, it has no effect then.
> and i also very confused about the option
>
> ndb_index_stat_update_freq<http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-system-variables.html#sysvar_ndb_index_stat_update_freq>and
>
> ndb_index_stat_cache_entries<http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-system-variables.html#sysvar_ndb_index_stat_cache_entries>,can
> anyone explain the useage?
I don't think this feature is much used. To check if there is
any effect use "sql> explain select..." for enable on and off.
You can leave update frequency as it is. If by some accident
this feature seems useful then cache entries could be increased
a lot from default 32.
--
Pekka Nousiainen, Software Engineer, Sun Microsystems / MySQL
