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