…and I know this is not the best place to ask this question… but I am sure that the people here will probably know the answer… and probably enjoy getting a howl out of me asking this question… so here it goes.
I am running WPMU, not yet using multi-db, but I’m in the process of planning my attack… today I decided I’d just double check how long before I’m in trouble… you know with the whole number of files in a directory thing… and this is what I discovered…
** My mysql directory has over 130,000 files in in it. **
No kidding… there appear to be about 51 files PER blog… and since we have around 2700 blogs, that adds up pretty fast.
How do I get 51 files per blog, well, I have a couple plugins installed/built that install per blog tables, things like a stats plugin and polls plugin, etc… but it also appears as if for each table I get 3 files, a .frm, .MYD, and .MYI… so the point is… lots of files.
Now, I thought there was a 32k file limit… apparently not.
I am running Fedora Core 6, and these are mounted as a ext3 file system.
So my question is:
1) Am I going crazy?
2) Is there not really a limit in ext3?
yes, yes, yes… I know, this has nothing to do with Andrew and his premium plugins… except for the fact that I was planning on using his plugins to address a problem which I apparently all ready have or maybe don’t have or maybe… jeez I’m totally confused.