امتیازها
113
راهحلها
27
- محل سکونت
- England
- نوشتهها
- 26,276
- تاریخ ثبتنام
- ۱۳۹۹٫۰۴٫۰۶
- پسندها
- 3,286
- سن
- 29
- وب سایت
- xenforo.xyz
- نسخه PHP
- 7.3
- نسخه زنفورو
- xenforo 2.2
One of my nodes have 200,000+ threads and page loads are taking more than 5 seconds sometimes.
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.
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.
