King of punk
kingattitude at gmail.com
Thu Feb 7 00:48:02 GMT 2008
Maybe the solution is a ReiserFs linux partitioning ?
Matt Mullenweg wrote:
> Dan Milward wrote:
>> ...Then we will probably hit the limit of files at around 350 users.
> 32,000 / 3 files per table = 10666 tables / 350 blogs = 30 tables per
> blog? That seems high, even with plugins.
> Also as far as I know the 32k file limit is only with 2.4 kernels, not
> 2.6 ones.
>> So what I want to know is whether or not MySQL does something smart to
>> work around this - and if not does a separate machine running HyperDB
>> sound like a good idea.
> With InnoDB all tables are put in a single file.
> But really you should use a kernel made within the past few years.
>> And does HyperDB work well with Super Cache 2 :))
> I don't see how they're related.
More information about the HyperDB