Time to first byte > 500 :(

[Anatoliy]

So I checked my forum with the Site Audit from Ahrefs. It scanned 20k pages. Average html file size - 11k. All of them are compressed with Brotli.

Time to first byte​

86% are "Too slow" (>500ms). 14% ate "Slow" (300-500ms).

Load time​

88% are "Medium" (500-1000ms). 11% are "Fast" (<500ms). Average load time 680ms.

Is there a way to make TTFB "Fast" (<200ms) or at least "Medium" (200-300ms)? Can load time of html file be "Fast" (<500ms)?
I have VPS, use redis cache (pages for guests), so those htmls should fly as static pages, right? Or I don't understand something?

Could someone help me crack this case, please?

 

[Kirby]

What are optimal settings for Mysql?

Ask your DBA to monitor and analyse your MySQL/MariaDB server and configure it optimally

There are no "optimal settings for MySQL", it always depends on your setup/hardware/workload.

Settings for a server with limited RAM on spinning rust with a small DB would be vastly different than for a server with plenty or cores, hundreds of GB RAM running on NVME and having a few thousand TPS for TB-sized DBs.