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

[Baki Goxhaj]

>
> *You might ask the WordPress.com folks. They're running one big
> installation, they can probably tell you how they've subdivided to help
> performance.*
>

That would be very interesting to know. Do we have a WP.com buddy around?

Baki Goxhaj
www.wplancer.com | www.banago.info | www.lintuts.com


On 11 May 2010 20:13, rex posadas <rexposadas at yahoo.com> wrote:

> 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
>
>
>
>
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers
>