Hi, i have a simple question: how many databases is mysql able to handle.
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. 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 ? Box OS FBSD 4.3 (yes a OS not scrap) regards. I personlay prefere postgresql but there i have no such problems but others ;) -- Andre Schwaller ----------------------------------------------------- Interdata AG Andre Schwaller Gewerbepark CH-5506 Mägenwil E-Mail [EMAIL PROTECTED] Voice: +41 62 887 3732 Fax: +41 62 896 1133 Internet: http://www.interdata.ch --------------------------------------------------------------------- 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
