Date: Sun, 10 Feb 2008 13:27:07 -0600 From: Derek Ragona <derek@computinginnovations.com> To: VeeJay <maanjee@gmail.com>, FreeBSD-Questions <freebsd-questions@freebsd.org>, maanjee@gmail.com Subject: Re: Server getting crashed, any helpful comments? Message-ID: <6.0.0.22.2.20080210132216.0242b7e0@mail.computinginnovations.com> In-Reply-To: <2cd0a0da0802100137v5fe0868ct75c854c98d9b640b@mail.gmail.co m> References: <2cd0a0da0802100137v5fe0868ct75c854c98d9b640b@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?6.0.0.22.2.20080210132216.0242b7e0>