Huge amount of data

[Sebastien Salou]

Hi,

I'm using a MySQL server 5.0.37, and I would like to store a huge amount of data from logs (about 2 000 000 rows per day, so approximately 260Go for 2 years), so I'm a bit worried about performance and I'm trying to figure out how I can improve it.

You can see below the data I have to store :
id - int (auto_increment and primary key)
area - tinyint (value between 1 and 8 with equivalent quantities for each)
date - datetime
host - tinyint (value between 0 and 99)
type - varchar(4) (about 20 kind of types, but 5 will be very used in queries)
description - varchar(255)

ENGINE=MyISAM

As I'm using MySQL server 5.0.37, I simply can't use partitioning so I tried INDEXES on the field 'area' and 'type' but without any significant performance enhancements.

Does anybody know what I can do ?

Thank you in advance

Sebastien Salou