[svlug] Linux + MySQL w/ very large data sets

[J C Lawrence]

On Wed, 12 Jun 2002 17:51:46 -0700 
Drew Bertola <drew at drewb.com> wrote:

> The queries will be frequent and somewhat complex, so I'm thinking a
> quad Xeon.  

You might like to consider a move to PostgresQL or another SQL server
that performs better on complex queries.  Historically MySQL has not
performed well on complex queries.  Investigate.

> Would it be better to employ a 64-bit machine?

You're going to be manipulating large files (>2GB).  If you stay x86
that means you'll need large file support from your SQL database.  This
has two risks: 1) not being present, 2) not being stable (as most people
don't use it).  Depending Depending on your stance this is can be good
reason to either go for a database built for such large tables (Oracle,
DB2, etc), or a 64bit platform with your current DB choice.

-- 
J C Lawrence                
---------(*)                Satan, oscillate my metallic sonatas. 
claw at kanga.nu               He lived as a devil, eh?		  
http://www.kanga.nu/~claw/  Evil is a name of a foeman, as I live.