-----Forwarded by Peter J Milanese/MHT/Nypl on 01/20/2004 02:36PM -----
To: "STE-MARIE, ERIC" <[EMAIL PROTECTED]>
From: Peter J Milanese/MHT/Nypl
Date: 01/20/2004 02:31PM
cc: [EMAIL PROTECTED]
Subject: Re: Advice needed for high volume of inserts
It'll work.
I do slight less on the way of inserts. What I do is dynamically generate
the tables within my entry code, and merge tables based on the query. Good
for large log parsers. Be aware that this can break greatly if it's a
non-redundant live feed (to mysql). I think that's a problem anywhere
though. Mysql should not hold you back though.
Peter J. Milanese
-----"STE-MARIE, ERIC" <[EMAIL PROTECTED]> wrote: -----
To: [EMAIL PROTECTED]
From: "STE-MARIE, ERIC" <[EMAIL PROTECTED]>
Date: 01/20/2004 02:20PM
Subject: Advice needed for high volume of inserts
Hello,
This is my first message on this list. So I take the occasion to salute
every
one of you.
I'm looking to implement a database server wich will mostly insert data.
The
data structure is not complexe. The data will be insterted in 1 table at
burst rates of 13000 insert/seconds and sustained rates of about 5000/sec
for
about 8 hours a day. There will be selects from time to times, so let
assume 100 selects /day. Note that the row size will be about 80 bytes.
The data needs to be kept in the database for around 90 days after which,
the
data is dropped from the database. Being more familiar with Oracle, I was
considering a partitioned table for the entries. Someone I work with told
me
that MySQL had merge tables that could serve the same purpose. The goal is
to optimize selects and simplify the aging of the data by droping a
partition
and creating an other one every day.
If I have a choice between MySQL and other products, I might push the MySQL
solution as long as it can do the job. My hope, with this message is to get
comments or suggestions for this kind of setup that could help me fit MySQL
in this project. Any suggestion is welcomed, like hardware size, warnings,
pros, cons, etc. etc.
Finally, we hope to save a bundle in oracle licenses.
Thank You in advance.
-Eric
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
