LOG4JDBC is a Java based database driver that can be used to log SQL and/or JDBC calls. So here I am going to show how to monitor JDBC operations on Governance Registry using log4jdbc.
Here I believe you have already configured Governance Registry instance with MySQL. If not, please follow the instruction available in the Governance Registry documentation.
Copy log4jdbc driver into CARBON_HOME/repository/components/lib directory.
Navigate to log4j.properties file located in CARBON_HOME/repository/conf/ directory and add below entry in to log4j.properties file.
# Log only the SQL that is executed.
# Log timing information about the SQL that is executed.
Restart the server and enjoy your work with log4jdbc. Log files are created under CARBON_HOME/repository/logs/ directory. So using sqltiming.log file you can monitor execution time of each query.
PS : If you want to simulate lower bandwidth situation, you can use trickle when the server is starting.