Can MySql handle Large data?

------=_Part_53874_31322148.1226942122971
Content-Type: text/plain; charset=WINDOWS-1252
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I want to quickly ask if MySql can handle large data like 10 =96 20 million
rows in one database (e.g member table)

The question came to my mind is, How did large website like Yahoo handle
such data? Sure. Yahoo users may be more than 20 millions users or so.


Users will have -permission table
-profile table
-page table and so on, so query will be perform on 2
or three tables same time, i`m trying to check the speed, performance and
risk .

I need your advice on how to handle such data and the best structure to use=
..

------=_Part_53874_31322148.1226942122971--

Re: Can MySql handle Large data?

Just my two cents, but I doubt if Yahoo uses the same implementation of
MySQL as we do. They probably have a tweaked version of it that fits their
needs better than the free public version. Bare in mind too that MySQL *is*
a commercial company, even more so now they've been acquired by Sun.

That being said: The largest table I've had so far has 1 million+ records in
it. No problems with performance, but much depends on how you define indexes
and how you write your queries obviously. I think design is more important
than size!

Yves

----- Original Message -----
From: "Abah Joseph"
To:
Sent: Monday, November 17, 2008 11:15 AM
Subject: [PHP-DB] Can MySql handle Large data?


I want to quickly ask if MySql can handle large data like 10 – 20 million
rows in one database (e.g member table)

The question came to my mind is, How did large website like Yahoo handle
such data? Sure. Yahoo users may be more than 20 millions users or so.


Users will have -permission table
-profile table
-page table and so on, so query will be perform on 2
or three tables same time, i`m trying to check the speed, performance and
risk .

I need your advice on how to handle such data and the best structure to use.



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Can MySql handle Large data?

On Mon, Nov 17, 2008 at 9:15 AM, Abah Joseph wrote:
> The question came to my mind is, How did large website like Yahoo handle
> such data? Sure. Yahoo users may be more than 20 millions users or so.

Very large data sets are often partitioned in some way so that a given
lookup doesn't have to be performed against the entire data set.
That's quite an expansive topic in fact.

http://en.wikipedia.org/wiki/Partition_(database)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php