WordPress MU

Greets:

Just a quick heads up that there appears to be a max number of files setting within a standard CPanel install. We've all thought that a single directory could have a max of 32k files within a directory. It appears CPanel changes that to about 11k.

Well, I'm having fun. :(

NICE. >:-|

Doh!

Strike # 3297 for cPanel/WHM.

lol

Guess I can't bitch too much. I use it on my shared boxes.

Is there any way to fix this by tweaking cpanel settings?

Not a clue actually. My host sent in a emergency ticket but I don't think she's heard back yet.

Guess we better get a method of multiple databases in place. I know we've discussed it but nener really agreed on anything. I don't think the solution gave us a way to split the wp_blogs or the other main tables.

I'd venture to guess that the main tables would be in there own db, and then break up blogs accordingly, in some fashion.

"Best" guess would be:

blog id's 1-5000 (or 1k, 10k, whatever) = db1
blog id's 5001 - 10000 = db2

etc.

I'm just pulling that out of my ass, btw. But if you go by a hash of the blog id, then you have to make XX number of db's, unless you do it on the fly. Some servers let you do that, some don't.

even with the hash you can just start with 16 databases. Also, as a tip to anyone who might be trying multiple dbs soon, the time sucker is actually transferring blog tables from the one database to the multiple other databases. If you have over 10K blogs, you're best bet is to just put it in a crontab and let it run.

It got fixed during the night. I've asked my host to point me in the direction of what she had done so I can post about it.

I would really hate to have to do table copies. I was hoping to do something easier with just the individual blog tables.

From Pat over at http://synhosting.com

Hi Mike,
The problem was caused by a default limit with the FreeBSD operating system where the maximum files PER PROCESS was set to 11,096. It actually took 3 cPanel technicians before that limit was finally identified as the problem, and has since been raised to 36,984 files.

FreeBSD Fix:
sysctl kern.maxfilesperproc=36984
echo "kern.maxfilesperproc=36984" >> / etc /sysctl.conf

The first command will raise the limit immediately, the second one will make sure it stays after a reboot. There should be no spaces between "/ etc /", however I had to add them to prevent mod_security from blocking this reply.

Hope this helps,
-drmike

So basically this was a FreeBSD issue and not CPanel exclusively.

Hmm, good point. Last time I checked and I'll admit that I haven't run a FreeBSd box in ages, the file limit was the 32k rule that Linux has.

I use CentOS for linux installs.

Might be nice to know if I use it on an OS X Server box though.

Got three but they're my backup boxes and they don't have the server software running.

CentOS has been my choice lately also. For some reason it doesn't have the lovely politics cloud that most other distros have.

Well, not so far it doesn't seem to. I keep my nose out of it usually, and just use the damn thing. Be it MEPIS, CentOS, Fedora, Debian, whatever.

Well, except for SUSE. Their on my No-No list for their partnership with microsloth, and the absolute sh*t spewing from Steve Ballmer's mouth. Funny last name isn't it? I'm surprised he can talk all this sh*t, really. Considering the name and that's the same part of Gate's it's usually attached to.

Steve Ballmer attacks open source.

OK, that's all. Else I'll end up on a rant.

Don't even get me started on Ballmer. He makes ME want to throw a chair at HIM every time I hear him speak...

Not that Microsoft has ever been a company worthy of my respect but Ballmer has taken it to a whole new low.

I'll shut up now.

Yep.

'nuff said.