Re: multiple dbwr's and deadlock

Having a large db_block_lru_latches in 7.3 is going to give you problems with 'free buffer waits'.
I know that some books say that it should be 2*cpu, you wil see in reality that a value of 4-8 is sufficient in 95 percent of the cases (there are always exceptions).

Anjo.

Nuno Souto wrote:

> On Tue, 08 May 2001 07:21:57 GMT, Anjo Kolk <k.kolk_at_chello.nl> wrote:
> >So what to do in your case:
> >
> >1) db_block_lru_latches = 4-8
> >2) db_writers = 16 or even higher
> >3) _db_block_write_batch = <something decent, less than (db_files *
> >db_file_multi_block_read_count)/2).
> >
>
> PMFJI. Shouldn't 1) be (indirectly) related to the number of CPUs?
> By this I mean for example: 4 CPUs, 8 DBWR, then 1) = 4? Or is it "no
> relation"?
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Tue May 08 2001 - 13:57:04 CDT