MySQL Forums
Forum List  »  Optimizer & Parser

Huge amount of data
Posted by: Sebastien Salou
Date: April 25, 2007 02:47AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Huge amount of data
4026
April 25, 2007 02:47AM
2080
April 29, 2007 10:23PM
2158
May 02, 2007 10:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.