OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
RE: Key Buffer Size

From: Al Caponi (don_alcaponiyahoo.com.sg)
Date: Fri Mar 19 2004 - 04:21:57 CST


i did: http://www.mysql.com/doc/en/Server_system_variables.html

-----Original Message-----
From: Terence [mailto:terencesunway.edu.my]
Sent: Friday, March 19, 2004 3:11 PM
To: mysqllists.mysql.com
Subject: Key Buffer Size

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=don_alcaponiyahoo.com.sg

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql