Assuming Linux ... install MySQLTuner -
https://github.com/major/MySQLTuner-perl
there are probably more pages like the following, but this will do:
https://www.linode.com/docs/databases/mysql/how-to-optimize-mysql-performance-using-mysqltuner/
https://github.com/major/MySQLTuner-perl
there are probably more pages like the following, but this will do:
https://www.linode.com/docs/databases/mysql/how-to-optimize-mysql-performance-using-mysqltuner/
The table mdl_logstore_standard_log is the 'who done it' log. And there are settings in
yoursite/admin/settings.php?section=logsettingstandard
yoursite/admin/settings.php?section=logsettingstandard
Keep logs for logstore_standard | loglifetime
This specifies the length of time you want to keep logs about user activity. Logs that are older than this age are automatically deleted. It is best to keep logs as long as possible, in case you need them, but if you have a very busy server and are experiencing performance problems, then you may want to lower the log lifetime. Values lower than 30 are not recommended because statistics may not work properly.
Default is 'never delete logs' ... options are in days from 1000 days to 2 days. Like it warns ... not lower than 30.
This specifies the length of time you want to keep logs about user activity. Logs that are older than this age are automatically deleted. It is best to keep logs as long as possible, in case you need them, but if you have a very busy server and are experiencing performance problems, then you may want to lower the log lifetime. Values lower than 30 are not recommended because statistics may not work properly.
Default is 'never delete logs' ... options are in days from 1000 days to 2 days. Like it warns ... not lower than 30.
'SoS', Ken