Stuck on improving page load for large number of threads

[PracticalBot]

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.

برای دیدن لینک ها باید ثبت نام کنید