Elentra Platform Technical Documentation
  • Introduction
  • Reporting Issues
    • Security Notices
  • Administrators
    • Server Requirements
    • Application Server
      • Shibboleth Single Sign-on
      • Installing Supervisor
      • Branded API Setup
      • Installing Mailhog
    • Database Server
  • Developers
    • Getting Started
    • Overview
    • Contributions
      • Request for Change
      • Jira and GitHub Details
      • Coding Standards
      • Quickstart Guide
      • Code Review
    • Database
    • Dataviews for Analytics
    • Global Namespace
    • Elentra ACL
    • Authentication Methods
    • Compatibility Matrix
    • Elentra ME Versions
    • Elentra Settings
    • Elentra Deployment
    • Elentra API
    • Elentra JS
    • Feature Configuration
      • Event Resource Integration
      • Microsoft Teams Integration
    • Troubleshooting & Guides
      • New developer features in Elentra ME 1.22
      • Testing With Codeception
        • Unit Testing
          • Unit Testing Best Practises
          • Writing Unit Testable Code
          • PHPUnit Testing for API
          • PHPUnit Json String Compare Function
        • Functional Testing
          • Functional Testing Best Practices
        • Integration Testing
          • Integration Testing Best Practices
      • Upgrading elentra-developer Docker
      • VS Code Setup
      • Using XDebug in VSCode
      • Upgrading PHP
      • Switching Databases
      • Creating a new virtual host
      • Logging In
      • Composer
      • Curriculum Tag Selector
      • Performance Issues
      • Docker
      • Seed Data Generation
      • Fail Fast Programming
      • Advanced Custom Exception Classes
    • Support
  • Upgrade Guides
    • Upgrading to ME v28.0
    • Upgrading to ME 1.27
    • Upgrading to ME 1.26
    • Upgrading to ME 1.25
    • Upgrading to ME 1.24
    • Upgrading to ME 1.23
    • Upgrading to ME 1.22
    • Upgrading to ME 1.21
    • Upgrading to ME 1.20
    • Upgrading to ME 1.19
    • Upgrading to ME 1.18
    • Upgrading to ME 1.17
    • Upgrading to ME 1.16
    • Upgrading to ME 1.15
Powered by GitBook
On this page
  • Application Server
  • Database Server
  1. Developers
  2. Troubleshooting & Guides

Performance Issues

PreviousCurriculum Tag SelectorNextDocker

Last updated 4 years ago

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

https://docs.elentra.org/technical/administrators/application-server
https://mariadb.com/kb/en/slow-query-log-overview/
https://docs.elentra.org/technical/administrators/database-server