Hello,
I have Moodle 3.5 hosted in VM at on-premise and RDS for MySQL at AWS. Virtual machine server specs are higher where memory is 7G and 2vCPU. Connection between VM and RDS is over private tunnel link.
Inside of the server components are my custom settings.
1) Apache 2.4.6
Timeout 7200 ProxyTimeout 7200
2) PHP 7.0.33
with Zend OPcache v7.0.33 and other modules.
3) PHP-FPM 7.0
php_admin_value[post_max_size] = 101M php_admin_value[upload_max_filesize] = 100M php_admin_value[max_execution_time] = 3600 php_admin_value[max_input_time] = 3600 php_admin_value[memory_limit] = 512M
Now, when browsing the link https://..../report/completion/index.php?course=199&format=csv to download the generated csv file, it takes 10-15 minutes to complete. I tried to enable debugging mode into "developer" but it doesn't print any value on apache/php-fpm access/error logs at all.
What is the best way to debug Moodle within that 10-15 minutes of generating csv file it will print in the logs on what is happening? I want to track which is much causing slowness either in my settings in server components or server loads or the RDS for mysql? So far, when I monitor the server resources and RDS MySQL, there is no spikes at all.
Any advise is deeply appreciated.
Thanks!