I checked MYSQL slow logs, most of the slow logs are 'core_sessions' and 'core_view_updates'
::IPS\Session\Store\_Database::updateSession:381*/ INSERT INTO `core_sessions` ( `id`, `member_name`, `seo_name`, `member_id`, `ip_address`, `browser`, `running_time`, `login_type`...
But I use the default 10s long_query_time, I think I need to change it to 3s.
I won't be using the query cache as it is deprecated. I'm unsure about what I can do to reduce the TTFB on topics, 1 second is too high.
OPcache is enabled.
PHP FPM set dynamic.
I'm using Redis.
Nginx.
Cloudflare.
My server using NVME SSD and is not overloaded.