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]
