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

[Drew Bertola]

On Wed, Jun 12, 2002 at 07:19:31PM -0700, J C Lawrence wrote:
> 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.

A possibility, but not a cause for concern right now.
 
> > 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.

My thoughts exactly.  That's why I asked.

There's also the possibility of using the mysql RAID-TYPE (or
RAID_TYPE ?) attribute.  Anyone try that?

-- 
+---------------------- T h e C o o p . n e t ----------------------+
| Drew Bertola         Hosting - Colocation      Tel:  408-738-8337 |
| TheCoop.net      Programming - Administration  Mob:  408-887-0426 |
| drew at thecoop.net    Open Source Specialists    http://thecoop.net |
+-------------------------------------------------------------------+