From owner-freebsd-questions@FreeBSD.ORG Sun Feb 10 19:25:35 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 5485516A417 for ; Sun, 10 Feb 2008 19:25:35 +0000 (UTC) (envelope-from derek@computinginnovations.com) Received: from betty.computinginnovations.com (mail.computinginnovations.com [64.81.227.250]) by mx1.freebsd.org (Postfix) with ESMTP id 3576C13C4D5 for ; Sun, 10 Feb 2008 19:25:33 +0000 (UTC) (envelope-from derek@computinginnovations.com) Received: from p28.computinginnovations.com (dhcp-10-20-30-100.computinginnovations.com [10.20.30.100]) (authenticated bits=0) by betty.computinginnovations.com (8.14.2/8.13.8) with ESMTP id m1AJPG0W019072; Sun, 10 Feb 2008 13:25:16 -0600 (CST) (envelope-from derek@computinginnovations.com) Message-Id: <6.0.0.22.2.20080210132216.0242b7e0@mail.computinginnovations.com> X-Sender: derek@mail.computinginnovations.com X-Mailer: QUALCOMM Windows Eudora Version 6.0.0.22 Date: Sun, 10 Feb 2008 13:27:07 -0600 To: VeeJay , FreeBSD-Questions , maanjee@gmail.com From: Derek Ragona In-Reply-To: <2cd0a0da0802100137v5fe0868ct75c854c98d9b640b@mail.gmail.co m> References: <2cd0a0da0802100137v5fe0868ct75c854c98d9b640b@mail.gmail.com> Mime-Version: 1.0 X-ComputingInnovations-MailScanner-Information: Please contact the ISP for more information X-ComputingInnovations-MailScanner: Found to be clean X-ComputingInnovations-MailScanner-From: derek@computinginnovations.com X-Spam-Status: No Content-Type: text/plain; charset="us-ascii"; format=flowed X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: Subject: Re: 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 19:25:35 -0000 At 03:37 AM 2/10/2008, VeeJay wrote: >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 You don't mention what version of FreeBSD you are running or what kernel (custom or generic.) The first things I would do is to be sure you are on the latest production release version of FreeBSD which would be 6.3 and use a generic kernel if possible. Then I would update the ports you using that you suspect are causing the lock-ups. Specifically update your apache, mysql-server and php. Once you have all the latest software running, test to see if the problem persists. -Derek -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.