If "max_connections" is set to "75", does this mean 75 people at most can access the database until the connection is closed? On a WordPress website, when a visitor loads the website does that make a MySQL connection? If so, does it close immediately after?
If the WordPress website doesn't allow commenting or posting/uploading of any kind, are there any database connections needed? Or only to pull the WordPress initially? Does ach page require a new connection?
If I run 3 WordPress Websites on a single VPS, the max_connections variable globally covers the 3 databases, correct? To clarify, all the databases together have a total of 75 connections combined, not 75 each, right?
Are there variables that are dependent or must be changed when adjusting the max_connections variable?
Best Answer
The caching I described varies based on your web server, if you want to cache at that layer. For Nginx there's a great article on microcaching here, you can just extend the caching time. There will be plenty of article on caching with Apache.
Caching at the CDN layer is more dangerous. You don't want logged in user pages to be served to anonymous users or vice versa, so proceed with caution and research.