PROTECTED]
Sent: Tuesday, June 19, 2007 4:53 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: maximum number of records in a table
At 6:24 PM -0400 6/11/07, kalin mintchev wrote:
>hi all...
>
>from http://dev.mysql.com/doc/refman/5.0/en/features.html:
>
>"Handles lar
At 6:24 PM -0400 6/11/07, kalin mintchev wrote:
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
"Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about 5,000,000,00
> You should be fine. 100 000 000 is not that much.
> Just make sure you set the right keys (and then query by them) on the
> table
> and even more importantly, set caches and buffers to utilize your RAM
> appropriately.
thanks.
> Olaf
>
>
> On 6/12/07 11:09 AM, "kalin mintchev" <[EMAIL PRO
From: "kalin mintchev" <[EMAIL PROTECTED]>
Sent: Tuesday, June 12, 2007 11:20 AM
To: [EMAIL PROTECTED]
Subject: Re: maximum number of records in a table
thanks j.r...
>
> Olaf is right.
>
> It is really more about query execution time, and more import
You should be fine. 100 000 000 is not that much.
Just make sure you set the right keys (and then query by them) on the table
and even more importantly, set caches and buffers to utilize your RAM
appropriately.
Olaf
On 6/12/07 11:09 AM, "kalin mintchev" <[EMAIL PROTECTED]> wrote:
>> I guess a l
On Tue, Jun 12, 2007 at 11:09:41AM -0400, kalin mintchev wrote:
> > I guess a lot of that depends what an acceptable query execution time for
> > you is.
>
> well... i don't really know. 30 secs maximum?! i've never worked with
> such huge tables. 3 - 5 million records is fine but i've never work
From: Olaf Stein <[EMAIL PROTECTED]>
> Sent: Tuesday, June 12, 2007 8:13 AM
> To: [EMAIL PROTECTED]>, "David T. Ashley" <[EMAIL PROTECTED]
> Subject: Re: maximum number of records in a table
>
> I guess a lot of that depends what an
From: Olaf Stein <[EMAIL PROTECTED]>
> Sent: Tuesday, June 12, 2007 8:13 AM
> To: [EMAIL PROTECTED]>, "David T. Ashley" <[EMAIL PROTECTED]
> Subject: Re: maximum number of records in a table
>
> I guess a lot of that depends what an
> I guess a lot of that depends what an acceptable query execution time for
> you is.
well... i don't really know. 30 secs maximum?! i've never worked with
such huge tables. 3 - 5 million records is fine but i've never worked on a
db with a table with 100 000 000 records.
> Also, what else does
ct: Re: maximum number of records in a table
I guess a lot of that depends what an acceptable query execution time for
you is.
Also, what else does the machine do, are there other databases or tables
that are queried at the same time, do you have to join other tables in for
your queries, etc?
Ol
I guess a lot of that depends what an acceptable query execution time for
you is.
Also, what else does the machine do, are there other databases or tables
that are queried at the same time, do you have to join other tables in for
your queries, etc?
Olaf
On 6/12/07 3:24 AM, "kalin mintchev" <[EMA
hi david.. thanks...
i've done this many times and yes either trough php, perl, python or on
the mysql cl client. but my question here is not about doing it and insert
times it's more about hosting it and query times. i currently have a
working table for the same purpose with about 1.5 million r
On 6/11/07, kalin mintchev <[EMAIL PROTECTED]> wrote:
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
"Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about 5,000
> The answer depends upon the actual queries and/or how much data is being
> returned.
there is ALWAYS only one record found/returned per query it's like
looking up one unique id it's like checking if number 5893786 is there
in row number one... or something like number 5893786 - a uniqu
hi all...
from http://dev.mysql.com/doc/refman/5.0/en/features.html:
"Handles large databases. We use MySQL Server with databases that contain
50 million records. We also know of users who use MySQL Server with 60,000
tables and about 5,000,000,000 rows."
that's cool but i assume this is distrib
At 12:13 -0400 4/30/02, Andrew Kuebler wrote:
>Everyone on this list has been very helpful so far. I greatly appreciate
>all the help!
>
>I use Perl/DBI with MySQL. Normally to count records, I pull a query
>like:
>
>$a = $db->prepare("SELECT * FROM table");
>$a->execute;
>
>Then:
>
>$numrows = $a
$a = $db->prepare("SELECT COUNT(table.column) FROM TABLE");
$a->execute
- Original Message -
From: "Andrew Kuebler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 12:13 PM
Subject: Number Of Records in a Table
> Every
Everyone on this list has been very helpful so far. I greatly appreciate
all the help!
I use Perl/DBI with MySQL. Normally to count records, I pull a query
like:
$a = $db->prepare("SELECT * FROM table");
$a->execute;
Then:
$numrows = $a->rows;
to get a total count of records in the table. Is
18 matches
Mail list logo
