• memory use
• application caches
• system properties
• threads
• MySQL processes
• MySQL InnoDB status
• plugins
• OpenOffice status
• logs

This can aid quick diagnosis of problems where access to the server or database is limited.

The buttons are:

Memory

This tab  displays:

MySQL - InnoDB

This tab displays the result of the SQL statement:

SHOW ENGINE INNODB STATUS

If the message:

Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

is displayed, it means that the MySQL user doesn't have permissions to execute the command.

This can be granted using the following SQL statement:

GRANT SELECT, PROCESS ON *.* TO 'openvpms'@'localhost';

Replace 'openvpms' and 'localhost' the actual database user name and host if they have been changed from their default values.

NOTE: this may not take effect until Tomcat has been restarted.

Logs

The Logs tab enables:

• log files to be browsed and searched
• logging to be configured at runtime

The buttons are: