From owner-freebsd-isp@FreeBSD.ORG  Tue Sep 28 14:59:03 2004
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
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 82E9416A4CE
	for <freebsd-isp@freebsd.org>; Tue, 28 Sep 2004 14:59:03 +0000 (GMT)
Received: from mail2.palnet.com (mail2.palnet.com [217.66.226.5])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 9BFB643D46
	for <freebsd-isp@freebsd.org>; Tue, 28 Sep 2004 14:59:02 +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 1CCJPn-0008Bf-JS; Tue, 28 Sep 2004 16:57:15 +0200
Message-ID: <122c01c4a56c$0fe603c0$8800000a@felfel>
From: "Mustafa N. Deeb" <mustafa@palnet.com>
To: "Erik @ Microcontroller.nl" <erik@microcontroller.nl>
References: <1096380086.31926.9.camel@tessa.mysmt.net>
	<11ab01c4a567$30b2df60$8800000a@felfel>
	<1096382924.31926.27.camel@tessa.mysmt.net>
Date: Tue, 28 Sep 2004 18:01:40 +0300
Organization: Palnet Communications Ltd.
MIME-Version: 1.0
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
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
Reply-To: "Mustafa N. Deeb" <Mustafa@palnet.com>
List-Id: Internet Services Providers <freebsd-isp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
List-Post: <mailto:freebsd-isp@freebsd.org>
List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 28 Sep 2004 14:59:03 -0000

i've meant our server configuration

and are u doing big DBs?

Cheers
  ----- Original Message -----=20
  From: Erik @ Microcontroller.nl=20
  To: Mustafa N. Deeb=20
  Cc: freebsd-isp@freebsd.org=20
  Sent: Tuesday, September 28, 2004 5:48 PM
  Subject: Re: mysql


  On Tue, 2004-09-28 at 16:26, Mustafa N. Deeb wrote:=20
what is your configuration ?
  I put:
  [mysqld]
  query_cache_type =3D ON
  query_cache_size =3D 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 -----=20
From: "Erik @ Microcontroller.nl" <erik@microcontroller.nl>
To: <freebsd-isp@freebsd.org>
Sent: Tuesday, September 28, 2004 5:01 PM
Subject: mysql


>=20
> 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.
>=20
> any tips are welcome.
>=20
> -Erik.
>=20
> _______________________________________________
> 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> =20