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. Review the /etc/httpd/conf.d/000-elentra.conf file and ensure that the MaxRequestWorkers and ServerLimit is 512. (this is step 24 in

Database Server

  1. Enable Slow Query Log and check the log for issues with queries taking too long

  2. Ensure your version of MySQL or MariaDB is supported

  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. Ensure that your MariaDB/MySQL in /etc/my.cnf.d/elentra.cnf configuration matches the suggestions in the documentations here:

  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. Ensure table_open_cache is set to 4000

  7. Ensure table_definition_cache is set to 1800

  8. Set max_connections to 512 (if it's currently commented out)

  9. Set vm.swappiness to 1 on your database server: sudo sysctl -w vm.swappiness=1

Last updated