|
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-------
Date: sexta-feira, 28 de março de 2003 10:13:25
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/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
. | 