Recent content by ddrager

I've added Mike to the licensed list, he is good to go (y)

I really like this idea. If it is a fully formed email address (checked on frontend by regex), it switches to an exact search (maybe with an indicator?). Optionally, give ability to disable exact search at that point.

When trying to locate a user by email (used for GDPR removal requests), search takes a very, very long time and sometimes times out. We have a large 12M+ member database. It seems like the cause is that email search is using LIKE '%email%' Is it possible to refactor user search, so that...

We usually soft delete in case there is a mistake, so in that case I think it does make sense to keep the Attachment. But, I think there should be some way to find that attachment if there is some issue with it (or make it completely unavailable if post was deleted).

Not sure this strictly should be categorized as a bug, but this seems the best place to post this. We received a complaint that an attachment on our server was being used in a Phishing email. The image was attached to a post, which had already been deleted (along with the member). Since we...

I'm curious if your question has been answered. I guess in summary, "It depends". When you say APC do you mean opcache? PHP 7 should have built in opcache via php-opcache module. Memcache also a great idea. We swapped between redis/memcache, they both did help with performance.

I'm still trying to get the scale working right on monitoring but I believe that is 100s of mbps. So DB traffic went from 200-300mbps to 50-70mbps

I can confirm :eek:

Could have used this thread a few weeks ago! We actually just came up with what I think is a pretty decent setup for production/staging systems that integrate Github Actions. There are a few remaining issues that are hard to handle via code repositories: /data/, attachments, avatars, etc. These...

Hello again! We worked together years ago on vB things. Our forum just moved to XenForo :) I am probably looking to get Cloudflare caching set up like you said. I would prefer to handle it with page rules, but this only supports invalidating cache by cookie. I think in order to set up good...

We have encountered a new kind of spam. It seems a new spam account will sign up, immediately follow up the maximum number of people (1000). When that account is deleted, the follows remain and they remain listed on the page of people they followed. I guess there are a few ways to handle this...

Thanks for the reply Mike! We already are losing some of the total users count since we full page cache with nginx in front of PHP, and eventually I would like to push this out to Cloudflare as well as it can really save on page download times for international logged out visitors. I know our...

Hello, We just migrated our large forum over to XenForo 2.1. Loving it so far! Occasionally, about every 2 hours, it seems like the xf_session_activity gets locked for writing and everything comes to a halt for about 2 minutes. APM shows it is this query that is locked and unable to complete...

My team is working on a large vBulletin to XenForo migration. During this migration, we have tested ElasticSearch and several other search providers with additional plugins but are not quite getting the search results we would like. We would like someone to consult with long-term for search on...

This is how vB used to handle it. Since its an exact match search it is much quicker.