From owner-freebsd-isp Wed Oct 27 14: 6:38 1999 Delivered-To: freebsd-isp@freebsd.org Received: from apache.vineyard.net (PRIMARY.VINEYARD.NET [199.232.92.254]) by hub.freebsd.org (Postfix) with ESMTP id 9206514DFC for ; Wed, 27 Oct 1999 14:06:34 -0700 (PDT) (envelope-from ericx@apache.vineyard.net) Received: (from ericx@localhost) by apache.vineyard.net (8.9.0/8.9.0) id RAA04972; Wed, 27 Oct 1999 17:05:55 -0400 (EDT) Message-Id: <199910272105.RAA04972@apache.vineyard.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit To: FengYue Cc: freebsd-isp@FreeBSD.ORG Subject: FreeBSD & MySQL In-Reply-To: References: <99102522020700.58260@310.priebe.alt.na> X-Mailer: VM 6.34 under Emacs 19.34.1 Reply-To: "Eric W. Bates" From: "Eric W. Bates" X-Work: Vineyard.NET, Inc., Box 4249, Vineyard Haven, MA 02568-4249 X-Phone: 508/696-6688 X-Fax: 508/696-8989 Date: Wed, 27 Oct 1999 17:05:55 -0400 Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org We are using MySql to track our web log. We have gone as high as 20 M hits in a week. We try to maintain 6 weeks of data. We found the limiting factor to be disk IO. We eventually built a small ccd of 2 disks working off an Adaptec U2W controller for the db files. This improved performance an order of magnitude or so over a single spindle for the entire machine running off a UW controller. We are also running the 3.23 version of the code because it has better multi-threading support and a new ISAM file format which allows non-blocking queries to the same table. I believe it is still alpha code, but has worked well for us. Bear in mind that mysql does not support transactions and probably never will. Mysql does not support triggers either. There are other "missing" pieces which might frustrate a programmer used to the commercial products. > From: FengYue > Date: Mon, 25 Oct 1999 16:42:45 -0700 (PDT) > > > Recently I'm convinced to help a company buildup an ecomm site. I've been > thinking about using FreeBSD and MySQL. > Has someone here used this combination on a heavy site? Could > you give me some figures? (such as trancation/s ...etc) Or if you have > any tips to share that would be great too > > My goal is build up this site with only open-source products. > > Thanks! > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-isp" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message