Re: Collisions

HI Henrik

Tha database parameter CONVERTER_REGIONS = 8.
Yes , I have backup at night and at noon with update statisctics following
it.
I will cancel the noon task.

Should I increase the aprameter?

Best regards,

2007/7/11, Henrik Hempelmann <[email protected]>:
>
>
> On 11.07.2007, at 20:01, Daniel Castro wrote:
>
> > Hi,
> >
> > I get the following message:
> >
> > I  CONV2: collision rate 4.17%, 351 collisions, 326 waits (3.87%),
> > 8425
> > accesses on region 6
> >      CON: REGION_COLLISION_PERCENT[""] > 2
> >      VAL: 4.17
> >
> > What is this "CONV2" region?
>
> Regions protect the internal data structures to prevent conflicts
> during concurrent access. CONV is for the converter, the mapping
> table between logical page numbers to physical block addresses on the
> data volumes. To reduce collisions on the converter, it's striped
> into a number of regions, usually 8 to 64 regions depending on the
> total size of the data area. So CONV2 is the second region out of a
> number of converter regions.
> For a short explanation have a look at the parameter CONVERTER_REGIONS.
> Are there any collisions on the other converter regions? Do you have
> I/O intensive tasks running in parallel - like data backup, check
> data or update statistics?
>
>
>    Henrik
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/[email protected]
>
>


-- 
Daniel Castro - דניאל
MSN: [email protected]
Skype: danielti2005
ICQ : 316727989
Jabber: danielti
Linux User: 387864
AOL User: Danielti2005
Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria