Performance problems

Question

Hi,

Web UI of Knowage-6_1_1 installed on Linux+MySQL works very slow (about 10-15 sec to show data sources list for example). I've added JAVA_OPTS="$JAVA_OPTS -Xms4096m -Xmx4096m" (half of available RAM) to bin/setenv.sh but see no results and even see no significant resource consuming:

top - 09:56:40 up 31 min,  1 user,  load average: 0,00, 0,00, 0,01
Tasks: 127 total,   1 running, 126 sleeping,   0 stopped,   0 zombie
%CPU(s):  2,5 us,  0,2 sy,  0,0 ni, 96,6 id,  0,6 wa,  0,0 hi,  0,0 si,  0,1 st
KiB Mem:   8170744 total,  3788808 used,  4381936 free,    47544 buffers
KiB Swap:        0 total,        0 used,        0 free,  1284404 cached

Is it possible to increase perfomance of Knowage Web UI ?

Answer 1

These timings does not reflect Knowage common timings.

I would suggest you to work on you setup, maily two things:

1. MySQL setup and performance
2. Network troubleshooting

Increasing the amount of memory is good for sure, but it is not directly related with the performance itself.

Last but not least, Knowage 6.2.0-RC has just been release. Please consider to upgrade to the latest.

Comments

Noticed, that request http://10.0.0.1:8080/knowage/restful-services/2.0/datasources takes about 10 secs, but same request via 127.0.0.1 works less than 1 sec. So, I solved problem by nginx before Tomcat but still can't understand what was happen (both requests was executed locally)