Claudio,
please provide details:
Which engine (InnoDB or MyISAM) are you running?
Which MySQL version are you running?
What is the OS?
What is the files system?
Regards
Theo
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Tuesday, 6 January 2009 10:05
Hi Ananda,
1. Long term solution: When you upgrade to MySQL 5.1 partition the table
e.g. by time. This approach was used for 10s of years in the other DBs.
http://dev.mysql.com/tech-resources/articles/performance-partitioning.ht
ml
http://dev.mysql.com/tech-resources/articles/mysql_5.1_partition