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
