MySQL Forums
Forum List  »  Performance

Millions storage...
Posted by: Vinicius Marques De Bernardi
Date: March 28, 2005 03:02PM

Hi everybody,

I'm new hear, and I'm using mysql at some time, my application is a track information, that make storage about positions of vehicles, in a table with all the information about the HARDWARE and GPS.

I start this product storing this information in 1 table and using MYSQL and POSTGRES, now we have some clients, and in some cases they has 1000 vehicles or more.

To maintance this table is my problem, in 2 months with 500 vehicles, I have 40 000 000 rows. ( VEHICLE + DATE is the key )

Monthly I had to delete 1 month of data, and many times I had to make reports, about distance, velocity, and others things that I have to select a part of this data using the key VEHICLE and DATE (between a period)

Witch kind of servers I need for? (2 XEON 2.8 HT 1 Gb RAM HD SCSI )

Witch king of tables ? (MyISAM)

I'm thinking to create tables of days ( one table per day )

Where can I go?

To fast data access I had a table with the last position of vehicles, but to the reports I can't do this kind of optimize.

Thanks for all kind of help

Vinicius Marques De Bernardi

Options: ReplyQuote

Written By
Millions storage...
March 28, 2005 03:02PM
March 28, 2005 07:53PM
March 30, 2005 12:50AM
March 30, 2005 01:16AM
April 01, 2005 12:51AM
March 31, 2005 11:34PM
April 01, 2005 09:07AM
April 01, 2005 09:09PM

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.