"...stand out ...." If striving for perfection ... 0 [!!] ... full time credentialed DB admin ... got one of those?
So what stands out to me ... the biggies ...
Anything [!!] isn't good
On web server:
Performing tests on vm-mysql-08.cca.edu:3306 is a FQDN
** BIG OOPS! **
Outside ... ie, me, doing dig on the FQDN above gives
;; ANSWER SECTION:
vm-mysql-08.cca.edu. 3600 IN A 10.16.x.x
A 10. private IP which in non-routeable to outside world unless there is a map/boundary FW rules that allow public IP -> 10.
So should never be shown to public DNS.
On Web server config.php ... DB host should be IP address ... not FQDN. Web server OS does need to be able to ping the 10.
Your networking folks need to fix that!
Above leads to this:
[!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
On DB server config ... skip networking setting
[!!] InnoDB buffer pool / data size: 128.0M/4.3G
Buffer Pool should be = or slightly higher than data size ... 4.3G or higher.
See the recommendations also say that.
On DB server
[--] Physical Memory : 11.7G
[--] Max MySQL memory : 21.3G
name resolution is active : a reverse name resolution is made for each new connection and can reduce performance
InnoDB Metrics
[!!] InnoDB buffer pool / data size: 128.0M/9.8G
buffer pool needs to be 10G
InnoDB buffer pool instances 10
Run OPTIMIZE TABLE to defragment tables for better performance
OPTIMIZE TABLE `moodle26`.`mdl_stats_daily`; -- can free 114 MB
OPTIMIZE TABLE `moodle30_prod`.`mdl_files`; -- can free 123 MB
OPTIMIZE TABLE `moodle30_prod`.`mdl_logstore_standard_log`; -- can free 272 MB
Total freed space after theses OPTIMIZE TABLE : 509 Mb
???? moodle26 and moodle30_prod ...
Is moodle26 DB a dev? Is it tied/linked to any other Moodle Web server? How about the DB named 'moodle30_prod'? Is that the DB name in the config.php of the web server?
The above questions probably best not answered in forums ... but do sort those out.
Optimization above needs doing - period.
If you look at the tables ... stats_daily, mdl_files, and mdl_logstore_standard_log
are all hit daily/hourly/every second? .... last one the most.
Highly recommend getting your networking and server folks from IT on board there! Takes a village!
Uhhh ... is the 'stand out' question a quiz? Did I pass?
'SoS', Ken