|
|
|
[
Permlink
| « Hide
]
Todd Scholl [23/Nov/18 08:15 PM]
I have attached a copy of the console for the time in question. Let me know if you need other data.
Looks like there are too many audit log entries in your database. Please remain auto-backup off and configure less log entry preserve time in system setting. After one night, the audit log entry will be cleaned up and then enable auto-backup. Also if UI blocks next time, please run below command from QB server to get a stack trace:
/path/to/jdk/bin/jstack <QB JVM process id> (not the wrapper process id) Also I noticed that memory of your QB server is too small to handle many database entries. Please increase it by editing property "wrapper.java.maxmemory" in "conf/wrapper.conf". I'd suggest to give it at least 6G for millions of database entries.
Robin,
Thank you for the info. Will work with my team on these recommendations. We have 16 GB of memory space on this server. Is there any down side to increasing the max memory further? say 12 - 14 GB? Giving it too much memory will cause noticeable JVM pause when it garbage collects memory. I'd suggest 8G for maximum.
|