[wp-hackers] Max number of WP sites per MySQL DB

[rex posadas]

Thank you both for the response. 

 

Rex 



----- Original Message ----
From: Beau Lebens <beau at dentedreality.com.au>
To: wp-hackers at lists.automattic.com
Sent: Tue, May 11, 2010 10:51:01 AM
Subject: Re: [wp-hackers] Max number of WP sites per MySQL DB

Eventually (around a thousand installs I think), you'll start running
into files-per-directory limits for most operating systems where the
number of files stored on disk (to handle the DB) is too many to
manage.

At that point you'd need to start splitting things out to separate databases.

There's no inherent limit coming from WordPress, it's all
server/DB/file-system limits.

On Tue, May 11, 2010 at 10:46 AM, John Bloch <jbloch at olympianetworks.com> wrote:
> I don't think there's any theoretical limit. As long as all the installs have different table prefixes and the DB has enough space, there is no limit placed by WordPress (I could be wrong on this, so please correct me if I'm wrong).
>
> -John
>
> On May 11, 2010, at 1:43 PM, rex posadas wrote:
>
>>
>>
>> Hi All,
>>
>> Is there is a limit to the number of WP instances a single MySQL database can handle?  For example, can a single MySQL DB handle 100+ WP sites?
>>
>>
>> Thanks,
>>
>>
>> Rex
>>
>>
>>
>> _______________________________________________
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
>> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>
_______________________________________________
wp-hackers mailing list
wp-hackers at lists.automattic.com
http://lists.automattic.com/mailman/listinfo/wp-hackers