From owner-freebsd-questions@FreeBSD.ORG Sun Feb 10 10:03:31 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 52C9616A419 for ; Sun, 10 Feb 2008 10:03:31 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.158]) by mx1.freebsd.org (Postfix) with ESMTP id BC46B13C4F5 for ; Sun, 10 Feb 2008 10:03:30 +0000 (UTC) (envelope-from maanjee@gmail.com) Received: by fg-out-1718.google.com with SMTP id 16so3631122fgg.35 for ; Sun, 10 Feb 2008 02:03:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=tXthbhjlGMskdVTvo34LtkIH0QpNsADbhAH+FxtuMB4=; b=Q4Id6oJXDywQRt2FIbRHi4NS/SvD/5QJ5tvPnh1Xo2rbM4Bl0gRz5idH0XqGjmUnfRC+Yo2jRBiBAgpsmpOgnImD376ylSWP97N5zFUYAeZ/87tIjdu7+xUxGyxIxS+aIcHdNsPGFqVxXWT57cxD5exrjJ8x/VRimzJdKsxb6lw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=tVwKkHFwK0ActGbnE0Cm/3P9OHMfm5sR2UgFne1SAszibuBAdSKO2BrZhyleosbSMAT9/bD6z1BvE4fCRvZfA351vZ96Ax+LYWxEZx1z6yzKjWwV5Jv7dPSx6nC0M42RaAXWz+OBYurJ+qY/CL4IcDtwofjpsLuXWL0CEVnYnEM= Received: by 10.78.129.16 with SMTP id b16mr26361054hud.39.1202636226756; Sun, 10 Feb 2008 01:37:06 -0800 (PST) Received: by 10.78.67.7 with HTTP; Sun, 10 Feb 2008 01:37:06 -0800 (PST) Message-ID: <2cd0a0da0802100137v5fe0868ct75c854c98d9b640b@mail.gmail.com> Date: Sun, 10 Feb 2008 10:37:06 +0100 From: VeeJay To: FreeBSD-Questions , maanjee@gmail.com MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: Server getting crashed, any helpful comments? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 10 Feb 2008 10:03:31 -0000 Hello I am running a Freebsd server: 1. Software: Apache 1.3 mysql 5.0.27 php 4.4 2. Hardware: 2 intel procerssors 4 gb ram RAID 10 with hard drives 15K rpm I am having this problem quite often now. Apache stops responding due to mysql (my guess). And I cannot connect to mysql server: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: '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' There is following configuration for mysql: # The following options will be passed to all MySQL clients [client] port = 3306 socket = /tmp/mysql.sock default-character-set=utf8 # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking skip-networking skip-name-resolve server-id=1 max_connections=1000 key_buffer = 1024M max_allowed_packet = 16M table_cache = 512K sort_buffer_size = 4M net_buffer_length = 64K read_buffer_size = 4M read_rnd_buffer_size = 4M join_buffer_size=4M myisam_sort_buffer_size = 128M # increase until threads_created doesnt grow anymore thread_cache=512 query_cache_type=1 query_cache_limit=2M query_cache_size=64M # Try number of CPU's*2 for thread_concurrency thread_concurrency=4 set-variable=local-infile=0 init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8' default-character-set=utf8 character-set-server=utf8 collation-server=utf8_unicode_ci ft_min_word_len=2 ft_max_word_len=15 log-bin=mysql-bin server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash default-character-set=utf8 [isamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout ANY COMMENTS WILL BE WELCOMED, thanks!!! -- Thanks! BR / vj