Linux & MySQL on Intel

Hello all,

I have a project which I am not sure if MySQL can handel.

I will be getting around 80Million records daily (230 bytes per record)

I need to insert these in to a database and have only a month window,
this would make my database after the first 4 months around 96 Billion
records at 230 bytes each.

I will have limited indexing, around 4 or 5

My question is can MySQL handle this, I will be running SuSe 8.2 or can
upgrade to 10+ with a P4 with 1GB+ memory with a large RAID drive.

Should I even attempt this? If so, where are the pitfalls?

Thank you for reading this.

Q

Please respond to q<AT>starlinx.com or reply to the posting here

Q wrote:

> Hello all,
>
> I have a project which I am not sure if MySQL can handel.
>
> I will be getting around 80Million records daily (230 bytes per record)
>
> I need to insert these in to a database and have only a month window,
> this would make my database after the first 4 months around 96 Billion


You are out by an order of magnitude (9.6bn)


--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png