I've heard some bad things about turning off swap on Linux. I think it was on Jeremy Z.'s Blogger page. If he sees this maybe he can comment.
DeepBlue, take a look in the "support-files" directory under your MySQL install directory. There are 4 example my.cnf files for various memory/box configurations. These are only a general reference, but should give you a good starting point. I agree with David, though, in that your key_buffer size is way too low. Thanks, --jeff ----- Original Message ----- From: "Lopez David E-r9374c" <[EMAIL PROTECTED]> To: "'DeepBlue'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 7:38 AM Subject: RE: Memory Leak DeepBlue For 1000 simultaneous connections, your key_buffer seems way low. Should be in the 100's of megabytes. You may have to increase your RAM on that box. It almost always the cheapest thing you can do. Also, some people shut off the swap on Linux boxes. You might check on variable "net_buffer_length" since each connection will eat up memory. I have mine set at 8k. This is much lower than the default size. I only have 200 simultaneous connections with mostly inserts with low number of bytes for insert statement. Search the old list archives for the real guru's have given advice on this. I found it quite helpful. My experience is that memory leaks in mysqld is way down in the list of things to watch out for. but I'm no expert in tuning mysql either. David filter: sql, select, mysql -----Original Message----- From: DeepBlue [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 6:36 AM To: [EMAIL PROTECTED] Subject: re: Memory Leak The variables we change are the following: set-variable = key_buffer=32M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=512K set-variable = record_buffer=512K set-variable = max_connections = 500 It's 500 max connections and the server has 512 Kb memory and we experience memory leaks. Are these variables incorrectly setted for our memory or something like this ? The memory lead occurs only on high traffic time. Could anyone send hints for making this configuration better ? Thanks in advance. DeepBlue -------Original Message------- From: Egor Egorov <mailto:[EMAIL PROTECTED]> Date: sexta-feira, 28 de março de 2003 10:13:25 To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Subject: re: Memory Leak On Friday 28 March 2003 11:23, DeepBlue wrote: > I'm experiencing a memory leak problem on a server with runs Mysql 3.23.55 > with 1000 simultaneous users. > > It's an athlon XP 1800 with 512 Mb ram. > > Befor starting Mysql, webmin shows 350 Mb free memory, but after starting > mysql server it goes down, down, down and the server hangs for lack of > memory. > > We didn't have this problem one week ago, but a technician changed some > things on the server and we started to have this problem. > > The most strange part is that we have put back the my.cnf file and it keeps > happening. > > Does anyone has any clue of what may be happening ? I'm desperate ! There are no known memory leaks in MySQL for the moment of .55. So I advise you to check variables - 1000 connections is not an easy job for the default configuration. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ <http://www.ensita.net/> __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com <http://www.mysql.com> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql <http://lists.mysql.com/mysql> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] <http://lists.mysql.com/[EMAIL PROTECTED]> . ____________________________________________________ <http://www.incredimail.com/redir.asp?ad_id=309&lang=9> IncrediMail - Email has finally evolved - <http://www.incredimail.com/redir.asp?ad_id=309&lang=9> Click Here -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
