Forum Replies Created
-
Posts
-
Okay, so…. bypassing Cloudflare, that page will come up for a non-admin user, it just takes a few minutes.
Any recommendations for speeding that up at all?
(Grr… used backticks around those two settings. Too used to Slack. Forum won’t let me edit it. Oh well…)
Hey Jeremy,
My
memory_limitwas already at 2048M (2G). I tried bumping up themax_execution_timeas suggested. The other values would apply to actually submitting the form. That’s not my problem yet though. My problem is getting that form to come up at all.It spins for a few minutes before getting a 502 error from Cloudflare. Attempting to bypass that right now for some more testing….
Meanwhile, I’d like to ask this about your local installation if you don’t mind:
- How many events, venues, and organizers were you working with there? Because yes, it’ll work with 10 of each. Does it work with 4,000–10,000 of each though?
- Have the database (my.cnf), web server (httpd.conf or nginx.conf), or PHP (php.ini) settings on your installation been adjusted beyond the WP requirements to run TEC better, and if so how?
Next option almost seems like I’ll need to upgrade PHP from 7.1 to 7.2 and MariaDB from 10.0 to 10.3. That sounds exhausting. haha
I suppose it could be a database bottleneck too…. We have a really beefy dedicated server (48GB RAM, 12 cores), so maybe something is misconfigured in the Database there, but it’s slow to not working on my own machine too.
Really appreciating the help in solving this problem.
+1
Same thing happened to me. My site also has thousands of events, venues, and organizers.
Released the code updates on Saturday and MySQL CPU usage quickly shot up to over 1000%. Queries wouldn’t finish and pages wouldn’t complete, so PHP-FPM kept spawning new workers. Had to keep killing MariaDB just to keep the site on while I reverted all the stuff that was deployed trying to find the culprit. (Lessons learned: smaller deploys & turn on and dig into the query logs first).
Also probably didn’t help that search engines looked to be crawling at the time.
Mostly commenting to find out more as this progresses, but also hoping that the “thousands of events, venues, and organizers” and “CPU usage of over 1000%” are also of some use in troubleshooting.
Just as a slight tangent, and I’m positive your developers have thought of this before, but there’s nothing out there saying not to add extra tables to the WordPress database—particularly useful for things like those venue coordinates and event times, drastically reducing all these subqueries and joins happening everywhere. 🙂
Hey, thanks for finding that and following up.
Yes, disabling the Text link counter as described in one of the links inside the link you sent did end up working.
It’d be great to ultimately be able to keep that feature of that plugin on, but for now, no one’s missing it.
Thanks again!!
—Roger
Hi there. Finally got a chance to get back to this and test it out…
Disabled all plugins but the Tribe Events plugins.
Cleared cache, and did force refresh for each test.
Used different strings to search, just in case something was mysteriously cached there. (don’t know why it would, as those aren’t AJAX fields, and that’s a whole different problem ?)Tried on Twenty Seventeen, Sixteen, Fifteen, Fourteen, Thirteen, and Twelve—same results as initially reported: those dropdowns will only match from the beginning of the string, not from anywhere in it.
And just to be 100% sure that what I was told and testing was true, I checked out an earlier commit from our repo that put TEC at 4.3.5, ECP at 4.3.4, Community Events at 4.3.2, and Filterbar at 4.3.4. At that version, it was matching anywhere in the string: I could type “Leelanau” and see “Leelanau Peninsula” as well as “Wineries of the Leelanau Peninsula”
Hope that helps!
