From owner-freebsd-isp Sun Feb 7 17:08:42 1999 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id RAA17697 for freebsd-isp-outgoing; Sun, 7 Feb 1999 17:08:42 -0800 (PST) (envelope-from owner-freebsd-isp@FreeBSD.ORG) Received: from gras-varg.worldgate.com (gras-varg.worldgate.com [198.161.84.12]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id RAA17685 for ; Sun, 7 Feb 1999 17:08:36 -0800 (PST) (envelope-from skafte@gras-varg.worldgate.com) Received: (from skafte@localhost) by gras-varg.worldgate.com (8.9.1a/8.9.1) id SAA12015; Sun, 7 Feb 1999 18:08:18 -0700 (MST) Date: Sun, 7 Feb 1999 18:08:18 -0700 From: Greg Skafte To: Dennis Cc: isp@FreeBSD.ORG Subject: Re: MySQL vs mSQL Message-ID: <19990207180817.A10802@gras-varg.worldgate.com> References: <199902042354.XAA10802@etinc.com> <199902052248.RAA03762@etinc.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95i In-Reply-To: <199902052248.RAA03762@etinc.com>; from Dennis on Fri, Feb 05, 1999 at 12:56:47PM -0500 Organization: WorldGate Inc. X-PGP-Fingerprint: 42 9C 2C A8 4D 2B C9 C4 7D B6 00 B0 50 47 20 97 X-URL: http://gras-varg.worldgate.com/~skafte Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org checkout http://www.tcx.se/benchmark.html that may help ... Quoting Dennis (dennis@etinc.com) On Subject: Re: MySQL vs mSQL Date: Fri, Feb 05, 1999 at 12:56:47PM -0500 > At 11:28 AM 2/5/99 +0800, Francis Percival C. Favoreal wrote: > > > > > >On Thu, 4 Feb 1999, Dennis wrote: > > > >> Does anyone know how they measure up? We've got a dbase with 2.7 million > >> records in mSQL and its just about on the edge of usability in a system > >> with 64meg of ram... > >> > >> wondering if anyone has used MySQL with this large a dbase? > >> > > > >I remember using MySQL to keep all the logs of my former ISP. > >At the end of the day, thousands of records are inserted to the MySQL > >database. And if i remember correctly, the size of the MySQL database > >containing the user dialup accounting when I left a year ago was > >around 8M already. And by now, it is still growing. > > 8Meg of records, or size of the DB? Mine is almost 2GB..so its hardly > a comparision. > > Dennis > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-isp" in the body of the message -- Email: skafte@worldgate.com Voice: +403 413 1910 Fax: +403 421 4929 #575 Sun Life Place * 10123 99 Street * Edmonton, AB * Canada * T5J 3H1 -- -- When things can't get any worse, they simplify themselves by getting a whole lot worse then complicated. A complete and utter disaster is the simplest thing in the world; it's preventing one that's complex. (Janet Morris) To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message