MySQL Forums
Forum List  »  Optimizer & Parser

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


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)


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

Written By
Huge amount of data
April 25, 2007 02:47AM
April 29, 2007 10:23PM
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.