G
George Potemkin
Guest
> BROKER 0: (4239) Number of Buffers Database (-B): 390000. > BROKER 0: (4242) Table Entries Hash (-hash): 32 . Just can't believe it! KB-18889: -hash How it affects performance. How it should be set. (written by GHB) The default value for -hash is chosen to be a prime number approximately equal to one fourth of the number of database buffers (specified with the -B startup parameter). The exact size of the hash table is not important (see below), but its size should be a prime number because that will produce the most even distribution of buffer headers across hash chains. > Finally I solved the problem by reducing the parameter -hash of 32-0 The -hash parameter requires an argument greater than 0. (1404)
Continue reading...
Continue reading...