Date: Wed, 27 Oct 1999 17:05:55 -0400 From: "Eric W. Bates" <ericx@vineyard.net> To: FengYue <fengyue@bluerose.windmoon.nu> Cc: freebsd-isp@FreeBSD.ORG Subject: FreeBSD & MySQL Message-ID: <199910272105.RAA04972@apache.vineyard.net> In-Reply-To: <Pine.BSF.4.10.9910251635590.5997-100000@bluerose.windmoon.nu> References: <99102522020700.58260@310.priebe.alt.na> <Pine.BSF.4.10.9910251635590.5997-100000@bluerose.windmoon.nu>
next in thread | previous in thread | raw e-mail | index | archive | help
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 <fengyue@bluerose.windmoon.nu> > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?199910272105.RAA04972>