Hi,
On Moodle 3.10, when trying to view the log of an activity (assignment) or a user's log, the system hangs and the MySql consumes the CPU usage, please see attached snapshot (LMS-TOP.png).
Then it fails to Server Internal Error page, see attached snap (LMS-Error.png).
My server specs. are:
CPU
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
Address sizes: 42 bits physical, 48 bits virtual
CPU(s): 16
On-line CPU(s) list: 0-15
Thread(s) per core: 1
Core(s) per socket: 8
Socket(s): 2
NUMA node(s): 2
Vendor ID: GenuineIntel
CPU family: 6
Model: 63
Model name: Intel(R) Xeon(R) CPU E5-2698 v3 @ 2.30GHz
Stepping: 2
CPU MHz: 2297.339
BogoMIPS: 4594.67
Hypervisor vendor: VMware
Virtualization type: full
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 40960K
Memory
Total online memory: 64G
MySql
Server version: 10.3.22-MariaDB-0+deb10u1 Debian 10
Apache 2.4
PHP 7.3 FPM
Is there any special settings for the log features? and also any optimization tricks and hints?
Best regards,