From owner-freebsd-database@FreeBSD.ORG Wed Nov 26 03:13:43 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2EB6C16A4CE for ; Wed, 26 Nov 2003 03:13:43 -0800 (PST) Received: from mailbox.univie.ac.at (mail.univie.ac.at [131.130.1.27]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2B65043FEC for ; Wed, 26 Nov 2003 03:13:40 -0800 (PST) (envelope-from l.ertl@univie.ac.at) Received: from pcle2.cc.univie.ac.at (pcle2.cc.univie.ac.at [131.130.2.177]) by mailbox.univie.ac.at (8.12.10/8.12.10) with ESMTP id hAQBDUu6235888 for ; Wed, 26 Nov 2003 12:13:35 +0100 Date: Wed, 26 Nov 2003 12:13:30 +0100 (CET) From: Lukas Ertl To: freebsd-database@freebsd.org Message-ID: <20031126120308.R414@pcle2.cc.univie.ac.at> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-DCC-ZID-Univie-Metrics: mailbox 4246; Body=0 Fuz1=0 Fuz2=0 Subject: MySQL tuning X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 26 Nov 2003 11:13:43 -0000 Hi, can someone recommend some values for tuning a MySQL installation running on FreeBSD 4.9 on a Dual 2.4Ghz Xeon with 4GB RAM? My my.cnf currently looks like this: skip-locking key_buffer = 384M max_allowed_packet = 1M table_cache = 1024 sort_buffer_size = 8M read_buffer_size = 2M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M set-variable = max_connections=500 thread_concurrency = 8 Now I randomly get this error when connecting: ERROR 1135: Can't create a new thread (errno 12). if you are not out of available memory, you can consult the manual for a possible OS-dependent bug. And the MySQL error log says: Out of memory; Check if mysqld or some other process uses all available memory. If not you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space This is a plain MySQL 4.0.16 installation from ports, statically linked. According to top, mysqld uses 515M RAM (148M RSS), and there's plenty of RAM free (or rather, 'inactive'). Any ideas, hints, tips? best regards, le -- Lukas Ertl eMail: l.ertl@univie.ac.at UNIX Systemadministrator Tel.: (+43 1) 4277-14073 Vienna University Computer Center Fax.: (+43 1) 4277-9140 University of Vienna http://mailbox.univie.ac.at/~le/