Comment on page

Performance Issues

There are many factors and variables that come into play and might be the cause when experiencing slow loading times. Here are a few things to look into before starting to look into the code:

Application Server

  1. 1.
    Review the /etc/httpd/conf.d/000-elentra.conf file and ensure that the MaxRequestWorkers and ServerLimit is 512. (this is step 24 in https://docs.elentra.org/technical/administrators/application-server)

Database Server

  1. 1.
    Enable Slow Query Log and check the log for issues with queries taking too long https://mariadb.com/kb/en/slow-query-log-overview/
  2. 2.
    Ensure your version of MySQL or MariaDB is supported
  3. 3.
    Check the size of your elentra_me database. As the database gets larger, queries will take longer to execute and might need to be optimized
  4. 4.
    Ensure that your MariaDB/MySQL in /etc/my.cnf.d/elentra.cnf configuration matches the suggestions in the documentations here: https://docs.elentra.org/technical/administrators/database-server
  5. 5.
    The innodb_buffer_pool_size should be as big as the size of the elentra_me database. Example: If your database is 6GB and you have enough memory on the database server, it should be 6GB as well, providing you have enough RAM
  6. 6.
    Ensure table_open_cache is set to 4000
  7. 7.
    Ensure table_definition_cache is set to 1800
  8. 8.
    Set max_connections to 512 (if it's currently commented out)
  9. 9.
    Set vm.swappiness to 1 on your database server: sudo sysctl -w vm.swappiness=1