|
ARAGATO
|
April 3, 2019 at 2:46 am
As an amendment to this thread: https://eventespresso.com/topic/recommended-php-settings/
Do you have any general data on EE4’s resource usage?
Do you have any data on how much RAM is being allocated/used on one user in EE4. Lets say, I have a fresh WP install and E4 plus addons installed. How much server resources would be taken when a single user goes onto the website and browses the events, registers and books an event.
|
|
ARAGATO
|
April 3, 2019 at 2:48 am
I am a little bit lost in trying to optimize server performance (e.h. php max children etc.)
|
|
ARAGATO
|
April 3, 2019 at 2:57 am
Right now we experience a server overload in the case of a very high CPU usage on the mySQL DB. Do you have any mysql performace tips. Which caching works good with EE4 (php, wordpress plugins etc.).
|
|
Josh
|
April 3, 2019 at 8:19 am
Hi,
Do you have any general data on EE4’s resource usage?
Do you have any data on how much RAM is being allocated/used on one user in EE4.
We actually do not have that kind of data.
Generally speaking, questions related to how to make a web server performant are best answered by someone with knowledge about server administration. We don’t have that knowledge.
As an example, Eventsmart.com servers (our hosted Event Espresso service) are managed by Page.ly. Event Espresso & Eventsmart staff leave anything related to server configuration to the Page.ly staff because they’re the experts and they have the knowledge and experience to take that on.
With regards to caching plugin recommendations, we typically recommend WP Super Cache because it doesn’t require special configuration to use with Event Espresso 4.
|
|
ARAGATO
|
April 3, 2019 at 11:39 pm
I was always worried about using caching plugins together with EE4, because of session data or so that might get “cut off” by the caching.
Which mode of WP Super Cache do you recommend: Simple or WP-Cache caching?
|
|
ARAGATO
|
April 4, 2019 at 4:15 am
After 6 hours of use it did not change a thing.
As far as I can tell WP Super Cache only helps by caching the php side.
However, we have an abnormal high CPU load on our SQL Servers.
We have a lot of custom queries, but only using the EE4 Model, e.g.
return EEM_Event::instance()->count(
array(
array('Term_Taxonomy.Term.slug' => $term->get('slug')),
)
);
Are those queries cached?
|
|
Tony
|
April 4, 2019 at 6:50 am
I was always worried about using caching plugins together with EE4, because of session data or so that might get “cut off” by the caching.
As long as the plugin respects the no-cache headers setup by EE, it will work, some don’t and some also need the pages manually excluding from caching. All depends on the plugin.
However, we have an abnormal high CPU load on our SQL Servers.
As Josh mentioned above:
Generally speaking, questions related to how to make a web server performant are best answered by someone with knowledge about server administration. We don’t have that knowledge.
You need someone familiar with the process to investigate further on your server, we don’t have enough info nor enough server administration experience to troubleshoot this for you.
A lot of it is also relative, running your SQL Server on a Raspberry Pi will show higher CPU usages than a machine with better hardware, I’m not asking for your server specs, because its only part of the picture and you need someone to look at the whole picture (which also includes your custom code) to know what it going on.
Are those queries cached?
No, pretty much none of the methods within the database models are cached and that’s intentional.
There’s some basic caching within the objects themselves but not the models as you use the models to query the DB for live data, I’m not sure why we would cache data from the models.
You’re free to cache the responses from your custom queries and reuse those values should you wish, but that’s, not something we can help you with.
|
