From owner-freebsd-isp Fri Feb 5 09:49:18 1999 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id JAA18771 for freebsd-isp-outgoing; Fri, 5 Feb 1999 09:49:18 -0800 (PST) (envelope-from owner-freebsd-isp@FreeBSD.ORG) Received: from etinc.com (et-gw.etinc.com [207.252.1.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id JAA18764 for ; Fri, 5 Feb 1999 09:49:16 -0800 (PST) (envelope-from dennis@etinc.com) Received: from dbsys (dbsys.etinc.com [207.252.1.18]) by etinc.com (8.8.8/8.6.9) with SMTP id RAA03762; Fri, 5 Feb 1999 17:48:29 -0500 (EST) Message-Id: <199902052248.RAA03762@etinc.com> X-Sender: dennis@etinc.com X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0 Date: Fri, 05 Feb 1999 12:56:47 -0500 To: "Francis Percival C. Favoreal" From: Dennis Subject: Re: MySQL vs mSQL Cc: isp@FreeBSD.ORG In-Reply-To: References: <199902042354.XAA10802@etinc.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org 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