- Server operating system version
- Ubuntu 22.04
- Plesk version and microupdate number
- 18.0.44
Just wiped server, installed Ubuntu 22, Plesk 18.0.44
Cloned a repo to primary domain. Previous DB was mySQL 7, used Plesk to repopulate new mariadb instance. This works good. I *was* having massive performance issues, due to load and some large queries, but added these two lines to my.cnf and things started rolling again.
innodb_buffer_pool_size=3072M
query_cache_size=64M
Next, I cloned the exact same repo to a subdomain, to use as a staging site. Used plesk to import the exact same database. As far as I can tell, every single setting is the same between the main site, and the duplicate in the subdomain. I adjusted a few php settings, but only using the Plesk interface, and the same on both. But the subdomain site is painfully slow, with constant Gateway Timeouts. The logs show "upstream timeout", so I assume its database issues.
I've exhausted my attempts to debug this... no idea where to look.
Cloned a repo to primary domain. Previous DB was mySQL 7, used Plesk to repopulate new mariadb instance. This works good. I *was* having massive performance issues, due to load and some large queries, but added these two lines to my.cnf and things started rolling again.
innodb_buffer_pool_size=3072M
query_cache_size=64M
Next, I cloned the exact same repo to a subdomain, to use as a staging site. Used plesk to import the exact same database. As far as I can tell, every single setting is the same between the main site, and the duplicate in the subdomain. I adjusted a few php settings, but only using the Plesk interface, and the same on both. But the subdomain site is painfully slow, with constant Gateway Timeouts. The logs show "upstream timeout", so I assume its database issues.
I've exhausted my attempts to debug this... no idea where to look.