Hi.
On Tue, Oct 02, 2001 at 05:23:51PM +0200, [EMAIL PROTECTED] wrote:
> Hi,
>
> i have a simple question:
> how many databases is mysql able to handle.
There is no hard limit by MySQL. There are limits brought in by your
operating system, though.
> i have a mysql server on a dual xenon with 2GB ram
> with 300 Databases (for each customer one)
> but in the meantime a simple query takes ages to complete >10s
> select * from table tablename
> (11K rows)
> (no other links are active 100% cpu for this query)
>
> the same db on a fresh mysql installation (same binary & config)
> on a second box (dual xenon 2GB Ram) is as fast as it i expect
> it to be les than 1s.
What happens if you run this query a second time (on both boxes)?
What about other tasks like copying files?
> therfore the exact dirrence between the boxes is only that
> one has 300 DB's the other not.
>
> both boxes had no load while testing.
>
> has someone the same a idea if this realy the reason or not ?
300 other DB will not bother, if they are not going to be used during
your test (as you described). The main effect that others DB have
(during load) will be that the resources have to be shared, mainly
filesystem caches and disk accesses.
300 DB with its tables _might_ be a problem for the filessystem to
handle, but then the filesystem is crap, IMNSHO.
> Box OS FBSD 4.3 (yes a OS not scrap)
Bye,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
