From: Dan Nelson
Date: December 21 2006 4:02pm
Subject: Re: What to do if a table is supposed to get > 3GB data per day?
List-Archive: http://lists.mysql.com/mysql/204060
Message-Id: <20061221160217.GA40028@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Dec 21), Asif Lodhi said:
> Would you like to express your opinion as to what design strategy to
> take if a table (used for read operations only) is supposed to get
> more than 3GB of data per day? With 1000 simultaneous users ?

With that data rate, you'll definitely have to use partitioning or
MERGE tables, and generate a table per day or something similar. 
Otherwise aging records out of the table would be impossible.  You
didn't mention the insert rate, size of the records inserted, or
expected queries, so it's difficult to suggest which storage engine to
use.  The archive engine will significntly reduce your 3gb data size,
for example, but doesn't support indexes.

-- 
	Dan Nelson
	dnelson@stripped