On Tue, Jan 30, 2001 at 09:44:55AM -0600, johnny p. wrote:
>
> I have several tables in my db that can potentially become *very*
> large *very* quickly. I was thinking about creating a table for
> each user of my database to keep data separate and allow each table
> to be 4GB due to OS restrictions. How many tables can a database
> have in it?
Lots. :-)
How many files can you put in a directory on your OS and still have
reasonable performance? Divide that number by 3 and you'll have the
number you seek.
> or should i create a database for each user with an identical table?
> and... in that case... how many databases can MySQL successfully
> handle at any given time?
Similar issue. Just don't divide by 3.
Since MySQL stores databases as directories full of files, and each
table is composed of 3 files, it boils down the the performance of
your operating system and how its filesystem is implemented.
Are you talking about a few hundred or a few million?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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