MySQL Bugs: #5808: mysql crash 99 % cpu

Bug #5808	mysql crash 99 % cpu
Submitted:	29 Sep 2004 19:02	Modified:	8 Oct 2004 12:40
Reporter:	mwayfarer wayfarer	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.0.20 standar	OS:	Linux (linux redhat 9)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
the server go 99% cpu 

i have 50.000 rows in table client and the cpu is almost 50 percent  the time at 99 
the id of the table is an integer (255) 
the bug is :

if i change the integer id at (250) it fix the problem 
 

How to repeat:
in the main page i have lots of inner join  like 10 

Suggested fix:
if i change the integer id at (250) it fix the problem

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info: