MySQL Bugs: #36603: Falcon; Performance drop when ageGroup hits 2^31

Bug #36603	Falcon; Performance drop when ageGroup hits 2^31
Submitted:	8 May 2008 19:22	Modified:	8 Jan 2009 9:41
Reporter:	Kevin Lewis	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S3 (Non-critical)
Version:	6.0.5	OS:	Any
Assigned to:	Kevin Lewis	CPU Architecture:	Any

Description:
In performance tests where DBT2 ran 30 minutes or more, Kelly Long found that there was a precipitous drop in NOTPM after a the test ran long enough that the age group, a 32 byte int on some systems, wrapped over.

How to repeat:
DBT2 on a fast system for 30 minutes or more.

Suggested fix:
Change age group types to uint64

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/46539

ChangeSet@1.2674, 2008-05-08 15:30:19-05:00, klewis@klewis-mysql. +8 -0
  Bug#36603 - Adjust age group values to uint32

Changes made and tested by Kelly were provided and pushed in this changeset by Kevin.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/46580

ChangeSet@1.2671, 2008-05-09 14:58:50-05:00, klewis@klewis-mysql. +10 -0
  Bug#36603 - Adjust age group values to uint32

Fix is in version 6.0.6

No documentation needed.