Hello.
On Tue, Apr 03, 2001 at 10:53:06AM +0100, [EMAIL PROTECTED] wrote:
> Hi,...
>
> Does anyone knows how many databases can handle on MySQL Server?
AFAIK, it is only limited by your operating system (databases are
stored as directories, so the question is how many directories your OS
is able to handle).
> Does a big number of databases ( perhaps 2.000 or 3.000) can
> impact on the system Performance?
This depends on your OS.
Only the number of tables are directly relevant to MySQL (use of file
descriptors, table cache, ...). From the point of view of MySQL,
database names are almost only a naming scheme (regarding performance
issues).
Having several thousands databases probably will have some impact. But
how much depends on how you use it. Best is to create a test case for
your application and see, how it scales.
Bye,
Benjamin.
---------------------------------------------------------------------
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
