Strong doubt on small table(_small_table_threshold)
It is well known that the table is called “small” when the size is smaller than 2% of the buffer cache. That size is calculated on startup into _small_table_threshold parameter. Some links about this: http://jonathanlewis.wordpress.com/2007/01/29/small-partitions/ http://www.ixora.com.au/q+a/cache.htm For instance, in my local database whose db_cache_size is 200m, the _db_block_buffers is 24950. Hence _small_table_threshold should be 24950*2% … Continue reading Strong doubt on small table(_small_table_threshold)
5 Comments