On Saturday 21 July 2001 00:28, Jeremy Zawodny wrote:
> 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.
From what I understand, if you only select things that are indexed, it won't
access the table. That is, if everything in your select and where clauses is
in the index file, it won't open the table (I think...). So, you should not
have to worry about this.
>
> Jeremy
---------------------------------------------------------------------
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
