List:General Discussion« Previous MessageNext Message »
From:Terence Date:March 19 2004 9:41am
Subject:Key Buffer Size
View as plain text  
Hi,

Can somebody tell me whether this is good or bad:
Our mysql server has
key_buffer_size = 402,653,184 (without the commas)

The MySQL administrator tool indicates a 100% usage most of the time, and
362,324,992 as current usage within 24 hours which builds up very fast. Are
there memory leaks for threads on my system? Or is this normal behaviour?
Restarting the mysql server clears the above. I can't seem to find much
information on the mysql site or documentation as to what the ideals
are.

Running MySQL 4.1.1
Dual Xeon 2.4GhZ
1 Gig Ram
Redhat 9

Thanks

Thread
Key Buffer SizeTerence19 Mar
  • RE: Key Buffer SizeAl Caponi19 Mar
  • Key Buffer SizeVicky19 Mar
  • Re: Key Buffer SizeEric B.19 Mar