5.2 Recommended External Tools
There are large numbers of closed and open source tools that you can use to administer your Tomcat/MySQL stack. Only some that we have familiarity with are listed here.
Psi probe is a community driven fork of Lambda Probe. It monitors connections and health of your Tomcat instance and allows you to (remotely) restart OSCAR independently of Tomcat. https://github.com/psi-probe/psi-probe
apt-get install mysqltuner . The script will analyse your MySQL instance and suggest settings for /etc/mysql/my.cnf
While the patch.sql adds a number of optimized indexes to a deb installed OSCAR 15 instance, your data may not be representative. If you are experiencing slowdowns you may activate the slow query log of mysql in /etc/mysql/my.cnf
long_query_time=2 log-slow-queries=/var/log/mysql/log-slow-queries.log log-queries-not-using-indexes
Note that the slow-log itself can slow performance. Turn it off when you are not using it!