From owner-freebsd-isp@FreeBSD.ORG Tue Sep 28 14:52:31 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 B341316A4CE for ; Tue, 28 Sep 2004 14:52:31 +0000 (GMT) Received: from rena.mysmt.net (rena.mysmt.net [82.150.137.102]) by mx1.FreeBSD.org (Postfix) with ESMTP id E098343D53 for ; Tue, 28 Sep 2004 14:52:30 +0000 (GMT) (envelope-from erik@microcontroller.nl) Received: (qmail 58032 invoked by uid 1003); 28 Sep 2004 14:52:30 -0000 Received: from erik@microcontroller.nl by rena.mysmt.net by uid 89 with qmail-scanner-1.21 (clamdscan: 0.70-rc. spamassassin: 2.63. Clear:RC:1(213.84.50.76):. Processed in 0.050869 secs); 28 Sep 2004 14:52:30 -0000 Received: from unknown (HELO ?192.168.0.14?) (microcon@microcontroller.nl@213.84.50.76) by 82-150-137-14.mysmt.net with SMTP; 28 Sep 2004 14:52:29 -0000 From: "Erik @ Microcontroller.nl" To: "Mustafa N. Deeb" In-Reply-To: <11ab01c4a567$30b2df60$8800000a@felfel> References: <1096380086.31926.9.camel@tessa.mysmt.net> <11ab01c4a567$30b2df60$8800000a@felfel> Message-Id: <1096382924.31926.27.camel@tessa.mysmt.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 28 Sep 2004 16:48:44 +0200 Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.1 cc: freebsd-isp@freebsd.org Subject: Re: mysql X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 28 Sep 2004 14:52:31 -0000 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