MySQL Forums
Forum List  »  Performance

big tables performance
Posted by: Carlos Sola
Date: October 21, 2004 11:31AM

I'm writting an application to store about 250.000.000 rows per month (about 8 million at day) and I need to store 6 months of data.

The application makes the insert and then queries for some data (the table has only 4 integer fields).

My question is, what machine I need? I think I have to build more than one table (one per month) and join together using views or merge engine but I need queries takes no more than 10 seconds.

I'm going to buy some dell hardware with dual Xeon 3.2ghz, 4 Gb ram, 6 scsi disks (10000rpm) using raid 5.

PD: its a network monitoring system

Options: ReplyQuote

Written By
big tables performance
October 21, 2004 11:31AM

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.