[RSS Feed/News] Stuck on improving page load for large number of threads

Status
Not open for further replies.

XenForo

Administrative
  • Thread starter
  • Admin
  • #1
One of my nodes have 200,000+ threads and page loads are taking more than 5 seconds sometimes.

1674188531755.png
Debug shows runtime of 4.5 seconds for xf_thread.

I do have a large dedicated server and I feel like I can fix the load time with proper mysql tuning.
CPU : 4c/8t - 3.8 GHz/4.2 GHz
Memory : 64 GB
SSD storage

Any advice on where I should start? Anyone with large number of threads can share their mysql config?

Also posting something within a thread takes just as long. :(

ادامه مطلب...
 
Status
Not open for further replies.
Back
Top Bottom