DBA
Well-known member
Out of curiosity, how come you're storing them in the database?Attachments & Avatars - stores them the database (not file system), disallows animated avatars if your setup allows GIF avatars (via ImageMagick).
Out of curiosity, how come you're storing them in the database?Attachments & Avatars - stores them the database (not file system), disallows animated avatars if your setup allows GIF avatars (via ImageMagick).
I've just gotten started... I just needed to get it to a point where there was no functionality loss for users to be able to roll it out. Probably the most impressive thing actually is my importer that made it so we could migrate 18M+ posts and everything that went along with it in an hour.Impressive stuff, Shaun.
I dunno, it's all a blur now. LolWant.
Searching conversations is critical. I also think (possibly as a larger discussion about XF search in general) that things like user profile comments and... basically anything that you as a user have permission to see... should be searchable.
How much work was involved in writing the extension?
Multiple web servers.Out of curiosity, how come you're storing them in the database?
Shaun I suggest a conference with KAM seriously. Some of your stuff is essential core.
Like I've long thought that new users should not be able to post links in content or sig to prevent spam. Similarly New Content Filter.
Makes sense, but doesn't that make for a ridiculously large database? For example my 11,000+ attachments take up ~1.5GB of disk space.Multiple web servers.
Impressive stuff, Shaun.
You have to put them somewhere... {shrug}Makes sense, but doesn't that make for a ridiculously large database? For example my 11,000+ attachments take up ~1.5GB of disk space.
What's your database/file backup setup?You have to put them somewhere... {shrug}
Sorry, should have been more specific.Not sure what you mean? I use MySQL 5.5 and run backups nightly...
...Multiple web servers.
Why not use a fileserver and NFS?
the most impressive thing actually is my importer that made it so we could migrate 18M+ posts and everything that went along with it in an hour. .
Why not use a fileserver and NFS?
We host millions of files for our users...no way I'm going to put them in a DB
Exactly that. MySQL is fine for very large tables if you are doing primary key lookups (which is what happens here). It's not like the records in the database that stores the files are ever JOINed to, sorted or anything else.SPOF?
About 20 minutes (I also built a CLI based system for rebuilding indexes that will utilize multiple servers in parallel for the process).2 things are the most concern for big boards owners, import and search index rebuild.
how long did your search index rebuild took?
Yep... pretty sure it would be less work to build my own than try to fix it.Mods? He'd probably ditch the whole forum package and build his own from scratch.
Yep... pretty sure it would be less work to build my own than try to fix it.
Not really... vB5 doesn't even have infractions/warnings or paid user upgrades/subscriptions.Xenforo is less features ATM, but at least you have a great piece of forum software to start.
Not really... vB5 doesn't even have infractions/warnings or paid user upgrades/subscriptions.
Enhanced Search - XenForo's Elastic Search. My "Search" addon adds "Areas" tab to member profiles and makes a bunch of content types searchable (users, conversations & reports). Makes soft-deleted stuff searchable. Adds Elastic Search stats to admin area.
We use essential cookies to make this site work, and optional cookies to enhance your experience.