On Thu, Jul 19, 2001 at 03:15:02PM -0500, Tom Wheeler wrote:
>
> Our two most important requirements for the database engine are
> speed and scalability. We will be inserting probably 5,000,000
> records per day into our database
Sounds doable--on reasonable hardware.
> and will maintain around 2TB of data.
Sounds doable--on an OS which handles large files, disks, etc.
> We would like to be able to scale easily, potentially by splitting
> databases up across multiple machines.
Makes good sense.
> My questions are: Is mySQL up to such a task? I have been using
> mySQL for four years now, but have never used it in a project of
> this magnitude. We'll be handling financial data in the database,
> so integrity is important.
There's nothing theoretically wrong with it. It's just a matter of
having the right OS and enough raw CPU/IO power to do the work.
> Where can I find information about very large databases with mySQL?
Don't know... Some of the folks here have experience. But some of
the biggest MySQL installations are probably known only to the folks
at MySQL AB who do corporate support. At lunch last year, Monty
mentioned someone at a good sized company (Texas Instruments, maybe?)
who was putting a few billion records in a MyISAM table and not having
any trouble.
> Is there a really efficient way to implement a function like
> indexseek() in FoxPro? This function will simply check an index to
> tell you if a record with that key exists. Sort of like "select
> count(id) from Foo where id=1" except that it doesn't actually fetch
> the field value and it just checks the index file, not the data
> file.
That's been covered separately, I think.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 34 days, processed 268,958,054 queries (89/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
