Skip navigation links

MySQL Forums :: Performance :: Maximun number of databases per server


Advanced Search

Maximun number of databases per server
Posted by: Michael Erkelens ()
Date: March 29, 2005 06:25AM

Hi,

Does anyone know if there is any limit to the number of databases mysql can handle on a single machine ?

I am considering a setup where I will have thousands or even hundereds of thousands of databases (all reasonably small, about 10 MB per db) per server.

I am wondering if and how this could effect mysql performance, perhaps slow startups or other unforseen problems with the filesystem ? I know mysql will slow down if there are too many tables per database, but I have no idea what thousands of databases will do.

Any help or insights would be appriciated !

Michael

Options: ReplyQuote


Subject Views Written By Posted
Maximun number of databases per server 10255 Michael Erkelens 03/29/2005 06:25AM
Re: Maximun number of databases per server 6209 Nick Morley 12/03/2005 01:15PM
Re: Maximun number of databases per server 4276 Thomas CORBIERE 12/04/2005 02:14AM
Re: Maximun number of databases per server 3609 Gerald DeConto 09/13/2007 10:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.