On Fri, Feb 15, 2002 at 09:17:52PM +0300, Mikhail V.Soloviev wrote: > Hello, > > I have a problem with mysqld (3.32.46 under Red Hat Linux 7.2, > pIII-800 512K RAM). It starts and works fine until some time is > passed, then it starts eating my memory and CPU.
What does SHOW PROCESSLIST say at that time? > I have the following config in my.cnf: > [mysqld] > set-variable = max_connections=200 > set-variable = key_buffer=16M > set-variable = table_cache=100 > set-variable = sort_buffer=4M > set-variable = record_buffer=1M > set-variable = join_buffer=1M > > the usual number of connections if 70-120, maximum is 190. How much data do you have? With 512MB of RAM, you can afford to use more for your key_buffer if you have the data to justify it. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 10 days, processed 328,305,254 queries (377/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php