Dear list, a friend of mine asked for assistance on the following problem (which I cannot solve myself):
He has a mysqld 3.23.38 running on Linux, with 2 cpus (400 MHz celeron) and 512 MB ram. mysqld runs as a production server, with some applications running about 80 queries per second. There are about 20 concurrent connections per hour. He uses myisam tables, no innodb or something. Quite often he finds that new clients (apps) cannot connect to mysqld, the connection is refused. My friend tried to connect from localhost to mysqld once when this happened, trying to log in as admin. Even for him, the connection was refused by mysqld (although mysqld is supposed to keep one connection open for the admin, in any case). To be correct about this, mysqld didn't respond at all, for 5 minutes. When connections for new users (apps) are blocked by mysqld, he finds that response times will slow down by factor 20, for users that are connected at this time. Also, he finds that Linux will kill mysqld *sometimes* (the server is re-started automatically). I did not find anything unusual using mysqladmin extended-status or mysqladmin variables. In my.cnf however, I found something strange: [mysqld] ... skip-locking set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable = thread_concurrency=8 log-bin server-id = 1 If I count these buffers and caches, this will add up to > 320 MB plus the table cache. Could this be the cause of the problem, when my friend only has 512 MB of RAM on the machine? Any help is greatly appreciated. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 --------------------------------------------------------------------- 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
