Hi,
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
Thanks
ViSolve DB Team
----- Original Message -----
From: "Asif Lodhi" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Thursday, December 21, 2006 5:24 PM
Subject: What to do if a table is supposed to get > 3GB data per day?
Hi,
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 ?
--
Thanks in advance,
Asif
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
