From owner-freebsd-isp@FreeBSD.ORG Tue Sep 28 15:27:05 2004 Return-Path: Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 24E2E16A4CE for ; Tue, 28 Sep 2004 15:27:05 +0000 (GMT) Received: from mail2.palnet.com (mail2.palnet.com [217.66.226.5]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4401C43D41 for ; Tue, 28 Sep 2004 15:27:04 +0000 (GMT) (envelope-from mustafa@palnet.com) Received: from dogbert.palnet.com ([192.116.17.51] helo=felfel) by mail2.palnet.com with smtp (Exim 4.30) id 1CCJqv-0002Jh-3u; Tue, 28 Sep 2004 17:25:17 +0200 Message-ID: <127501c4a56f$fa327460$8800000a@felfel> From: "Mustafa N. Deeb" To: "Erik @ Microcontroller.nl" References: <1096380086.31926.9.camel@tessa.mysmt.net> <11ab01c4a567$30b2df60$8800000a@felfel> <1096382924.31926.27.camel@tessa.mysmt.net> <122c01c4a56c$0fe603c0$8800000a@felfel> <1096384464.31926.41.camel@tessa.mysmt.net> Date: Tue, 28 Sep 2004 18:29:42 +0300 Organization: Palnet Communications Ltd. MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2096 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2096 cc: freebsd-isp@freebsd.org Subject: Re: mysql X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list Reply-To: "Mustafa N. Deeb" List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 28 Sep 2004 15:27:05 -0000 hi you might be suffering from an I/O problem if it takes a long time in big queries, consider raid and using InnoDB Cheers ----- Original Message ----- From: "Erik @ Microcontroller.nl" To: "Mustafa N. Deeb" Cc: Sent: Tuesday, September 28, 2004 6:14 PM Subject: Re: mysql On Tue, 2004-09-28 at 17:01, Mustafa N. Deeb wrote: >  > i've meant our server configuration > > and are u doing big DBs? ah o.k., freebsd 4.9 with mysql 4.018 there is one site with a big index, a big select query for every visit. this generates the problem. Should I increase the number of connections? I don't believe this is the issue Should I increase some kind of read buffer? but is this not dynamically regulated by mysql already? hmm,. I now switched to the my-large.cnf configuration in /usr/local/share/mysql/ I copied it to /usr/local/share/mysql/my.cnf and restarted mysql let's see how that goes.. Greetings, -Erik. > > Cheers > > ----- Original Message ----- > From: Erik @ Microcontroller.nl > To: Mustafa N. Deeb > Cc: freebsd-isp@freebsd.org > Sent: Tuesday, September 28, 2004 5:48 PM > Subject: Re: mysql > > On Tue, 2004-09-28 at 16:26, Mustafa N. Deeb wrote: > > > what is your configuration ? > > > I put: > [mysqld] > query_cache_type = ON > query_cache_size = 10M > > in /usr/local/etc/my.cnf > > I read that doing mysqld --help will give me all parameters,. > but how do we do that on a freebsd install where I use > mysqld_safe? > > > > > > > > > > ----- Original Message ----- > > From: "Erik @ Microcontroller.nl" > > To: > > Sent: Tuesday, September 28, 2004 5:01 PM > > Subject: mysql > > > > > > > > > > Hi all,. > > > Are you using any mysql tuning settings in my.cnf? > > > I'm having a bit of trouble with some have mysql sites with > big query's > > > resulting in a mysqld process at 80% continue. > > > > > > any tips are welcome. > > > > > > -Erik. > > > > > > _______________________________________________ > > > freebsd-isp@freebsd.org mailing list > > > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > > > To unsubscribe, send any mail to > "freebsd-isp-unsubscribe@freebsd.org" > > -- > Erik @ Microcontroller.nl -- Erik @ Microcontroller.nl _______________________________________________ freebsd-isp@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-isp To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org"