In our opinion, you can opt any or all of these:
a) Build indexes; or rebuild indexes with REPAIR TABLE
b) Take Periodic backup(mysqldump) based on the importance of the data.
Clear the current table on specific condition.
c) If clearing the table affects the transactions that depends on past data,
then well and good compress the table.[only for myisam]
shell> myisampack <tablename>.MYI
shell>myisamchk -rq <tablename>.MYI
ViSolve DB Team
----- Original Message -----
From: "Asif Lodhi" <itmailster@stripped>
Sent: Thursday, December 21, 2006 5:24 PM
Subject: What to do if a table is supposed to get > 3GB data per day?
> Would you like to express your opinion as to what design strategy to take
> a table (used for read operations only) is supposed to get more than 3GB
> data per day? With 1000 simultaneous users ?
> Thanks in advance,