Max. no of database in a server?

How may databases are allowed to host in a given MySQL server? e.g. 4
or 5

Will performance suffer If I install too many Database in a single server?

Thanks.

howa wrote:
> How may databases are allowed to host in a given MySQL server? e.g. 4
> or 5

That depends how many your database administrator has limited you to. I
can't find the exact limit in the manual, but it will handle far more
than you will ever need. Probably way more than thousands.

Cheers,
Nicholas Sherlock

--
http://www.sherlocksoftware.org

howa wrote:
> How may databases are allowed to host in a given MySQL server? e.g. 4
> or 5

That depends how many your database administrator has limited you to. I
can't find the exact limit in the manual, but it will handle far more
than you will ever need. Probably way more than thousands.

Cheers,
Nicholas Sherlock

--
http://www.sherlocksoftware.org

Nicholas Sherlock ¼g¹D¡G

> howa wrote:
> > How may databases are allowed to host in a given MySQL server? e.g. 4
> > or 5
>
> That depends how many your database administrator has limited you to. I
> can't find the exact limit in the manual, but it will handle far more
> than you will ever need. Probably way more than thousands.
>
> Cheers,
> Nicholas Sherlock
>
> --
> http://www.sherlocksoftware.org

how to limit?

Nicholas Sherlock ¼g¹D¡G

> howa wrote:
> > How may databases are allowed to host in a given MySQL server? e.g. 4
> > or 5
>
> That depends how many your database administrator has limited you to. I
> can't find the exact limit in the manual, but it will handle far more
> than you will ever need. Probably way more than thousands.
>
> Cheers,
> Nicholas Sherlock
>
> --
> http://www.sherlocksoftware.org

how to limit?

Nicholas Sherlock wrote:

> howa wrote:
> > How may databases are allowed to host in a given MySQL server? e.g. 4
> > or 5
>
> That depends how many your database administrator has limited you to. I
> can't find the exact limit in the manual, but it will handle far more
> than you will ever need. Probably way more than thousands.
>
> Cheers,
> Nicholas Sherlock
>
> --
> http://www.sherlocksoftware.org
But that would be a limit to how many that user could create. Other
users could create more in the same server.

Nicholas Sherlock wrote:

> howa wrote:
> > How may databases are allowed to host in a given MySQL server? e.g. 4
> > or 5
>
> That depends how many your database administrator has limited you to. I
> can't find the exact limit in the manual, but it will handle far more
> than you will ever need. Probably way more than thousands.
>
> Cheers,
> Nicholas Sherlock
>
> --
> http://www.sherlocksoftware.org
But that would be a limit to how many that user could create. Other
users could create more in the same server.

howa ¼g¹D¡G

> How may databases are allowed to host in a given MySQL server? e.g. 4
> or 5
>
> Will performance suffer If I install too many Database in a single server?
>
> Thanks.

some background information...

we have a limited set of user, say. 500, they have many rows (e.g. avg.
more than 10000 rows stored on a table, so num of row = 5000000, and
the number still increasing, what i am think is stored the data in
different database per user, so each user owned a set of tables, the
scablity of the system can be greatly increased.

but i want to know the exact limit of the number of Database.

howa ¼g¹D¡G

> How may databases are allowed to host in a given MySQL server? e.g. 4
> or 5
>
> Will performance suffer If I install too many Database in a single server?
>
> Thanks.

some background information...

we have a limited set of user, say. 500, they have many rows (e.g. avg.
more than 10000 rows stored on a table, so num of row = 5000000, and
the number still increasing, what i am think is stored the data in
different database per user, so each user owned a set of tables, the
scablity of the system can be greatly increased.

but i want to know the exact limit of the number of Database.

howa wrote:
> howa ¼g¹D¡G
>
>
>>How may databases are allowed to host in a given MySQL server? e.g. 4
>>or 5
>>
>>Will performance suffer If I install too many Database in a single server?
>>
>>Thanks.
>
>
> some background information...
>
> we have a limited set of user, say. 500, they have many rows (e.g. avg.
> more than 10000 rows stored on a table, so num of row = 5000000, and
> the number still increasing, what i am think is stored the data in
> different database per user, so each user owned a set of tables, the
> scablity of the system can be greatly increased.
>
> but i want to know the exact limit of the number of Database.
>

I don't know the limit in MySQL, but you'll run out of system resources
long before you'll run out of databases. 500 is piddly.

As to performance suffering - insufficient information. There are too
many variables involved. Your best bet is to test it yourself.

Whether you *should* break up your database into 500 separate ones is
another question (which you didn't ask).

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex-at-attglobal.net
==================